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

by Martin Kleppmann

However, if the database allows the WHERE clause to read from an old snapshot, this statement may not prevent lost updates,