Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems

by Martin Kleppmann

To be safe, the database needs to assume that any change in the query result (the premise) means that writes in that transaction may be invalid.