数据仓库设计

Design of Data Warehouse

数据仓库改变了传统的以支持查询为主的事务型处理,变成以面向主题为主的分析型处理,并在此基础上建立了联机分析处理和数据挖掘应用,以适应快速的访问和支持决策分析操作。本文作者使用了信息动态打包法构造概念模型和逻辑模型,并通过事实星座模式构造物理数据存储模型,来实现数据仓库的构建。

Data warehouse changes traditional transaction processing which mostly supports query into analytical subject-oriented processing .On the base of DW,OLAP and Data Mining Application is built in order to adapt to the operation,such as quick access,supporting decision-analysis,and so on.In order to realize the construction of DW,in this paper the information dynamic package is used to construct the concept model and logic model,it also uses fact constellation to construct physical data storage model.