Time stamp ordering ensure both conflict serializability & freedom from deadlock - Database

Q.  Which is the concurrency control protocol that ensure both conflict serializability and freedom from deadlock? (Database)
- Published on 25 Aug 15

a. Time stamp ordering
b. 2 - phase locking
c. Both A and B
d. Neither A nor B

ANSWER: Time stamp ordering
 

    Discussion

  • Nirja Shah   -Posted on 04 Nov 15
    2 Phase Locking (2PL)
    - It is a concurrency control method that guarantees serializability.
    - This protocol utilizes the 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.
    - It may be lead to deadlocks that result from the mutual blocking of two or more transactions.

    Timestamp-based concurrency
    - It is a control algorithm which is a non-lock concurrency control method.
    - In this method, deadlock cannot occur as no transaction ever waits.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)