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)

Paper ID: 8472
Venue: VLDB
Year: 1995
Pagerank: 0.00025092273
Overall Rank: 206 | 98.59%
DOI: -

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 1 of 51 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
12,954	Partial-Sum Queries in OLAP Data Cubes Using Covering Codes	1997	PODS	5.093636e-05

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

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