1 votes 1 votes As commit operations are ordered in each transcations, this schedule is recoverable right? Also please explain how to check for view serializabilty? Databases transaction-and-concurrency databases + – AnilGoudar asked Jan 11, 2018 AnilGoudar 1.0k views answer comment Share Follow See all 10 Comments See all 10 10 Comments reply Anu007 commented Jan 11, 2018 i edited by Anu007 Jan 11, 2018 reply Follow Share there is no write read so commit order does not matter and it is always recoverable. it is not view seralizable . 2 votes 2 votes AnilGoudar commented Jan 11, 2018 i edited by AnilGoudar Jan 11, 2018 reply Follow Share @Anu Sir, please explain, how to check for View serializability? 0 votes 0 votes Hemant Parihar commented Jan 11, 2018 reply Follow Share @Anu sir, I think it is not view serializable. T2 -> T3 -> T1 and T3 -> T2 -> T1. In both of these T1 will read the value x written by T2, while in the given schedule T1 will read the original value of x. 2 votes 2 votes Anu007 commented Jan 11, 2018 reply Follow Share sorry hemant i didnt saw the T1 read(x). yes this is not view searilizatble , if Read(x) not given then it is. 2 votes 2 votes Anu007 commented Jan 11, 2018 reply Follow Share Anil plz check here 1 votes 1 votes AnilGoudar commented Jan 11, 2018 reply Follow Share Thank You, Anu sir. 1 votes 1 votes Pawan Kumar 2 commented Jan 11, 2018 reply Follow Share Anu007 Sir,Hemant Parihar Sir ,Does this schedule has blind write ? I think it has....Kindly help sir T1 T2 T3 R(X) W(X) W(Y) W(Y) W(Y) C C C 0 votes 0 votes smsubham commented Jan 14, 2018 reply Follow Share Blind write: Writing without reading. So yes it has. 0 votes 0 votes Pawan Kumar 2 commented Jan 14, 2018 reply Follow Share so if a schedule has blind write .. it may or may not be view serializable depending upon initial read., read update and final write but if no blind write then it is definitely not view serializable ... Im i right? 1 votes 1 votes smsubham commented Jan 14, 2018 i moved by smsubham Jan 14, 2018 reply Follow Share Conflict serializable -> view serializable view serializable -> conflict serializable , unless we have at least one blind write operation 0 votes 0 votes Please log in or register to add a comment.