Changes from 3 rd edition: This chapter has been reorganized from the previous edition. Some of the material from the Concurrency Control chapter of the second edition (Chapter 11), such as schedules and testing for serializability have been moved into Chapter 15 of the third edition. The sections on deadlock handling (Section 16.6) and concurrency in index structures (Section 16.9) have been moved in from Chapter 12 of the second edition (Transaction Processing. The section on multiversion two-phase locking is new. mywbut.com
Exercises 16.1 Show that the two-phase locking protocol ensures conflict serializability, and that transactions can be serialized according to their lock points.
