Research And Application Of Data Model Of Telecom Business Analysis System

In recent years, the resolution and reorganization of China's telecommunications market have prompted the telecommunications industry more competitive. Enterprise decisions have increasing influence on the telecommunications industry pattern. After years of development, Communications firms have been gradually building comparatively complete accounting system, settlement system, channel system, customer service system, network management system, finance system, statistic system, and other operational support systems, these systems have accumulated a huge amount of different types of information. How to integrate historical data and build BI ( Business Intelligence ) platform for the enterprises to play a supporting role in the decision-making, is a major task which the telecommunications industry are facing.The entire BI architecture, from simple report forms output system and the EIS (Executive Information System) , to multi-dimensional analysis statistic and data mining, to the ability to explore and customizable analytical application technology, has developed considerably. The starting point of supporting and maintaining any BI environment is creating a high-quality and reliable data warehouse. The development and maturation of data warehouse technology have brought unprecedented opportunities and challenges to BI application of the telecommunications. Faced with huge market potential and drastic competition, how to build a advanced, perfect data storage system (Operating System) for telecommunications enterprises to support decision, thereby enhancing their core competitiveness, enhancing customer satisfaction, has become a prior problem of the domestic telecommunications enterprises of the moment.Based on the comparative study of the typical architectures of the data warehouse, the modified project of centralized architecture which is suitable for the large enterprise data warehouse and is composed of central data warehouse layer, the middle layer, data mart layer, is promoted. The three layer data warehouse architecture project can enhance the reusability, flexibility and expandability of data warehouse, realize the data sharing of data marts , reduce the difficulty of ETL script, use space for time to improve system performance and to reduce consumption of system resource. Then the management and analysis system of a provincial level domestic telecommunications company is used as an example, the implementary background and business objectives were reviewed. On the basis of the use of data warehouse technology and commercial logic, The thesis discourses on the design ideas, principles, methods and agreement of the central data warehouse data model, the middle layer data model and data mart level data model of the telecom Data Warehouse.