Design and Implementation of Short Messages Analysis System Based on Multidimensional Data Modeling

Jing Lin

doi:10.4028/www.scientific.net/AMM.130-134.200

Paper Titles

A Novel Dictionaries Preconditioning Algorithm for Compressive Sensing
p.183

Minimality and Closeure of Random Exponential Systems
p.188

Analysis and Finite Element Method Simulation of Rear Sub-Frame Hydroforming Process
p.191

Modeling Method for Complex Structure System in Finite Element Simulating Analysis
p.195

Design and Implementation of Short Messages Analysis System Based on Multidimensional Data Modeling
p.200

A Model of Tactic Threat Assessment in PAAIS
p.204

The Automatism Capture the Account Parameter in Engineering Figure Using Computer
p.208

Relationship between the Least Mesh Numbers of Models and Distance of Viewpoint in Efficient Real-Time Rendering
p.213

Designing and Kinematics Analysis on Running Mechanism of Biped Robot for Water-Running
p.217

HomeApplied Mechanics and MaterialsApplied Mechanics and Materials Vols. 130-134Design and Implementation of Short Messages...

Design and Implementation of Short Messages Analysis System Based on Multidimensional Data Modeling

Abstract:

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.

You might also be interested in these eBooks

Mechanical and Electronics Engineering III

View Preview

Info:

Periodical:

Applied Mechanics and Materials (Volumes 130-134)

Pages:

200-203

DOI:

https://doi.org/10.4028/www.scientific.net/AMM.130-134.200

Citation:

Cite this paper

Online since:

October 2011

Authors:

Jing Lin

Keywords:

Dimension Table, Fact Table, Multidimensional Data Modeling, OLAP, SMS Data Analysis Model

Export:

RIS, BibTeX

Price:

Permissions CCC:

Request Permissions

Permissions PLS:

Request Permissions

Сopyright:

Citation:

References

[1] Tony Bain, Professional SQL Server 2000 Data Warehousing with Analysis Services, China Electric Power Press, 2003, pp.180-196.

Google Scholar

[2] Chen Wenwei, Huang Jincai, Data Warehouse and Data Mining, Posts and Telecom Press, 2004, pp.55-58.

Google Scholar

[3] Xu Bihua, Li Jian, Liao Haode, Wang Bing, Research of Data-Warehouse-Based OLAP Drilling Analysis System, Information Technology and Applications (IFITA), 2010 International Forum on, July, 2010, pp.415-418, doi: 10. 1109/IFITA. 2010. 239.

DOI: 10.1109/ifita.2010.239

Google Scholar