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

by Martin Kleppmann

When a transaction writes to the database, it must look in the indexes for any other transactions that have recently read the affected data.