Question: Consider the three transactions T 1 , T 2 , and T 3 , and the schedules S 1 and S 2 given below. T

Consider the three transactions T1, T2, and T3, and the schedules S1 and S2 given below.
T1: r1(x); r1(z); w1(x)
T2: r2(z); r2(y); w2(z); w2(y)
T3: r3(x); r3(y); w3(y)
S1: r1(x); r2(z); r1(z); r3(x); r3(y); w1(x); c1; w3(y); r2(y); c3; w2(z); w2(y); c2
S2: r1(x); r2(z); r1(z); r3(x); r3(y); w1(x); r2(y); w3(y); w2(z); w2(y); c1; c2; c3
Notes: r1(x) represents transaction 1 read x; w2(y) represents transaction 2 write y; c3 represents transaction 3 commits.
1. Draw the serializability graphs for S1 and S2 and state whether each schedule is serializable or not. If a schedule is serializable, write down the equivalent serial schedule(s).[20 marks]
2.Determine whether the schedules S1 and S2 are strict, cascadeless, recoverable, or nonrecoverable. [20 marks]

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 Programming Questions!