Unit 4: Concurrency and Recovery
Database management systems must be able to support concurrency; that is, they must be able to support multiple users and processes accessing the same records in a table. Modern database management systems handle concurrency in a variety of ways, including through the use of locking and versioning mechanisms. Database management systems must also be able to ensure transaction consistency and recover from catastrophic failures. In this unit, we will look at methods of ensuring that systems are capable of concurrency and recovery.
Completing this unit should take you approximately 13 hours.
4.1: Transactions and the ACID Property of Transactions
4.2: Serializability and the Serializability Theorem
4.3: Two-Phase Locking