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: ha74a4d219c5f7458
Venue: VLDB
Year: 1995
Pagerank: 0.00024759805
Overall Rank: 213 | 98.57%
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 4 of 54 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
12,793	Ordering, Distinctness, Aggregation, Partitioning and DQP Optimization in Sybase ASE 15	2009	SIGMOD	4.9793485e-05
13,003	Composite Subset Measures	2006	VLDB	4.9793485e-05
13,109	Estimating the Output Cardinality of Partial Preaggregation with a Measure of Clusteredness	2003	VLDB	4.9793485e-05
13,244	Partial-Sum Queries in OLAP Data Cubes Using Covering Codes	1997	PODS	4.9793485e-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
73	Including Group-By in Query Optimization	1994	VLDB	0.00037522101
109	Extensible/Rule Based Query Rewrite Optimization in Starburst	1992	SIGMOD	0.0003276959
196	Grammar-like Functional Rules for Representing Query Optimization Alternatives	1988	SIGMOD	0.00025626873
202	Aggregate-Query Processing in Data Warehousing Environments	1995	VLDB	0.00025244649

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	567	Answering Queries with Aggregation Using Views	1996	VLDB
2	2,438	Groupwise Processing of Relational Queries	1997	VLDB
3	552	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD
4	9,016	Faster Plan Generation through Consideration of Functional Dependencies and Keys	2016	VLDB
5	4,653	Translating Aggregate Queries into Iterative Programs	1986	VLDB
6	7,138	The Generalized Pre-Grouping Transformation: Aggregate Query Optimization in the Presence of Dependencies	2003	VLDB
7	7,907	A Practical Approach to Groupjoin and Nested Aggregates	2021	VLDB
8	73	Including Group-By in Query Optimization	1994	VLDB
9	11,617	Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle	2024	VLDB
10	4,209	Accelerating Queries with Group-By and Join by Groupjoin	2011	VLDB