Web services model to snapshot replication over multiple database engines

Authors

  • Roberto Erazo Universidad del Cauca
  • Carlos Cobos Universidad del Cauca
  • Martha Mendoza Universidad del Cauca

DOI:

https://doi.org/10.17533/udea.redin.18511

Keywords:

Web services, open replication model, snapshot, RDBMS, push, pull, subscription, publication, distribution, SOA

Abstract

In this paper, we present a web service model to support snapshots replication in multiple database engines. This model is open and is composed by a set of web services, agents and a manage console that allows to perform administrative tasks independently from the application and the database engines. This model uses a replication master catalog (CMR) to store the replication data. We show the architecture used and the behavior of our replication model to provide a better understanding about the data replication, as well as, discussion of several papers related to the replication services independent from the database engines.

|Abstract
= 192 veces | PDF (ESPAÑOL (ESPAÑA))
= 49 veces|

Downloads

Download data is not yet available.

Author Biographies

Roberto Erazo, Universidad del Cauca

Grupo de I+D en Tecnologías de la Información, Departamento de Sistemas

Carlos Cobos, Universidad del Cauca

Grupo de I+D en Tecnologías de la Información, Departamento de Sistemas

Martha Mendoza, Universidad del Cauca

Grupo de I+D en Tecnologías de la Información, Departamento de Sistemas

References

C. J. Date. Introducción a los sistemas de bases de datos: Bases de datos distribuidas. 7a ed. Prentice Hall. México. 2001. p. 651.

S. D. Michael. Using Sharing to Simplify System Management. In Computer Systems: Theory, Technology, and Applications. A. Herbert, K. Sparck Jones Eds. Springer-Verlag. New York. 2004. pp. 259- 268.

K. Bettina. Implementing Database Replication based on Group Communication. School of Computer Science. McGill University. Montreal. Published in Fudico.2002. pp.1-3. http://citeseer.ist.psu.edu/kemme02implementing.html. Consultada octubre 20 de 2006.

P. A. Bernstein, E. Newcomer. Principles of Transaction Processing. The Morgan Kaufmann Series in Data Management Systems. pp. 293-310.

Mercury. IBM – LEGENT. IBM-LEGENT make distributed database management splash. http://www.findarticles.com/p/articles/mi_qa3649/is_199403/ai_n8719514. Consultada enero 18 de 2007.

PeerDirect Distributed Enterprise. PeerDirect Announces Native Linux Support for PeerDirect Distributed Enterprise. http://www.peerdirect.com/news/pressitem/pressrelease_197440/index.ssp. Consultada julio 12 de 2006.

Progress DataXtend Enterprise. Progress DataXtend . http://www.progress.com/dataxtend/dataxtend_enterprise/index.ssp. Consultada julio 15 de 2006.

SQL Server 2005. SQL Server Replication. Types of Replication. Microsoft Corp 2007. http://msdn2.microsoft.com/en-us/library/ms151198.aspx. Consultada abril 4 de 2006.

S. Swaminathan, A. Gustavo, P. Guillaume, V. S. Maarten, Globe DB. “Autonomic Data Replication for Web Applications”. Proceedings of the 14th international conference on World Wide. Web. WWW ’05. ACM press. May 2005. p. 33

M. Arenas, L. Libkin. “A normal form for XML documents”. ACM Trans. Database Systems. Vol. 29. 2004. pp.195-232. DOI: https://doi.org/10.1145/974750.974757

B. Byfield. “Take command: password’s progress”. Linux J. Vol 89. 2001, p. 6.

D. Wagner, B. Schneier. “Analysis of the SSL 3.0 protocol”. Proceedings of the 2nd Conference on Proceedings of the Second USENIX Workshop on Electronic Commerce - Volume 2 (Oakland, California, November 18 - 21, 1996). USENIX Association, Berkeley, CA, p. 4-4.

T. Henriksson, D. Liu. “Implementation of fast CRC calculation”. Proceedings of the 2003 Conference on Asia South Pacific Design Automation (Kitakyushu, Japan, January 21 - 24, 2003). ASPDAC. ACM Press, New York, NY, pp. 563-564. DOI= http://doi.acm. org/10.1145/1119772.1119892 DOI: https://doi.org/10.1145/1119772.1119892

Smart Client Technology. Microsoft smart clients: Power, performance, flexibility. Micro-soft Corp. March 2005. http://www.microsoft.com/net/SmartClient.mspx. Consultada febrero 14 de 2006.

ANSI/ISO/IEC International Standard. SQL/ Framework: Data types specified in ISO/IEC 9075-2. ANSI/ISO/IEC International Standard. 1999. p. 29.

SQL Validator for SQL99. Mimer Developer http://developer.mimer.com/validator/parser99/index.tml. Consultada abril 8 de 2006.

Core SQL 1999: feature comparison chart. Mimer SQL Developers: http://developer.mimer.com/validator/comparison/upd_comparison_chart.tml?pf=true. Consultada abril 10 de 2006.

Application Blocks Definition. Patterns and Practices: Application Blocks. Microsoft Patterns and Practices developer center. http://msdn.microsoft.com/practices/guidetype/AppBlocks. Consultada junio 14 de 2006.

Published

2014-02-17

How to Cite

Erazo, R., Cobos, C., & Mendoza, M. (2014). Web services model to snapshot replication over multiple database engines. Revista Facultad De Ingeniería Universidad De Antioquia, (44), 144–157. https://doi.org/10.17533/udea.redin.18511