Database Buffer Size Investigation for OLTP Workloads
Summary: Empirical study on real-world OLTP databases shows how buffer size, database size, and CPU count affect throughput and buffer hits on SMP systems. Offers predictive models and rules-of-thumb for memory sizing vs. CPU scaling in OLTP workloads. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Thin-Fong Tsuei
- 2. Allan N. Packer
- 3. Keng-Tai Ko
Incoming Citations (Sorted by Pagerank)
Showing 4 of 4 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,035 | Bitmap Index Design and Evaluation | 1998 | SIGMOD | 0.00014532778 |
| 5,724 | Flash-Based Extended Cache for Higher Throughput and Faster Recovery | 2012 | VLDB | 5.3518469e-05 |
| 8,426 | Avoiding Read Stalls on Flash Storage | 2022 | SIGMOD | 4.5162792e-05 |
| 10,668 | Twisted Twin: A Collaborative and Competitive Memory Management Approach in HTAP Systems | 2025 | VLDB | 4.1945683e-05 |
Previous
Page 1 / 1
Next
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 |
|---|---|---|---|---|
| 128 | An Evaluation of Buffer Management Strategies for Relational Database Systems | 1985 | VLDB | 0.00044535268 |
| 812 | A Modeling Study of the TPC-C Benchmark | 1993 | SIGMOD | 0.00016408423 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 52 | Database Architecture Optimized for the new Bottleneck: Memory Access | 1999 | VLDB | 0.00066474881 |
| 13,202 | Micro-architectural Analysis of OLAP Systems on Persistent Memory | 2022 | CIDR | - |
| 124 | DBMSs On A Modern Processor: Where Does Time Go? | 1999 | VLDB | 0.00045103515 |
| 812 | A Modeling Study of the TPC-C Benchmark | 1993 | SIGMOD | 0.00016408423 |
| 11,776 | The Next 700 Transaction Processing Engines | 2017 | SIGMOD | 4.1945683e-05 |
| 4,358 | Buffer Pool Aware Query Optimization | 2005 | CIDR | 6.2571485e-05 |
| 2,445 | OLTP on Hardware Islands | 2012 | VLDB | 8.8057827e-05 |
| 2,964 | In-Memory Performance for Big Data | 2015 | VLDB | 7.80643e-05 |
| 5,272 | Micro-architectural Analysis of In-memory OLTP | 2016 | SIGMOD | 5.5937875e-05 |
| 215 | OLTP Through the Looking Glass, and What We Found There | 2008 | SIGMOD | 0.0003354907 |