期刊文献+
任意字段
题名或关键词
题名
关键词
文摘
作者
第一作者
机构
刊名
分类号
参考文献
作者简介
基金资助
栏目信息

基于物化视图的查询重写技术研究与应用 被引量：1

Research and implementation of query system based on materialized views
下载PDF
导出
摘要 在数据库领域,如何加快查询执行速度非常重要。查询重写技术能透明地利用物化视图回答查询,避免了直接访问大量的原始记录以及耗时的连接和聚集计算,提高查询的执行速度。本研究讨论了基于数据库中的外键连接关系进行扩展的查询重写方法,以此为核心研究了针对小型数据库的物化视图查询系统,并通过实验证明了查询重写策略的有效性。 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.
作者 齐鸿志 胡雅颖 张玉新
机构地区 河北大学计算中心 河北农业大学信息科学与技术学院
出处 《河北农业大学学报》 CAS CSCD 北大核心 2008年第5期107-110,共4页 Journal of Hebei Agricultural University
关键词 查询重写 物化视图 外键 query rewriting materialized view foreign key
分类号 TP311.13 [自动化与计算机技术—计算机软件与理论]
  • 相关文献

参考文献6

  • 1[1]Grumbach S,Rafanelli M,Tininini L.Querying Aggregate Data[C]//In:Proceedings of the eighteenth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems,New York,USA:ACM Press,1999:174-184.
  • 2[2]Srivastava D,Dar S,Jagsdish H V,et al.Answering Queries with Aggregation Using Views[C]//ln:Proc of the 22nd VLDB Conf,Mumbai,India:Morgan kaufmann,1996:318-329.
  • 3[3]Jonathan Goldstein,Per-Ake Larson.Optimizing Queries Using Materialized Views A Practical,Scalable Solution[C]//ACM SIGMOD,Santa Barbara,California,USA:ACM Press,2001:86-89.
  • 4[4]Dobra A,Garofalakis M,Gehrke J,et al.Complex Aggregate Queries over Data Streams[C]//In:Proceedings of the 2002 ACM SIGMOD international conference on Management of data.New York,NY,USA:ACM Press,2002:61-72.
  • 5[5]Grumhaeh S,Tininini L.On the Content of Materialized Aggregate Views[C]//In:Proceedings of the nineteenth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems.New York,NY,USA:ACM Press,2000:47-57.
  • 6[6]Cohen S,Nutt W,Serebrenik A.Algorithms for Rewriting Aggregate Queries Using Views[C]//In:Proceedings of the East-European Conference on Advances in Databases and Information Systems.London,UK:SpringerVerlag,2000:65-78.

同被引文献8

  • 1HALEVY A.Y.Answering queries using views:a survey[J].International Journal on Very Large Data Bases,2001,10(4):270-294.
  • 2HALEVY A Y,MENDELZON A O,SAGIV Y,et al.Answering queries using views[C]//Proceedings of thefourteenth ACM SIGACT-SIGMOD-SIGART symposiumon Principles of database systems.New York,NY,USA:ACM,1995:95-104.
  • 3CHEN Li,RUNDENSTEINER E A.ACE-XQ:a cache-aware XQuery answering system[C]//Proceedings of the5th International Workshop on the Web and Databases.[S.l.]:IWWD,2002:31-36.
  • 4BALMIN A,OZCAN F,BEYER K,et al.A frameworkfor using materialized XPath views in XML query processing[C]//Proceedings of the 30th VLDB Conference.Toronto,Canada,VLDB,2004:60-71.
  • 5XU Wan-hong,OZSOYOGLU Z M.Rewriting XPath que-ries using materialized views[C]//Proceedings of the 31stInternational Conference on Very Large Data Bases.Nor-way:[s.n.],2005:121-132.
  • 6MANDHANI B,SUCIU Dan.Query caching and view se-lection for XML databases[C]//Proceedings of the 31st In-ternational Conference on Very Large Data Bases.Norway:[s.n.],2005:469-480.
  • 7FAN Wen-fei,GEERTS Floris,JIA Xi-bei.Rewriting re-gular XPath queries on XML views[C]//Proceedings of2007.IEEE 23rd International Conference on Data Engi-neering.Istanbul:IEEE,2007:666-675.
  • 8李静.基于XPath的XML查询重写算法[J].计算机工程,2009,35(10):83-85. 被引量：3

引证文献1

二级引证文献1

河北农业大学学报
2008年 第5期

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

内容加载中请稍等...
;
使用帮助 返回顶部