设计数据仓库

Design of Data Warehouse

扼要地论述了建立数据仓库系统的需求分析、系统模型、几类关键数据表以及对有关数据仓库的软硬件环境的要求．提出了数据仓库数据源的采集、整理、异构环境下的转换和存储这一系列过程中的问题，及解决这些问题所需的相关数据处理程序模块．讨论了数据仓库五个部分的功能及它们间的关系．所叙述的步骤及方法，可为设计和实施数据仓库的工程人员提供参考．

This paper presents a data warehouse system, whose design principles, the model structure and some main tables are discussed. The data extraction and transfer in different operation system and database system and store are given in detail. The environment in which the system is established is also covered. The architecture and their relations in the system are described. The paper can be used as references for engineers engaged in the design and creation of data warehouse.