2 Phase-Locking 2. Consider the timeline of the schedule shown below, T1 T2 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...


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

Extracted text: 2 Phase-Locking 2. Consider the timeline of the schedule shown below, T1 T2 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 TI aborts (replace e 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).

Jun 10, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here