摘要： 数据仓库的思想和工具在企业中得到了越来越广泛的体现和应用。在当前典型的数据仓库应用中，数据仓库的填充或者说数据的提取、转换和加载是设计人员遇到的最大挑战之一，预计在数据仓库的设计过程中，８０％的努力都将用于此过程。该文从工程角度介绍了数据提取、转换和加载的过程和实现方式，并介绍了４种可灵活应用的数据提取方法。

关键词: 数据仓库, 提取, 转换, JDBC, 脚本

Abstract: The thought and utility of data warehouse are becoming widely used. At current typical application of data warehouse, stuffing of data warehouse or extraction, transformation and loading of data is one of the biggest challenges.We can predict that 80% of effort is employed in this procedure during the design of data warehouse. In this paper, the procedure of extraction, transformation and loading, the way of implementing are introduced and three methods of data extraction are provided at the end.

中图分类号: 

• TP311.13