Parallel processing is very useful in database management. The parallelization of database operations enable the database related activities to speed up and allow faster responses as more transactions are carried…
Category: <span>DBMS</span>
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…
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…
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…
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…
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…
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…
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:…
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…
Before we delve into the discussion of Transaction and Concurrency Control, let’s understand its context. In today’s times when most of the work is done on computers there are certain…