ANALYSIS OF CHANGE DATA CAPTURE METHOD IN HETEROGENEOUS DATA SOURCES TO SUPPORT REAL TIME DATA WAREHOUSE
The need for rapid decision-making on the organization, causing the importance of developing a real time data warehouse (RTDW) system. In addition, what needs to be considered is how to keep the Extract, Transform, Load (ETL) process done, would not interfering the performance of the operational dat...
Saved in:
| Main Author: | |
|---|---|
| Format: | Theses |
| Language: | Indonesia |
| Online Access: | https://digilib.itb.ac.id/gdl/view/27747 |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| Institution: | Institut Teknologi Bandung |
| Language: | Indonesia |
| Summary: | The need for rapid decision-making on the organization, causing the importance of developing a real time data warehouse (RTDW) system. In addition, what needs to be considered is how to keep the Extract, Transform, Load (ETL) process done, would not interfering the performance of the operational database being used. One of the method that can be used is change data capture. Nowadays, the data sources that companies use for many operations are usually coming from different sources. The proposed research will identified which change data capture method is the best from three types of methods in three database application for each type of data structure in each data source to be tested, that supports the RTDW system-making process. Then there will be a simulation of query execution test in a certain number and period, to test the methods and get the best quality comparison between various change data capture methods available. Finally, an integration scheme design will be created to build the data warehouse system needed to make strategic decisions with real time data and analysis of the results at the level of data structures to identify which variables influence the quality of change data capture method on certain types of data sources. From the results of research conducted proved that the best change data capture method is different for each type of data source tested in the same environment. |
|---|