数据仓库中数据抽取、转换及加载工具研究

Data Extraction, Transformation and Loading Tools in a Data Warehouse

分析数据仓库体系结构,描述数据加载过程中的不同实现方法.在实现过程中引入工作流的思想,提出了一种以工作流为模式的基于元数据的ETL模型,将数据加载分解成可配制的具有不同语义的过程,并给出了相关元素的定义,提供了一个可配置的具有良好伸缩性的ETL解决方案.

Studies the data warehouse architecture and illustrates different methods of data loading. In the process of implementation, the idea of workflow is introduced. A series of tools are proposed and discussed for data extraction, cleansing, transformation and loading, that are based on the management of metadata and workflow. Some concepts which describe the elements of ETL process are defined. A solution is proposed as a scalable, configurable and effective way out for data migration.