| 基于物化视图的查询重写技术研究与应用 |
| |
| 引用本文： | 齐鸿志,胡雅颖,张玉新. 基于物化视图的查询重写技术研究与应用[J]. 河北农业大学学报, 2008, 31(5) |
| |
| 作者姓名： | 齐鸿志 胡雅颖 张玉新 |
| |
| 作者单位： | 河北大学,计算中心,河北,保定,071000;河北农业大学,信息科学与技术学院,河北,保定,071001 |
| |
| 摘 要： | 在数据库领域,如何加快查询执行速度非常重要。查询重写技术能透明地利用物化视图回答查询,避免了直接访问大量的原始记录以及耗时的连接和聚集计算,提高查询的执行速度。本研究讨论了基于数据库中的外键连接关系进行扩展的查询重写方法,以此为核心研究了针对小型数据库的物化视图查询系统,并通过实验证明了查询重写策略的有效性。
|
| 关 键 词： | 查询重写 物化视图 外键 |
Research and implementation of query system based on materialized views |
| |
| QI Hong-zhi,HU Ya-ying,ZHANG Yu-xin. Research and implementation of query system based on materialized views[J]. Journal of Agricultural University of Hebei, 2008, 31(5) |
| |
| Authors: | QI Hong-zhi HU Ya-ying ZHANG Yu-xin |
| |
| Abstract: | To quickly answer queries matters most in database environment.Queries are transparently rewritten using materialized views and the time consumed by queries is reduced by avoiding accessing huge raw records and performing time-consuming operations.This paper discusses the extended query rewriting method based on join relation with foreign key,studies query system based on materialized views,and aims to prove its validity. |
| |
| Keywords: | query rewriting materialized view foreign key |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
