Research And Implementation Of ETL Based On Network Data Mining System

Telecom operators have their own operation support system. The scale of communication systems is becoming more and more tremendous, and the business data and user data will continue to accumulate rapidly. How to get the information we are concerned form the mass data efficiently and how to extract and analyze the related information is becoming a very important question worth to study.The complexity of mobile communications services in business operations system make the convertional way of data storage and processiong became difficult to adapt to the current management of massive data analysis needs. In recent years, in the information field, the emergence of data warehousing and data mining techniques, specifically addressing the problem of mass data processing.This paper relies on the mobile network data mining system. It describes the background of the subject and the concepts and basic features of data warehouse and ETL. Then there is a brief introduction of the project’s overall architecture and implementation. The system is part of mobile operator support system. In this system, we use data mining and ETL technology to extract and analyze the business data generated by the base stations. Based on the introduction of the framework and project design, this paper focuses on the design and detailed implementation of the ETL process.The author of this paper responsible for the study and realization of ETL part in this project independently, the project objectives was successful completed, and good results are achieved. The entire project solves the problem of mining enterprise network data, and implements the network optimization program support effectively. ETL is the most basic and most critical module in the whole project. It is the base in building the data platform, and palys an important role of linking the system.