Journal of University of Chinese Academy of Sciences >
Research and implementation of heterogeneous database replication technology
Received date: 2010-09-15
Revised date: 2010-12-13
Online published: 2012-01-15
Data need to be replicated because of performance and availability in the cluster system composed of heterogeneous database, and data replication between different databases is an important issue to be solved. A new method for the heterogeneous data replication is described on the basis of the database replication technology. Since most of the existing solutions are dependent on the specific DBMS, a new fully heterogeneous data replication method is proposed and it uses common database interface and data structure to achieve the DBMS independence. Application of the method to the database cluster for data replication between backend data nodes improves the availability and scalability of the system.
Key words： heterogeneous database; data replication; database cluster
ZHANG Da-Peng , CHEN Chi , XU Zhen . Research and implementation of heterogeneous database replication technology[J]. Journal of University of Chinese Academy of Sciences, 2012 , 29(1) : 101 -108 . DOI: 10.7523/j.issn.2095-6134.2012.1.015
[1] Anderson T, Breitbart Y, Korth H F, et al. Replication, consistency, and practicality: are these mutually exclusive? //Proc 1998 ACM SIGMOD Int Conf on Management of Data. Seattle, Washington D C, June 1998.
[2] Wiesmann M, Pedone F, Schiper A, et al.Understanding replication in databases and distributed systems //20th IEEE International Conference on Distributed Computing Systems (ICDCS'00). 2000:464.
[3] Golding R. A discussion of relational database replication technology //InfoDB 8, 1. Spring 1994.
[4] Wiesmann M, Schiper A. Comparison of database replication techniques based on total order broadcast //IEEE Transactions on Knowledge and Data Engineering. 2005,17(4):551-566.
[5] Wiederhold G, Qian X. Consistency control of replicated data in federated databases //Management of Replicated Data, Proceedings.1990,8-9 N:130-132. Digital Object Identifier 10.1109/MRD.1990.138260.
[6] 者敬. 开放式异构数据库复制框架的研究与实现 . 北京: 中国科学院软件研究所, 2002.
[7] Gai J Y, Zhang Z N, Xiao H. Data replication technique analysis and application in distributed database system
[J]. Computer Applications and Software, 2005, 22(7):36-38, 41(in Chinese). 盖九宇,张忠能,肖鹤. 分布式数据库复制技术的分析和应用
[J]. 计算机应用与软件,2005,22(7):36-38,41.
[8] Oracle 9iTM replication . An Oracle White Paper, June 2001. http://www.oracle.com/technology/products/dataint/pdf/oracle_adv_replication_twp.pdf.
[9] Replication strategies: data migration, distribution and synchronization . . A Sybase® White Paper. http://www.sybase.com/content/1028711/6143_whitepaper_v2.pdf.
[10] WebSphere information integrator Q replication: fast track implementation scenarios. IBM/Redbooks . .http://www.redbooks.ibm.com/redbooks/pdfs/sg246487.pdf.
[11] Li J H, Zhou M Q, Geng G H, et al. Research and application of heterogeneous data integration based XML
[J]. Computer Applications, 2002, 22(9): 10-12(in Chinese). 李军怀,周明全,耿国华,等. XML在异构集成中的应用研究
[J]. 计算机应用,2002,22(9):10-12.
[12] Bernstein P A. Middleware: a model for distributed system services //CACM 39, 2.February 1996.
/
| 〈 |
|
〉 |