| 数据库多条件组合查询优化算法研究 |
| |
| 引用本文： | 骆力明,陈小兵,王彦丽. 数据库多条件组合查询优化算法研究[J]. 首都师范大学学报(自然科学版), 2007, 28(2): 23-27 |
| |
| 作者姓名： | 骆力明 陈小兵 王彦丽 |
| |
| 作者单位： | 首都师范大学信息工程学院,北京,100037;首都师范大学信息工程学院,北京,100037;首都师范大学信息工程学院,北京,100037 |
| |
| 摘 要： | 提出了一种查询优化算法，通过本算法，可以有效地减少查询语句的分支和数量以及IF条件语句的嵌套层数，大大提高了程序代码的可读性，通过分析研究该算法并未降低程序的运行效率。
|
| 关 键 词： | 数据库 条件查询 优化 |
| 修稿时间： | 2006-04-21 |
Research on an Optimization Algorithm of Multi-Condition Assembling Query on Database |
| |
| Luo Liming,Chen Xiaobing,Wang Yanli. Research on an Optimization Algorithm of Multi-Condition Assembling Query on Database[J]. Journal of Capital Normal University(Natural Science Edition), 2007, 28(2): 23-27 |
| |
| Authors: | Luo Liming Chen Xiaobing Wang Yanli |
| |
| Affiliation: | Information Engineering Institute of Capital Normal University, Beijing 100037 |
| |
| Abstract: | This article comes up with an query optimization algorithm. The branch and number of query sentence as well as layer number of IF sentence nesting can be decreased via this algorithm effectively. Also the readability of programming code can be improved efficiently via this algorithm. The analysis and research on this algorithm indicates that running efficiency of program has not been reduced. |
| |
| Keywords: | database condition query optimization. |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
