A Buffer Pool Optimization Algorithm Based on Max-Heap

To reduce the number of requests to the database connection, this paper designed the max-heap in buffer pool. We use the buffer pool maintenance algorithm to manage SQL data query request when database access intensive. When we update the max-heap, the structure of the buffer pool will be updated and the heap will be balance through the heap of recursive sequence, it got good performance in database access request. Experiment results show that this algorithm can improve the operation efficiency of system effectively.

Based on SVM Classification of Connection Pools Algorithm

The connection pool technology has become a deal with large amount of data requested a solution that is widely used now. This paper used the SVM classification algorithm for classified all database requests quickly, so the corresponding database request could be assigned to different connection pool distribution. We applied the connection pool to measurement service platform and tested on the accuracy of the SVM classifier and buffer pool hit ratios of the connection pool module. The experimental results show that the connection pools can improve the efficiency of database access obviously.