1
$\begingroup$

While going through the DBMS book by Korth, it was mentioned :

" For a set of transactions, there may be conflict-serializable schedules that cannot be obtained through the two-phase locking protocol.

Does this imply that basic 2 PL ensures serializability but does not always ensure conflict serializability ?

$\endgroup$
2
$\begingroup$

No,

If you use 2PL protocol you are guaranteed to have a conflict-serializable schedule but there are conflict serializable schedules which may not honour 2 PL protocol i.e. locking data items in the growing phase and releasing them in the shrinking phase.

$\endgroup$
  • $\begingroup$ Thnk u 4 da answer. $\endgroup$ – mahesh 2222 Aug 29 '19 at 6:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.