Module
Transactions, Concurrency Control, and Recovery
Sign in to add this module to your path and practice.
About
ACID properties, schedules, conflict/view serializability, locking protocols (2PL, strict/rigorous), deadlock handling, isolation levels and anomalies, optimistic/multi-version concurrency (overview), logging (WAL), checkpoints, and recovery (steal/no-steal, force/no-force, ARIES-style ideas).
Goal
Determine whether a schedule is serializable and what anomalies it allows; apply 2PL and reason about lock modes; explain how WAL + checkpoints enable atomicity and durability after crashes; map isolation levels to concurrency phenomena.
Unlocks
Tutor
Ask questions about this module.
Hi — I'm your tutor for Transactions, Concurrency Control, and Recovery. Ask about the concepts, goal, or where you're stuck.