Statistics And Analysis System For Telecommunication Accounts Based On The Data Warehouse And OLAP

With the development of information and technology, the competition ofthe telecommunication market is more and more vigorous, all telecomcarriers are constantly cutting down the cost, developing new service,maintaining current customer, and responding to the change of marke timelyand rapidly. Customer data is one of the most valuable resourses for thetelecom carriers,we must consider how to make good use of the customerdata bring the high profit and great competitions for the telecom carriers. Soit is very important to build the data warehouse and OLAP model for specifictopics." A data warehouse is an subject-oriented,integrated,time-variant,andnonvolatile collection of data in support of management's decision makingprocess ". Data warehouse is a kind of language which can storage theconsistent data, it provides architectures and tools for business executives tosystematically organize,understand,and use their data to make strategicdecision.As an enterprise–ranked application, the data warehouse maily providethe following advantages for the enterprise :1)Lighten the system burden and simplify dayly maintain and management;2)Improved the data's integrity, and compatiblity and availability;3)Raised the efficiency of the data access;4)Provided simple unified query and report mechanisms.The thesis is just to complete the data warehouse and OLAP model oftelecom accout's design and implement. First, it introduces the knowledge ofdata warehouse and the on line analytical process,and then elaborated how todesign cube model in telecom enterprise, last it tell us the design andimplement of the software structure of telecom accout statistics and analysissystem.The thesis summarizes ways and steps of DW design as well as itsprocess-realizing in order to make DW up to anticipant standard.Thuseffective storage and management of data can be realized and OLAP inE-commerce Decision Support System can be supported. Though buildingthe data warehouse can provide the resource for the online analytical process. In the application of the telecom carriers, the data warehouse mainlyincludes following few aspects:●Analysis the customer data●Analysis the customer runs off...