Multiversion Concurrency Control
Review of Strict 2-Phase Locking
- A serializable schedule is guaranteed by 2-phase locking.
- Strict 2PL needed to avoid introducing dependencies on
data introduced by aborted transactions. Relies on:
- Shared lock: For reading rows.
- Exclusive lock: For updating rows.
|