Application Of Data Warehouse Technology In MIDC Operation Data Analysis System

In terms of the whole world, recently, mobile communication network has been evolving from 2.5G to 3G, and the development of mobile data service is extremely rapid. As the development of SP service, the inset menu of the mobile phone by of terminal manufacturer has been an important product of SP marketing service, gradually emphasized by SP. The cooperation of the SP Company and terminal manufacturer is becoming a more and more important marketing method in promoting the terminal inset service. At the same time, the benefit allocation between SP Company and terminal manufacturer is also the main difference from their cooperation. And MIDC(Monternet Internet Data Center) appear in this case.MIDC, the operation platform provided by China Mobile Company for SP and terminal manufacturer, implements the service trusteeship, and becomes the according of the benefit allocation and the cooperation criterion between SP and terminal manufacturer. Besides, China Mobile Company also participate in the cooperation, which made the MIDC become the cooperation platform of China Mobile , SP and terminal manufacturer, and strengthen the controlling degree of China Mobile to SP and terminal manufacturer.China Mobile Data Service Operation and Support Center mainly takes charge in the design and implementation of operation data analysis system in the MIDC operation analysis platform, this system which is extendable would provide agile, nice and complete report forms. Statistic analyzer, according to relevant requirement and logic relationship between the analysis elements, can distill the relative data, workout all kinds of statistic and design report forms, and bring forth the forms with diversification including form, file, chart and diagram. Service department, according to self requirement, can make a further knowledge and design of the customer and service operation, and then workout the way and manner that the service develops next.The paper takes the building of the MIDC operation data analysis system in the China Mobile Data Service Operation and Support Center for background, and introduces the concrete database application in the MIDC combining the implementation process of the database system. Linking with my work, the paper introduces the database modeling, ETL design ,implementation and optimization and the subject analysis design and implementation.