locking mechanism

In databases and transaction processing, two-phase locking (2PL) is a concurrency control method that guarantees serializability.
It is also the name of the resulting set of database transaction schedules (histories). The protocol uses 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.Two types of locks are used by the basic protocol: Shared and Exclusive locks. Refinements of the basic protocol may use more lock types. Using locks that block processes, 2PL may be subject to deadlocks that result from the mutual blocking of two or more transactions.

View More On Wikipedia.org
  1. D

    No Charge flap open detection?

    Very nearly drove off with the Charge Flap open yesterday, it was only because a neighbour said something as I was pulling out that I noticed. Kind of surprised the car didn't warn that this was the case, is there no sensor on the locking mechanism? This is the pre-facelift 5
Back
Top Bottom