1 votes 1 votes S:- r1(a) , w2(a) c2 w1(a) c1 w3(a) c3 Is this strict recoverable and serializable ? c1 means commit of transaction T1 Databases databases transaction-and-concurrency strict-schedule + – rahul sharma 5 asked Dec 16, 2017 rahul sharma 5 1.0k views answer comment Share Follow See all 10 Comments See all 10 10 Comments reply Anu007 commented Dec 16, 2017 i edited by Anu007 Dec 16, 2017 reply Follow Share yes STRICT Recoverable , yes it is view serializable order T1-> T2-> T3 0 votes 0 votes rahul sharma 5 commented Dec 16, 2017 reply Follow Share why serial order , T1-> T3-> T2? Final write by T3 on A should be there? 0 votes 0 votes Anu007 commented Dec 16, 2017 reply Follow Share yes .... only one order. 0 votes 0 votes srestha commented Dec 16, 2017 reply Follow Share yes strict, but not conflict or view serializable As there is blind write but no dirty read 0 votes 0 votes rahul sharma 5 commented Dec 16, 2017 reply Follow Share @srestha.It is view serializable.See the order given by @Anu007 0 votes 0 votes srestha commented Dec 16, 2017 reply Follow Share a schedule is view serializable, if it is view equivalent to some serial schedule Is the given schedule is serial schedule? 0 votes 0 votes srestha commented Dec 16, 2017 reply Follow Share If dirty read satisfies, it will be not strict right? 0 votes 0 votes Shreya kumari commented Dec 22, 2017 reply Follow Share This is strict recoverable and serializable. Kindly correct it if it is wrong. 1 votes 1 votes srivivek95 commented Dec 22, 2017 reply Follow Share @ Shreya kumari To be precise, this schedule is: 1. View serializable but not conflict serializable 2. Strict recoverable schedule 1 votes 1 votes Ram Swaroop commented Sep 26, 2019 reply Follow Share 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 votes 0 votes Please log in or register to add a comment.
