| 关系代数与SQL查询优化的研究 |
| |
| 引用本文： | 王峥,王亚平.关系代数与SQL查询优化的研究[J].电子设计工程,2009,17(8). |
| |
| 作者姓名： | 王峥 王亚平 |
| |
| 作者单位： | 1. 郑州铁路职业技术学院,河南郑州,450052
2. 西安外事学院,陕西西安,710077 |
| |
| 摘 要： | 详细分析关系代数表达式等价变换前后的查询代价.针对DBMS查询优化器如何生成成本最小的查询计划问题,给出关系代数表达式的优化规则.提出基于关系代数运算等价变换规则的SQL查询优化策略.该策略提供了查询优化器生成成本最小的查询计划的设计依据.
|
| 关 键 词： | 关系代数 查询优化 查询计划 优化策略 |
Research on relational algebra and SQL query optimization |
| |
| WANG Zheng,WANG Ya-ping.Research on relational algebra and SQL query optimization[J].Electronic Design Engineering,2009,17(8). |
| |
| Authors: | WANG Zheng WANG Ya-ping |
| |
| Abstract: | In this paper,the query cost before and after the equivalent transformation of the relational algebra expression is researched and analyzed in detail.Aiming at how the DBMS query optimizer to generate the smallest cost query plan,opti-mization rules of the relational algebra expression are given.SQL query optimization strategy based on equivalent transformation rules of the relational algebra is proposed.The strategy provides the design basis for the query optimizer to generate query plan of the smallest cost. |
| |
| Keywords: | relational algebra query optimization query plan optimization strategy |
| 本文献已被 万方数据 等数据库收录！ |
|
