| 查询表达式优化的研究与实现 |
| |
| 引用本文： | 金洪伟,苏厚勤.查询表达式优化的研究与实现[J].计算机应用与软件,2008,25(6):123-125. |
| |
| 作者姓名： | 金洪伟 苏厚勤 |
| |
| 作者单位： | 东华大学计算机科学与技术学院,上海,200051 |
| |
| 摘 要： | 查询是数据库应用系统中使用最频繁的操作,其执行效率很大程度上影响了整个系统的性能.介绍了查询表达式优化的一般过程,在查询重写阶段提出了一种面向对象的框架,设计和实现了"多字段间关系自动推理"等若干种优化算法.测试结果表明,查询取得了良好的优化效果.
|
| 关 键 词： | 查询表达式优化 where子句 查询重写 |
| 修稿时间： | 2007年8月21日 |
ON QUERYING-EXPRESSION OPTIMIZATION AND ITS IMPLEMENTATION |
| |
| Jin Hongwei,Su Houqin.ON QUERYING-EXPRESSION OPTIMIZATION AND ITS IMPLEMENTATION[J].Computer Applications and Software,2008,25(6):123-125. |
| |
| Authors: | Jin Hongwei Su Houqin |
| |
| Affiliation: | Jin Hongwei Su Houqin(College of Computer Science , Technology,Donghua University,Shanghai 200051,China) |
| |
| Abstract: | Inquiries are most frequently used in database application system,the operation efficiency of them will greatly affect the performance of the whole system.This paper introduces general procedure of querying optimization,an object-riented frame in query-ewrite phase is proposed,and several optimized algorithms which include uto-atiocination for Relationship among Multi-ields have been planned and implemented.The testing results show that the query performance is well optimized. |
| |
| Keywords: | Query expression optimization Where clause Query rewrite |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
