数据ETL研究综述

计算机科学 ›› 2011, Vol. 38 ›› Issue (4): 15-20.

数据ETL研究综述

徐俊刚,裴莹

(中国科学院研究生院信息科学与工程学院北京100190)

出版日期:2018-11-16 发布日期:2018-11-16
基金资助:
本文受国家863计划课题“数据中心的运行时功耗管理技术”(2009AA01Z139)资助。

Overview of Data Extraction, Transformation and Loading

XU Jun-gang,PEI Ying

Online:2018-11-16 Published:2018-11-16

摘要/Abstract

摘要： 数据抽取、转换和装载(Extraction, Transformation and Loading，简称ETL)是数据仓库化的关键环节，对数据仓库数据质量有着至关重要的影响。随着信息化的发展，ETL已经成为当前较活跃的研究领域之一，但是ETL理论和技术的发展还不成熟。针对当前ETL研究中存在的一些问题和需要考虑的各种因素，从ETL各个阶段存在的主要问题出发，列举了各种研究方法及研究成果，并进行了分析。最后，总结并提出了E`I'I的未来研究方向和今后工作的建议。

关键词: ETL，数据仓库，数据质量，元数据

Abstract: Data extraction, transformation and loading arc crucial steps of data warehousing, which influences data qualily of data warehouse intensively. With the development of informationization, ETL has already become one of most popular research fields,but till now,ETL theory and technology are still not mature. As to the problems and factors appeared in ETL research, many research methods and achievements were listed according to the main problems existed in each ETL phase. Finally, several future research trends of ETL and some proposals for the future research work were summarized and presented respectively.

Key words: ETL, Data warehouse, Data quality, Metadata

徐俊刚,裴莹. 数据ETL研究综述[J]. 计算机科学, 2011, 38(4): 15-20. https://doi.org/

XU Jun-gang,PEI Ying. Overview of Data Extraction, Transformation and Loading[J]. Computer Science, 2011, 38(4): 15-20. https://doi.org/

参考文献

Metrics

Viewed

Full text

Abstract

Cited

Shared

Discussed