第十六章,对应原版教材第五版.pptVIP

?Silberschatz, Korth and Sudarshan, Bo Zhou 16.* Database System Concepts 3rd Edition Chapter 16: Concurrency Control Lock-Based Protocols Multiple Granularity Deadlock Handling Insert and Delete Operations Concurrency in Index Structures Lock-Based Protocols A lock is a mechanism to control concurrent access to a data item Data items can be locked in two modes : 1. exclusive (X) mode. Data item can be both read as well as written. X-lock is requested using lock-X instruction. 2. shared (S) mode. Data item can only be read. S-lock is requested using l