in Databases
3,364 views
1 vote
1 vote
Consider the transactions T1, T2, T3 with the following schedule S:

S : T1: Read (x); T2: Read (z); T1:Read(z);

    T3:Read(x);T3:Read(y); T1:Write(x);

    T3:Write (y);T2:Read(y);

     T2:Write(z); T2:Write(y)

If the schedule S is serializable, the equivalent serial schedule is ____.

  i am getting T3T1T2 but answer given is T3T2T1
in Databases
by
3.4k views

1 comment

$T_3 \rightarrow T_1 \rightarrow T_2$ is correct
1
1

1 Answer

1 vote
1 vote
Best answer
$T_{1}$ $T_{2}$ $T_{3}$
R(X)    
  R(Z)  
R(Z)    
    R(X)
    R(Y)
W(X)    
    W(Y)
  R(Y)  
  W(Z)  
  W(Y)  

 

selected by