[计算机软件及应用]数据库课件9.pptVIP

What are the objects we lock? Relation A Relation B ... Tuple A Tuple B Tuple C ... Disk block A Disk block B ... DB DB DB Example R1 tu1 tu2 tu3 tu4 T1(IS) T1(S) , T2(S) Root Relation Tuples Example R1 tu1 tu2 tu3 tu4 T1(IS) T1(S) , T2(IX) T2(X) Root Relation Tuples Multiple granularity Requestor IS IX S X IS Holder IX S X T T T F F F F F F F T F T F T T 9. Concurrency Control JongHoon Kim DATABASE SYSTEMIMPLEMENTATIONHECTOR GARCIA-MOLINAJEFFRY D. ULLMANJENIFER WIDOM General process of assuring