Research Of Aggregation Design Tool Based On Dameng OLAP

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.