1 votes 1 votes Whether the given schedule is conflict serializable or view serializable or none. Databases databases transaction-and-concurrency ace-test-series + – Kai asked Jan 29, 2017 edited Mar 6, 2019 by ajaysoni1924 Kai 877 views answer comment Share Follow See all 9 Comments See all 9 9 Comments reply Show 6 previous comments Samujjal Das commented Jan 29, 2017 reply Follow Share In your last link, in all the examples, the commit statements are at the last. So those are not good counter examples. See this. Explained. https://gateoverflow.in/100871/precedence-graph 1 votes 1 votes Kai commented Jan 29, 2017 reply Follow Share I understand. But if possible can you give some reason why this happens? I mean if you consider the given question it does actually matter whether Write A of T2 is after read of T1 or not. Do you have any idea about why introduction of commit changes things? 0 votes 0 votes Samujjal Das commented Jan 30, 2017 reply Follow Share @asdfghjk I am not aware of the reason. Sorry!! 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes View Serialzble bad_engineer answered Jan 29, 2017 bad_engineer comment Share Follow See 1 comment See all 1 1 comment reply zorojuro commented Sep 11, 2022 reply Follow Share How this is view serializable. t2 is dependent on t1 since intial read is performed by t1 , but t2 commits before t1. 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes there is no cycle is precedence graph of this schedule , hence it is conflict serializable. but every conflict is also view serializable . therefor OPTION – C sachin486 answered Nov 29, 2020 sachin486 comment Share Follow See all 0 reply Please log in or register to add a comment.