Experimental results on change data capture methods implementation in different data structures to support real-time data warehouse

Harry Chandra

International Journal of Business Information Systems, 2020, vol. 34, issue 3, 373-402

Abstract: The need for rapid decision making in the organisation, causing the importance of developing a real-time data warehouse system. In addition, what also needs to be considered is how to make the extract, transform, load (ETL) processes carried out, would not interfere the performance of the operational database being used. One of the methods that can be used is change data capture. Nowadays, the data sources that companies used for many operations are usually coming from different sources. The proposed research will identified which one is the best change data capture method from three types of methods in three database application for each type of data structure to be tested, that supports the RTDW system making process. From the results of research conducted it is proved that the best change data capture method is different for each type of data source tested in the same environment.

Keywords: real-time data warehouse; RTDW; extract; transform; load; ETL; change data capture; data structures model; log-based; timestamp on file; timestamp on rows; trigger; replication. (search for similar items in EconPapers)
Date: 2020
References: Add references at CitEc
Citations:

Downloads: (external link)
http://www.inderscience.com/link.php?id=108651 (text/html)
Access to full text is restricted to subscribers.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:ids:ijbisy:v:34:y:2020:i:3:p:373-402

Access Statistics for this article

More articles in International Journal of Business Information Systems from Inderscience Enterprises Ltd
Bibliographic data for series maintained by Sarah Parker ().