Transactions and Concurrency Control
An overview of how a database shares resources among multiple user sessions.
ACID (Atomicity, Consistency, Isolation, Durability)
Transaction Phenomena: “Dirty Write,” “Dirty read,” “Non-repeatable read,” “Phantom read,” “Lost Update”
Isolation levels: “READ UNCOMMITTED,” “REPEATABLE READ,” “SERIALIZABLE,” “CURSOR STABILITY”
Pessimistic concurrency control
Data Item Constraint Violation
CAP (Consistency Availability and Partition Tolerance) Theorem
In the old days when we lived in ...