World's most popular travel blog for travel bloggers.

Issues in Concurrency Control

, , No Comments

Issues in Concurrency Control
Concurrency control is the process of managing simultaneous execution of transactions (such as queries, updates, inserts, deletes and so on) in a multiprocessing database system without having them interfere with one another.This property of DBMS allows many transactions to access the same database at the same time without interfering with each other.

Problems of Concurrency Control :

When concurrent transactions are executed in an uncontrolled manner, several problems can occur. 
The concurrency control has the following three main problems:
Lost updates.
Dirty read (or uncommitted data).
Unrepeatable read (or inconsistent retrievals).


Post a Comment

Let us know your responses and feedback