Eager Aggregation and Lazy Aggregation
Summary: Eager aggregation partially pushes a group-by below a join to shrink join input, while preserving the original group-by above. Lazy aggregation pulls a group-by above a join and merges group-bys for grouped-view reuse; experiments on TPC-D show gains. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Weipeng P. Yan (University of Waterloo)
- 2. Per-Ake Larson (University of Waterloo)
BibTeX Citation
@article{yan_vldb95,
title = {{Eager Aggregation and Lazy Aggregation}},
author = {Yan, Weipeng P. and Larson, Per-Ake},
journal = {PVLDB},
series = {{VLDB} '95},
pages = {345},
year = {1995}
}Incoming Citations (Sorted by Pagerank)
Showing 50 of 51 citing papers.
Outgoing Citations (Sorted by Pagerank)
Showing 4 of 4 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 71 | Including Group-By in Query Optimization | 1994 | VLDB | 0.00038021159 |
| 110 | Extensible/Rule Based Query Rewrite Optimization in Starburst | 1992 | SIGMOD | 0.0003309592 |
| 192 | Grammar-like Functional Rules for Representing Query Optimization Alternatives | 1988 | SIGMOD | 0.00026028406 |
| 198 | Aggregate-Query Processing in Data Warehousing Environments | 1995 | VLDB | 0.00025618616 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 554 | Answering Queries with Aggregation Using Views | 1996 | VLDB |
| 2 | 2,385 | Groupwise Processing of Relational Queries | 1997 | VLDB |
| 3 | 543 | Orthogonal Optimization of Subqueries and Aggregation | 2001 | SIGMOD |
| 4 | 8,856 | Faster Plan Generation through Consideration of Functional Dependencies and Keys | 2016 | VLDB |
| 5 | 4,574 | Translating Aggregate Queries into Iterative Programs | 1986 | VLDB |
| 6 | 7,020 | The Generalized Pre-Grouping Transformation: Aggregate Query Optimization in the Presence of Dependencies | 2003 | VLDB |
| 7 | 7,787 | A Practical Approach to Groupjoin and Nested Aggregates | 2021 | VLDB |
| 8 | 71 | Including Group-By in Query Optimization | 1994 | VLDB |
| 9 | 11,297 | Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle | 2024 | VLDB |
| 10 | 4,223 | Accelerating Queries with Group-By and Join by Groupjoin | 2011 | VLDB |