ER2MD：一种ER模型到多维模型的转换算法

多维模型是数据仓库概念设计不可缺少的工具,将传统数据库实体关系模型直接转换到多维模型,势必在很大程度上缩短数据仓库系统的开发周期.针对数据仓库概念设计需求,在传统数据库基础上,提出一种面向多维模型的转换算法ER2MD.该算法可将满足一定条件的实体关系模型转换到多维模型,产生的多维模型符合广义多维范式,能够确保多维数据库分析计算的有效性,进而有利于物理数据库的设计.

ER2MD:An Algorithm of the Transformation from ER Model to Multidimensional Model

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.