基于语义分解的联机分析处理查询并行优化方案  

Parallel OLAP query optimization method based on semantic decomposition

作　　者：魏莉[1] 杨科华[2] 

机构地区：[1]湘南学院计算机科学系,湖南郴州423000 [2]湖南大学计算机与通信学院,长沙410082

出　　处：《计算机应用》2010年第7期1956-1958,共3页journal of Computer Applications

基　　金：湘南学院科研基金资助项目(09Y028);广东省产学研项目(2007A090302079)

摘　　要：利用联机分析处理(OLAP)查询中存在的语义关联,对聚集关系与语义分解关系进行了形式化描述,并基于这些关系定义了查询与查询集之间的补集关系,在执行OLAP查询集时,可以利用这些关系尽可能地识别查询集中查询的公共部分,并且可以在查询时从多个角度来采取并行优化措施。实验验证表明采用并行优化方案后,系统的整体效率得到了提高。This article first gave out formalization definitions of aggregation relation and semantic decomposition relation between the Online Analytical Processing（OLAP） queries.Then the definition of supplementary set between the query and query set was provided.The common query in OLAP set could be found by using these relations and the OLAP queries could be optimized by parallel method from many aspects.Test results show that the system＇s overall efficiency has been improved by adopting parallel optimization method.

关 键 词：联机分析处理 语义关联 语义分解 查询集 并行查询优化 

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