My 2 Cents What Is Concurrency Control?

Swati Mishra

Content Writer
In database management system it is possible to multiple transaction can be executed simultaneously and it is important to control the concurrency of transaction, it means transaction of multiple database executed with same time and can access the same data.

We can divide the concurrency control in two parts which are:

Lock based Protocols
Time stamp based Protocols
 

steve taylor

White Belt
Concurrency means simultaneous excess of data from the database. if there are more user access the data from the database at the same time then there is a chance of data record may be goes into inconsistent state this results in error.To prevent database from inconstancy. There are some currency control mechanism are there which is used for control the in-contingency of the database these are time stamp ordering protocol and lock protocol.
 

VIVEK KUMAR

White Belt
Database stored the huge amount of data that may be accessed by the more than one people. When single file are accessed by the more than one users then there is a chance of inconstancy of data. Inconsistency means Incorrect data.
Example-
Let two friends are go to library for book. There are only one book available . One of them are take a book but not update the book count value. In this condition second one check for book availability then there are still one book are available logicaly but it is physically not available. It is known as inconsistency of data.
 
Top