数据库系统原理精品课件（康辉）ch16-kh.pptVIP

Chapter 16: Concurrency Control 16.1 Lock-Based Protocols 16.1 Lock-Based Protocols 16.1 Lock-Based Protocols Pitfalls of Lock-Based Protocols Pitfalls of Lock-Based Protocols Locking Protocol A locking protocol (封锁协议) is a set of rules followed by all transactions while requesting and releasing locks. Locking protocols restrict the set of possible schedules. We say that a schedule S is legal under a given locking protocol if S is a possible schedule for a set of transactions that follow the rules of the locking protocol We say that a locking protocol ensures conflict serializability if a