Transactions and Concurrency Control
Abstract
An overview of how a database shares resources among multiple user sessions.
Keywords
Batch job
Sessions
ACID (Atomicity, Consistency, Isolation, Durability)
Jim Grey
Andreas Reuter
Theo Härder
COMMIT
ROLLBACK
SAVEPOINT
CHECKPOINT
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
Read Skew
Write Skew
CAP (Consistency Availability and Partition Tolerance) Theorem
Eric Brewer
Fuzzy Reads
BASE
Eventual consistency
Error Handling
Deadlock
Livelocks
In the old days when we lived in ...
Get Joe Celko's SQL for Smarties, 5th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
