Experimental results on change data capture methods implementation in different data structures to support real-time data warehouse
by Harry Chandra
International Journal of Business Information Systems (IJBIS), Vol. 34, No. 3, 2020

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.

Online publication date: Fri, 24-Jul-2020

The full text of this article is only available to individual subscribers or to users at subscribing institutions.

Existing subscribers:
Go to Inderscience Online Journals to access the Full Text of this article.

Pay per view:
If you are not a subscriber and you just want to read the full contents of this article, buy online access here.

Complimentary Subscribers, Editors or Members of the Editorial Board of the International Journal of Business Information Systems (IJBIS):
Login with your Inderscience username and password:

    Username:        Password:         

Forgotten your password?

Want to subscribe?
A subscription gives you complete access to all articles in the current issue, as well as to all articles in the previous three years (where applicable). See our Orders page to subscribe.

If you still need assistance, please email subs@inderscience.com