DATABASE OF MIGRATION AND REPLICATION WITH ORACLE GOLDEN GATE

Authors

  • Suharjito Suharjito Master of Information Technology, Binus Graduate Programs, Bina Nusantara University Jl Kebon Jeruk Raya 27, Jakarta 11530, Indonesia
  • Raymond Raymond Computer Science, Faculty of Computing and Media, Bina Nusantara University Jl Hang Lekir I No. 6, Jakarta 10270
  • Ida Ratna Master of Information Technology, Binus Graduate Programs, Bina Nusantara University Jl Kebon Jeruk Raya 27, Jakarta 11530, Indonesia

DOI:

https://doi.org/10.21512/commit.v8i2.597

Abstract

The main goal of this research is to analyze and design a database configuration of migration and replication in PT Metro Batavia. Research methodologies used in this research are data collecting, analysis and design model. Data collecting method is conducted with library research and direct survey in the company. Analysis method is conducted by analyzing hangar system, migration and reflection process and the available problems. Design method is conducted by designing a prototype for migration process with the implementation of Oracle SQL Developer and replication process with implementation of Oracle Golden Gate. The result of this research is a prototype for configuration of migration and replication process by using Oracle Golden Gate, which can produce two sets of identical data for the purpose of backup and recovery, and also design a simple tool that is expected to help active-active or active-passive replication process. The conclusion of this research is migration process of MySQL database to Oracle database by using Oracle Golden Gate hasn’t been conducted, because Oracle Golden Gate still has bug related to binary log, so database of migration is conducted by using Oracle Golden Gate. However, replication of bi-directional in between database of Oracle by using Oracle SQL Developer can guarantee data availability and reduce work burden from primary database.
Dimensions

Plum Analytics

Downloads

Published

2014-10-01

Issue

Vol. 8 No. 2 (2014): CommIT Journal

Section

Articles

License

Authors who publish with this journal agree to the following terms:
a. Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License - Share Alike that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.

b. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.

c. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.

 

USER RIGHTS

All articles published Open Access will be immediately and permanently free for everyone to read and download.  We are continuously working with our author communities to select the best choice of license options, currently being defined for this journal as follows: Creative Commons Attribution-Share Alike (CC BY-SA)

Abstract 837  .
PDF downloaded 644  .