数据库多条件组合查询优化算法研究  

Research on an Optimization Algorithm of Multi-Condition Assembling Query on Database

作　　者：骆力明[1] 陈小兵[1] 王彦丽[1] 

机构地区：[1]首都师范大学信息工程学院,北京100037

出　　处：《首都师范大学学报（自然科学版）》2007年第2期23-27,共5页Journal of Capital Normal University：Natural Science Edition

基　　金：北京市教委项目(KM200510028018)

摘　　要：提出了一种查询优化算法,通过本算法,可以有效地减少查询语句的分支和数量以及IF条件语句的嵌套层数,大大提高了程序代码的可读性,通过分析研究该算法并未降低程序的运行效率。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.

关 键 词：数据库 条件查询 优化 

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