1 votes 1 votes Is the schedule given below View serializable or not ? explain with poly graph ? S: R1(a) W2(a) W1(a) hitendra singh asked Nov 30, 2018 • reshown Nov 30, 2018 by hitendra singh hitendra singh 1.6k views answer comment Share Follow See all 10 Comments See all 10 10 Comments reply Show 7 previous comments Lakshman Bhaiya commented Nov 30, 2018 reply Follow Share @srestha ma'am All Conflict serializable schedule are also view serializable but reverse need not be true. In given question, it does not conflict serializable, so we can't directly say anything about view serializable. 0 votes 0 votes himgta commented Nov 30, 2018 reply Follow Share not view serializable ...in the polygraph there is a cycle! 0 votes 0 votes srestha commented Dec 1, 2018 reply Follow Share https://www.gatevidyalay.com/view-serializability-in-dbms/ yes @akash.dinkar12 0 votes 0 votes Please log in or register to add a comment.
Best answer 2 votes 2 votes For checking Conflict serializable or not, go with precedence graph and For checking View serializable or not, go with poly graph. Lakshman Bhaiya answered Nov 30, 2018 • selected Dec 1, 2018 by srestha Lakshman Bhaiya comment Share Follow See all 4 Comments See all 4 4 Comments reply hitendra singh commented Nov 30, 2018 reply Follow Share how are making this polygraph , can u please elaborate ? Are u adding dummy transaction before and after the transactions? 0 votes 0 votes Lakshman Bhaiya commented Nov 30, 2018 reply Follow Share see this it might be helpful https://gateoverflow.in/185820/draw-polygraph-of-this-check-for-view-serializability https://djitz.com/neu-mscs/how-to-check-for-view-serializable-and-conflict-serializable/ 0 votes 0 votes Deepanshu commented Dec 1, 2018 reply Follow Share Lakshman Patel RJIT bro plzz one time cross check u r in wrong direction for this question 0 votes 0 votes Lakshman Bhaiya commented Dec 1, 2018 reply Follow Share @ Deepanshu where? 0 votes 0 votes Please log in or register to add a comment.