1 votes 1 votes T1: r1(x)w1(x)r1(y)w1(y) T2: r2(y)w2(y) L is xclusive lock and U is unlock L1(y)L1(X)R1(Y)W1(Y)R1(X)W1(X)U1(X)U1(Y)L2(Y)R2(Y)W2(Y)U2(Y)? IS THIS SCHEDULE VALID UNDER A 2 PHASE LOCKING SCHEDULER???? Databases 2phaselocking transaction-and-concurrency databases + – Shivam Gupta 3 asked Aug 3, 2017 Shivam Gupta 3 619 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 votes THIS SCHEDULE IS NOT VALID BECAUSE IN 2 PHASE LOCKING AFTER EXECUTING SHRINKING PHASE NO LOCK OPERATION CAN WE PERFORM ALL LOCK OPERATION PERFORM IN GROWING PHASE. Mritunjay Ashish answered Sep 13, 2019 Mritunjay Ashish comment Share Follow See all 0 reply Please log in or register to add a comment.