| 动态更新实物化视图以提高OLAP查询效率 |
| |
| 引用本文： | 武彤,赵雪,赵洵.动态更新实物化视图以提高OLAP查询效率[J].计算机科学,2012,39(105):315-317. |
| |
| 作者姓名： | 武彤 赵雪 赵洵 |
| |
| 作者单位： | (贵州大学计算机科学与信息学院 贵阳550025) (中国传媒大学信息工程学院 北京100024)(中国传媒大学计算机学院 北京100024) |
| |
| 摘 要： | 在数据仓库系统中，OLAP查询一般都涉及多表连接和分组聚集两部分操作，提高这些查询的性能成为提高OLAP响应速度的关键。利用实物化视图，可以准确地计算并保存表连接或聚集等耗时较多的操作的结果。研究基于查询频率的实物化视图的更新算法，可以使实物化视图得到最大效率的使用，明显地缩短查询的响应时间，从而提高OLAP的查询效率。
|
| 关 键 词： | 数据仓库，实物化视图，OLAP，多维数据查询，查询优化 |
Dynamically Update Materialized View in Order to Improve the Efficiency of OLAP Queries |
| |
| Abstract: | In the data warehouse system, OLAP query usually involves two operations which are multi-table connection and grouping congregation. To improve the performance of queries has become the key to speed up OI_AP responding.Some time-assuming operations such as table connection and congregation can be calculated and preserved by utilizing materialized view. This investigation is based on the updated arithmetic of materialized view relating query frequency. It makes materialized view is fully utilized and query time can is highly shortened so that the query efficiency is able to be highly elevated. |
| |
| Keywords: | Data warehouse Materialized view OLAP Multi-dimension data query Query optimizing |
|
| 点击此处可从《计算机科学》浏览原始摘要信息 |
|
点击此处可从《计算机科学》下载全文 |
