Isolation Levels
Read Committed
- non-repeatable read demo
Repeatable Read
- write skew demo
Serializable
- prevents write skew
- SSI (Serializable Snapshot Isolation) predicate locking
Reference
- Berenson et al. “A Critique of ANSI SQL Isolation Levels” (1995)