| Domestic telecom operating companies have gone through many years' market operation and established its own operating system. Under year's accumulation, large telecom operators have owned data volume with TB class, and are still generating tens of GB data days. Because the sharply increasing of the telecommunication data scale and the complexity of the service type, the traditional database technology has not been able to satisfy to the processing demand of the magnanimous data. But the appearance of the data warehouse technology and the data analysis technology, which has provided the highly effective data-handling capacity and the good data analysis tool for the enterprise, and has provided a better support to the scientific decision-making analysis. Thus the application of data warehouse technology has become the inevitable tendency in the telecommunication network management system.ETL, the basic and important part of data warehouse, is one of the core technologies in data warehouse. Through of the extraction, transformation, unity and refined from different types of source data, it provide high quality and accuracy data to data warehouse system.The main contributions in this paper are as follows:1,Analyze the necessity of building the key performance indicators analysis system;2,Discussion the limitation of traditional ETL technique and make improvements3,Implement The ETL module of analysis System;This paper includes the analysis of the data structure of the system and the traditional data warehouse. Through of the project the author involved before, the author designed the structure of ETL module and analyzed its process control. |
