Concurrency Control and Recovery in Database Systems

by Philip A. Bernstein, Nathan Goodman, Vassos Hadzilacos

Book Overview

Concurrencey Control and Recovery in Database Systems. P.A. Bernstein. Copyright 1987, Addison-Wesley, Reading. Hardcover in fine condition. Binding is secure, cover and spine are clean with minimal... This description may be from another edition of this product.

• Format: Hardcover
• Language: English
• ISBN: 0201107155
• ISBN13: 9780201107159
• Release Date: January 1987
• Publisher: Addison Wesley Publishing Company
• Length: 370 Pages
• Weight: 1.50 lbs.
• Dimensions: 0.8" x 6.7" x 9.5"

Customer Reviews

The seminal text on concurrency control

This book is outstanding. It is THE text to have for a study and understanding of database concurrency control algorithms and the concepts of concurrency control. In my work and writings, I always refer to this text and its precisely-defined properties for proper concurrency control (recoverable (RC), avoidance of cascading aborts (ACA), serializable (SR), and strict (ST)) in lieu of the more-often-cited but less precise "ACID" criteria.

Best book for Transaction Manangement & Concurrency Control

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 conclusionsAgain, 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 CollegeP.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.