Overview on ETL Technology
Qingbao Liu
Abstract
Qingbao Liu
Abstract
This paper introduces the importance of extract, transform and load (ETL) in the process of building data warehouse, analyses the process of ETL and cuts a full life cycle ETL process into five stages: source verification, source alteration, common interchange, target load determination and aggregation. Finally, it analyses the ETL productions and their function characteristics, and forecastes the future of function trends.
OpenAlex reports 5 citations for this work. Citation counts describe recorded attention and do not establish research quality.
A contribution statement is not available in the OpenAlex record.
Method details are not available in the OpenAlex metadata.
Findings are not separately available in the OpenAlex metadata.
Limitations are not available in the OpenAlex metadata.
Application details are not available in the OpenAlex metadata.
This paper introduces the importance of extract, transform and load (ETL) in the process of building data warehouse, analyses the process of ETL and cuts a full life cycle ETL process into five stages: source verification, source alteration, common interchange, target load determination and aggregation. Finally, it analyses the ETL productions and their function characteristics, and forecastes the future of function trends.
Key concepts: Computer science, Data warehouse, Function (biology), Process (computing), Database, Data mining, Operating system, Biology