Introduction to Concurrency Control

INTRODUCTION TO CONCURRENCY CONTROL

Concurrency control is the procedure in DBMS for managing simultaneous operations without conflicting with each another. Concurrent access is quite easy if all users are just reading data. There is no way they can interfere with one another. Though for any practical database, would have a mix of reading and WRITE operations and hence the concurrency is a challenge.

Concurrency control is used to address such conflicts which mostly occur with a multi-user system. It helps you to make sure that database transactions are performed concurrently without violating the data integrity of respective databases.

Therefore, concurrency control is a most important element for the proper functioning of a system where two or multiple database transactions that require access to the same data, are executed simultaneously.

Check out this video lecture, for more info on concurrency control


More topics from DBMS to read:

References:

  1. Korth, Silbertz,Sudarshan, “Fundamental of Database System”, McGraw Hill
  2. Atul Kahate , “ Introduction to Database Management System”, Pearson Educations