IMPROVEMENT ON CONCURRENCY CONTROL IN A DISTRIBUTED DATABASE

IMPROVEMENT ON CONCURRENCY CONTROL IN A DISTRIBUTED DATABASE

ABSTRACT

The study was conducted of the Improvement on concurrency control in a distributed database. The objectives of the study are to ensure consistent and correct transaction, efficient data collection and management and recoverability of data in a distributed database. The Mysql relational database was employed in collecting data for concurrency control protocols. The Unified Modeling Language (UML) was used in creating the use case, sequence diagram, class diagram and contract for the sequence diagram. Petri-nets a graphical tool for the analysis of sequence of operations in the distributed database was also used in this thesis. Finally MATLAB was applied to simulate the operation of concurrency control protocol in a distributed database. The result obtained from the improved concurrency control in a distributed database as developed in this thesis showed an improvement of 55% over the existing method of concurrency control in a distributed data base.