常用OLAP查询优化方法性能分析  

Performance Analysis of Several OLAP Query Optimization Methods

作　　者：张银玲[1] 武彤[1] 

机构地区：[1]贵州大学计算机科学与信息学院

出　　处：《计算机技术与发展》2014年第1期39-42,46,共5页Computer Technology and Development

基　　金：贵州省工业攻关项目(黔科合GY字[2010]3061)

摘　　要：OLAP(Online Analytical Processing)查询常常涉及到不同的维表和事实表,要得到查询结果通常需要进行多张表的连接操作。连接操作是一种非常耗时的操作,因此,如何提高OLAP查询效率成为数据仓库应用中的关键问题。文中对存储过程、索引技术、物化视图等几种常用的OLAP查询优化方法进行性能分析,针对特定应用通过反复实验比较得出物化视图的优越性。而就物化视图而言,其本身有优越性的同时也存在一些缺陷。因此,针对物化视图更新问题提出了几种更新方案。OLAP query often involves different dimension tables and fact tables, to get the query result usually requires more table join op- erations. The connection operation is very time-consuming, consequently how to improve the efficiency of OLAP queries becomes the key problem in data warehouse. Analyze several OLAP query optimization techniques like stored procedure,index technique, and materi- alized view, take the superiority of materialized view by doing experiments in application-specific system. And in terms of materialized views, it has the superiority, also has some defects. So, the several methods to solve the update problem of materialized view are pro- posed.

关 键 词：OLAP 存储过程 索引技术 物化视图 

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