引用本文: | 唐九阳,杨强,沙基昌,等.ER2MD:一种ER模型到多维模型的转换算法[J].国防科技大学学报,2003,25(1):31-34.[点击复制] |
TANG Jiuyang,YANG Qiang,SHA Jichang,et al.ER2MD:An Algorithm of the Transformation from ER Model to Multidimensional Model[J].Journal of National University of Defense Technology,2003,25(1):31-34[点击复制] |
|
|
|
本文已被:浏览 7243次 下载 5191次 |
ER2MD:一种ER模型到多维模型的转换算法 |
唐九阳, 杨强, 沙基昌, 邓苏, 陆昌辉 |
(国防科技大学 人文与管理学院,湖南 长沙 410073)
|
摘要: |
多维模型是数据仓库概念设计不可缺少的工具,将传统数据库实体关系模型直接转换到多维模型,势必在很大程度上缩短数据仓库系统的开发周期。针对数据仓库概念设计需求,在传统数据库基础上,提出一种面向多维模型的转换算法ER2MD。该算法可将满足一定条件的实体关系模型转换到多维模型,产生的多维模型符合广义多维范式,能够确保多维数据库分析计算的有效性,进而有利于物理数据库的设计。 |
关键词: ER模型 多维模型 转换 广义多维范式 |
DOI: |
投稿日期:2002-07-02 |
基金项目:国家自然科学基金资助项目(60172012) |
|
ER2MD:An Algorithm of the Transformation from ER Model to Multidimensional Model |
TANG Jiuyang, YANG Qiang, SHA Jichang, DENG Su, LU Changhui |
(College of Humanities and Management, National Univ.of Defense Technology, Changsha 410073,China)
|
Abstract: |
Multidimensional modeling is one of the chief techniques in conceptual design of data warehouse. If ER models of traditional databases can be directly transformed into multidimensional models, it would efficiently shorten the life circle of data warehouse design. Based on the traditional databases, an algorithm of the transformation from ER models to multidimensional models is presented. Those ER models under some conditions can be transformed, and the resulting multidimensional models conform to the standard of the generalized multidimensional normal form, ensuring the validity of analytical computations on multidimensional databases. Furthermore, the resulting multidimensional models favor an efficient physical database design. |
Keywords: ER model multidimensional model transformation generalized multidimensional normal form |
|
|
|
|
|