Week 12
Transaction Processing
Transaction Isolation
Transaction Isolation
Serializability
Ex1: Serializability Checking
Transaction Isolation Levels
Implementing Concurrency Control
Concurrency Control
Lock-based Concurrency Control
Two-Phase Locking
Problems with Locking
Deadlock
Ex2: Deadlock Handling
Optimistic Concurrency Control
Multi-version Concurrency Control
Concurrency Control in PostgreSQL
Ex3: Locking in PostgreSQL
Implementing Atomicity/Durability
Atomicity/Durability
Durability
Dealing with Transactions
Architecture for Atomicity/Durability
Execution of Transactions
Transactions and Buffer Pool
Logging
Undo Logging
Checkpointing
Redo Logging
Undo/Redo Logging
Recovery in PostgreSQL
Produced: 23 May 2016
![[index]](icon/up.gif){kind=icon}