Parallel I/O Aware Query Optimization
Summary: Exploits SSD I/O parallelism to speed up query processing, focusing on scan operators. Proposes a calibration-based I/O cost model using queue depth and device heterogeneity; implemented in SAP SQL Anywhere to yield near-optimal, device-agnostic plans. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Pedram Ghodsnia (University of Waterloo)
- 2. Ivan T. Bowman (SAP)
- 3. Anisoara Nica (SAP)
BibTeX Citation
@inproceedings{ghodsnia_sigmod14,
title = {{Parallel I/O Aware Query Optimization}},
author = {Ghodsnia, Pedram and Bowman, Ivan T. and Nica, Anisoara},
series = {{SIGMOD} '14},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/2588555.2595635},
url = {https://dl.acm.org/doi/10.1145/2588555.2595635},
year = {2014}
}Incoming Citations (Sorted by Pagerank)
Showing 1 of 1 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 6,827 | When Database Meets New Storage Devices: Understanding and Exposing Performance Mismatches via Configurations | 2023 | VLDB | 5.6699055e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 11 of 11 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1 | Access Path Selection in a Relational Database Management System | 1979 | SIGMOD | 0.0023947656 |
| 570 | A Case for Flash Memory SSD in Enterprise Database Applications | 2008 | SIGMOD | 0.00016224945 |
| 1,014 | Flashing Up the Storage Layer | 2008 | VLDB | 0.00012505292 |
| 1,484 | Query Processing Techniques for Solid State Drives | 2009 | SIGMOD | 0.00010535051 |
| 2,839 | Turbocharging DBMS Buffer Pool Using SSDs | 2011 | SIGMOD | 7.9506131e-05 |
| 3,800 | B+-tree Index Optimization by Exploiting Internal Parallelism of Flash-based Solid State Drives | 2012 | VLDB | 7.0153652e-05 |
| 5,177 | Hybrid Storage Management for Database Systems | 2013 | VLDB | 6.2412137e-05 |
| 5,251 | Data Management Over Flash Memory | 2011 | SIGMOD | 6.2090582e-05 |
| 5,260 | Advances in Flash Memory SSD Technology for Enterprise Database Applications | 2009 | SIGMOD | 6.2053402e-05 |
| 5,616 | Flash-Based Extended Cache for Higher Throughput and Faster Recovery | 2012 | VLDB | 6.0639583e-05 |
| 7,036 | DB2 Query Parallelism: Staging and Implementation | 1995 | VLDB | 5.6159672e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 4,893 | A Characterization of the Sensitivity of Query Optimization to Storage Access Cost Parameters | 2003 | SIGMOD |
| 2 | 5,955 | The Necessary Death of the Block Device Interface | 2013 | CIDR |
| 3 | 2,839 | Turbocharging DBMS Buffer Pool Using SSDs | 2011 | SIGMOD |
| 4 | 3,800 | B+-tree Index Optimization by Exploiting Internal Parallelism of Flash-based Solid State Drives | 2012 | VLDB |
| 5 | 446 | Query Optimization for Parallel Execution | 1992 | SIGMOD |
| 6 | 11,360 | SSD-iq: Uncovering the Hidden Side of SSD Performance | 2025 | VLDB |
| 7 | 3,103 | An Object Placement Advisor for DB2 Using Solid State Storage | 2009 | VLDB |
| 8 | 1,139 | Query Processing on Smart SSDs: Opportunities and Challenges | 2013 | SIGMOD |
| 9 | 10,332 | Re-evaluating Designs for Multi-Tenant OLTP Workloads on SSD-based I/O Subsystems | 2014 | SIGMOD |
| 10 | 4,987 | Optimizing Databases by Learning Hidden Parameters of Solid State Drives | 2020 | VLDB |