Research And Application Of Self-Optimized Database Connection Pool Technology Base On J2EE

The development in information society makes people depend on network more and more and, large numbers of application system based on network emerge continually. With the extension of network the quantity of information supplied by webs and quantity of user visiting and complexity of program in computer software are increasing greatly. How to make the limited computer system resources service further users and how to ensure the response velocity and service quality for users is becoming the all-important questions to software developers. These valuable system resources, such as memory, line and database connection, are important to the usage efficiency of internet applications in time and space, in which the usability of resources is interrelated to the performance of client application programs and the degree of client satisfaction. So, the system resource management is an important question for developing N-tier structure application programs with scalable and high parallel degree and is one of hotspot problem in software engineering region currently.In the first part, the background, meaning and status in quo concerning the research are introduced, and the technique and principle of JDBC access database based on J2EE are discussed. The shortage and limitation in traditional database accessing mode confine with the scalability and exuberance for application system, in which the treatment for this problem is to make use of the technique of connection pool presently. However, the farther analysis in the paper indicates that the strategy of parameter configuration in current connection pool technique is static state with 1-order enactment while initializes connection pool without Self-Optimized adjustment according as the variety of application demand, the operation results of high use frequency database are not cached and users visit the same database independently. The multi-propose connection strategy cannot control the database operation for the same transaction and cannot ensure the ACID attribute, etc. In according with the defections mentioned above, the service technique of Self-Optimized connection pool is presented in this paper and the composing structure for Self-Optimized connection pool is designed, then, some strategy in dynamic parameters adjustment, transaction management and data cache for connection pool is improved. The comparative experimental results show that the Self-Optimized connection pool is superior to the current connection pool both in reducing the resource possession of computer system and in enhancing visiting speed for large-scale application system.A MIRMS system is designed in Chapter 5 in the paper using the...