本文已被:浏览 1720次 下载 2974次
Received:November 02, 2013 Revised:December 09, 2013
Received:November 02, 2013 Revised:December 09, 2013
中文摘要: 利用面向对象语言C++作为开发语言,采用了ADO数据库访问技术、Socket网络通信技术进行了仓库信息管理系统的开发. 设计了一种改进混合蛙跳算法对关系数据库的多表查询进行优化,使其通信费用和响应时间都显著降低. 该系统使用C/S架构,具有登录权限管理,数据库访问,数据库操作,数据库查询管理,报表及打印等功能模块. 最后实验证明所设计的系统查询效率有显著提高,能够准确完成各种查询管理任务,提高了仓库管理效率并节约了成本,具有较强的实际意义.
Abstract: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.
文章编号: 中图分类号: 文献标志码:
基金项目:
引用文本:
李文俊,张爱林.数据库多表查询优化技术.计算机系统应用,2014,23(6):54-59
LI Wen-Jun,ZHANG Ai-Lin.Multiple-tables Query Optimization Technology for Database.COMPUTER SYSTEMS APPLICATIONS,2014,23(6):54-59
李文俊,张爱林.数据库多表查询优化技术.计算机系统应用,2014,23(6):54-59
LI Wen-Jun,ZHANG Ai-Lin.Multiple-tables Query Optimization Technology for Database.COMPUTER SYSTEMS APPLICATIONS,2014,23(6):54-59