Question: 2 Phase-Locking 2. Consider the timeline of the schedule shown below, T2 Ti R(X) R(Y) W (X) R(Z) R(Z) W (Y) R(Y) W(Y) W (X)

 2 Phase-Locking 2. Consider the timeline of the schedule shown below,

2 Phase-Locking 2. Consider the timeline of the schedule shown below, T2 Ti R(X) R(Y) W (X) R(Z) R(Z) W (Y) R(Y) W(Y) W (X) a. Show the schedule after applying regular 2PL with read/write locks. If there is a deadlock indicate it, otherwise specify the equivalent serial schedule. (Note: in regular 2PL, unneeded locks are released as soon as the growing phase ends) b. Show the schedule after applying 2PL-Strict with read/write locks. If there is a deadlock indicate it, otherwise specify the equivalent serial schedule. C. Assume instead Tl aborts (replace c with a in the schedule above), apply 2PL and 2PL- strict and indicate what is the results for both cases (i.e., both transactions abort, or T2 commits)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!