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

An Optimization Strategy of OLAP Query Based on Sematic

作　　者：杨科华[1] 刘胜钢[1,2] 

机构地区：[1]湖南大学计算机与通信学院,湖南长沙410082 [2]湖南理工学院计算机与信息工程系,湖南岳阳414000

出　　处：《湖南大学学报（自然科学版）》2009年第6期63-66,共4页Journal of Hunan University:Natural Sciences

基　　金：广东省产学研资助项目(2007A090302079)

摘　　要：根据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.

关 键 词：查询优化 联机分析处理 数据立方体 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]