Give Simple Please Example Schedule Concurrent Transactions Permissible Snapshot Isolation Q37171795

  1. Give a simple (please!) example of a schedule of concurrenttransactions permissible under snapshot isolation for which is itimpossible to insert lock/unlock steps following 2PL withoutreordering the steps of the schedule.

    Note that the “trick” here is that snapshot isolation keepsmultiple versions of data items in certain cases allowing atransaction to read a version that is older than the currentversion.


Answer


Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.