Concurrency Control and Recovery in Database Systems

Rating:
Summary: Best book for Transaction Manangement & Concurrency Control
Review: The Concurrency Control and Recovery in Database Systems, by Bernstein, Hadzilacos and Goodman is the jewel for the Theory of Transaction Management and Concurrency Control in Database Systems. Despite of the fact that it is out of print (the last edition going back to 1987), it is still consider up to date and the best source for important aspects of the implementation of the transaction manager of a DBMS such as: - Transaction design -- query formulation, isolation, degree desired, and transaction length - Serializabilty -- criterion for serializability, serialization graph, serialization order - Atomicity -- avoiding dirty reads, repeatable reads, phantom reads - Concurrency control -- two phase locking, resource & data contention, thrashing, detect deadlocks, intention locks, deadlock avoidance protocols, other concurrency control mechanisms - Recovery -- tolerating failures and guaranteeing atomicity, quantitative conclusions

Again, I would recommend this textbook to anyone who interests in the theory of Database Systems in general and at the Theory of Transaction Management in particular.

Regards, Prof. Sarbanes C U N Y Queens College

P.S. : I am looking for adopting this book for my database course for the Fall 2000, but I can NOT find this text book easily. Any help for this matter, would be greatly appreciated.