| 一种基于ER模型的数据仓库多维建模方法 |
| |
| 引用本文： | 刘洪磊,李卫玲,王锡民,余红兵.一种基于ER模型的数据仓库多维建模方法[J].广西科学院学报,2010,26(4):446-448,454. |
| |
| 作者姓名： | 刘洪磊 李卫玲 王锡民 余红兵 |
| |
| 作者单位： | [1]96251部队司令部,河南洛阳471003 [2]洛阳师范学院信息技术学院,河南洛阳471022 |
| |
| 摘 要： | 结合Ralph Kimball和Inmon的数据仓库设计和架构思想,以建设某学院办公自动化数据仓库为例,提出一种基于实体联系(ER)模型的数据仓库多维建模方法。该方法从构建数据仓库全局角度指导维度建模,同时兼顾用户需求与底层数据,从而得到既能满足用户需求、又具扩展性的维度模型。该方法规范了数据仓库的逻辑模型建模过程,可以为多维模型的设计提供方法上的指导。
|
| 关 键 词： | 数据仓库 ER模型 多维建模 办公自动化 |
| 收稿时间： | 2010/8/11 0:00:00 |
| 修稿时间： | 2010/10/13 0:00:00 |
A Multi-dimensional Modeling Mechanism of Data Warehouse Based on ER Model |
| |
| LIU Hong-lei,LI Wei-ling,WANG Xi-min and 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. |
| |
| Authors: | LIU Hong-lei LI Wei-ling WANG Xi-min and YU Hong-bing |
| |
| Institution: | 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. |
| |
| Keywords: | data warehouse ER model multi-dimensional model office automation |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
| 点击此处可从《广西科学院学报》浏览原始摘要信息 |
| 点击此处可从《广西科学院学报》下载免费的PDF全文 |
|
