|
|||||
|
|
| 对查询优化重写QRA算法的一种改进 | |
| 引用本文： | 涂利明,郑宁,葛灜龙. 对查询优化重写QRA算法的一种改进[J]. 计算机应用与软件, 2008, 25(4): 244-246 |
| 作者姓名： | 涂利明 郑宁 葛灜龙 |
| 作者单位： | 1. 杭州电子科技大学计算机学院,浙江,杭州,310018 2. 杭州电子科技大学软件职业技术学院,浙江,杭州,310012 |
| 摘 要： | 数据仓库系统中利用物化视图可以提高查询效率,但是,过分使用物化视图重写查询有时不一定能起到提高查询性能这一预期目的.针对QRA算法的不足并结合左深度处理树技术提出一种改进算法,通过实验结果表明由改进算法优化后查询的性能更优. |
| 关 键 词： | 物化视图 查询重写 查询优化 QRA算法 |
| 修稿时间： | 2006-05-16 |
AN IMPROVED QUERY REFORMULATION ALGORITHM FOR QUERY OPTIMIZATION |
|
| Tu Liming,Zheng Ning,Ge Yinglong. AN IMPROVED QUERY REFORMULATION ALGORITHM FOR QUERY OPTIMIZATION[J]. Computer Applications and Software, 2008, 25(4): 244-246 | |
| Authors: | Tu Liming Zheng Ning Ge Yinglong |
| Affiliation: | Tu Liming1 Zheng Ning1 Ge Yinglong21(College of Computer Science,Hangzhou Dianzi University,Hangzhou 310018,Zhejiang,China)2(College of Software Technology,Hangzhou 310012,China) |
| Abstract: | Materialized views can improve the performance of queries in data warehouse system.However,sometimes the performance of queries may not be raised if the materialized views are overused to rewrite queries.Considering the shortage of the QRA algorithm,and with the combination of the technology of left-deep processing tree,an advanced algorithm is proposed.Experiments show that the queries optimized by the advanced algorithm perform better than before. |
| Keywords: | Materialized views Query reformulation Query optimization QRA algorithm |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ | |