3 votes 3 votes Why is Blind write necessary for a view serializable schedule that is not conflict serializable? Databases transaction-and-concurrency view-serializable + – Saurabh1997 asked Dec 24, 2018 • edited Dec 24, 2018 by Shaik Masthan Saurabh1997 968 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
1 votes 1 votes > If it's conflict serializable then it's also view serializable. > If not Conflict serializable then: { If there is Blind Write then check if View Serializable or not. If there is no Blind Write then definitely not View Serializable. } ShamikBanerjee answered Jun 17, 2019 ShamikBanerjee comment Share Follow See all 0 reply Please log in or register to add a comment.
–1 votes –1 votes It is not necessary condition for view serializable, only if u find a schedule which is not conflict serializable u go for checking whether it is view serializable or not . If Blind write is there then it may or may not be view serializable. maddy0101 answered Dec 25, 2018 maddy0101 comment Share Follow See all 4 Comments See all 4 4 Comments reply rawan commented Dec 25, 2018 reply Follow Share From the textbook by Silberschatz: Blind writes appear in any view-serializable schedule that is not conflict serializable. Does this mean if it is a view serializable schedule but not conflict serializable, then it must have a blind write? Is the word 'any' above replaceable by 'all' without changing the meaning of the sentence? 1 votes 1 votes Shaik Masthan commented Dec 30, 2018 reply Follow Share check this https://gateoverflow.in/106187/go-17-mock-1-25 1 votes 1 votes rawan commented Dec 30, 2018 reply Follow Share Thanks, that not only cleared my doubt, but also the doubt that followed from it :) "Are there conflict serializable schedules that contain blind writes?" The answer is yes. 0 votes 0 votes Shaik Masthan commented Dec 30, 2018 reply Follow Share Does this mean if it is a view serializable schedule but not conflict serializable, then it must have a blind write? yes Is the word 'any' above replaceable by 'all' without changing the meaning of the sentence? yes "Are there conflict serializable schedules that contain blind writes? yes 1 votes 1 votes Please log in or register to add a comment.