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.

Full Text
Paper version not known

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call

Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.