Implementing Concurrency Control


Technical definition for Concurrency is the ability of a database management system to allow multiple users to access data at the same time while maintaining the integrity and consistency of the data. In other words, Concurrency control deals with the issues involved with allowing multiple users simultaneous access to shared entities, objects, data records, or some other representation.

To understand and implement the concurrency control you need to understand the transactions, detecting and understanding cause of concurrency such as deadlocks, lock timeouts etc. This helps you to understand and implement the concurrency control in your system as well as avoid retrieving the Dirty reads, Phantom reads.Concurrency control ensures the transactions in the database occur in an orderly manner.The main job of these control is to maintain the data consistency and integrity. Technically concurrency must preserve the four characteristics of database transactions: ACID (Atomicity, Isolation, Consistency and Durability). You may find different ways to control the concurrency but Alex Kuznetsov has written a very good explanatory article on Developing Modifications that Survive Concurrency.

I hope you like it. Enjoy reading 🙂 !

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s