Concurrency Control and Recovery in Database Systems
Conditions
A read copy that remains in clean condition.
Conditions
A read copy that remains in clean condition.
Conditions
A read copy that remains in clean condition.
Conditions
A read copy that remains in clean condition.
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.
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.