Transactions & Consistency
ACID properties, isolation levels, and consistency models
4 concepts DDIA Ch 7
ACID Properties
Atomicity, Consistency, Isolation, and Durability in databases
Isolation Levels
Read uncommitted, committed, repeatable read, and serializable
MVCC (Multi-Version Concurrency Control)
How databases provide isolation without locking
Serializability
Ensuring transaction outcomes are equivalent to serial execution