| 引用本文： |
-
刘洪磊,李卫玲,王锡民,余红兵.一种基于ER模型的数据仓库多维建模方法[J].广西科学院学报,2010,26(4):446-448,454. [点击复制]
- LIU Hong-lei,LI Wei-ling,WANG Xi-min,YU Hong-bing.A Multi-dimensional Modeling Mechanism of Data Warehouse Based on ER Model[J].Journal of Guangxi Academy of Sciences,2010,26(4):446-448,454. [点击复制]
|
|
| 摘要: |
| 结合Ralph Kimball和Inmon的数据仓库设计和架构思想,以建设某学院办公自动化数据仓库为例,提出一种基于实体联系(ER)模型的数据仓库多维建模方法。该方法从构建数据仓库全局角度指导维度建模,同时兼顾用户需求与底层数据,从而得到既能满足用户需求、又具扩展性的维度模型。该方法规范了数据仓库的逻辑模型建模过程,可以为多维模型的设计提供方法上的指导。 |
| 关键词: 数据仓库 ER模型 多维建模 办公自动化 |
| DOI： |
| 投稿时间：2010-08-11修订日期：2010-10-13 |
| 基金项目: |
|
| A Multi-dimensional Modeling Mechanism of Data Warehouse Based on ER Model |
|
LIU Hong-lei1, LI Wei-ling2, WANG Xi-min1, YU Hong-bing1
|
| (1.The Headquarters of 96251 Troops, Luoyang, Henan, 471003, China;2.College of Information Technology, Luoyang Normal University, Luoyang, Henan, 471022, China) |
| Abstract: |
| Based on Ralph Kimball and Inmon's design methods and the architecture idea of Data Warehouse, a multi-dimensional modeling mechanism is proposed based on ER (Entity Relationship) model.A data warehouse of college Office Automation is built as an example. The method provides dimensional modeling guidance for building a data warehouse from a global point, simultaneously considering users needs and the underlying data.Thus an extended dimension model with the users satisfactory can be obtained.This mechanism standardiezes the logical modeling process of data warehouse, and provides methodological guidance for the design of multi-dimensional model. |
| Key words: data warehouse ER model multi-dimensional model office automation |
