Research And Application Of Data Cache Management Based On JDBC

With the development of information technology and the Internet,various types of Web applications have penetrated into people's lives.With the use of more and more users,Web applications are also facing great challenges.How to reduce the response time of applications to improve user experience has become the focus of current research.JDBC cache technology extends the cache function in JDBC technology,and makes the cache applicable to all applications using JDBC in the application server,with strong sharing.This technology can reduce the frequency of DataBase connection and improve system performance.However,the resources of the Web server are limited after all,it is impossible to cache all the data into memory,and there is a consistency problem between the cached data and the DataBase data.The existing JDBC caching technology stores full table data and is optimized only for full table queries,so its cache utilization is not high.In addition,the existing technologies do not make further research on multi-table management,cache update and query,cache consistency and so on.That is to say,there is no effective management of the cached data,so there is a shortage in practical application.This topic has carried on the detailed analysis to the JDBC technology,in order to enhance the cache utilization and the promotion system performance.In view of the shortcomings of existing technologies,this paper studies the data organization and management,data reuse,data consistency and other aspects of JDBC caching technology.The main research work is as follows:First,the use of hash structure to store the full amount of data of many tables,so that JDBC caching technology supports multi-table cache management;The use of hash and list data structures to manage the multi-table SQL statement cache ensures the consistency of the cache with the DataBase at the end of the cache life cycle.Secondly,on the basis of the management of multi-table cache result set,a set of SQL statement analysis model is designed according to the characteristics of SQL statement,and the function of cache class is extended,so as to realize the query and update function of the cache result set.Thirdly,when the cache data changes,a consistency maintenance strategy based on the cache life cycle is designed to ensure the correctness of the data.Finally,an experiment is designed for verification.In the functional verification experiment,the validity of cache query and update and consistency maintenance strategy based on cache life cycle was tested.In the experiment of system performance,the actual application scenario is simulated and compared with the original JDBC technology and the existing JDBC caching technology to analyze the cache hit ratio and average response time.The experimental results show that the JDBC cache data management technology proposed in this paper can effectively improve the performance of Web system.