| 查询重写在查询优化中的应用 |
| |
| 引用本文： | 刘亚欣.查询重写在查询优化中的应用[J].大连铁道学院学报,2009(1):81-84. |
| |
| 作者姓名： | 刘亚欣 |
| |
| 作者单位： | 大连交通大学软件学院; |
| |
| 摘 要： | 查询优化是数据库系统设计和实现所采用的一项重要技术，也是影响数据库系统性能的一个关键因素。针对用户对查询效率要求较高的特点，对SQL查询语句具体的执行过程进行了深入地探讨，并以大连市公安局实际项目——刑事审讯辅助决策支持系统为研究背景，通过建立实视图的方法，对查询进行了重写，切实地提高了数据的查询效率。
|
| 关 键 词： | 查询重写 实视图 刑事审讯辅助决策支持系统 |
Query Rewriting Research and Application in Query Optimization |
| |
| LIU Ya-xin.Query Rewriting Research and Application in Query Optimization[J].Journal of Dalian Railway Institute,2009(1):81-84. |
| |
| Authors: | LIU Ya-xin |
| |
| Institution: | LIU Ya-xin(Software Institute,Dalian Jiaotong University,Dalian 116028,China) |
| |
| Abstract: | 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. |
| |
| Keywords: | query rewriting materialized view criminal Interrogation assistance decision support system |
| 本文献已被 CNKI 维普 等数据库收录！ |
