基于JDBC数据管理与查询优化的研究
|
摘要
在大多数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 decline in system performance and a lowquery speed. Reserving some of the data in Web application services using the caching technology can reduce the query operation of the database and improve the data utilization and retrieval efficiency. JDBC is the bridge between the application and the database,so we design a model based on JDBC data management by modifying and extending the classes and interfaces in JDBC,which focuses on the cache replacement mechanism. Combined with the least recently used algorithm,we propose a cache replacement 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 shows that this algorithm can achieve high data hit rate in the cache space about JDBC management and improve the server response speed.
In most Web applications,sending a query request to the database each time when users browse the content will lead to a decline in system performance and a lowquery speed. Reserving some of the data in Web application services using the caching technology can reduce the query operation of the database and improve the data utilization and retrieval efficiency. JDBC is the bridge between the application and the database,so we design a model based on JDBC data management by modifying and extending the classes and interfaces in JDBC,which focuses on the cache replacement mechanism. Combined with the least recently used algorithm,we propose a cache replacement 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 shows that this algorithm can achieve high data hit rate in the cache space about JDBC management and improve the server response speed.
引文
[1]张明.IaaS中基于热点数据的存储系统研究与实现[D].哈尔滨:哈尔滨工业大学,2015.
[2]陈正举.基于HIBERNATE的数据库访问优化[J].计算机应用与软件,2012,29(7):144-149.
[3]谢杰涛,吴敏,吴娟,等.Web系统高性能本地数据缓存实现机制[J].计算机应用研究,2014,31(7):2074-2077.
[4]CABRAL S K.MySQL 5.5:improving on the world's most popular open source database[J]. Database Trends and Applications,2011,25(3):30-33.
[5]邱林锋,曹学成,柏文阳.自适应的数据库查询缓存[J].计算机工程与应用,2008,44(22):159-161.
[6]BELKNAP P,DAGEVILLE B,DIAS K,et al. Self-tuning for SQL performance in Oracle database 11g[C]//IEEE25th international conference on data engineering. Shanghai,China:IEEE,2009:1694-1700.
[7]ZHANG Yi,ZHANG Luyong.JDBC-based middleware applications in instant message systems[C]//2nd international conference on systems and informatics. Shanghai,China:IEEE,2014:1044-1049.
[8]荣艳冬.关于Mybatis持久层框架的应用研究[J].信息安全与技术,2015(12):86-88.
[9]乔岚.基于MyBatis和Spring的JavaEE数据持久层的研究与应用[J].信息与电脑,2017(8):73-76.
[10]姚金成,张世栋,史玉良,等.基于Chunk Folding的多租户数据库缓存管理机制[J].计算机学报,2011,34(12):2319-2331.
[11]余文涛,李立新,毛秀青,等.移动环境下一种缓存管理策略[J].计算机应用与软件,2014,31(12):178-181.
[12]胡伟之,沈富可.基于Web访问特性的缓存替换策略[J].计算机应用,2008,28(S2):48-50.
[13]吴俊龙,杨清.基于协同过滤的Web缓存替换算法研究[J].计算机工程与科学,2015,37(11):2128-2133.
[14]蔡建宇,杨树强,贾焰,等.关系数据库语义缓存的研究进展[J].计算机工程与科学,2005,27(10):62-64.
[15]王文博,王菁,邢起源,等.移动即时通讯软件的缓存替换策略[J].计算机科学与探索,2015,9(3):292-299.
[16]邢起源,王菁,闫阿宾,等.一种基于社交关系的移动缓存替换算法[J].计算机科学,2016,43(6):44-49.
[17]KUMAR V R,SWATI M.Cache replacement algorithms for coordinated cooperative social wireless networks[J].International Journal of Computer Science and Mobile Computing,2014,3(10):718-725.
[2]陈正举.基于HIBERNATE的数据库访问优化[J].计算机应用与软件,2012,29(7):144-149.
[3]谢杰涛,吴敏,吴娟,等.Web系统高性能本地数据缓存实现机制[J].计算机应用研究,2014,31(7):2074-2077.
[4]CABRAL S K.MySQL 5.5:improving on the world's most popular open source database[J]. Database Trends and Applications,2011,25(3):30-33.
[5]邱林锋,曹学成,柏文阳.自适应的数据库查询缓存[J].计算机工程与应用,2008,44(22):159-161.
[6]BELKNAP P,DAGEVILLE B,DIAS K,et al. Self-tuning for SQL performance in Oracle database 11g[C]//IEEE25th international conference on data engineering. Shanghai,China:IEEE,2009:1694-1700.
[7]ZHANG Yi,ZHANG Luyong.JDBC-based middleware applications in instant message systems[C]//2nd international conference on systems and informatics. Shanghai,China:IEEE,2014:1044-1049.
[8]荣艳冬.关于Mybatis持久层框架的应用研究[J].信息安全与技术,2015(12):86-88.
[9]乔岚.基于MyBatis和Spring的JavaEE数据持久层的研究与应用[J].信息与电脑,2017(8):73-76.
[10]姚金成,张世栋,史玉良,等.基于Chunk Folding的多租户数据库缓存管理机制[J].计算机学报,2011,34(12):2319-2331.
[11]余文涛,李立新,毛秀青,等.移动环境下一种缓存管理策略[J].计算机应用与软件,2014,31(12):178-181.
[12]胡伟之,沈富可.基于Web访问特性的缓存替换策略[J].计算机应用,2008,28(S2):48-50.
[13]吴俊龙,杨清.基于协同过滤的Web缓存替换算法研究[J].计算机工程与科学,2015,37(11):2128-2133.
[14]蔡建宇,杨树强,贾焰,等.关系数据库语义缓存的研究进展[J].计算机工程与科学,2005,27(10):62-64.
[15]王文博,王菁,邢起源,等.移动即时通讯软件的缓存替换策略[J].计算机科学与探索,2015,9(3):292-299.
[16]邢起源,王菁,闫阿宾,等.一种基于社交关系的移动缓存替换算法[J].计算机科学,2016,43(6):44-49.
[17]KUMAR V R,SWATI M.Cache replacement algorithms for coordinated cooperative social wireless networks[J].International Journal of Computer Science and Mobile Computing,2014,3(10):718-725.