An Efficient Approach Concurrency Control in Database Management System: A Performance Analysis

The traditional pessimistic lock-based concurrency control mechanism which focuses on the data’s consistency and the transactions’ concurrency cannot meet the demand that the intime database systems make on the temporal consistency. This paper presents a new concurrency control method which is based on the locking, multi-version and single phase commit protocol concurrency control mechanisms, after the improvement of the concurrency control protocol for in-time transactions. Furthermore, we have adopted a method which is based on different concurrency control mechanisms according to the idiographic situation. In this way it can effectively improve the concurrency of transactions and increase the amount of the transactions completed within the deadline and through this database can make efficient.