Performance of B-tree concurrency control algorithms
- 1 January 1991
- conference paper
- Published by Association for Computing Machinery (ACM)
- Vol. 20 (2) , 416-425
- https://doi.org/10.1145/115790.115860
Abstract
A number,of algorithms,have,been,proposed,for access- ing B-trees concurrently, but the performance of these algorithms is not yet well understood. In this paper, we study,the,performance,of various,concurrency,control algorithms,using,a detailed,simulation,model,of B-tree operations,in a centralized,DBMS. Our study,considers a wide,range,of data,contention,situations,and,resource conditions.,Results from,our,experiments,indicate,that algorithms,in which,updaters,lock-couple,using,exclu- sive locks,perform,poorly,as compared,to those,that permit more optimistic index descents. In particular, the B-link algorithms,provide,the most,concurrency,and the,best overall,performance.Keywords
This publication has 0 references indexed in Scilit: