1 votes 1 votes check whether it is view serializable or not? schedule S:R1(X),W2(X),W1(X) Databases view-serializable + – ajit asked Apr 10, 2015 ajit 5.5k views answer comment Share Follow See 1 comment See all 1 1 comment reply Bhagirathi commented May 30, 2015 reply Follow Share Not view serializable as it violates the first point which says if transaction ti reads the initial value of x then transaction tj must read the initial value of x. But instead of that transaction t2 has started writing x without reading it Can it be concluded like this 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes its not a view serilizable..because if read t1 the t2 can also read the transaction.. pawankumartiwari answered Jun 11, 2015 pawankumartiwari comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 votes SCHEDULE IS VIEW SERIALIZABLE BUT NOT CONFLICT SERIALIZABLE SCHEDULE vijju answered Sep 23, 2016 vijju comment Share Follow See all 0 reply Please log in or register to add a comment.
–2 votes –2 votes 1.NO since there is a cycle in dependency graph _xor_ answered Apr 13, 2015 _xor_ comment Share Follow See 1 comment See all 1 1 comment reply Digvijay Pandey commented Apr 16, 2015 reply Follow Share cycle in dependency graph just giving information that schedule us NOT CONFLICT SERIALIZABLE.. but der is a possibility that schedule is VIEW SERIALIZABLE.. so checking cycle in dependency graph doesn't guaranty non serialization.. additionally Checking schedule is Serializable or not is NPC and Cycle detection in dependency graph is P problem.. 2 votes 2 votes Please log in or register to add a comment.