Design And Implementation Of Multidimensional Data Analysis Platform System

At present,big data is widely used in different fields.The previous multidimensional data analysis system is full of challenges under the massive data scale and structure,and the data analysis system assumes more responsibilities under the continuously increasing business volume.The main purpose of this paper is to design a multidimensional data analysis product,provide rich report functions,conduct multidimensional data analysis based on Netease News client data,and research and design the query optimization of online analytical processing(OLAP)system.The paper analyzes the actual situation of OLAP development in domestic and foreign,introduces the related concepts and technologies involved in the system,and makes an in-depth discussion based on the system requirements.The non functional,functional and feasibility requirements are analyzed.According to the requirements analysis,the overall design of the system and the design and implementation of each module function are carried out.According to the springboot development mode,the software hierarchy is designed,and the relevant functional modules of the system are set up,which are implemented according to the following three modules:report customization and management module,multidimensional data analysis module,and OLAP query optimization module.Then,based on springboot development framework,Hadoop big data framework,hive and other data warehouse technologies,Vue framework and other technologies,the front-end pages,back-end services and different functional modules are built,and the Apriori algorithm,which is commonly used in data mining,is improved,combined with the apriori improved algorithm to realize the query optimization of the system.Finally,the server configuration is selected,and the test environment of the system is constructed.The functional test cases are designed based on the system requirements to effectively test the system functional requirements.At the end of the paper,the overall summary of this work is made,and the further work prospects are described.