IPRI - www.ipri.kiev.ua -  IPRI - www.ipri.kiev.ua -
Title (journal) Data Rec., Storage & Processing. — 2006. — Vol. 8, N 1.
Pages 55-66
PDF,DOC, full text
Title (article) Execution of replication in heterogeneous database systems
Authors Wlodzimierz Khadzhynov, Mateusz Maksymiuk
Kiev, Ukraine
Annotation Database replication is a mechanism which allows distributed databases stay in synchronized and consistent state. In heterogeneous case there is a set of databases with different platforms, what additionally complicates this process. High demand for this technique causes that replication issue is de-veloped very fast nowadays. Database replication mechanism consists in in-tercepting data modifications and propagating them to other databases where they are executed again. This process is very complex and there are many variants and types of replication. In this paper are discussed database replication classification (synchronous, asynchronous, multiple master, master slave), kinds of replication conflicts with resolving strategies, data modification capturing and publication-subscription model. There is intro-duced an example for realization of replication in heterogeneous environ-ment. Also are discussed aspects of independence database assess mecha-nism from specific platform, what can be used in implementation of hetero-geneous database replication.
Key words Replication mode, Two-Phase Commit protocol, Master-Slave replication model, Multiple Master replication model, Replication conflicts, Hibernate package.
References 1. Manassiev K: Scalable and Highly Available Database Replication through Dynamic Multiver-sioning. — University of Toronto, 2005. — Р. 87. — http://www.cs.toronto.edu/~kaloianm/docs/ut-thesis.pdf
2. Guerraoui R., Oliveira R., Schiper A. Atomic Updates of Replicated Data. — 1996. — Р. 16. — http://citeseer.ist.psu.edu/guerraoui96atomic.html
3. Bausch W. Integrating Synchronous Update-Everywhere Replication into the PostgreSQL Data-base Engine. — Swiss Federal Institute of Technology (ETH). — Zurich. — 1999. — Р. 55. — http://www.iks.inf.ethz.ch/publications/files/bausch_postgres_r.pdf
4. Kemme B. Database Replication for Clusters of Workstations. — Swiss Federal Institute of Tech-nology (ETH). — Zurich. — 2000. — Р. 155. — http://www.cs.mcgill.ca/~kemme/papers/phd-dina4.pdf
5. Lin Y. Database Replication in Wide Area Networks. — 2005. — Р. 20. — http://www.cs.mcgill.ca/~ylin30/paper/proposal.pdf
6. Wiesmann M., Pedone F., Schiper A., Kemme B., Alonso G. Database Replication Techniques: a Three Parameter Classification. — Swiss Federal Institute of Technology (ETH). — Zurich. — 2000. — Р. 10. — http://citeseer.ist.psu.edu/wiesmann00database.html
File stattja.doc