浙江大学数据库系统概念第十六章,对应原版教材第五版.ppt

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