Optimizing Databases by Learning Hidden Parameters of Solid State Drives
Summary: Learns SSD-specific hidden geometry and behavior from request-size and location profiles, then derives I/O rules to tune databases rather than treating SSDs as black boxes. Applied to SQLite3/MariaDB, it improves throughput up to 29% and reduces flash wear up to 6.7%. (summarized by gpt-5.6-luna on Jul 24 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Aarati Kakaraparthy (University of Wisconsin)
- 2. Jignesh M. Patel (University of Wisconsin)
- 3. Kwanghyun Park (Microsoft)
- 4. Brian P. Kroth (Microsoft)
BibTeX Citation
@article{kakaraparthy_vldb20,
title = {{Optimizing Databases by Learning Hidden Parameters of Solid State Drives}},
author = {Kakaraparthy, Aarati and Patel, Jignesh M. and Park, Kwanghyun and Kroth, Brian P.},
journal = {PVLDB},
series = {{VLDB} '20},
volume = {13},
number = {4},
pages = {519--532},
doi = {10.14778/3372716.3372724},
url = {https://doi.org/10.14778/3372716.3372724},
year = {2020}
}Incoming Citations (Sorted by Pagerank)
Showing 6 of 6 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 6,294 | Database Kernels: Seamless Integration of Database Systems and Fast Storage via CXL | 2024 | CIDR | 5.8213142e-05 |
| 6,827 | When Database Meets New Storage Devices: Understanding and Exposing Performance Mismatches via Configurations | 2023 | VLDB | 5.6699055e-05 |
| 7,240 | SaS: SSD as SQL Database System | 2021 | VLDB | 5.577789e-05 |
| 10,133 | CloudJump: Optimizing Cloud Databases for Cloud Storages | 2022 | VLDB | 5.0751052e-05 |
| 10,725 | How to Write to SSDs | 2026 | VLDB | 4.9793485e-05 |
| 11,360 | SSD-iq: Uncovering the Hidden Side of SSD Performance | 2025 | VLDB | 4.9793485e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 3 of 3 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 513 | Tree Indexing on Solid State Drives | 2010 | VLDB | 0.00017044842 |
| 981 | Lazy-Adaptive Tree: An Optimized Index Structure for Flash Devices | 2009 | VLDB | 0.00012716964 |
| 3,800 | B+-tree Index Optimization by Exploiting Internal Parallelism of Flash-based Solid State Drives | 2012 | VLDB | 7.0153652e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 1,484 | Query Processing Techniques for Solid State Drives | 2009 | SIGMOD |
| 2 | 5,955 | The Necessary Death of the Block Device Interface | 2013 | CIDR |
| 3 | 5,177 | Hybrid Storage Management for Database Systems | 2013 | VLDB |
| 4 | 1,398 | SSD Bufferpool Extensions for Database Systems | 2010 | VLDB |
| 5 | 2,839 | Turbocharging DBMS Buffer Pool Using SSDs | 2011 | SIGMOD |
| 6 | 3,103 | An Object Placement Advisor for DB2 Using Solid State Storage | 2009 | VLDB |
| 7 | 6,827 | When Database Meets New Storage Devices: Understanding and Exposing Performance Mismatches via Configurations | 2023 | VLDB |
| 8 | 8,861 | Parallel I/O Aware Query Optimization | 2014 | SIGMOD |
| 9 | 10,725 | How to Write to SSDs | 2026 | VLDB |
| 10 | 11,360 | SSD-iq: Uncovering the Hidden Side of SSD Performance | 2025 | VLDB |