浙江大学数据库系统概念PPT第十六章.pptVIP

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.) The Two-Phase Locking Protocol The Two-Phase Locking Protocol (Cont.) The Two-Phase Locking Protocol (Cont.) Lock Conversions Automatic Acquisition of Locks(Commercial DBMS Uses) Automatic Acquisition of Locks (Cont.) Other Concurrency Control Protocols Graph-Based Locking Protocol – Tree protocol Maintain partial ordering of all data items. Only X lock Guarantee conflict serializable Timestamp-Based Protocol V