【作者】 张倩；

【导师】 李专；

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

【摘要】 商业智能工具迅速发展,多维查询技术日趋成熟,在线联机分析系统查询效率的提升成为急需解决的问题。聚集技术是提升在线联机分析系统性能的关键技术之一。在分析达梦聚集技术的基础上,研究聚集设计器的设计与实现,主要从系统的需求分析和体系设计、关键技术以及具体实现三方面进行研究。根据系统的需求分析,论证设计方案,设计出聚集设计器的体系结构。聚集设计器的体系结构主要包括元数据管理模块、聚集设计模块以及聚集方案优化模块。达梦多维查询模型元数据信息是聚集设计和聚集方案优化的重要依据,聚集元数据是多维查询模型元数据的一部分。元数据管理模块主要解决两方面的问题,一方面是多维查询模型元数据和聚集元数据格式的规范性问题,另一方面是元数据初始化方法的合理性问题。聚集设计模块主要功能是创建满足聚集技术要求的元素,这些元素包括聚集表、聚集表模式匹配以及聚集表排除。聚集方案优化模块研究聚集优化策略,其功能是从联机查询日志中分析系统执行查询的行为,然后根据优化策略动态生成聚集表,此模块主要包括查询日志分析组件、聚集方案优化组件、聚集物化组件和聚集元数据维护组件。实验表明,聚集设计器实现了聚集表设计、聚集模式匹配设计、聚集排除方式设计以及聚集方案优化策略,完成了系统的功能需求,提高了达梦在线联机分析系统的整体性能。更多还原

【Abstract】 With the rapid development of business intelligence tools and the mature of multidimensional query technology, the query efficiency of On-Line Analysis Processing system becomes an urgent problem.The aggregation technology is one of key technologies which can enhance the performance of the OLAP systerm.This paper,based on the analysis about Dameng aggregation technology,researches the design and implementation of the Aggregation Designer.Mainly research the three points about requirement analysis and system design,key technologies and implementation.According to the requirement analysis,demonstate the design program,and construct a reasonable system structure of Aggregation Designer.The structure mainly includes metadata management, the aggregation design and the aggregation program optimization.The metadata of Dameng Multi-dimensional query system is the basis of the aggregation design and the aggregation optimization.Aggregation metadata is part of it.The Metadata Management module mainly solves two problems of the storage format and the loading method.The Aggregation Design module is to creat elements which meet aggregation technical requirements.The elements include aggregation table,aggregation pattern matching and aggregation excluding tables.The Aggregation Program Optimization module researches the optimization strategy.Its function is to analyze the behavior of system’s queries from online query logs at first,and then dynamically generate aggregation table based on optimization strategy.The module includes analysis component of query log,optimization component,materilize component and aggregation metadata maintenance component.Experiment shows that the Aggregation Designer has achieved the design of aggregation tables,the design of aggregation pattern matching,the design of aggregation excluding tables and the optimization strategy,and realized the system functional requirements,improved the OLAP system performance.更多还原