Application Research Of Management And Optimization Of Data Storage And Retriveral Base On JDBC

With the rapid development of the Internet and related technology and the dramatic increase of website access,the disk has already overburdened for a large number of disk read operation,caused the traditional Web system under increasing pressure.At the same time people's experience of the Internet also raised new height and requirements,especially in terms of overall system performance.Therefore,how to make the Web application system can effectively and quickly access the data has become the key issues.This paper based on JDBC interface principle and technology for research,in order to improve the efficiency of data access.The paper has proposed that independently recognize data based on JDBC and can quickly access the pre-process of data.The paper detailedly analyzed the technology of data caching and access optimization for the three-tier architecture to popular Web application system,and then further studied and analysed the basic principles and implementation mechanism of the JDBC connection database technology.For the shortcomings of the current JDBC which cannot cache data,the paper design JDBC self-caching data program.This paper first through the research and analysis of hot data,and then standardized hot data identification strategy.It modified and expanded the traditional the JDBC interfaces,which implemented pre-processing the data that meet the requirements,and then cached the hot data.In addition,according to the data access filter methods to design data storage structure and it adopted key-value storage mechanism that can improve the performance of Web system by rapid snapshot-data access mechanism in the client-application layer.Based on the above research,design and implementation,this paper is designed suitable data storage structure for optimizing JDBC data access technology,which provides a solution for reducing database server load and improving system performance.Finally,Experimental results showed that the scheme can effectively improve the Web speed of data access and be able to achieve multi-client-side data sharing with a certain degree of universality and promotional value.