Research Of Memory Data Management Technology Based On JDBC

With the increase of Internet information and user access,how to make the web application system respond data quickly and reduce user's waiting time has become a hot issues in current research.Therefore,There are many new technologies proposed.JDBC data caching is a kind of in-memory caching technology using JDBC,which opens up a storage space in the memory of the Web server and then keeps frequently-accessed query results in it.So that the cached data can be returned immediately when the same query is sent next time,the interaction times between Web application system and database data can be reduced and the system's query efficiency can be improved.However,the capacity of the Web server's memory is limited,and the available cache space is also limited.It is impossible to cache all the data into memory.In addition,caching data in memory inevitably will bring about a coherent problem between in-memory cached data and the actual data in the database.However,existing JDBC data caching technology is only an attempt and an implementation based on the single-table cache function.It has some defects in the organization and storage of multi-table data,the replacement strategy and the maintenance of cache coherency.That is,it does not provides a effective management for web server's memory about these three issues,so it can't complete the actual application.in the Web system using JDBC data cache technology.This paper analyzes the JDBC interface principle and technology.In order to optimize the query efficiency and improve the performance of Web system,this paper researches on the organization and management of JDBC cache data in Web server memory aiming at the shortcomings of existing JDBC data caching technology.The main research work is as follows.First,when caching the entire amount of data of multiple single tables in memory,the paper uses hash map as a structure to organize and store the multiple cache data.Secondly,based on the LRU replacement algorithm,the paper proposes a caching data replacement algorithm based on the cache value according to the characteristics of the JDBC cache data in order to improve the cache hit rate.Thirdly,when the database data that the JDBC items depends on changes,in order to make the users obtain the correct and valid data,a strategy of maintaining a update when exiting is designed to maintain coherency.Lastly,the paper designs experiments to validate.In the experiment of cache replacement algorithm,this paper calculates the hits of JDBC cache items by simulating user's request sequence and comparing with the LRU replacement algorithm.In the experiment of strategy of consistency,the effectiveness and efficiency of maintaining a update when exiting were tested.The experimental result shows that the method of managing memory data proposed in this paper can improve the performance of web application system.