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

Query Rewriting Research and Application in Query Optimization

作　　者：刘亚欣[1] 

机构地区：[1]大连交通大学软件学院,辽宁大连116028

出　　处：《大连交通大学学报》2009年第1期81-84,共4页Journal of Dalian Jiaotong University

摘　　要：查询优化是数据库系统设计和实现所采用的一项重要技术,也是影响数据库系统性能的一个关键因素.针对用户对查询效率要求较高的特点,对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.

关 键 词：查询重写 实视图 刑事审讯辅助决策支持系统 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]