[工学]第9章DataBase.ppt

An Introduction to Database System Chapter 8 Concurrency control 并发控制 8.1 Introduction of Concurrency Control并发控制概述 8.2 Lock封锁 8.3 Lock-Based Protocols封锁协议 8.4 Starvation and Deadlock活锁和死锁 Introduction of Concurrency Control Multiple transactions (多事务执行方式): (1) Run transactions serially (事务串行执行) (2) Interleaved concurrency (交叉并发方式) (3) Simultaneous concurrency (同时并发方式 ) Data inconsistency in concurrent operations 并发操作带来的数据不一致性 lost update（丢失修改） non-repeatable read（不可重复读） dirty read （读“脏”数据） Figure 8.1 3 kinds of data inconsistency三种数据不一致性 Figure 8.1 3 kinds of data