基于语义的OLAP查询优化策略

An Optimization Strategy of OLAP Query Based on Sematic

根据Data Cube中单元格的层次性与聚集性,首先讨论了多个OLAP查询组成的OLAP查询集的查询优化策略,然后在单查询集优化的基础上,对于给定的多个OLAP查询集,识别公共查询.根据各查询之间的关系进行整体优化,采用动态启发式算法产生一个全局最优执行计划,从而避免磁盘冗余访问,减少查询执行时间.

This paper first studied the optimization strategy of single OLAP query set based on the hierarchy and semantic of cells in Data Cube, and then expanded the strategy to multi OLAP query sets. For the given multi OLAP Query sets, we discerned public query and carried on global optimization according to the relationship between the queries, and then produced a global optimum execute plan by using dynamic heuristic algorithm. The optimization can avoid redundant disk access and improve the efficiency of the OLAP queries.