1,547 views
0 votes
0 votes

anyone who can solve this  by this methos i think it has some mistakes ?

1 Answer

Best answer
2 votes
2 votes

Rules of View serializability,

  1. Whichever Transaction performs Read first on variable let say X, It must perform read first on variable X in the Serial schedule.
  2. Whichever Transaction performs Write last on variable let say X, It must perform write last on variable X in the Serial schedule.
  3. meanwhile Producer Consumer i.e. Write $\rightarrow $ Read conflict also should match in Serial Schedule.

Now in your question, T4 is writing last so T4 should be last in serial schedule too and T2 is reading first so T2 should be first in the serial schedule.

I am not solving the whole question but your serial schedule looks like T2 $\rightarrow$ . . . other . . .$\rightarrow$ T4. Now check for the 3rd rule.

selected by

Related questions

1 votes
1 votes
1 answer
1
shreejeetp asked Dec 14, 2018
307 views
Is every serializable schedule view serializable?, or like conflict serializable, there could be a serializable schedule which isn’t view serializable?
1 votes
1 votes
1 answer
2
Na462 asked Jan 13, 2019
1,522 views
Consider following Schedule S with data item x :S : W1(X) R2(X) W3(X) R4(X) W5(X) R6(X) W7(X) R8(X) W9(X) R10(X)The number of schedule view equivalent to Schedule S but n...
0 votes
0 votes
0 answers
3
Abhisek Tiwari 4 asked Dec 15, 2018
171 views
Can you please suggest some good resources to understand ‘How to draw Polygraph’ to check VSwhat is extra Constraint that we have to manage in polygraph compare to Pr...
2 votes
2 votes
1 answer
4