| Over the past decade, with the development of national economy and people's living conditions improve, people's demand for communication services is increasing, while the telecommunications industry, the deepening of reform and restructuring of telecommunications charges, also stimulated the continuous reduction of the communication enterprise customer base and business the rapid volume growth in the telecommunications industry, competition heating up. With the September 30, 2008, telecommunications companies from the existing two main mobile operators, both fixed-line business reorganized into three main operating full-service carriers, China Mobile, Telecom, China Unicom has three mobile operators in both the business and Fixed business, it becomes even more intense market competition, increasing customer choice, telecommunications, competition for customers between enterprises tend to white-hot. Operators in order to grab customer resource, they played the "price war" led to a large number of users to switch between network operators to pay a high cost, while the price has not brought about a large number of new users, as the market changes in preferential discard cards Heavy network, but after the end of the concession period, resulting in decreased stability of the telecommunications business customers, the overall revenue to continue to decline. On the other hand, the telecommunications enterprises operating for many years to accumulate and form a certain scale user groups, user groups, traffic between the characteristics of consumer behavior and preferences there is a big gap between business and therefore the urgent need for the various telecom operators in small markets points, customer segmentation, will fit the client's business of marketing to the corresponding targeted populations, to achieve the user's stability, thereby ensuring the steady growth of overall revenue.Based on the above background, the three telecom operators need to establish a "business analysis system" as the core of marketing support system, through existing and new data operate precipitation data mining, analysis, company leaders, managers at all levels to provide the operating basis in order to achieve precision marketing.In this paper, the investigation of today's telecommunications business, based on analysis of development trends, according to my personal involvement of the Jilin branch of China Telecom Business Analysis System project as an example, Combination of OLAP and data mining and other related knowledge, discusses in detail the analysis system Jilin telecommunications operators, and this system is suitable for all communication enterprises. Paper is divided into six chapters, the system carried out a detailed description of, Including the systematic use of the development of technology, data interface specification, systems architecture design environment, the system vertical structure system design, data warehouse structure, information architecture design, system networks, system security and management, report management system functions, system themes, themes function realization, This paper describes a comprehensive system design and solutions, Discussed in detail to achieve a suitable communication corporate business analysis systems.Its characteristics are as follows:1, Jilin telecommunications management analysis system architecture reference to the client machines, application logic and processing server, database server, this three-tiered structure.2, Jilin Telecom Management Analysis System data primarily from the business support systems of production data generated every day and manual data entry. Of business support systems include: operating systems, billing systems, payment systems, settlement systems, billing systems, customer service systems. That do not facilitate the various business systems directly from the data obtained using manual methods to obtain entry.3, Jilin telecom environment management analysis system architecture to query / statistical models of management data as the core, the data service support system from each production subsystem data (including electronic and manual data), through the show (including the provision of Data Interface access method) of the other systems for the enterprise to provide operational and customer service level management information statistics and analysis, decision support.4, Jilin telecommunications operators and the processing of information analysis system consists of three parts,information collection, information storage, information display.5, Jilin telecommunications management analysis system uses the "modular" software design strategy for planning, software in general, divided into several modules: data acquisition module, data warehouse generation module, the application logic modules, meta-data management module and system management module , thus forming a hierarchical modular architecture.6, Jilin telecom operators from the service support system analysis system for the production of sub-data source (unified customer data subsystem, integrated business subsystems, integrated billing subsystem, customer service subsystem, etc.) to extract, transform, load, forming the system, the required information.7, Jilin telecom operation analysis system, the system is a multi-layer structure can be divided into data acquisition layer, data warehouse generation layer, application logic layer of the three levels.8, Jilin, telecom operators and analysis system for the convenience of the user in the query to get results the fastest speed, DW database-specific "OLAP" the contents of the condition the establishment of redundant data. The redundant data is for the "OLAP" requirement from "raw precipitation data" through "ETL process" to deduce results. In this way, whenever the user to do "OLAP" query, in fact, to obtain the existing static data, thus saving processing time.9, The data warehouse from the DWD layer, MID, DM three-tier data model, in which pairs of ODS and DWD were merged, and collectively referred to as DWD; an increase of slightly consolidated layer (MID). Mild synthesis layer and DWD The main difference lies in the application of two different fields, DWD data from production systems and to meet the needs of some unforeseen carried out precipitation; mild layer is a comprehensive analytic applications for small particle size statistics and sediment, increasing slightly consolidated layer can significantly reduce DWD layer to handle stress. This system is suitable for large-scale communication operation. |
PDF Full Text Request