基于JDBC的缓存数据细粒度管理的研究

Research on Fine-grained Management of Cached Data Based on JDBC

现有的JDBC缓存技术对缓存的管理是粗粒度的,然而由于Web请求的多样性,粗粒度的缓存管理并不能合理地利用缓存的优势。为提高Web应用系统的效率以使用户获得更好的使用体验,分析了内存数据库、进程内数据缓存技术和JDBC缓存的技术,在原有对JDBC缓存的研究基础上进一步深入研究,提出了基于JDBC的缓存数据自我管理、基于缓存生命周期的一致性维护策略及其实现方案。通过对JDBC缓存细粒度的管理,实现了对缓存数据的查询和更新,将数据库的一部分功能前置到了应用服务器中,减少了数据库的负载,因此提高了缓存的使用率、缩短数据请求的路径,从而提升Web系统的综合性能。测试结果表明,该方案能有效提高查询请求的命中率,减少数据访问耗时。

Existing JDBC caching technologies manage caches at a coarse-grained level.However,due to the diversity of Web requests,coarse-grained cache management does not properly take advantage of caching.In order to improve the efficiency of Web application system and make users get better experience,we analyze the in-memory database,in-process data cache technology and JDBC cache technology,conduct further study on the basis of the original research on JDBC cache,and propose a JDBC-based cache data self-management,consistency maintenance strategy based on the cache life cycle and its implementation scheme.Through the fine-grained management of JDBC cache,we realize the query and update of the cached data,and preloads part of the database to the application server to reduce the load of the database,thus improving the utilization rate of the cache,shortening the path of data requests,and improving the comprehensive performance of the Web system.The test shows that the scheme can effectively improve the hit rate of query request and reduce the time of data access.