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,033 | Bitmap Index Design and Evaluation | 1998 | SIGMOD | 0.0001453376 |
| 5,731 | Flash-Based Extended Cache for Higher Throughput and Faster Recovery | 2012 | VLDB | 5.3476002e-05 |
| 8,797 | Avoiding Read Stalls on Flash Storage | 2022 | SIGMOD | 4.4444672e-05 |
| 10,676 | Twisted Twin: A Collaborative and Competitive Memory Management Approach in HTAP Systems | 2025 | VLDB | 4.1905499e-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.00044501642 |
| 810 | A Modeling Study of the TPC-C Benchmark | 1993 | SIGMOD | 0.00016389243 |
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.00066322421 |
| 13,216 | Micro-architectural Analysis of OLAP Systems on Persistent Memory | 2022 | CIDR | - |
| 124 | DBMSs On A Modern Processor: Where Does Time Go? | 1999 | VLDB | 0.0004501099 |
| 810 | A Modeling Study of the TPC-C Benchmark | 1993 | SIGMOD | 0.00016389243 |
| 11,784 | The Next 700 Transaction Processing Engines | 2017 | SIGMOD | 4.1905499e-05 |
| 4,353 | Buffer Pool Aware Query Optimization | 2005 | CIDR | 6.2535805e-05 |
| 2,437 | OLTP on Hardware Islands | 2012 | VLDB | 8.8206221e-05 |
| 2,976 | In-Memory Performance for Big Data | 2015 | VLDB | 7.7865451e-05 |
| 5,273 | Micro-architectural Analysis of In-memory OLTP | 2016 | SIGMOD | 5.5919449e-05 |
| 215 | OLTP Through the Looking Glass, and What We Found There | 2008 | SIGMOD | 0.00033609709 |