数据库原理 第9章 Concurrency Control.pptVIP

Chapter 9 Concurrency Control 9.1 Lock-Based Protocols 9.2 Multiple Granularity 9.3 Deadlock Handling 9.4 Insert and Delete Operations 9.1 Lock-Based Protocols One way to ensure serializability is to require that data items be accessed in a mutually exclusive manner以互斥的方式.(lock) 1. Shared: if a transaction Ti has obtained a shared-mode lock on item Q, then Ti can read, but cannot write Q. 2. Exculsive: if a transaction Ti has obtained an exclusive-mode lock on item Q, then Ti can both read and write Q. T1 lock-X(B) read(B) B:=B-50 write(B) unlock(B) lock-X(A) read(A)