Building Advanced SQL Analytics From Low-Level Plan Operators
Summary: Unified framework to compose all SQL advanced aggregates (associative, distinct, window, grouping) from low-level plan operators. Reuses materialized intermediates, modularizes aggregate implementations, and speeds up queries; Umbra beats HyPer. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. André Kohn (Technical University of Munich)
- 2. Viktor Leis (Friedrich Schiller University of Jena)
- 3. Thomas Neumann (Technical University of Munich)
BibTeX Citation
@inproceedings{kohn_sigmod21,
title = {{Building Advanced SQL Analytics From Low-Level Plan Operators}},
author = {Kohn, André and Leis, Viktor and Neumann, Thomas},
series = {{SIGMOD} '21},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/3448016.3457288},
url = {https://dl.acm.org/doi/10.1145/3448016.3457288},
year = {2021}
}Incoming Citations (Sorted by Pagerank)
Showing 9 of 9 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 3,985 | Designing an Open Framework for Query Optimization and Compilation | 2022 | VLDB | 6.8730085e-05 |
| 5,455 | Evolution of a Compiling Query Engine | 2021 | VLDB | 6.1239975e-05 |
| 5,771 | Database Technology for the Masses: Sub-Operators as First-Class Entities | 2021 | VLDB | 5.9992698e-05 |
| 6,296 | Declarative Sub-Operators for Universal Data Processing | 2023 | VLDB | 5.8195258e-05 |
| 6,587 | Maximus: A Modular Accelerated Query Engine for Data Analytics on Heterogeneous Systems | 2025 | SIGMOD | 5.7429023e-05 |
| 7,451 | Modularis: Modular Relational Analytics over Heterogeneous Distributed Platforms | 2021 | VLDB | 5.5236802e-05 |
| 7,907 | A Practical Approach to Groupjoin and Nested Aggregates | 2021 | VLDB | 5.4287568e-05 |
| 8,821 | Efficient Evaluation of Arbitrarily-Framed Holistic SQL Aggregates and Window Functions | 2022 | SIGMOD | 5.2691478e-05 |
| 9,472 | Query Compilation Without Regrets | 2024 | SIGMOD | 5.1711207e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 27 of 27 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 4,374 | Beyond Simple Aggregates: Indexing for Summary Queries | 2011 | PODS |
| 2 | 8,821 | Efficient Evaluation of Arbitrarily-Framed Holistic SQL Aggregates and Window Functions | 2022 | SIGMOD |
| 3 | 6,296 | Declarative Sub-Operators for Universal Data Processing | 2023 | VLDB |
| 4 | 10,189 | COMPARE: Accelerating Groupwise Comparison in Relational Databases for Data Analytics | 2021 | VLDB |
| 5 | 1,628 | Adaptive Parallel Aggregation Algorithms | 1995 | SIGMOD |
| 6 | 3,427 | Efficient Processing of Window Functions in Analytical SQL Queries | 2015 | VLDB |
| 7 | 6,055 | Translating and Optimizing SQL Queries Having Aggregates | 1987 | VLDB |
| 8 | 503 | Towards a Unified Architecture for in-RDBMS Analytics | 2012 | SIGMOD |
| 9 | 1,898 | Querying Multiple Features of Groups in Relational Databases | 1996 | VLDB |
| 10 | 12,606 | Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations | 2012 | SIGMOD |