GATE CSE
First time here? Checkout the FAQ!
x
+1 vote
94 views
Sort these various versions of Two Phase locking protocols in increasing order of restricted-ness:

1. 2-PL(normal)

2. S-2PL(Strict)

3. R-2PL(Rigorous)

4. C-2PL (Conservative)

5. LC-2PL(Lock Conversion)
asked in Databases by Active (1.3k points)   | 94 views

1 Answer

+1 vote
Normal < Conservative < Strict < Rigorous.

1) In Rigorous 2PL, a transaction does not release any of it's locks until after it commits.

2) In Strict 2PL, a transaction does not release any of it's exclusive lock until after it commits.

This makes R-2PL more strict than S-2PL.

3) Conservative 2PL has no such lock release restrictions.

4) And Normal 2PL is the simplest one.
answered by Junior (753 points)  
What about lock-conversion 2PL,i.e upgrading(shared to exclusive) and downgrading(exclusive to shared) of locks?


Top Users Sep 2017
  1. Habibkhan

    7096 Points

  2. Warrior

    2574 Points

  3. Arjun

    2412 Points

  4. rishu_darkshadow

    2402 Points

  5. A_i_$_h

    2204 Points

  6. nikunj

    1980 Points

  7. manu00x

    1846 Points

  8. makhdoom ghaya

    1760 Points

  9. Bikram

    1744 Points

  10. SiddharthMahapatra

    1718 Points


26,115 questions
33,691 answers
79,843 comments
31,098 users