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

• Growing
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  Growing Phase : Transaction may obtain locks , but may not release any lock.
  Shrinking Phase : Transaction may release locks, but may not obtain any new locks.
• 9 years agoHelpfull: Yes(1) No(1)
• In databases and transaction processing, two-phase locking (2PL) is a concurrency control method that guarantees serializability.[1][2] It is also the name of the resulting set of database transaction schedules (histories). The protocol utilizes locks, applied by a transaction to data, which may block (interpreted as signals to stop) other transactions from accessing the same data during the transaction's life.
  
  By the 2PL protocol locks are applied and removed in two phases:
  
  Expanding phase: locks are acquired and no locks are released.
  Shrinking phase: locks are released and no locks are acquired.
• 8 years agoHelpfull: Yes(1) No(0)
• Strict two phase locking
  Strong strict two phase locking
  
• 9 years agoHelpfull: Yes(0) No(1)
• expending,shrinking
• 9 years agoHelpfull: Yes(0) No(0)