【作者】 赵新；

【导师】 李专；

【作者基本信息】 华中科技大学 ， 计算机软件与理论， 2013， 硕士

【摘要】 联机分析处理是一种在多维数据集上进行多维分析的技术，它的目标是满足多维环境下用户的特定查询需求，方便用户做出决策。联机分析处理系统主要包括以下两个部分：联机分析处理服务器和多维查询客户端工具。在分析与研究达梦联机分析处理服务器的基础上，根据达梦多维查询客户端工具的需求设计与实现一个与达梦联机分析处理服务器进行交互的客户端工具。通过对国内外已有的多维查询客户端工具及采用的相关技术的分析，确定了本文的多维查询客户端工具主要有辅助用户生成多维查询语句、以二维表格形式展示多维查询结果集及支持常见的多维分析操作等功能，主要包括以下三个功能模块：多维数据的交互模块、多维查询语句的生成模块以及多维数据展示和操作模块。多维数据的交互模块的主要作用就是与服务器进行交互，本系统采用java远程方法调用的技术与服务器进行通信，主要通过连接服务和元数据服务来获取元数据信息并以树形结构来展示获取的元数据。多维查询语句的生成模块的主要作用就是生成多维查询语句，本系统采用的多维查询语言为多为表达式语言，根据查询语句的语法结构以一个图形化的向导页面来辅助用户生成多维查询语句。多维数据展示和操作模块的主要功能就是以二维表格的形式来展示多维查询的结果集，本系统采用维度嵌套技术设计了一个二维交叉表来展示多维数据，并且在二维交叉表上进行了特殊处理，即系统自动生成了完成常见多维操作所需要的代码，用户只需要点击系统提供的多维操作的按钮就可以完成这些操作，而不需要知道具体的实现细节。最后通过实验表明，本系统达到了预期目标，能够辅助用户生成正确的多维查询语句并能够展示和分析用户的多维查询结果集。更多还原

【Abstract】 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.更多还原