
repeatable read
strengthens read committed by additionally prohibiting single-object anti-dependency cycles
repeatable read in a sentence
“With repeatable read, querying the same row twice in a transaction always returns the same value.”
Related Words
serializability
all transactions appear to execute in some total serial order, prohibiting dirty writes, dirty reads, and anti-dependency cycles
sequential consistency
operations appear in a total order consistent with each process's order but not necessarily real-time order
snapshot isolation
each transaction receives an isolated snapshot of the database; it commits only if no concurrent writes exist to the same keys
strong consistency
a broad term covering models including sequential, linearizable, and serializable consistency
strong serializability
strengthens serializability by requiring the apparent transaction order to match real-time order
strong session serializability
strengthens serializability by additionally prohibiting session phenomena within each process