Review on Scheduling Algorithms for Data Warehousing

S. M. Ramesh, B. Gomathy

Abstract: These instructions Poor performance can turn a successful data warehousing project into a failure. Consequently, several attempts have been made by various researchers to deal with the problem of scheduling the Extract-Transform-Load (ETL) process. In this paper present several approaches in the context of enhancing the data warehousing Extract, Transform and loading stages. To focus on enhancing the performance of extract and transform phases by proposing two algorithms that reduce the time needed in each phase through employing the hidden semantic information in the data. Also focus on the problem of scheduling the execution of the ETL activities, with the goal of minimizing ETL execution time. Explore and invest in this area by choosing three scheduling techniques for ETL. Finally, the experimentally show their behavior in terms of execution time in the sales domain to understand the impact of implementing any of them and choosing the one leading to maximum performance enhancement

Keywords: Data warehousing, Data loading schedules, ETL optimization, Scheduling algorithms, Round robin