基于JADE的数据库自适应负载控制分析

摘要

传统DBA数据库控制方法对系统参数进行设置和配置时,存在控制效率低以及能耗高的问题.提出基于JADE的数据库自适应负载控制方法,设计以JADE平台为基础的数据库自适应负载控制系统.系统由搜索和查询两部分构成,通过Agent之间相互协作来完成总体系统的负载控制.通过数据库爬虫Agent在数据库中搜集信息,形成原始数据库;应用KNN算法对原始数据库进行分类,实现数据库负载控制.查询部分通过JSP页面中的用户接口Agent实现与用户的交互;采用JDBC桥技术实现查询Agent对数据库的访问.实验结果表明,采用所提方法控制数据库负载,可提高数据库的实现价值、吞吐率以及资源利用率.%The traditional DBA database control method exists low efficiency and high energy consumption for system parameter setting and allocation,so the JADE-based adaptive load control method of database is proposed to design the database adaptive load control system based on JADE platform.The system is composed of search and query.The load control of the overall system is completed by the mutual collaboration between Agents.The information is collected in the database by Agent,and the original database is formed.KNN algorithm is used to classify the original database to realize the load control of the database.The query part realizes the interaction with the users through the user interface Agent in the JSP page,and uses the JDBC bridge technology to query the Agent access to the database.The experimental results show that the proposed method for the database load control can improve the value,throughput and resource utilization of database.