0 votes 0 votes How to find number of conflict equivalent schedules possible :) Databases databases conflict-serializable + – gauravkc asked Feb 1, 2018 gauravkc 540 views answer comment Share Follow See all 6 Comments See all 6 6 Comments reply Show 3 previous comments srestha commented Feb 2, 2018 reply Follow Share can chk this https://gateoverflow.in/115201/number-of-schedules-conflict-equivalent-schedule 1 votes 1 votes raviyogi commented Feb 2, 2018 reply Follow Share ans is 56 1 votes 1 votes gauravkc commented Feb 2, 2018 reply Follow Share Thanks :) 0 votes 0 votes Please log in or register to add a comment.
Best answer 2 votes 2 votes SEE THIS raviyogi answered Feb 2, 2018 selected Feb 2, 2018 by gauravkc raviyogi comment Share Follow See all 4 Comments See all 4 4 Comments reply gauravkc commented Feb 2, 2018 reply Follow Share Thanks bro :) 1 votes 1 votes gauravkc commented Feb 2, 2018 reply Follow Share If view serializable is asked, we first see dependencies based upon two things - Rules of view serializibilty - Order of operations within the transaction itself Fix order with spaces between it for other operations. Check which operations can come anywhere and which can be shuffled maintaining the dependencies. Correct? 0 votes 0 votes raviyogi commented Feb 2, 2018 reply Follow Share bro this is procedure for finding conflict equall schedules , for findind view serilizable you have to consider final write condition only , like in above solution if u have to find view schedule then fix w3b that is final write and w1b and w2b can be interchanged . 0 votes 0 votes gauravkc commented Feb 2, 2018 reply Follow Share Okk.. Yes initial read and final write must be maintained and the read-write order on a variable. 1 votes 1 votes Please log in or register to add a comment.