The Flatter, the Better: Query Compilation Based on the Flattening Transformation
Summary: Flattening-based query compiler translates nested iterations into lifted primitives for data-parallel backends. Haskell-embedded frontend demonstrates expressiveness for ordered data, grouping, and aggregation, with PostgreSQL and VectorWise backends and broad engine applicability beyond shredding. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Alexander Ulrich (University of Tübingen)
- 2. Torsten Grust (University of Tübingen)
BibTeX Citation
@inproceedings{ulrich_sigmod15,
title = {{The Flatter, the Better: Query Compilation Based on the Flattening Transformation}},
author = {Ulrich, Alexander and Grust, Torsten},
series = {{SIGMOD} '15},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/2723372.2733539},
url = {https://dl.acm.org/doi/10.1145/2723372.2733539},
year = {2015}
}
Incoming Citations (Sorted by Pagerank)
Showing 5 of 5 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 3,257 | One WITH RECURSIVE is Worth Many GOTOs | 2021 | SIGMOD | 7.590651e-05 |
| 8,958 | The Power of Nested Parallelism in Big Data Processing – Hitting Three Flies with One Slap – | 2021 | SIGMOD | 5.3449654e-05 |
| 10,630 | Cephalopod - Virtual Data Model Composition through Partial Query Translation | 2025 | CIDR | 5.093636e-05 |
| 10,771 | Nested Parquet Is Flat, Why Not Use It? How To Scan Nested Data With On-the-Fly Key Generation and Joins | 2025 | SIGMOD | 5.093636e-05 |
| 11,711 | TraNCE: Transforming Nested Collections Efficiently | 2021 | VLDB | 5.093636e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 5 of 5 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 147 | Making Smalltalk a Database System | 1984 | SIGMOD | 0.00029474235 |
| 2,507 | AQuery: Query Language for Ordered Data, Optimization Techniques, and Experiments | 2003 | VLDB | 8.4889096e-05 |
| 3,155 | Query Shredding: Efficient Relational Evaluation of Queries over Nested Multisets | 2014 | SIGMOD | 7.695861e-05 |
| 3,406 | Cache-Conscious Radix-Decluster Projections | 2004 | VLDB | 7.4392655e-05 |
| 4,847 | Avalanche-Safe LINQ Compilation | 2010 | VLDB | 6.4805473e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 5,376 | Evolution of a Compiling Query Engine | 2021 | VLDB |
| 2 | 10,008 | Towards Unifying Query Interpretation and Compilation | 2023 | CIDR |
| 3 | 4,215 | Designing an Open Framework for Query Optimization and Compilation | 2022 | VLDB |
| 4 | 3,155 | Query Shredding: Efficient Relational Evaluation of Queries over Nested Multisets | 2014 | SIGMOD |
| 5 | 23 | Efficiently Compiling Efficient Query Plans for Modern Hardware | 2011 | VLDB |
| 6 | 11,708 | Low-Latency Compilation of SQL Queries to Machine Code | 2021 | VLDB |
| 7 | 2,488 | How to Architect a Query Compiler, Revisited | 2018 | SIGMOD |
| 8 | 534 | Building Efficient Query Engines in a High-Level Language | 2014 | VLDB |
| 9 | 6,377 | Scalable Querying of Nested Data | 2021 | VLDB |
| 10 | 1,797 | How to Architect a Query Compiler | 2016 | SIGMOD |