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

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

2 Phase-Locking 2. Consider the timeline of the schedule shown below, TI T2 R (X) R(Y) W(X) R(2) R(2) W(Y) R(Y) W (Y) W(X) 4. 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 T1 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!