Question: Problem 1 . Transaction management. Ri ( x ) refers to transaction Ti reading item x and Wj ( y ) refers to transaction Tj

Problem 1. Transaction management. Ri(x) refers to transaction Ti reading item x and Wj(y) refers to transaction Tj writing item y. For each schedule below:
a) S1: R1(x) R1(y) R2(y) R2(x) W1(z) W2(z) W1(x) W2(y)
b) S2: R1(x) R2(y) R2(x) W2(z) W1(x) W1(z) W2(y)
[20+20 points] Prove whether or not it is conflict serializable
[10+10 points] If it is serializable write down an equivalent serial schedule. If it is not serializable explain why not
Problem 2.[20+20 points] Assuming the 2PL protocol is in place, prove the presence/absence of deadlocks for each one of the previous schedules

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!