Data Warehouse And Olap Technology, Applied Research In The Field Of Telecommunications

At present, the data warehouse technology is being in the fast development time, and on-line analysis processing system based on the data warehouse technology is becoming a new growing point of the IT profession. The data warehouse technology origins in carries on processing to the mass data, it is along with the service application need. Compares with the traditional database technology, the data warehouse has provided a better support for the decision analysis and jumped out the categories in traditional on-line business processes. Therefore, data warehouses technological development is very quick in the last few years, and peoples have developed many applications in each profession. Compare to the overseas middle or large scale enterprises our country enterprise's data warehouse construction is still in the exploration stage at present. In large-scale and information based enterprises like the telecommunication companies in China, building data warehouse application is a high-level request to the technology users. At present, books and the articles which introduced the data warehouse and the OLAP technology discuss many in the concept and the structure aspect, this article hoped through the discussion in the design and the specific implementation data warehouse, and OLAP based on data warehouse in practical and detail way, achieved embarks, prominent usable from the reality and the integration characteristic. This article first elaborated the data warehouse and the on-line analysis processing concept and their development histories, and then Described the situation of the traditional database application in our current country telecommunication profession; Met down this article theoretically analyzed the deference between the data warehouse and the multi-dimensional analysis technology to the traditional database applications, and elaborated with emphasis the concept and the method of the multi-dimensional analysis to the data , and proposed a algorithm which could effectively enhance the multi-dimensional inquiry efficiency - the substantialized view algorithm. In the application analysis part, carried on the analysis and the discussion in view of data warehouse construction in each key point, try to obtains the way which most suits the current telecommunication profession application with theory knowledge and the practical experience , then discussed several possible domain which the data warehouse and the online analytical processing technology can be used. Finally...