The Rearch Of Database Connection Sharing Technology

The main research content of this paper is the technology of database connection sharing.When multiple applications share the database, because of the limit of the databaseconnection, causing some applications take up too much database connections and some appstake up too less database connection, Databases become a performance bottleneck. The key ofthe problem is that achieve sharing of database connection between the various applicationsand effective distribution. In this paper，based on the JDBC connection pool, build a higherlevel of connection sharing scheme between applications. There is a distributed connectionmanagement system. The main work of this paper:1. Reaching a dynamic load balancing strategy of the distributed connection pool.Distributed Connection Management System assign the request of Application ServicesAccording to the load of each node.2. Dynamic management of all nodes in distributed connection management systemwhen overall load of the distributed connection pool is high, new node will be added, whenthe overall load of the distributed connection pool is low, disable some nodes.3. Designing an efficient and effective allocation algorithm for database connection. Thisarticle uses the connection based on multi-priority allocation policy, so that the databaseconnection can assign priority to the more important database access requests.3. Connection pool design. Design a connection pool which can provide stable serviceunder high concurrency access. This paper presents a structured database connection using apacket-pool structure.4. Implementation a connection management program which can dynamically adjust thenumber of connections. When the pressure of the connection pool increases, the number ofconnections the connection pool will be increased. When the pressure of the connection poolis relatively small, reducing the number of connections the connection pool.Finally, the paper introduce the implementations of Distributed Connection ManagementSystem, describes the realization of the overall structure and the implementation of some ofthe core modules, and also connected on a priority-based allocation strategy testing, theconnection pool dynamically adjust strategies testing, dynamic load balancing strategy testingand overall system throughput testing.