Index Access with a Finite Buffer

Summary: Analyzes buffer-fault rates for repeated clustered-index access in B-trees under finite memory. Shows conventional LRU is suboptimal; introduces ILRU (uniformly superior, especially with small buffers) and OLRU (optimal for uniform reference densities), with Zipfian behavior discussed. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: 8003
Venue: VLDB
Year: 1987
Pagerank: 5.5725248e-05
Overall Rank: 7,663 | 47.43%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Giovanni Maria Sacco (University of Turin)

BibTeX Citation

@article{sacco_vldb87,
        title = {{Index Access with a Finite Buffer}},
        author = {Sacco, Giovanni Maria},
        journal = {PVLDB},
        series = {{VLDB} '87},
        year = {1987}
}

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
12,605	Towards Efficient Main-Memory Use For Optimum Tree Index Update	2008	VLDB	5.093636e-05
12,911	GHOST: Fine Granularity Buffering of Index Pages	1999	VLDB	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 2 of 2 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
135	An Evaluation of Buffer Management Strategies for Relational Database Systems	1985	VLDB	0.00030209257
609	A Mechanism for Managing the Buffer Pool in a Relational Database System Using the Hot Set Model	1982	VLDB	0.00015792907

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	1,512	On the Analysis of Indexing Schemes	1997	PODS
2	8,689	Adaptive Index Structures	2002	VLDB
3	8,937	Dynamic Indexability and Lower Bounds for Dynamic One-Dimensional Range Query Indexes	2009	PODS
4	4,270	Interaction of Query Evaluation and Buffer Management for Information Retrieval	1998	SIGMOD
5	9,324	Main-Memory Operation Buffering for Efficient R-Tree Update	2007	VLDB
6	231	The LRU-K Page Replacement Algorithm For Database Disk Buffering	1993	SIGMOD
7	1,110	Buffering Accesses to Memory-Resident Index Structures	2003	VLDB
8	12,911	GHOST: Fine Granularity Buffering of Index Pages	1999	VLDB
9	13,030	Estimating Page Fetches for Index Scans with Finite LRU Buffers	1994	SIGMOD
10	2,590	Extensible Buffer Management of Indexes	1992	VLDB