数据库多表查询优化技术  

Multiple-tables Query Optimization Technology for Database

作　　者：李文俊[1] 张爱林[1] 

机构地区：[1]中国船舶重工集团公司第七一〇研究所生产部,宜昌443003

出　　处：《计算机系统应用》2014年第6期54-59,共6页Computer Systems & Applications

摘　　要：利用面向对象语言C++作为开发语言,采用了ADO数据库访问技术、Socket网络通信技术进行了仓库信息管理系统的开发.设计了一种改进混合蛙跳算法对关系数据库的多表查询进行优化,使其通信费用和响应时间都显著降低.该系统使用C/S架构,具有登录权限管理,数据库访问,数据库操作,数据库查询管理,报表及打印等功能模块.最后实验证明所设计的系统查询效率有显著提高,能够准确完成各种查询管理任务,提高了仓库管理效率并节约了成本,具有较强的实际意义.This paper uses object-oriented programming language C＋＋ as a development language. The work uses ADO database access technologies and socket network communication technology in warehouse management information system design. It uses Shufled Frog Leaping Algorithm on multiple-table query Optimization for relational database. It makes their communications and response time are significantly reduced. The system uses c/s framework with logon rights management, database access, database operations, database query management and function modules such as printing a report. At last, experiment proves system designed makes Query time improved significantly and it accurately complete all kinds of queries management tasks. The system improues the storage management efficiency and makes cost saued, it has a strong practical relevance.

关 键 词：混合蛙跳算法 查询优化 关系数据库 赫夫曼编码 C++ 

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