16:I[96247,["60901","static/chunks/a93b707c-e0d4e3ec9b5d0d40.js","90939","static/chunks/c6b276f6-8f45a7d62a1c123d.js","1921","static/chunks/79812939-293f59e6857c36ee.js","34726","static/chunks/8777d6a5-1ee38c8cc2861f8c.js","73222","static/chunks/73222-2df06011cda90776.js","80785","static/chunks/80785-8f37fb6aaf555b83.js","31829","static/chunks/31829-17dd9b9d28a68f0c.js","63712","static/chunks/63712-c15d68eb2916c00c.js","84334","static/chunks/84334-e76ece763e63c963.js","73761","static/chunks/73761-ecd62f2dab95bcd2.js","74588","static/chunks/74588-7c4e5ca1202759a4.js","15611","static/chunks/15611-c3c51f0b96db5f8c.js","41033","static/chunks/41033-6bc8c1315d862e40.js","51182","static/chunks/51182-2ca762ae83faa0d3.js","58406","static/chunks/58406-eb654203f92a178b.js","41235","static/chunks/41235-4908e48da1060101.js","67740","static/chunks/67740-fdcdd8da52f234b6.js","88702","static/chunks/88702-f931fd8eec80b054.js","66651","static/chunks/66651-ce19d1885e4ab3ac.js","19864","static/chunks/19864-9fed3e3a8915e610.js","5262","static/chunks/5262-6838d9b739eebb54.js","72470","static/chunks/72470-5454836339ddd1e8.js","57757","static/chunks/57757-b4b343a58ff6e3ac.js","70642","static/chunks/70642-a7c0688be693616c.js","49290","static/chunks/49290-cb6905322d5b363d.js","14116","static/chunks/14116-adb978fc51d2d4c0.js","22250","static/chunks/app/(free)/%5Bcategory-slug%5D/%5Barticle-slug%5D/page-0bc1f676845ac8fd.js"],"default"] 18:I[18185,[],"IconMark"] 17:Tbf3,

Concurrency Control in Database Management System is a procedure of managing simultaneous operations without conflicting with each other. It is required for controlling the concurrent execution of the operations on a database. Concurrency control is the working concept that is required for controlling and managing concurrent execution of database operations and thus avoiding the inconsistencies in the database. Therefore, for maintaining concurrency we have concurrency control protocols.

Concurrency Control Protocols

In the present scenario of a multiprogramming environment where multiple transactions can be executed simultaneously, it is highly important to control the concurrency of transactions. Therefore, for this, we have concurrency control protocols to ensure atomicity, isolation, and serializability of concurrent transactions.

Concurrency Control Protocols can be broadly classified into two main categories:-

Lock-based concurrency control Protocol
TimeStamp-based concurrency control Protocol

Lock based concurrency control Protocol

Database systems equipped with lock-based protocols use a mechanism by which any transaction cannot read or write data until it acquires an appropriate lock on it.

Locks are of two types:

Shared lock: In this, the data can only be read by transaction therefore it is also known as a read-only lock.
Exclusive lock: In this lock, the data item can be both reads as well as written by the transaction.

There are four types of Lock Protocols :

Simplistic Lock Protocol
Pre-claiming Lock Protocol
Two-phase locking (2PL)
Strict Two-phase Locking (Strict 2-PL)

TimeStamp-based concurrency control Protocol

The TimeStamp-based concurrency Control Protocol