Workload-driven, Lazy Discovery of Data Dependencies for Query Optimization
Summary: Workload-driven, lazy discovery that extracts dependency candidates from executed plans, validates them dynamically, and maintains lightweight metadata to enable practical dependency-based query optimizations. Hyrise prototype shows feasibility and up to 27% JOB speedup, demonstrating practicality in columnar DBMSs. (summarized by gpt-5-mini on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Jan Kossmann (Hasso Plattner Institute)
- 2. Daniel Lindner (Hasso Plattner Institute)
- 3. Felix Naumann (Hasso Plattner Institute)
- 4. Thorsten Papenbrock (Philipps University Marburg)
BibTeX Citation
@inproceedings{kossmann_cidr22,
address = {Amsterdam, Netherlands},
series = {{CIDR} '22},
title = {{Workload-driven, Lazy Discovery of Data Dependencies for Query Optimization}},
booktitle = {Proceedings of the {Conference} on {Innovative} {Data} {Systems} {Research}},
author = {Kossmann, Jan and Lindner, Daniel and Naumann, Felix and Papenbrock, Thorsten},
year = {2022}
}
Incoming Citations (Sorted by Pagerank)
Showing 2 of 2 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 9,280 | Themis: A GPU-accelerated Relational Query Execution Engine | 2025 | VLDB | 5.2933689e-05 |
| 9,913 | Adaptive data transformations for QaaS | 2025 | CIDR | 5.1955087e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 6 of 6 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 18 | How Good Are Query Optimizers, Really? | 2016 | VLDB | 0.00059284255 |
| 103 | DuckDB: an Embeddable Analytical Database | 2019 | SIGMOD | 0.00034161428 |
| 476 | The Making of TPC-DS | 2006 | VLDB | 0.00017860667 |
| 618 | A Hybrid Approach to Functional Dependency Discovery | 2016 | SIGMOD | 0.00015711835 |
| 941 | Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation | 2016 | SIGMOD | 0.00013078348 |
| 6,720 | Fast Incremental Discovery of Pointwise Order Dependencies | 2020 | VLDB | 5.794237e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 4,481 | Dynamically Optimizing Queries over Large Scale Data Platforms | 2014 | SIGMOD |
| 2 | 203 | Dependency Inference | 1987 | VLDB |
| 3 | 10,296 | Succinct Structure Representations for Efficient Query Optimization | 2026 | SIGMOD |
| 4 | 2,465 | Optimization of Queries with User-defined Predicates | 1996 | VLDB |
| 5 | 729 | Functional Dependency Discovery: An Experimental Evaluation of Seven Algorithms | 2015 | VLDB |
| 6 | 6,114 | Fundamentals of Order Dependencies | 2012 | VLDB |
| 7 | 143 | Optimization of Nonrecursive Queries | 1986 | VLDB |
| 8 | 618 | A Hybrid Approach to Functional Dependency Discovery | 2016 | SIGMOD |
| 9 | 11,743 | Making DBMSes Dependency-Aware | 2020 | CIDR |
| 10 | 6,018 | Dependency-Aware Reordering for Parallelizing Query Optimization in Multi-Core CPUs | 2009 | SIGMOD |