Isolation Levels

The _ACID Properties_ chapter introduced isolation as the guarantee that concurrent transactions don't interfere with each other. But isolation isn't binary. The SQL standard defines four isolation levels, each offering a different trade-off between data correctness and concurrency performance. Stronger isolation means fewer surprises, but more contention between transactions.