Research on the Transformation Between ER Model and Multidimensional Model
Tang Jiuyang · Jisuanji gongcheng · 2003
The ER model is often used in MIS, but it con't completely meet the requirements of OLAP. On the other hand, multidimensional model is widely used in the data warehouse design, while enterprise data are frequently defined in terms of ER model. Therefore, a key issue of data warehouse design is how to establish the association between ER model and multidimensional model. This paper firstly compares ER model with multidimensional model in detail, then with practical applications, demonstrates the condition and method of the transformation between ER model and multidimensional model, thus efficiently integrates the two models into the process of data warehouse design.