0 votes 0 votes Which of the following 2PL schemes guarantee conflict serializability? Basic 2PL Conservative 2PL Strict 2PL Rigorous 2PL Databases transaction-and-concurrency concurrency + – Aghori asked Dec 3, 2016 edited Dec 3, 2016 by Aghori Aghori 993 views answer comment Share Follow See 1 comment See all 1 1 comment reply iita commented Dec 3, 2016 reply Follow Share For details you can see this..https://en.wikipedia.org/wiki/Two-phase_locking 1 votes 1 votes Please log in or register to add a comment.
0 votes 0 votes Any schedule which is possible under 2-PL scheme ensures conflict serializability iita answered Dec 3, 2016 iita comment Share Follow See all 5 Comments See all 5 5 Comments reply Aghori commented Dec 3, 2016 reply Follow Share https://gateoverflow.in/?qa=blob&qa_blobid=13437144873558516789 But KORTH says this. 0 votes 0 votes Akriti sood commented Dec 3, 2016 reply Follow Share i am also having confusion in this thing.one thing that is sure is every conflict serializable schedule is not possible in basiz /strict/rigorous 2pl. but i have also read somewhere that basic 2pl ensures conflcit serializability but can suffer from deadlock. T1 T2 T3 sh(A) r(a) sh(B) r(B) sh(C) r(C) x(D) w(D) rel(C) rel(D) x(C) w(C) rel(B) rel(C) x(B) w(B) rel(A) basic 2pl schedule ensures conflict serilizability as t3 -> t2 -> t1 0 votes 0 votes Aghori commented Dec 3, 2016 reply Follow Share Meanwhile got it. 2PL guaranteed conflict serializable schedule are proper set of conflict serializable schedules. i.e every 2PL schedule is conflict serializable but every serializable schedule is not to be ensured by 2PL. 0 votes 0 votes Akriti sood commented Dec 3, 2016 reply Follow Share ok..thnaks for confirming.and what about uther 2pl??do they ensure conflcit serializabiltiy?? 0 votes 0 votes Aghori commented Dec 3, 2016 reply Follow Share All 2PL schemes guarantee conflict serializability. 0 votes 0 votes Please log in or register to add a comment.