When a transaction is rolled back under timestamp ordering, it is assigned a new timestamp. Why can it not simply keep its old timestamp?
Answer to relevant QuestionsIn multiple-granularity locking, what is the difference between implicit and explicit locking?For each of the following protocols, describe aspects of practical applications that would lead you to suggest using the protocol, and aspects that would suggest not using the protocol:• Two-phase locking• Two-phase ...Explain the difference between the three storage types—volatile, nonvolatile, and stable—in terms of I/O cost.Explain how the buffer manager may cause the database to become inconsistent if some log records pertaining to a block are not output to stable storage before the block is output to disk.Instead of storing shared structures in shared memory, an alternative architecture would be to store them in the local memory of a special process, and access the shared data by interprocess communication with the process. ...
Post your question