What benefit does rigorous two-phase locking provide? How does it compare with other forms of two-phase locking?
Answer to relevant QuestionsMost implementations of database systems use strict two-phase locking. Suggest three reasons for the popularity of this protocol.Consider the following graph-based locking protocol that allows only exclusive lock modes, and that operates on data graphs that are in the form of a rooted directed acyclic graph.• A transaction can lock any vertex ...Use of multiple-granularity locking may require more or fewer locks than an equivalent system with a single lock granularity. Provide examples of both situations, and compare the relative amount of concurrency allowed.Devise a timestamp-based protocol that avoids the phantom phenomenon.Consider a database consisting of 10 consecutive disk blocks (block 1, block 2, . . ., block 10). Show the buffer state and a possible physical ordering of the blocks after the following updates, assuming that shadow paging ...
Post your question