Design and Implementation of Short Messages Analysis System Based on Multidimensional Data Modeling
Multidimensional data modeling is the foundation of OLAP. This paper presents methods of multidimensional data modeling and applies it to the SMS(short messages) communication service. In order to analyze SMS data, a OLAP model must be designed. After the data from SMS communication are divided into fact data and dimension data in accordance with needs for SMS data analysis, the fact table and dimension tables are created. The multidimensional SMS data analysis model is built on the tables and then implemented by SQL server.
J. Lin "Design and Implementation of Short Messages Analysis System Based on Multidimensional Data Modeling", Applied Mechanics and Materials, Vols. 130-134, pp. 200-203, 2012