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
8281
Venue
VLDB
Year
1995
Pagerank
0.00030785339
Overall Rank
248 | 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.0010801504
454 An Overview of Query Optimization in Relational Systems 1998 PODS 0.00022734812
639 Orthogonal Optimization of Subqueries and Aggregation 2001 SIGMOD 0.00018791492
731 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00017468889
829 Simultaneous Optimization and Evaluation of Multiple Dimensional Queries 1998 SIGMOD 0.0001618536
885 Query Processing for Sensor Networks 2003 CIDR 0.00015646925
962 Maintenance of Data Cubes and Summary Tables in a Warehouse 1997 SIGMOD 0.00014986226
1,167 Learning Generalized Linear Models Over Normalized Data 2015 SIGMOD 0.00013547713
1,238 Incremental Query Evaluation in a Ring of Databases 2010 PODS 0.00013114581
1,259 Aggregation and Ordering in Factorised Databases 2013 VLDB 0.00012995821
1,263 Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation 2016 SIGMOD 0.00012982857
1,279 Towards Linear Algebra over Normalized Data 2017 VLDB 0.00012868394
1,359 Range Queries in OLAP Data Cubes 1997 SIGMOD 0.0001238588
1,754 Querying Multiple Features of Groups in Relational Databases 1996 VLDB 0.00010670609
1,881 Ibex - An Intelligent Storage Engine with Support for Advanced SQL Off-loading 2014 VLDB 0.00010217568
1,927 Reusing Invariants: A New Strategy for Correlated Queries 1998 SIGMOD 0.00010062716
1,948 Groupwise Processing of Relational Queries 1997 VLDB 9.989482e-05
2,216 On Parallel Processing of Aggregate and Scalar Functions in Object-Relational DBMS 1998 SIGMOD 9.2699038e-05
2,504 Enhanced Subquery Optimizations in Oracle 2009 VLDB 8.6351917e-05
3,277 A Layered Aggregate Engine for Analytics Workloads 2019 SIGMOD 7.2871625e-05
3,807 Supporting Ad-hoc Ranking Aggregates 2006 SIGMOD 6.747576e-05
4,465 Robust Join Processing with Diamond Hardened Joins 2024 VLDB 6.1604282e-05
4,505 SPOOF: Sum-Product Optimization and Operator Fusion for Large-Scale Machine Learning 2017 CIDR 6.1327108e-05
4,648 Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates 2020 SIGMOD 6.0247446e-05
4,938 On the Correct and Complete Enumeration of the Core Search Space 2013 SIGMOD 5.8184655e-05
5,087 Accelerating Queries with Group-By and Join by Groupjoin 2011 VLDB 5.7075009e-05
5,176 User-Defined Aggregate Functions: Bridging Theory and Practice 2006 SIGMOD 5.6439407e-05
6,166 View Matching for Outer-Join Views 2005 VLDB 5.1724475e-05
6,443 Optimizing Join Enumeration in Transformation-based Query Optimizers 2014 VLDB 5.0599139e-05
6,832 Stacked Indexed Views in Microsoft SQL Server 2005 SIGMOD 4.9128255e-05
6,837 The Generalized Pre-Grouping Transformation: Aggregate-Query Optimization in the Presence of Dependencies 2003 VLDB 4.9111342e-05
7,045 Processing Star Queries on Hierarchically-Clustered Fact Tables 2002 VLDB 4.8528709e-05
7,992 On Relational Support for XML Publishing: Beyond Sorting and Tagging 2003 SIGMOD 4.6113031e-05
8,016 User-Optimizer Communication using Abstract Plans in Sybase ASE 2001 VLDB 4.6050078e-05
8,066 Optimizing Iceberg Queries with Complex Joins 2017 SIGMOD 4.5937212e-05
8,506 New Query Optimization Techniques in the Spark Engine of Azure Synapse 2022 VLDB 4.4957661e-05
8,680 A Practical Approach to Groupjoin and Nested Aggregates 2021 VLDB 4.4694927e-05
8,844 Faster Plan Generation through Consideration of Functional Dependencies and Keys 2016 VLDB 4.437664e-05
9,330 Parallel Query Processing: To Separate Communication from Computation 2022 SIGMOD 4.3556432e-05
9,798 Threshold Queries in Theory and in the Wild 2022 VLDB 4.2818172e-05
11,091 Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle 2024 VLDB 4.1945683e-05
11,363 Givens QR Decomposition over Relational Databases 2022 SIGMOD 4.1945683e-05
11,479 Vertex-centric Parallel Computation of SQL Queries 2021 SIGMOD 4.1945683e-05
11,624 Towards Multi-way Join Aware Optimizer in SAP HANA 2020 VLDB 4.1945683e-05
12,174 Score-Consistent Algebraic Optimization of Full-Text Search Queries with GRAFT 2011 SIGMOD 4.1945683e-05
12,278 Slicing Long-Running Queries 2010 VLDB 4.1945683e-05
12,309 Ordering, Distinctness, Aggregation, Partitioning and DQP Optimization in Sybase ASE 15 2009 SIGMOD 4.1945683e-05
12,520 Composite Subset Measures 2006 VLDB 4.1945683e-05
12,626 Estimating the Output Cardinality of Partial Preaggregation with a Measure of Clusteredness 2003 VLDB 4.1945683e-05
12,760 Partial-Sum Queries in OLAP Data Cubes Using Covering Codes 1997 PODS 4.1945683e-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