Avoiding Materialisation for Guarded Aggregate Queries
Summary: Introduces guarded aggregate queries, whose syntactic restrictions enable logical and physical rewrites that compute aggregates without materialising massive join results. Implemented in Spark SQL and validated on standard benchmarks, addressing join-heavy analytical and graph-path workloads. (summarized by gpt-5.6-luna on Jul 24 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Matthias Lanzinger (Vienna University of Technology)
- 2. Reinhard Pichler (Vienna University of Technology)
- 3. Alexander Selzer (Vienna University of Technology)
BibTeX Citation
@article{lanzinger_vldb25,
title = {{Avoiding Materialisation for Guarded Aggregate Queries}},
author = {Lanzinger, Matthias and Pichler, Reinhard and Selzer, Alexander},
journal = {PVLDB},
series = {{VLDB} '25},
volume = {18},
number = {5},
pages = {1398--1411},
doi = {10.14778/3718057.3718068},
url = {https://doi.org/10.14778/3718057.3718068},
year = {2025}
}Incoming Citations (Sorted by Pagerank)
Showing 1 of 1 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 9,512 | Poisson Sampling over Acyclic Joins | 2026 | SIGMOD | 5.2571354e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 22 of 22 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 | 7,591 | Efficiently Processing Joins and Grouped Aggregations on GPUs | 2025 | SIGMOD |
| 2 | 3,622 | Robust Join Processing with Diamond Hardened Joins | 2024 | VLDB |
| 3 | 5,950 | Translating and Optimizing SQL Queries Having Aggregates | 1987 | VLDB |
| 4 | 12,386 | Efficient Rank Join with Aggregation Constraints | 2011 | VLDB |
| 5 | 3,813 | Query Simplification: Graceful Degradation for Join-Order Optimization | 2009 | SIGMOD |
| 6 | 554 | Answering Queries with Aggregation Using Views | 1996 | VLDB |
| 7 | 4,223 | Accelerating Queries with Group-By and Join by Groupjoin | 2011 | VLDB |
| 8 | 11,297 | Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle | 2024 | VLDB |
| 9 | 71 | Including Group-By in Query Optimization | 1994 | VLDB |
| 10 | 7,787 | A Practical Approach to Groupjoin and Nested Aggregates | 2021 | VLDB |