ETL过程的思考

ETL是构建数据仓库的一个非常重要的环节,可以这样认为:ETL就是整个数据仓库系统乃至整个决策支持系统的基石。如何设计高效的ETL过程就成为了众多计划或正在实施数据仓库项目的企业考虑的重要问题。从前期的数据理解阶段入手,分别讨论了数据的抽取、清洗转换、装载等不同阶段需要考虑的设计问题及相应的解决方案。提出了以数据理解为根基,以清洗转换为中心的设计思想,并给出了具体的实施步骤。

Thinking in ETL Process

ETL is one of the major processes when building a data warehouse.Can consider that ETL is the basis of the data warehouse even though the whole decision support system.Many enterprises which is planning or beginning to build a data warhorse now is highly concerned about how to design the ETL process effectively.Starts with the data comprehension,and discusses the design issues and its solutions about data extraction,data cleaning and data loading.Propose a method which is based on data comprehension and centered on data cleaning to design the ETL process and describe the steps to follow.