'Intention locks' presentation slideshows

Carnegie Mellon Univ. Dept. of Computer Science 15-415/615 - DB Applications

580 views • 57 slides

Concurrency Control

Concurrency Control. Lecture 22 Ramakrishnan - Chapter 19. Review. DBMSs support concurrency, crash recovery with: ACID Transactions Log of operations A serial execution of transactions is safe but slow Try to find schedules equivalent to serial execution

301 views • 19 slides

Managing Hierarchies of Database Elements (18.6)

Managing Hierarchies of Database Elements (18.6). -Neha Saxena Class Id: 214. Two problems that arise with locks when there is a tree structure to the data are: When the tree structure is a hierarchy of lockable elements

254 views • 18 slides

Managing Hierarchies of Database Elements (18.6)

Managing Hierarchies of Database Elements (18.6). -Neha Saxena Class Id: 214. Two problems that arise with locks when there is a tree structure to the data are: When the tree structure is a hierarchy of lockable elements

265 views • 18 slides

Figure 15.2 Multiversion database.

Figure 15.1 Conflict table for a two-phase locking concurrency control. Conflicts between lock modes are denoted by X. Figure 15.2 Multiversion database. Figure 15.3 Conflict table for intention locks. Conflicts between lock modes are denoted X.

116 views • 4 slides