Multidimensional Data Modeling Method Based On The Relational Data Model

Data model is one of the key problems of data warehouse. And many learns proved that traditional Relation Data Models couldn't effectively describe the structure and semantic of data warehouse applications,and couldn't meet the requirement of OLAP's applications also. Because the OLAP is multidimensional,the multidimensional data modeling techniques attract human's general attentions and wide interests.With the business competition becomes more and more hotly,the MISs couldn't completely meet the leader's requirements. They needed urgently a Data Warehouse System to help their decision-making. And how to build a Data Warehouse System based on MISs,how to build a Multidimensional Data Model based on Relation data Model attract human's general attentions.On these situations,this paper concluded the concept,motive,basic techniques,key problems and the present situation of researching of Multidimensional Data Modeling seriously. Based on the stock exchange,This paper described the approach of Conceptual Multidimensional Data Modeling Based on Multidimensional E/R Model in detail,and used it to model the stock exchange subject,then compared it with the existing Multidimensional Data Models. Based the applications,This paper described systemically the Multidimensional Data Modeling techniques,and stated classifiedly the main operations used in this technique with formalization means. This paper stated vividly the approach of building the Multidimensional Data Model based on the Relation data Model. In the process of building the Multidimensional Data Model,We made some mends on the time dimension,adapted the time model based on competition,and this model provided enough information for the later analysis based on time. And contempary,this paper used a new schema called Star Cluster Schema as the basic structure of the Multidimensional Data Model. The Cluster Schema is the joint of Star Schema and Snowflake Schema,it inherits their merits,and mends their disadvantages. This schema made good use in the application of stock exchange.