Database Paper Browser

Back to papers

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
8282
Venue
VLDB
Year
1995
Pagerank
0.00030773137
Overall Rank
249 | 98.28%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 50 of 50 citing papers.

Rank Citing Paper Year Venue Pagerank
14 Online Aggregation 1997 SIGMOD 0.0010813443
454 An Overview of Query Optimization in Relational Systems 1998 PODS 0.00022796106
640 Orthogonal Optimization of Subqueries and Aggregation 2001 SIGMOD 0.00018780632
728 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00017459654
825 Simultaneous Optimization and Evaluation of Multiple Dimensional Queries 1998 SIGMOD 0.00016171735
881 Query Processing for Sensor Networks 2003 CIDR 0.00015634948
963 Maintenance of Data Cubes and Summary Tables in a Warehouse 1997 SIGMOD 0.00014975448
1,172 Learning Generalized Linear Models Over Normalized Data 2015 SIGMOD 0.00013504249
1,231 Incremental Query Evaluation in a Ring of Databases 2010 PODS 0.00013141213
1,255 Aggregation and Ordering in Factorised Databases 2013 VLDB 0.00013011216
1,260 Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation 2016 SIGMOD 0.00012990853
1,283 Towards Linear Algebra over Normalized Data 2017 VLDB 0.00012826013
1,363 Range Queries in OLAP Data Cubes 1997 SIGMOD 0.00012380611
1,754 Querying Multiple Features of Groups in Relational Databases 1996 VLDB 0.00010663123
1,882 Ibex - An Intelligent Storage Engine with Support for Advanced SQL Off-loading 2014 VLDB 0.00010210181
1,930 Reusing Invariants: A New Strategy for Correlated Queries 1998 SIGMOD 0.00010052743
1,952 Groupwise Processing of Relational Queries 1997 VLDB 9.9806285e-05
2,220 On Parallel Processing of Aggregate and Scalar Functions in Object-Relational DBMS 1998 SIGMOD 9.2614686e-05
2,503 Enhanced Subquery Optimizations in Oracle 2009 VLDB 8.6306662e-05
3,280 A Layered Aggregate Engine for Analytics Workloads 2019 SIGMOD 7.2813732e-05
3,809 Supporting Ad-hoc Ranking Aggregates 2006 SIGMOD 6.7413981e-05
4,466 Robust Join Processing with Diamond Hardened Joins 2024 VLDB 6.1545841e-05
4,508 SPOOF: Sum-Product Optimization and Operator Fusion for Large-Scale Machine Learning 2017 CIDR 6.1261819e-05
4,645 Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates 2020 SIGMOD 6.0190618e-05
4,939 On the Correct and Complete Enumeration of the Core Search Space 2013 SIGMOD 5.8131374e-05
5,087 Accelerating Queries with Group-By and Join by Groupjoin 2011 VLDB 5.7032118e-05
5,177 User-Defined Aggregate Functions: Bridging Theory and Practice 2006 SIGMOD 5.6386942e-05
6,168 View Matching for Outer-Join Views 2005 VLDB 5.1709078e-05
6,438 Optimizing Join Enumeration in Transformation-based Query Optimizers 2014 VLDB 5.0552953e-05
6,830 Stacked Indexed Views in Microsoft SQL Server 2005 SIGMOD 4.9081078e-05
6,836 The Generalized Pre-Grouping Transformation: Aggregate-Query Optimization in the Presence of Dependencies 2003 VLDB 4.9065277e-05
7,042 Processing Star Queries on Hierarchically-Clustered Fact Tables 2002 VLDB 4.8483133e-05
7,996 On Relational Support for XML Publishing: Beyond Sorting and Tagging 2003 SIGMOD 4.606878e-05
8,020 User-Optimizer Communication using Abstract Plans in Sybase ASE 2001 VLDB 4.6005954e-05
8,070 Optimizing Iceberg Queries with Complex Joins 2017 SIGMOD 4.5893281e-05
8,502 New Query Optimization Techniques in the Spark Engine of Azure Synapse 2022 VLDB 4.491819e-05
8,676 A Practical Approach to Groupjoin and Nested Aggregates 2021 VLDB 4.4652082e-05
8,844 Faster Plan Generation through Consideration of Functional Dependencies and Keys 2016 VLDB 4.4334103e-05
9,335 Parallel Query Processing: To Separate Communication from Computation 2022 SIGMOD 4.351469e-05
9,801 Threshold Queries in Theory and in the Wild 2022 VLDB 4.2777144e-05
11,094 Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle 2024 VLDB 4.1905499e-05
11,365 Givens QR Decomposition over Relational Databases 2022 SIGMOD 4.1905499e-05
11,483 Vertex-centric Parallel Computation of SQL Queries 2021 SIGMOD 4.1905499e-05
11,628 Towards Multi-way Join Aware Optimizer in SAP HANA 2020 VLDB 4.1905499e-05
12,182 Score-Consistent Algebraic Optimization of Full-Text Search Queries with GRAFT 2011 SIGMOD 4.1905499e-05
12,286 Slicing Long-Running Queries 2010 VLDB 4.1905499e-05
12,317 Ordering, Distinctness, Aggregation, Partitioning and DQP Optimization in Sybase ASE 15 2009 SIGMOD 4.1905499e-05
12,529 Composite Subset Measures 2006 VLDB 4.1905499e-05
12,635 Estimating the Output Cardinality of Partial Preaggregation with a Measure of Clusteredness 2003 VLDB 4.1905499e-05
12,769 Partial-Sum Queries in OLAP Data Cubes Using Covering Codes 1997 PODS 4.1905499e-05
Previous Page 1 / 1 Next

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.

Previous Page 1 / 1 Next

Semantically Similar Papers