Research And Implementation Of Database Optimization Model Based On The Framework Of Java/Web

With the development of information and Internet technology, the application of information system based on Java Web technology in the enterprise is involved in the management of the enterprise more and more widely. In order to make the information system run stably and effectively in various fields, one of the most important aspects is to ensure the access performance of database. But now with the information and data increasing sharply, the data transmission is busy between the networks, and the data visits of information system database also become bigger. These cause a lot of pressure to the database performance of information system, and the data size will be bigger, so the common database technology can’t completed a quick and efficient data interaction with the server database. Then how to design and management database reasonably and how to carry on the improvement of optimization of the database query is an urgent problem needed to solve in the era of huge amounts of data when we can also have access to the Web application system efficiently, and the database optimization technology under Java Web is also getting more and more attention.This paper researched the technology of database optimization deeply for the most outstanding problem of database access in information system under Java Web framework on basis of a project about enterprise information management undertaken by my aboratory. At the same time, the detailed scheme of database optimization is given in this paper for the problem of latency of the database access that occurs in the operation of project. The optimization of database is divided into three parts from the perspective of the program design:Firstly, database access is optimized via the database connection pool when it gets connection; Secondly, the efficiency and speed of the query in the database access is improved through the index technology and SQL optimization technology in view of the database operation; Thirdly, This paper optimizes the processes of the results by adopting the data transfer technology. By the design and implementation of optimization scheme for database, we optimize the performance of database access of the system, and shorten the time of the query access. Also, we reduce the unnecessary waste of resources, and then improve the efficiency of the access of the system’s database, and resolve the delay of the access to the system’s database.