Chapter 19, Problem 13PE

Explanation of Solution

Scheme for buffer handling:

• A snapshot protocol refers to a validation based multi-version concurrency protocol in which a transaction is provided with the snapshot of the database when it begins.
• A snapshot isolation protocol acquires exclusive locks on data items and releases them when transaction commit.
• The buffer handling scheme when transactions are provided a snapshot view of the pages in buffer is given below:
  • Initially, check if a transaction is updating the buffer currently...