一种基于ER模型的数据仓库多维建模方法  

A Multi-dimensional Modeling Mechanism of Data Warehouse Based on ER Model

作　　者：刘洪磊[1] 李卫玲[2] 王锡民[1] 余红兵[1] 

机构地区：[1]96251部队司令部 [2]洛阳师范学院信息技术学院

出　　处：《广西科学院学报》2010年第4期446-448,454,共4页Journal of Guangxi Academy of Sciences

摘　　要：结合Ralph Kimball和Inmon的数据仓库设计和架构思想,以建设某学院办公自动化数据仓库为例,提出一种基于实体联系(ER)模型的数据仓库多维建模方法。该方法从构建数据仓库全局角度指导维度建模,同时兼顾用户需求与底层数据,从而得到既能满足用户需求、又具扩展性的维度模型。该方法规范了数据仓库的逻辑模型建模过程,可以为多维模型的设计提供方法上的指导。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.

关 键 词：数据仓库 ER模型 多维建模 办公自动化 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]