Register

In a strict 2 phase locking protocol

371 views

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

1 votes
1 votes
1 answer
3
Kushagra Gusain asked Sep 7, 2017
1,004 views
Serializability and 2 phase locking protocol
Why is cascading rollback possible in 2 phase locking protocol, we know it guarantee serializability and serializable schedule are strict, which implies it is cascadeless? Please clear the doubt and correct me.
Why is cascading rollback possible in 2 phase locking protocol, we know it guarantee serializability and serializable schedule are strict, which implies it is cascadeless...
User Avatar
1 votes
1 votes
1 answer
4
Shivam Gupta 3 asked Aug 3, 2017
633 views
DBMS: CONCURRENCY CONTROL 2 PHASE LOCKING PROTOCOL
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????
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 PH...
User Avatar
Link Copied!