Application Of Data Warehouse And OLAP Technology In Comprehensive Traffic Analysis

After large-scale reorganization of China's telecoms industry, six companies were collapsed into three, each spanning mobile, fixed and broadband services. There is more intense competition in telecom market. Meanwhile, the quality requirements of telecommunications services are increasing.Good running of communications networks become the important factor to achieve competitive advantages.Current communication networks includ many types of network elements and the network structure is complex.,thus the certain difficulty of operation management of communication network increased. Data in different network management systems is accumulating, so it is difficult to form a unified view of operational information. There is no an effective analysis tools to analyze these vast amounts of data.Lack of full control of operational information can not support operate decision-making.Data warehouse and OLAP technology provide an effective way to solve this problem.In the data warehouse we create a unified data model, and integrate the data in the different network systems through ETL(Extract,Transform,Load) process into data warehouse,then build the cube according to the business model. OLAP technology make up for data warehouse deficiency in multidimensional data display. By slice, dice, drilling and other operations on the multidimensional data, flexible in-depth analysis and various ways of data display can meet the multi-level user data needs.This paper is based on Comprehensive traffic analysis system in Heilongjiang Branch of China Telecom.now system has been through inspection, running well, and provides forceful support for data analysis and operation decision.