in Databases
966 views
1 vote
1 vote
S:- r1(a) , w2(a) c2 w1(a) c1 w3(a) c3

Is this strict recoverable and serializable ? c1 means commit of transaction T1
in Databases
966 views

4 Comments

This is strict recoverable and serializable.

Kindly correct it if it is wrong.
1
1

Shreya kumari

To be precise, this schedule is:

1. View serializable but not conflict serializable

2. Strict recoverable schedule

1
1
View serializable because first read by T1 so T1 should be first in order final write by T3 so it should be last.

T1 T2 T3
0
0

Please log in or register to answer this question.