HYBRIDIZED CONCURRENCY CONTROL TECHNIQUE FOR TRANSACTION PROCESSING IN DISTRIBUTED DATABASE SYSTEM

Concurrency control has been actively investigated for the past several years and two-phase locking used as a standard solution for transaction processing in a database management system but the system is saturated with conflicts due to frequent rollbacks, long time waiting and blocking, high rate of aborted transactions that leads to deadlock. Hence to solve these problems, this paper presented a hybridized concurrency control technique which combines two phase locking and timestamp ordering. This technique will enhance the performance of the concurrency control techniques for transaction processing in a distributed database management system. This work is developed in ASP.Net using C# programming language as the front end and Microsoft SQL Server 2008 as the back end that is the database. Our result shows that two-phase locking and timestamp ordering is slow, time consuming during execution while our hybridized approach optimizes faster and consumed less time. This approach will give confidence to database administrators when handling concurrency transactions and make them deliver their work timely.