ProAnswers.org

What are different types of two phase lockings (2pl)?

  1. Basic

  2. Conservative

  3. Strict

  4. Rigorous

this is the basic technique of 2pl described above.

Conservative 2pl requires a transaction to lock all the items it accesses before the transaction begins its execution, by pre-declaring it’s read-set and write-set.

Strict 2pl guarantees that a transaction doesn’t release any of its exclusive locks until after it commits or aborts.

Rigorous guarantees that a transaction doesn’t release any of its locks (including shared locks) until after it commits or aborts.