我国海洋产业和远洋运输不断发展,海上信息中心的分布范围也日益广泛,因此保持分布式数据库中的数据一致性,成为海洋信息中心建设和维护需要面对的主要问题。本文设计一种基于中间件的数据库同步系统。系统使用中间件实现数据库同步,通过事务管理模块、冲突检测模块、通信模块、事务执行模块完成事务捕获、分析以及冲突检测和处理事务。实验结果表明,本文方法执行本地检测和处理冲突的性能,与两阶段锁定方法(2PL)相比,基于中间件的数据库同步系统减少了事务的响应时间,减少了不必要的流量,提高了系统的性能。
With the continuous development of China's marine industry and ocean transportation, distribution of Marine Information Center has been more and more widely, therefore, to maintain data consistency in distributed database, has become the main problems in the construction of Marine Information Center and maintenance need to face. This paper designs a kind of database synchronization system based on middleware. The system uses middleware to realize database synchronization, through transaction management module, collision detection module, communication module, transaction execution module to complete transaction capture, analysis, and conflict detection and processing transactions. The experimental results show that the local detection and handling conflict, and two-phase locking (2PL), synchronization middleware database based on reducing the response time of transaction, reduce unnecessary traffic, improve the performance of the system.
2017,39(1A): 159-161 收稿日期:2016-11-21
DOI:10.3404/j.issn.1672-7619.2017.1A.054
分类号:TP311
基金项目:河北省科技厅重点研发计划资助项目(15214519)
作者简介:周真真(1982-),女,硕士,讲师,研究方向为虚拟仪器与智能仪器。
参考文献:
[1] DING Zhiming, ZHOU Xiaofang. Location update strategies for network-constrained moving objects[C]//13th International Conference on Database Systems for Advanced Applications, DASFAA 2008.
[2] DING Zhi-ming, GUO Li-min, MENG Xiao-feng. Adaptive location update mechanism for network-constrained moving objects in changeful trafficconditions[C]//2009 Tenth International Conference on Mobile Data Management:Systems, Services and Middleware.
[3] DING Zhi-ming, GÜTING RH. Managing moving objects on dynamic transportation networks[C]//Proceedings-16th International Conference on Scientific and Statistical Databse Management, SSDBM 2004.
[4] WOLFSON O, YIN Hua-bei. Accuracy and resource consumption in tracking and location prediction[J]. SSTD, 2003, (27):89-96.
[5] DÜNTGEN C, BEHR T, GÜTING RH. BerlinMOD:a benchmark for moving object databases[J]. The VLDB Journal, 2009(18):1335-1368.