Research And Design Of The Database Connection Pool With Multi-pool Structure

In recent years, with the popularity of database application, more and more businessoperations turn to be realized by office automation, the amount of database operations showthe characteristics of large amount of data and high concurrency. How to build a data channelfor the database request rapidly and accurately goes to be the main target to improve theefficiency of the system.The related concepts of risk assessment and the key technology of connection pool werefirstly summarized in this paper. It introduces the key technology of mainstream connectionpool from the underlying database driver, the composition of database connection pool andthe affairs management of database.Then aimed at the shortcomings of single connection pool, it researched and designed theconnection pool structured by several pools. The connection pool structured by several poolsmainly include: the decision module, the buffer pool and the connection son pool. In order tomake the database request can be quickly assigned to different connection son pool, thedecision module researched the related principles of algorithm that support vector machine,used a vector space model to represent the database request with mathematics method, andused the SVM classification algorithm for classifying the database request quickly so that thecorresponding database request could be assigned to different connection son pool distribution.It designed buffer pool that based on max heap in order to reduce the connection request. Thebuffer pool will keep down the result set that with a high visitor volume, for high concurrent,the same database request service and give service to the database request with highconcurrency and similarity. At the same time it put forward the load balance strategy amongthe son pools and the affairs management strategy in the framework of many pools.Finally it applied a connection pool to the assessment service platform and tested on theaccuracy of the SVM classifier that is in the connection pool decision module.At the same time, it tested on the hit rate of buffer pool. Then carried out the simulationtest through pressure tools, the test results show that the connection pools based on theamount of connection pools can improve the efficiency and concurrency of database accessobviously.