基于IDP的学校数据仓库设计

A college data warehouse design based on IDP

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

Data warehouse changes traditional transaction processing which is mostly query supporting into analytical processing which is mostly subject-oriented. On the base of which 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 college data warehouse, in this text, information dynamic package is used to construct concept model and logic model, it is also used fact constellation to construct physical data storage model.