The Applications Of Datawarehouse And Data Analyse Technologies In Internet Telecomunications Value-Added Services

With the rapid development of Internet telecommunication value-added service, a mass of data were stored in the relational database management System .At the same time, with competition intensification among telecommunication operators, the Internet telecommunication value-added services play a more and more important role in the market of telecommunication. The traditional rational database cannot be used to find hidden information from the raw data. How to analyze historical data and get knowledge has become a factor for telecommunication operators to win the competition. Data warehouse, OLAP (On-line analytical processing) and Data mining technologies provide an effective way to solve this problem. But nowadays, there is seldom successful case and systemic achievement in the applications of data warehouse in Internet telecommunications value-added service fields. Under this background, this thesis designed and implemented the Operation and Analysis System of Internet telecommunication value-added service based on Data Warehouse and OLAP Analyse.Firstly, the paper introduces the research background and studies the technologies related to the data warehouse, OLAP and Data mining technologies which are the technological foundation of this paper.Secondly, the paper summarizes the character of Internet telecommunication value-added services, the function and business process of the Information platform of Internet telecommunication value-added service. This section is the business foundation of this paper.Thirdly, the paper discusses the design and realization of the subject analysis subsystem of the Internet telecommunication value-added services's Operation and Analysis System. This section is the emphasis of the whole paper. The subsystem is composed of three part: data store layer , data ETL layer and data access layer. In data store layer, we use...