IJCATR Volume 4 Issue 8

Enhancing Data Staging as a Mechanism for Fast Data Access

Reagan Muriithi Gatimu Wilson Cheruiyot Michael Kimwele
10.7753/IJCATR0408.1001
keywords : Data Staging; Source System; Deterministic Prioritization; Data Warehouse

PDF
Most organizations rely on data in their daily transactions and operations. This data is retrieved from different source systems in a distributed network hence it comes in varying data types and formats. The source data is prepared and cleaned by subjecting it to algorithms and functions before transferring it to the target systems which takes more time. Moreover, there is pressure from data users within the data warehouse for data to be availed quickly for them to make appropriate decisions and forecasts. This has not been the case due to immense data explosion in millions of transactions resulting from business processes of the organizations. The current legacy systems cannot handle large data levels due to processing capabilities and customizations. This approach has failed because there lacks clear procedures to decide which data to collect or exempt. It is with this concern that performance degradation should be addressed because organizations invest a lot of resources to establish a functioning data warehouse. Data staging is a technological innovation within data warehouses where data manipulations are carried out before transfer to target systems. It carries out data integration by harmonizing the staging functions, cleansing, verification, and archiving source data. Deterministic Prioritization Approach will be employed to enhance data staging, and to clearly prove this change Experiment design is needed to test scenarios in the study. Previous studies in this field have mainly focused in the data warehouses processes as a whole but less to the specifics of data staging area.
@artical{r482015ijcatr04081001,
Title = "Enhancing Data Staging as a Mechanism for Fast Data Access",
Journal ="International Journal of Computer Applications Technology and Research(IJCATR)",
Volume = "4",
Issue ="8",
Pages ="584 - 591",
Year = "2015",
Authors ="Reagan Muriithi Gatimu Wilson Cheruiyot Michael Kimwele"}
  • null