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

Locking

Two Phased Locking (2PL)

Timestamp Ordering

Optimistic Concurrency Control

Deadlock

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