Database Management Systems II - Prof. Holowczak

Zicklin School of Business - Baruch College
City University of New York

Database Management Systems II

Concurrency Control

What You'll Learn This Week

Concurrency Control

Elmasri/Navathe (3rd ed.) Elmasri/Navathe (2nd ed.) Connolly, Begg (3nd ed.) McFadden (5th ed.)
Chapter 20 Chapter 18 Chapter 19 (19.2) Chapter 13


Two Phased Locking (2PL)

Timestamp Ordering

Optimistic Concurrency Control


Deadlock Prevention

Deadlock Detection

Waiting Schemes for Locking

Oracle Implementation of Concurrency and Transaction Isolation

MS SQL Server Support for Locking

File: cc_index.html Date: Thu Mar 20 11:05:17 EST 2003
All materials Copyright, 1997-2003 Richard Holowczak