DR. PANKAJ DADHICH

Deadlock in DBMS

Deadlock in DBMS A deadlock is a condition where two or more transactions are waiting indefinitely for one another to give up locks. Deadlock is said to be one of the most feared complications in DBMS as no task ever gets finished and is in waiting for state forever. Deadlock conditions (Coffman conditions) Coffman specified four conditions for a dead…

Starvation in DBMS

Starvation in DBMS Starvation or Livelock is the situation when a transaction has to wait for an indefinite period of time to acquire a lock. Reasons for Starvation – · If the waiting scheme for locked items is unfair. ( priority queue ) · Victim selection. (the same transaction is selected as a victim repeatedly ) · Resource leak. · Via denial-of-…

Validation Based Protocol (optimistic concurrency control technique) in DBMS

Concurrency Control techniques in DBMS Multiple transactions executing at the same time on the same data may affect the result of the transaction. In order to maintain concurrent access to transactions, different protocols are introduced. Lock Based Protocol Time-Stamp Based Protocol Validation Based Protocol Validation…

Timestamp Ordering Protocol in DBMS

Concurrency Control techniques in DBMS Multiple transactions executing at the same time on the same data, it may affect the result of the transaction. In order to maintain the concurrent access of transactions, different protocols are introduced. Lock Based Protocol Time-Stamp Based Protocol Validation Based Protocol Ti…