Optimization research of the OLAP query technology based on P2P

Abstract

With the increasing data of the application system, the fast and efficient access to the information of support decision-making analysis has become more and more difficult. At the same time, analysis of the data is no longer on a single server or a single enterprise data, but on multiple servers, multiple departments or multiple enterprise data. So, the original OLAP technologies have also revealed many shortcomings. Although we can use index technology optimization method to improve the performance in a certain extent, but for the continually expanding amount of information in data warehouse, its performance is still the problem needed to be solved. Using the method of P2P network technology and OLAP storage query and query method, the paper has constructed a distributed P2P-OLAP network model and the model distributed stores the data and centralized manages the node. Next, the paper has put forward the storage and sharing scheme of multidimensional data, OLAP query scheme based on collaboration support. The idea of the scheme is that the query analysis is done by the coordination and cooperation of OLAP nodes. Finally, the paper has shown that the scheme can effectively improve the performance of decision analysis by the experiment.