Design And Implementation Of Query Analysis Client Of OLAP

Online Analytical Processing is one kind of multi-dimensional data analysistechnology on cube, its goal is to meet the user’s specific query needs in multi-dimensionalenvironment, facilitating the user to make decisions. OLAP system mainly consists of theOLAP server and multi-dimensional query client tool. On the basis of analysis and researchof the DMOLAP server, according to the needs of DM multi-dimensional client tool,designing and implementing a client tool to interact user with DMOLAP server.Through researching on the multi-dimensional query client tools and relatedtechnologies, multi-dimensional query client tool has mainly the following functions:generating multi-dimensional query and displaying the multi-dimensional query results setwith a two-dimensional table and supporting the operation of the commonmulti-dimensional analysis, so, this system includes three functional modules: themulti-dimensional data interaction module, multi-dimensional query generation module andmulti-dimensional data displaying and operating module.The multi-dimensional data interaction module is to interact with the server, thissystem uses Java Remote Method Invocation technology to communicate with the server,mainly through connected services and metadata services to get the metadata information，showing the metadata with tree structure. Multi-dimensional query generation module is togenerate a multi-dimensional query, this system uses Multi-dimensional eXpressions asmulti-dimensional query language, according to the grammatical structure of the query,providing a graphical wizard pages to assist the user to generate multi-dimensional query.Multi-dimensional data displaying and manipulation module is to display query results witha two-dimensional table, this system uses the dimension nested technique to design atwo-dimensional cross-table and display multi-dimensional data, the system canautomatically generate the code needed to complete common multi-dimensional operations,to complete the multi-dimensional operation user need only click the multi-dimensionaloperation button without the need to know the specific implementation details.Finally, the experiment shows that the system has achieved the expected goals, canassist users to generate the correct multi-dimensional query and be able to demonstrate andanalyze multi-dimensional query result set.