Research And Appliction Of Multidimensional Data Analysis Based On The Cloud Platform

With the development in today’s information society, enterprise has produced huge amounts of data. These data contain a variety of enterprise information system data. Find an effective way of using and analyzing these data, provide enterprises with advantageous decision information, and at the same time, enables decision makers see the query results and data in a more easy way, so as to make enterprise development direction to obtain greater economic benefits, become the problem concerned by enterprises. The data warehouse and on-line analytical processing is now a way used for data analysis. The emergence of cloud platform provides a new way to deal with huge amounts of data.This paper first analyzes the status of development of the OLAP system at home and abroad, to determine the Hive data warehouse based on the cloud platform and the Angle of the combination of relational data analysis and research, and then introduces the on-line analytical processing (OLAP), Hadoop platform, Hive and relational database conversion tool, front desk display technology Jpivot related technology, and then the cloud platforms of multidimensional data analysis system architecture design, respectively from the relational database and Hive and relational database synchronization of data warehouse system of the detailed design and implementation.This system adopt ExJS frame at the front desk, the background by using the combined form of relational database and Hive data warehouse to support of multidimensional data analysis, completed the coding of the whole system, the final test.The system finished the data between relational database and data warehouse of Hive synchronization, completed the design of the report, such as storage and display function, at the same time realize the multidimensional data of drilling, roll-up, slice and dice, rotating OLAP operations.At the end of the paper, the work is summarized and prospected.