分布式数据库同步中间件系统的设计与研究  

Research and design of distributed database synchronization system based on middleware

作　　者：王珏[1] 孟晓蕊[2] 

机构地区：[1]镇江船艇学院,江苏镇江212000 [2]洛阳广播电视大学,河南洛阳471000

出　　处：《现代电子技术》2016年第9期31-36,共6页Modern Electronics Technique

基　　金：青年科学基金:基于多核系统多维限制的节能实时调度研究(61402527)

摘　　要：针对分布式数据库系统中对等模式下副本一致性的问题,设计了一个基于中间件的数据库同步系统。该系统利用中间件实现数据库同步的目的,通过事务管理模块、冲突检测模块、通信模块、事务执行模块完成事务的捕获、分析以及对冲突事务的检测和处理。实验结果表明,由于冲突在本地得到检测和处理,与两阶段协议(2PL)相比,基于中间件的数据库同步系统降低了事务的响应时间,减少了不必要的通信,提升了系统的性能。To improve the duplicate consistency under peer-to-peer pattern in distributed database system,a middlewarebased database synchronization system was designed. The middleware is used to realize the database synchronization in the system to capture and analyze the transaction with transaction management module,collision detection module,communication module and transaction execution module,and then detect and treat with the conflict transaction. The experimental results show that,in comparison with the two-phase locking（2PL）,the middleware-based database synchronization system can reduce the response time of the transaction due to the conflict detected and treated at local,decrease the unnecessary communication,and improve the system performance.

关 键 词：数据库同步 对等模式 中间件 冲突检测 

分 类 号：TN915.34[电子电信—通信与信息系统] TP311.133[电子电信—信息与通信工程]