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

OLAP（OnlineAnalyticalProcessing）查询常常涉及到不同的维表和事实表，要得到查询结果通常需要进行多张表的连接操作。连接操作是一种非常耗时的操作，因此，如何提高OLAP查询效率成为数据仓库应用中的关键问题。文中对存储过程、索引技术、物化视图等几种常用的OLAP查询优化方法进行性能分析，针对特定应用通过反复实验比较得出物化视图的优越性。而就物化视图而言，其本身有优越性的同时也存在一些缺陷。因此，针对物化视图更新问题提出了几种更新方案。

Performance Analysis of Several OLAP Query Optimization Methods

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.