Implementación de una base de datos heterogénea distribuida entre los SGBDs ORACLE, MySQL y PostgreSQL con replicación, mediante un script bash implementado en el sistema operativo CentOS usando software libre
Main Article Content
Abstract
This article allows to obtain a heterogeneous distributed database with replication in a
CentOS environment in less than 5 minutes, using a bash script, using only free software. The
idea is focused on having a slave that will be ORACLE and the master nodes will be in MySQL
and PostgreSQL, in order to reduce costs when designing and implementing a distributed
database since the power of a manager is maximized of payment, which is Oracle, with the free
and good performance of MySQL and PostgreSQL. The result of this article will be an ODBC
that configures the two managers without spending a single cent and in record time, and thus be
able to obtain a distributed database made up of different managers, who work as one.
Downloads
Article Details
COPYRIGHT NOTICE
Authors who publish in the INNOVA Research Journal keeps copyright and guarantee the journal the right to be the first publication of the work under the Creative Commons License, Attribution-Non-Commercial 4.0 International (CC BY-NC 4.0). They can be copied, used, disseminated, transmitted and publicly exhibited, provided that: a) the authorship and original source of their publication (magazine, publisher, URL and DOI of the work) is cited; b) are not used for commercial purposes; c) the existence and specifications of this license of use are mentioned.
References
Barroso, V. (2015). Explotación e Integración de Bases de Datos Heterogéneas para la Universidad de Valladolid.
Cisneros, J. (1998). Panorama sobre base de datos. (Un enfoque práctico). UABC.
Cuadra, D., & Castro, E. (2013). Desarrollo de bases de datos:casos prácticos desde el análisis a la. Ra-Ma.
Devart. (2017). Devart Web Site. Obtenido de https://www.devart.com/purchase.html.
Edward, L. (2006). MySQL. Peachpit Press.
Espinoza, C. (2010). Metodología de investigación tecnológica. Perú: Imagen Gráfica SAC.
Gonzalez, Ó. (2000). Arquitecturas de sistemas de bases de datos. Castilla: Universidad De Castilla La Mancha.
Harvey, P., & Gorham, N. (31 de 08 de 2015). UnixODBC. Obtenido de http://www.unixodbc.org/.
Heurtel, O. (2015). Oracle 12c: administración. Ediciones ENI.
Jurado, C. (2010). Diseño Ágil con TDD. Lulu.com.
Martin, S. (2011). PostgreSQL: Una poderosa base de datos libre. EAE.
Martínez, L. (2010). Diseño y construcción de bases de datos distribuidas heterogéneas sobre Oracle y SQL Server. Madrid: Universidad Carlos III de Madrid.
Muñoz, A., & Obando, A. (2006). Heterogeneidad de Datos y Posibles Soluciones. Bógota: Pontificia Universidad Javeriana.
Sheth, A. (1990). Federated Database Systems for Managing distributed, Heterogeneus, and Autonomus Database. ACM Computing.
Smyth, N. (2010). CentOS 5 Essentials. eBookFrenzy.