A Buffer Pool Optimization Algorithm Based on Max-Heap

Xiao Mei Xiong

doi:10.4028/www.scientific.net/AMR.945-949.2439

Paper Titles

Structural Expert Modeling of Buildings on the Basis of Mamdani's Algorithm
p.2417

A Class of Nonlinear Difference Inequality with Weakly Singularity in Engineering
p.2426

Application of the Improved Mapping Approach to Exact Solutions and Chaotic Patterns for a Nonlinear Equation
p.2430

Based on SVM Classification of Connection Pools Algorithm
p.2435

A Buffer Pool Optimization Algorithm Based on Max-Heap
p.2439

Matrix Analysis and Design Based on Algorithm of Paper Analysis
p.2443

Speech Signal for the Recognition of Emotion by Cultural Genetic Algorithm
p.2447

Intrinsically Knotted and 3-Linked Graph
p.2451

Research and Implementation of Multidimensional Customer Behavior Segmentation Model Based on Bayes and Fisher
p.2455

HomeAdvanced Materials ResearchAdvanced Materials Research Vols. 945-949A Buffer Pool Optimization Algorithm Based on...

A Buffer Pool Optimization Algorithm Based on Max-Heap

Abstract:

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.

You might also be interested in these eBooks

Advances in Manufacturing Science and Engineering V

View Preview

Info:

Periodical:

Advanced Materials Research (Volumes 945-949)

Pages:

2439-2442

DOI:

https://doi.org/10.4028/www.scientific.net/AMR.945-949.2439

Citation:

Cite this paper

Online since:

June 2014

Authors:

Xiao Mei Xiong

Keywords:

Connection Pool, Connection Reusing, Database Transaction, Max-Heap

Export:

RIS, BibTeX

Price:

Permissions CCC:

Request Permissions

Permissions PLS:

Request Permissions

Сopyright:

Citation:

References

[1] Wang Jiangpeng, LiXianguo. Data Transmission of WebGIS Based on Multithread and Buffer Pool [J]. Computer Engineering, 2010, 36(4): 79-81.

Google Scholar

[2] Wei Bangguo, Yang Chun. Simulation research of adaptive optimization algorithm at data buffer pool [J]. Computer Engineering and Design. 2011, 32(10): 3410-3413.

Google Scholar

[3] Tran D N, Huynh P C, Tay Y C. A new approach to dynamic self-tuning of database buffers [J]. ACM Transactions on Stroage, 2008, 4(1): 1-25.

DOI: 10.1145/1353452.1353455

Google Scholar

[4] Narayanan D, Thereska E, Ailamaki A. Challengs in building a DBMS resource advisor[J]. IEEE Data Engineering Bulletin, 2006(3): 40-46.

Google Scholar

[5] Wang Qiansong, Bao Chen. Optimal Design and Application of Database Access Based on AOP and Connection Pool [J]. 2013, 36(01), 121-127.

Google Scholar

[6] MengPeichao, HuShengbo, Shu Heng, YanFuyu. Optimization strategy of connection pool based on ADO[J]. Computer Engineering and Design. 2013, 34(5): 1706-1710.

Google Scholar