Design And Implementation Of MMS System Based On Data Warehouse Technology

With MMS and the total number of mobile phone penetration rate continuously improve, MMS phone compatibility issues gradually weaken, MMS business has been growing rapidly into the mature stage, ushering in a new development at its peak, MMS (MMS) operational system will become a mobile operator focus, the scale of its network have also expanded.With time the growth, size and complexity of the network and the expansion of MMS business information system data indicate the explosive growth trends, business systems are also starting to many problems. On the one hand, the huge data system, data storage Heterogeneous result of the characteristics of data collection, collation, analysis of the increasingly onerous task; On the other hand, massive data is not effectively use, not for the decision-making system to provide in-depth and meticulous data analysis support, the formation of islands of information, the information can not play a powerful role in the network.Then, on the need to establish a system of information storage environment, will analyze large amounts of data needed for decision-making from the traditional separation of the operating environment, it was scattered, inconsistent data into integrated, unified data, different Users can be in this single environment, through the use of the data and found that a new vision and new problems, new ideas and analysis, and develop a systematic decision-making system. Based on the original system of MMS business network structure, data sources and user needs analysis, based on data warehouse technology to achieve MMS business system can achieve the data and make effective use of data for decision-making system to provide data analysis support purposes.This paper mainly focuses on the following aspects:(1) Introduce the participation of the provinces mobile MMS business systems projects, and I am responsible for the data processing module. MMS business through participation in the analysis of the status and characteristics of system was proposed based on the MMS data warehouse technology business solutions, designed and implemented the system logical model of data warehouse and data processing.Heterogeneous data for the characteristics of the system of data sources for the analysis of participation in the design and realization of the data processing to the data integration, unity of purpose and resolve of the original system data scattered, inconsistent problems.(2) According to the data warehouse design method, combining the needs of MMS business systems analysis, the system has defined "business flow analysis" and "quality of service analysis" theme. Based on the theme involved in the design and realization of the logic of relations between the data model, the original system to resolve the island's massive data problem.(3) Heterogeneous data for the characteristics of the system of data sources for the analysis, design and realization of the data processing to the data integration, unity of purpose.