Two Phase Locking Protocol

Explain the concept of two phase locking protocol with an example?

Questions by veerun14   answers by veerun14

Showing Answers 1 - 2 of 2 Answers

rpeters83

  • Dec 8th, 2008
 

I'm no DB admin but I'll give it a shot. It's a protocol gauranteed to allow serialized actions on a database by having a locking phase and an unlocking phase. Meaning, during locking, no other transactions may be performed on the database until it is unlocked.

  Was this answer useful?  Yes

dhs01

  • Apr 15th, 2009
 

Not sure of the particular terminology but 2 phase locking I believe would be similar to 2 phase commit where you must first make sure that everybody involved is ready, able, and willing (phase 1) then the next phase is when it actually happens (phase 2).   

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions