0 votes 0 votes W1(X)R2(Y)R1(Y)R2(X) ? Is it view Serializable or Conflict or both ? Databases databases + – Dexter asked Apr 29, 2016 Dexter 568 views answer comment Share Follow See all 3 Comments See all 3 3 Comments reply ManojK commented Apr 30, 2016 reply Follow Share @srestha can u check this qus? 0 votes 0 votes srestha commented Apr 30, 2016 reply Follow Share yes I think it is both conflict serializable and also view serializable . there is a blind write W1(X) , so it is view serialzable Also we can tell any conflict serializable schedule is view serializable .rt? 1 votes 1 votes ManojK commented Apr 30, 2016 reply Follow Share AFAIK same concept . 1 votes 1 votes Please log in or register to add a comment.
0 votes 0 votes It is conflict searializable equivalent T1→T2 and also view searializable . ManojK answered Apr 29, 2016 ManojK comment Share Follow See all 6 Comments See all 6 6 Comments reply Dexter commented Apr 29, 2016 reply Follow Share Even i have solved same . But then i had a doubt , A view serializable is less restrictive as compared to conflict . All those View Serializable which are not conflict must have Blind write . While Conflict doesnt allow Blind write also . (That why CS is strict over VS) But here T1 is having Blind write . So i am confused ! 0 votes 0 votes ManojK commented Apr 29, 2016 reply Follow Share Conflict doesnt allow Blind write ???Is it? 0 votes 0 votes Dexter commented Apr 29, 2016 reply Follow Share Yes , https://gateoverflow.in/9429/problem-on-view-serializability ( a similar question ) https://en.wikipedia.org/wiki/Blind_write 0 votes 0 votes ManojK commented Apr 29, 2016 reply Follow Share but here it is conflict.and according to source Any view serializable schedule that is not conflict serializable must contain a blind write. 0 votes 0 votes Dexter commented Apr 29, 2016 reply Follow Share i said the same above 0 votes 0 votes ManojK commented Apr 29, 2016 reply Follow Share what r thinking in above prblm ? what it should not be? 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes Here as no cycle is form in dependency graph,so it is conflict serializable... Aboveallplayer answered Apr 30, 2016 Aboveallplayer comment Share Follow See all 0 reply Please log in or register to add a comment.