Design And Implementation Of Jiangsu Telecom Data Warehouse Software

Data warehouse is a growing field in data management technology and information marketwith promising future. In the view of data management, developments will allow databasecompanies keep introducing new data warehouse engines as server, which will be competent tocompete with database servers. In this field, parallel database with decision support expansionenjoys the greatest potentially. In the view of data performance, arithmetic and function ofmathematical statistics will be commonly integrated into on-line analytical processing systems.Also, they will tightly couple with INTERNET/WEB to be applied for front-end access to datawarehouse of Internet, which is free maintenance. Data warehouse client front end softwarecustomized on industry features will be part of the date warehouse solution. The methodology ofdata warehouse processing will be more popular and become branch of database design as well asnecessary element of information management system design.With the diversification of operation and realization of full service operation, Jiangsu Telecomhas set up several production management systems targeting for different services. However, in thepractice, a lot of problems have been found out, such as mass of data, widely data courses; differentunderstanding of data in various departments; influences on production system caused y unifiedanalysis.The three level structure of data warehouse provides complex application operation for dataanalysis as well as support to existing application integration and future expansions. Furthermore,the structure strengths safety mechanism improves performances and supports LDAP index service.The line-on of data warehouse will effectively integrate client’s data of BSS, billing systems andoperation analysis through unified structure, and provide decision support to managers with unifiedstandard in data warehouse.