摘要: 在基于数据库的大型分布式应用系统中,以较小的开销实现异构数据库间的复制是一个难题。分析原有异构数据库复制方法存在的不足,提出在数据访问接口中捕获数据变更SQL语句的改进方法,在不显著增加额外开销的情况下能完全捕获数据变更,同时保持变更的事务特性。实际应用验证了该方法的可行性。
关键词:
异构数据库复制,
SQL重现,
数据访问接口
Abstract: It is difficult to deal with heterogeneous database replication with little overhead in large distributed applications. After analyzing original approach, this paper intends to capture database changes SQL in data access interface of applications. All database changes can be easily captured with new method and transaction property of database is guaranteed. Practical application verifies the feasibility of the approach .
Key words:
heterogeneous database replication,
SQL reproducing,
data access interface
中图分类号:
李晓航;胡晓鹏;李 岗. 异构数据库复制方法的改进与实现[J]. 计算机工程, 2009, 35(8): 79-81.
LI Xiao-hang; HU Xiao-peng; LI Gang. Improvement and Implementation of Heterogeneous Database Replication Approach[J]. Computer Engineering, 2009, 35(8): 79-81.