Research and Design of Distributed Database Synchronization System Based on Middleware

To solve the problem of data consistency in distributed database system based on Peer-to-Peer model, this paper designed a middleware-based database synchronization system. The system uses middleware to realize database synchronization, through the transaction management module, collision detection module, communication module, transaction execution module to complete the transaction capture, analysis, as well as matters of conflict detection and treatment. Experiment results show that the conflict be detected and treated at local, compared with the two-phase locking (2PL), middleware-based database synchronization system reduces the response time of the transaction, reducing unnecessary traffic, improve the performance of the system.