The System Of Telecom Analysis & Research

Enterprises on the regrouped Chinese telecom market are facing great challenges, which are market pressure, customers'demand, increase of cost, decline of ARPU and income and transfer of profit. It is hard for enterprises to maintain the competition advantage by way of expanding. Net quality of every operator inclines to be the same and their business range is open and consistent. All these demand telecom enterprises set up a business intelligent system (operation Analysis & decision support system ), on the basis of data organizing, data mining and information passage in order to improve competition ability, enhance competition advantage and support enterprise's market strategy.Operation Analysis & Decision Support System is based on the data warehouse technique, and orients analysis data processing. Data warehouse, varied from present operation database, efficiently integrates some data sources with different structures, and then recombines the data. The historical data storing in data warehouse is rarely modified. We can get the knowledge from information by mining the magnanimous data in data warehouse and exhibiting the information in multi-dimension.We consider metadata as core during the process of data warehouse construction and maintenance. Data are stored, called and managed in metadata, which is data about data. It connects with the whole process of data warehouse structure, operation and maintenance. According to the difference between metadata use and opposite object, metadata is classified into business, technique and operation. Metadata management concerns the life periods of data warehouse structure, operation and maintenance. Data warehouse in Jilin Telecom Company deals with large amount of business system and every level of enterprise operation. Only effective metadata management can guarantee the synchronization of data warehouse and business operation and enterprise adjusting according to market and business demand.This thesis describes how to construct data warehouse system in telecom enterprise by detailed elaborating the System of Telecom Analysis & Research of Jilin province communication corporation enterprise. Data warehouse extracts all kinds of detailed data from enterprise inner system. We combine client's property and other properties through combining data source and logic joint, format , reconstruct, split input data element on demand of output data format and analysis dimension. On demand of analysis subject and dimension, we create some data elements on base of input data elements, and correctly evaluate new value to new data elements by relative procedure. Data warehouse's data come from many data sources, and there are different code indications for same data. Before data enter database, we must standard the data by program, so we build a set of standard code warehouse and build the relationship of other systems'codes in process of data integration. Data integration program standardizes the relative...