Author: <span class="vcard">Anupreet Kalsi</span>

Whenever a deadlock is detected within transactions using any of the deadlock detection techniques, the deadlock must be recovered so that the transactions can perform their respective operations. The process…

Uncategorized

Whenever a deadlock occurs in DBMS it must be handled with care. DBMS Deadlock Handling involves preventing or avoiding deadlocks . The following approaches may be followed. Deadlock Prevention Approaches…

DBMS

Although concurrency control techniques ensure Serializability, it may at times lead to a situation known as deadlocks in database. Introduction – Deadlocks A deadlock can be defined as a situation…

DBMS

In the previous article, we had read that, transactions should be in a serializable schedule. But, testing for Serializability is computationally expensive and impractical. Hence, in order to ensure the…

DBMS

The main aim of multi user DBMS is to help in maximising the degree of concurrency in the system. But as the degree of concurrency increases there is a possibility…

DBMS

In DBMS when multiple users are allowed to access the same data at the same time it is referred to as Concurrency. The process to do this is called Concurrency…

DBMS

Transactions are not a single operation on the database but is a collection of operations which are performed on the database. Upon execution, these transactions transform the database from one…

DBMS

There are a different states of a transaction during its term of execution. A transaction can be in any one of the following states when it is executing: Active State:…

DBMS

As discussed in the previous post, a transaction in DBMS can be defined as a program which groups various operations to be performed on the database and executes this collection…

DBMS

DBMS