基于JDBC数据管理与查询优化的研究  

Research on Data Management and Query Optimization Based on JDBC

作　　者：韩兵 李晶晶 方英兰 HAN Bing;LI Jing-jing;FANG Ying-lan(School of Computer Science,North China University of Technology,Beijing 100144,China;Beijing Key Laboratory on Data Integration and Analysis Technology of Large-scale Stream,Beijing 100144,China)

机构地区：[1]北方工业大学计算机学院,北京100144 [2]大规模流数据集成与分析技术北京市重点实验室,北京100144

出　　处：《计算机技术与发展》2018年第9期176-180,共5页Computer Technology and Development

基　　金：国家自然科学基金(61370051)

摘　　要：在大多数Web应用系统中,当用户浏览数据时,每次都向数据库发送查询请求的做法会使系统性能下降,查询速度降低,而利用缓存技术将部分数据缓存在Web应用服务中可以减少对数据库的查询操作,提高数据的利用率和检索效率。JDBC是应用程序与数据库进行交互的桥梁,通过对JDBC中类和接口进行修改和扩展,设计了一个基于JDBC数据管理的模型,其中重点研究了缓存置换机制。根据系统对缓存项访问的频率、时间间隔以及缓存项占用存储空间的大小等特性,结合最近最少使用算法,提出了一种基于价值函数的缓存置换算法,选择价值最小的缓存项进行置换,并设计模拟实验进行验证。实验结果表明,在JDBC管理的缓存空间中利用该算法可以取得较高的缓存命中率,服务器的响应速度也得到了提高。In most Web applications,sending a query request to the database each time when users browse the content will lead to a de-cline in system performance and a low query speed. Reserving some of the data in Web application services using the caching technologycan reduce the query operation of the database and improve the data utilization and retrieval efficiency. JDBC is the bridge between theapplication and the database,so we design a model based on JDBC data management by modifying and extending the classes and inter-faces in JDBC,which focuses on the cache replacement mechanism. Combined with the least recently used algorithm,we propose a cachereplacement algorithm of cache value according to characteristics such as frequency of data access,time interval and size of cache entries,selecting the cache item with least value for replacement and designing the simulation experiment for verification. The experiment showsthat this algorithm can achieve high data hit rate in the cache space about JDBC management and improve the server response speed.

关 键 词：JDBC WEB应用 热点数据 缓存置换 缓存价值 命中率 

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