Kajian Pendekatan Binary Log dalam Change Data Capture

  • Muhammad Febrian Rachmadhan Amri Program Studi Teknologi Informasi Universitas Udayana Bukit Jimbaran, Bali, Indonesia
  • I Made Sukarsa Program Studi Teknologi Informasi Universitas Udayana Bukit Jimbaran, Bali, Indonesia
  • I Ketut Adi Purnawan Program Studi Teknologi Informasi Universitas Udayana Bukit Jimbaran, Bali, Indonesia

Abstract

The online business era causes the form of transactions to occur so quickly that the information stored in the data warehouse becomes invalid. Companies are required to have a strong system, which is a system that is real time in order to be able to perform data loading into the media repository that resides on different hosts in the near-real time. Data Warehouse is used as a media repository of data that has the nature of subject-oriented, integrated, time-variant, and is fixed. Data Warehouse can be built into real time management with the advantages possessed and utilize Change Data Capture. Change Data Capture (CDC) is a technique that can be used as problem solution to build real time data warehousing (RTDW). The binary log approach in change data capture is made to record any data manipulation activity that occurs at the OLTP level and is managed back before being stored into the Data Warehouse (loading process). This can improve the quality of data management so that the creation of the right information, because the information available is always updated. Testing shows that Binary Log approach in Change Data Capture (BinlogCDC) is able to generate real time data management, valid current information, dynamic communication between systems, and data management without losing any information from data manipulation.

Published
2017-08-29
How to Cite
AMRI, Muhammad Febrian Rachmadhan; SUKARSA, I Made; PURNAWAN, I Ketut Adi. Kajian Pendekatan Binary Log dalam Change Data Capture. Jurnal Ilmiah Merpati (Menara Penelitian Akademika Teknologi Informasi), [S.l.], p. 11-22, aug. 2017. ISSN 2685-2411. Available at: <https://ojs.unud.ac.id/index.php/merpati/article/view/33179>. Date accessed: 29 may 2020. doi: https://doi.org/10.24843/JIM.2017.v05.i02.p02.
Section
Articles

Most read articles by the same author(s)

Obs.: This plugin requires at least one statistics/report plugin to be enabled. If your statistics plugins provide more than one metric then please also select a main metric on the admin's site settings page and/or on the journal manager's settings pages.