《Database System Concepts Course Introduction》ch16 Concurrency Control.pptVIP

Chapter 16 : Concurrency Control Chapter 16: Concurrency Control Lock-Based Protocols Lock-Based Protocols (Cont.) Lock-Based Protocols (Cont.) Pitfalls陷阱 of Lock-Based Protocols Pitfalls of Lock-Based Protocols (Cont.) If we do not use locking, or if unlock data items as soon as possible after reading or writing them, we may get inconsistent states If we do not unlock a data item before requesting a lock on another data items, deadlocks may occur A locking protocol is a set of rules followed by all transactions while requesting and releasing locks. Locking protocols restrict the set of poss