数据仓库系统中源数据的提取与集成

Data Extraction and Integration for Data Warehouse

人们对数据分析的要求的不断提高导致了数据仓库的发展,而在建设数据仓库的过程中非常关键的一步就是从事务数据库或其它的数据源中抽取和集成原始数据.本文在对数据集成方法和数据获取中可能碰到的问题进行全面分析的基础上,较为详细地介绍了我们自行开发的数据仓库系统SEUwarehouse中源数据提取与集成工具的设计与实现.

The improving of the requirement of data analysis promoted the development of data warehouse. While designing a data warehouse system it is one of the most important work to extract and integrate data from heterogeneous data sources into it. In this paper, based on the research of existing data integrating methods and possible meeting conflicts while data extracting, the design and implementation of the data getting tool in our data warehouse system SEUwarehouse are introduced in detail.