Distributed And Parallel Database Consistency Mechanism And Realization

Distributed and Parallel Database System (DPDBS) is the joint of distributed computing, Parallel Process, and Network technology. It is not only powerful at distributed data management, but also has well performance in parallel processing. With the extension of database application, the DPDBS has obtained more and more recognition. It has become one of the most active and promising research areas of computer science.DPSQL is a distributed and parallel database system developed by 8010 Research Lab. Based on the most popular open-source database system Mysql, it not only retains the high performance of Mysql itself, but also possesses most virtues of Distributed and Parallel Systems, such as high reliability, high availability, high throughput, large storage capability, etc.This thesis mainly research the consistency mechanism of distributed and parallel database, the consistency mechanism of database system can provide user normal database service. Lock mechanism of that concurrency control can effectively void the dead-lock , two phase commit can guarantee atomicity of the distribute transaction while distributed transaction is executed with which the consistency of the database system is guaranteed. The method of checking the inconsistent is mainly to track the update status of multiple repetitions when distributed and parallel database system is not busy, and to detect inconsistent early. Consequently, system can be recovered to best status. This method advances the usability of distributed and parallel database system.The balance of this thesis is organized as follows. In Chapter 1 this thesis review the progress of research on DDBMS. Then, In Chapter 2 the features of DDBMS and the conventional consistency mechanisms are discussed. Chapter 3 this thesis introduce the architecture of a quality DPDBS named DPSQL. Some implementation details also are discussed. Then this thesis designed and implemented the consistency mechanisms in DPSQL. In Chapter 4, performance test and analysis are also discussed. The last chapter makes expectation for the future research.