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,198 | Database Kernels: Seamless Integration of Database Systems and Fast Storage via CXL | 2024 | CIDR | 5.945932e-05 |
| 7,135 | SaS: SSD as SQL Database System | 2021 | VLDB | 5.6940523e-05 |
| 7,996 | When Database Meets New Storage Devices: Understanding and Exposing Performance Mismatches via Configurations | 2023 | VLDB | 5.5096162e-05 |
| 9,950 | CloudJump: Optimizing Cloud Databases for Cloud Storages | 2022 | VLDB | 5.1915905e-05 |
| 10,543 | How to Write to SSDs | 2026 | VLDB | 5.093636e-05 |
| 10,974 | SSD-iq: Uncovering the Hidden Side of SSD Performance | 2025 | VLDB | 5.093636e-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 |
|---|---|---|---|---|
| 512 | Tree Indexing on Solid State Drives | 2010 | VLDB | 0.00017196795 |
| 961 | Lazy-Adaptive Tree: An Optimized Index Structure for Flash Devices | 2009 | VLDB | 0.00012941098 |
| 3,747 | B+-tree Index Optimization by Exploiting Internal Parallelism of Flash-based Solid State Drives | 2012 | VLDB | 7.1555585e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 1,455 | Query Processing Techniques for Solid State Drives | 2009 | SIGMOD |
| 2 | 5,841 | The Necessary Death of the Block Device Interface | 2013 | CIDR |
| 3 | 5,080 | Hybrid Storage Management for Database Systems | 2013 | VLDB |
| 4 | 1,490 | SSD Bufferpool Extensions for Database Systems | 2010 | VLDB |
| 5 | 3,095 | Turbocharging DBMS Buffer Pool Using SSDs | 2011 | SIGMOD |
| 6 | 3,055 | An Object Placement Advisor for DB2 Using Solid State Storage | 2009 | VLDB |
| 7 | 7,996 | When Database Meets New Storage Devices: Understanding and Exposing Performance Mismatches via Configurations | 2023 | VLDB |
| 8 | 8,800 | Parallel I/O Aware Query Optimization | 2014 | SIGMOD |
| 9 | 10,543 | How to Write to SSDs | 2026 | VLDB |
| 10 | 10,974 | SSD-iq: Uncovering the Hidden Side of SSD Performance | 2025 | VLDB |