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

查询重写在查询优化中的应用

Query Rewriting Research and Application in Query Optimization
下载PDF
导出
摘要 查询优化是数据库系统设计和实现所采用的一项重要技术,也是影响数据库系统性能的一个关键因素.针对用户对查询效率要求较高的特点,对SQL查询语句具体的执行过程进行了深入地探讨,并以大连市公安局实际项目──刑事审讯辅助决策支持系统为研究背景,通过建立实视图的方法,对查询进行了重写,切实地提高了数据的查询效率. Query optimization is an important technique for designing and implementation database system and a crucial factor that affects the capability of the database. Aim at the factual problem of query efficiency, the concretely executive process of SQL statement reference to the characteristic of database query is analyzed Based on Dalian Criminal Interrogation assistance decision support system, materialized view is constructed, and the SQL statement is rewritten, which improves query efficiency.
作者 刘亚欣
机构地区 大连交通大学软件学院
出处 《大连交通大学学报》 CAS 2009年第1期81-84,共4页 Journal of Dalian Jiaotong University
关键词 查询重写 实视图 刑事审讯辅助决策支持系统 query rewriting materialized view criminal Interrogation assistance decision support system
分类号 TP311.13 [自动化与计算机技术—计算机软件与理论]
  • 相关文献

参考文献6

二级参考文献20

  • 1[1]A Y Levy, A O Mendelzon, Y sagiv et al. Answering queries using views. In: Proc of the 16th ACM SIGACT SIGMOD SIGART Symp on Principles of Database Systems (PODS'95). San Jose, California, 1995. 95～104
  • 2[2]Rajaraman, Y Sagiv, J D Ullman. Answering queries using templates with binding patterns. In: The 16th ACM SIGACT SIGMOD SIGART Symp on Principles of Database Systems (PODS'95). San Jose, California, 1995
  • 3[3]Rachel Pottinger, Alon levy. A scalable algorithm for answering queries using views. In: Proc of the 26th Int'l Conf on Very Large Data Bases (VLDB). Vairo, Egypt, 2000
  • 4[4]S Cohen, W Nutt, A Serebrenik. Rewering aggregate queries using views. In: Proc of the 18th ACM SIGACT SIGMOD SIGART Symp on Principles of Database Systems (PODS'99). Philadelphia, Pennsylvania, 1999
  • 5[5]D Srivastava, S Dar, H V Jagadish et al . Answering queries with aggregation using views. In: Proc of the 22nd Int'l Conf on Very Large Data Bases (VLDB'96). Bombay, India, 1996. 318～329
  • 6[6]Duschka, M R Genesereth. Answering recursive queries using views. In: Proc of the 16th ACM SIGACT SIGMOD SIGART Symp on Principles of Database Systems (PODS'97). Tucson, Arizona, 1997
  • 7[7]Yannis Papakonstantinou, Vasilis Vassalos. Query rewriting for semi-structured data. In: Proc of ACM SIGMOD Conf on Management of Data. Philadephia, Pennsylvania, 1999
  • 8[8]Vasillis Vassalos, Yannis Papakonstantinou. Describing and using query capabilities of heterogeneous sources. In: Proc of the Conf on Very Large Data Bases (VLDB). Athens, Greece, 1997. 256～265
  • 9[9]D Calvanese, G De Giacomo, M lenzerini et al. Rewriting of regular expressions and regular path queries. In: Proc of the ACM SIGACT SIGMOD SIGART Symp on Principles of Database Systems (PODS'99). Philadelphia, Pennsylvania, 1999
  • 10[10]Gio Wiederhold. Mediators in the architecture of future information systems. IEEE Computer, 1992, 25(3): 38～49

共引文献21

大连交通大学学报
2009年 第1期

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

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