CFP last date
20 May 2024
Reseach Article

Database Replication: A Survey of Open Source and Commercial Tools

by Salman Abdul Moiz, Sailaja P., Venkataswamy G., Supriya N. Pal
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 13 - Number 6
Year of Publication: 2011
Authors: Salman Abdul Moiz, Sailaja P., Venkataswamy G., Supriya N. Pal
10.5120/1788-2469

Salman Abdul Moiz, Sailaja P., Venkataswamy G., Supriya N. Pal . Database Replication: A Survey of Open Source and Commercial Tools. International Journal of Computer Applications. 13, 6 ( January 2011), 1-8. DOI=10.5120/1788-2469

@article{ 10.5120/1788-2469,
author = { Salman Abdul Moiz, Sailaja P., Venkataswamy G., Supriya N. Pal },
title = { Database Replication: A Survey of Open Source and Commercial Tools },
journal = { International Journal of Computer Applications },
issue_date = { January 2011 },
volume = { 13 },
number = { 6 },
month = { January },
year = { 2011 },
issn = { 0975-8887 },
pages = { 1-8 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume13/number6/1788-2469/ },
doi = { 10.5120/1788-2469 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T20:01:58.840308+05:30
%A Salman Abdul Moiz
%A Sailaja P.
%A Venkataswamy G.
%A Supriya N. Pal
%T Database Replication: A Survey of Open Source and Commercial Tools
%J International Journal of Computer Applications
%@ 0975-8887
%V 13
%N 6
%P 1-8
%D 2011
%I Foundation of Computer Science (FCS), NY, USA
Abstract

The most critical and important aspect of disaster recovery is to protect the data from application fail over, natural disasters and infrastructure failures. Taking frequent backups of the huge volumes of data and storing it is also an integral part of the disaster recovery plan. Various scenarios of database replication strategies and techniques are provided in this survey paper addressing the need for replication of data. A wide range of open source and commercial tools have evolved over a period of time to deal with the issues and challenges involved during the process of database replication. This paper describes the general characteristics of replication & disaster recovery. Later the features of open source and commercial replication tools are compared.

References
  1. May Mar Oo, “Fault Tolerance by Replication of Distributed Database in P2P System using Agent Approach”, International Journal of Computers, Issue 1. vol.4, 2010.
  2. Sujoy P.Paul, “Pro SQL Server 2008 Replication”
  3. “PostgreSQL 8.4 Server Administration”, Volume II- The PostgreSQL Global Development Group, 1996.
  4. Shuqing Wu, Bettina Kemme, “Postgres-R(SI): Combining Replica Control with Concurrency Control Based on Snapshot Isolation”, ICDE, 2005.
  5. Bettina Kemme, Gustavo Alonso, “Don’t be lazy, be consistent: Postres-R, A new way to implement Database Replication”, VLDB, 2000.
  6. Brad Ediger, “ Advanced Rails”, 2007
  7. Jan Weick, “Slony-I, A replication system for PostgreSQL”
  8. Rui Oliveira,”GORDA open replication of databases”- A report, 2008.
  9. Alfranio Correio Jr. et. Al, “GORDA: An Open Architecture for Database Replication”, IEEE, NCA, 2007.
  10. http://dbreplicator.org
  11. Bettina Kemme, Gustavo Alonso, “Database Replication: A Tale of Research across Communities”, VLDB, Vol.3, No. 1, 2010.
  12. Jean-Paul Argudo, “ Pgpool-II”, 2010.
  13. Will Schmied, Orin Thomas, “Implementing & Managing Exchange Server 2003”, pp.219, 2004.
  14. IBM Informix Dynamic Server Enterprise Replication Guide, Version 9.4, 2003, Part No. CT1T2NA.
  15. Mrktheni, “Data Propagator Setup”
  16. Bart Steegmans et.Al, IBM DB2 for z/OS and OS/390 Data Management Tools Update, 2002.
  17. Charles B.Clifford, “Sybase Replication Server –Primer“, 1995.
  18. Nagraj Alur et.Al, “Websphere Information Integrator Q-Replication: Fast Track Implementation Scenarios”, 2005.
  19. Ashish Ray, “Implementing Replication with Oracle Streams”
  20. Emanuel Cecchet et.Al, “Middleware-based Database Replication: The Gaps between Theory & Practice”, SIGMOD, 2008.
Index Terms

Computer Science
Information Sciences

Keywords

Database replication Replication strategies Open source replication tools Commercial replication tools