Title :
Modeling and optimization of extraction-transformation-loading (ETL) processes in data warehouse: An overview
Author :
Anand, Nitin ; Kumar, Manoj
Abstract :
ETL processes are responsible for the extraction of data from several sources, their cleansing, their customization and transformation, and finally, their loading into a data warehouse. In this paper we are reviewing the optimization of its execution plan. We review on the optimization of the sequence of the ETL operations involved in the overall process.
Keywords :
data warehouses; ETL operations; ETL processes; data cleansing; data customization; data extraction; data transformation; data warehouse; extraction-transformation-loading processes; modeling; optimization; Data mining; Data models; Data warehouses; Databases; Loading; Unified modeling language; Warehousing; Data Mart; Data Quality (DQ); Data Staging Area; Data warehouse; ETL; Metadata; OLTP;
Conference_Titel :
Computing, Communications and Networking Technologies (ICCCNT),2013 Fourth International Conference on
Conference_Location :
Tiruchengode
Print_ISBN :
978-1-4799-3925-1
DOI :
10.1109/ICCCNT.2013.6726592
