Analytical Comparison of Concurrency Control Techniques

In database management system, there always comes a time where we need to execute various transactions simultaneously, and thus the database consistency must be maintained. The way to make sure that this consistency between the shared databases is maintained is to use concurrency control techniques. Most of the concurrency control techniques are developed using the serializability property in mind. The serializability property makes sure that the accessed data is in the manner of mutual exclusion, meaning that whenever one transaction is accessing a data, other transaction will not be able to access the same data. This paper deals with another viewpoint of various concurrency control techniques, there comparison based on the data obtained practically. Furthermore, a comparison of pessimistic, optimistic, multiversion, and two-phase locking techniques is done. We have set up an environment to analyze the performance and compare these techniques analytically.