张云春《数据库原理与实用技术》Chapter 9 Update Transactions.pptVIP

9.3 Locking to Ensure Serializability The locking discipline used to assure transactional consistency in commercial database systems is known as two-phase locking, abbreviated 2PL. DEFINITION 9.3.1 Two-Phase Locking, or 2PL. When transaction Ti attempts to read a data item, Ri(A), the scheduler intercepts this call and first issues a call on its behalf to read lock the data item, RLi(A) Similarly when Ti attempts to write (update) a data item, Wi(A), the scheduler first issues a call on its behalf to write lock the data item, WLi(A). Before granting （加载） a lock on a data item, the scheduler r