|< < 16 > >|

Strict Two-Phase Locking

Two-phase

If locking is two-phase:

T1 T2
X(A)
R(A)
W(A)
X(A)
X(B)
R(B)
W(B)
U(B)
U(A)
X(B)
R(A)
commit
W(A)
R(B)
W(B)
U(B)
U(A)
commit

  • All unlocks moved to the end of each transaction.

  • 2PL has introduced a delay in T2 resulting in a serializable schedule.

|< < 16 > >|