基于语义缓存的数据库查询优化研究  

Database query optimization based on semantic caching

作　　者：富宇[1] 李春生[1] 高雅田[1] 

机构地区：[1]大庆石油学院计算机与信息技术学院,黑龙江大庆163318

出　　处：《计算机工程与设计》2009年第19期4432-4435,共4页Computer Engineering and Design

基　　金：黑龙江省教育厅海外学人基金项目(1151hz004)

摘　　要：为了应用智能化的方法提高数据库访问效率,基于多Agent技术构建了分布式数据库访问平台,研究并解决了平台的结构、各种Agent的设计、Agent间的协作机制、以及数据库系统的包装方法等关键问题。在优化策略方面,研究了分布式环境下的语义缓存技术,并提出了一种Agent平台下的智能预取算法,弥补了传统数据库优化手段缺乏智能性、预动性,以及重用困难等不足。通过在大型数据库系统上进行测试,表明该方案在进行大规模数据库操纵时效率有明显提高。To improve database manipulation efficiency with intelligent way, the distributed database accessing platform is constructed based on multi-agent, and the key problems are researched and solved, including the structure of the platform, the design of various agents, collaboration mechanism among the agents, and also the wrapper of database. Distributed semantic caching is studied as regards the optimization strategy, and an intelligent pre-fetching algorithm is proposed in agent-based platform, so the defects of the traditional optimization technologies is compensated, including the lack of intelligence, pre-mobility, and difficulties in reuse. Lastly, test on large-scale database system shows that the manipulation efficiency for large-scale database is improved markedly.

关 键 词：多AGENT系统 语义缓存 预取 分布式数据库 优化 

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