Database Paper Browser

Back to papers

Online Aggregation

Summary: Online aggregation replaces batch-only queries with an interactive, progressive interface that exposes progress and lets users steer execution. Introduces random-order output, relative-rate control for aggregates, and running confidence intervals; implemented initially in PostgreSQL. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
2944
Venue
SIGMOD
Year
1997
Pagerank
0.0010801504
Overall Rank
14 | 99.91%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 50 of 206 citing papers.

Rank Citing Paper Year Venue Pagerank
18 On Random Sampling over Joins 1999 SIGMOD 0.00092385438
43 Models and Issues in Data Stream Systems 2002 PODS 0.00072723062
119 Answering Queries using Humans, Algorithms and Databases 2011 CIDR 0.0004564788
168 MAD Skills: New Analysis Practices for Big Data 2009 VLDB 0.00038946305
184 New Sampling-Based Summary Statistics for Improving Approximate Query Answers 1998 SIGMOD 0.00036625711
191 The Design of the Borealis Stream Processing Engine 2005 CIDR 0.00035738595
205 Monitoring Streams – A New Class of Data Management Applications 2002 VLDB 0.00034731577
211 Join Synopses for Approximate Query Answering 1999 SIGMOD 0.00033981214
217 Ripple Joins for Online Aggregation 1999 SIGMOD 0.00033536712
273 Approximate Computation of Multidimensional Aggregates of Sparse Data Using Wavelets 1999 SIGMOD 0.00029390945
308 Distinct Sampling for Highly-Accurate Answers to Distinct Values Queries and Event Reports 2001 VLDB 0.00028142852
321 MCDB: A Monte Carlo Approach to Managing Uncertain Data 2008 SIGMOD 0.00027527389
325 The History of Histograms (abridged) 2003 VLDB 0.00027378328
361 Histogram-Based Approximation of Set-Valued Query Answers 1999 VLDB 0.00025775749
388 Graph Summarization with Bounded Error 2008 SIGMOD 0.00024662272
405 Approximate Query Processing Using Wavelets 2000 VLDB 0.00024057494
424 Tuning Database Configuration Parameters with iTuned 2009 VLDB 0.00023616398
449 Approximate Query Processing: Taming the TeraBytes! A Tutorial 2001 VLDB 0.00022846068
477 Model-Driven Data Acquisition in Sensor Networks 2004 VLDB 0.00022221803
549 Tracking Join and Self-Join Sizes in Limited Storage 1999 PODS 0.00020376603
619 On Computing Correlated Aggregates Over Continual Data Streams 2001 SIGMOD 0.00019066583
696 BlazeIt: Optimizing Declarative Aggregation and Limit Queries for Neural Network-Based Video Analytics 2020 VLDB 0.00018048935
739 Congressional Samples for Approximate Answering of Group-By Queries 2000 SIGMOD 0.00017401518
943 Wander Join: Online Aggregation via Random Walks 2016 SIGMOD 0.00015145883
967 Aqua: A Fast Decision Support System Using Approximate Query Answers 1999 VLDB 0.00014959939
1,023 Query Steering for Interactive Data Exploration 2013 CIDR 0.00014611863
1,204 VerdictDB: Universalizing Approximate Query Processing 2018 SIGMOD 0.00013319541
1,228 Toward a Progress Indicator for Database Queries 2004 SIGMOD 0.00013164884
1,260 Dynamic Sample Selection for Approximate Query Processing 2003 SIGMOD 0.00012993347
1,323 Quickr: Lazily Approximating Complex AdHoc Queries in BigData Clusters 2016 SIGMOD 0.00012601997
1,334 SkewTune: Mitigating Skew in MapReduce Applications 2012 SIGMOD 0.0001250413
1,335 ICICLES: Self-tuning Samples for Approximate Query Answering 2000 VLDB 0.00012502131
1,350 Northstar: An Interactive Data Science System 2018 VLDB 0.00012431059
1,369 Random Sampling over Joins Revisited 2018 SIGMOD 0.00012339777
1,425 Scalable Approximate Query Processing With The DBO Engine 2007 SIGMOD 0.00012051353
1,427 Towards Scalable Dataframe Systems 2020 VLDB 0.0001204248
1,464 Online Aggregation for Large MapReduce Jobs 2011 VLDB 0.00011865546
1,512 Estimating Progress of Execution for SQL Queries 2004 SIGMOD 0.00011597041
1,531 Online Dynamic Reordering for Interactive Data Processing 1999 VLDB 0.00011482597
1,552 Overview of Data Exploration Techniques 2015 SIGMOD 0.00011408814
1,574 Approximate Query Processing: No Silver Bullet 2017 SIGMOD 0.00011287495
1,626 Exploratory Mining and Pruning Optimizations of Constrained Association Rules 1998 SIGMOD 0.00011094469
1,631 Incremental Distance Join Algorithms for Spatial Databases 1998 SIGMOD 0.00011078269
1,770 ParaTimer: A Progress Indicator for MapReduce DAGs 2010 SIGMOD 0.00010618229
1,773 Offering a Precision-Performance Tradeoff for Aggregation Queries over Replicated Data 2000 VLDB 0.00010609478
1,801 Online Processing Algorithms for Influence Maximization 2018 SIGMOD 0.00010510943
1,840 dbTouch: Analytics at your Fingertips 2013 CIDR 0.0001034905
1,846 Combining User Interaction, Speculative Query Execution and Sampling in the DICE System 2014 VLDB 0.00010335419
1,874 Knowing When You’re Wrong: Building Fast and Reliable Approximate Query Processing Systems 2014 SIGMOD 0.00010244443
1,927 Reusing Invariants: A New Strategy for Correlated Queries 1998 SIGMOD 0.00010062716
Previous Page 1 / 5 Next

Outgoing Citations (Sorted by Pagerank)

Showing 11 of 11 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
1 Access Path Selection in a Relational Database Management System 1979 SIGMOD 0.0040449103
9 Implementation Techniques For Main Memory Database Systems 1984 SIGMOD 0.0014279444
30 Hashing Methods and Relational Algebra Operations 1984 VLDB 0.00078672446
39 Statistical Estimators for Relational Algebra Expressions 1988 PODS 0.00074745564
134 Processing Aggregate Relational Queries with Hard Time Constraints 1989 SIGMOD 0.00042452811
218 Aggregate-Query Processing in Data Warehousing Environments 1995 VLDB 0.00033503922
247 On the Computation of Multidimensional Aggregates 1996 VLDB 0.00030927763
248 Eager Aggregation and Lazy Aggregation 1995 VLDB 0.00030785339
315 Error-Constrained COUNT Query Evaluation in Relational Databases 1991 SIGMOD 0.0002802103
703 Query Execution Techniques for Caching Expensive Methods 1996 SIGMOD 0.00017916705
1,313 Cost-Based Optimization for Magic: Algebra and Implementation 1996 SIGMOD 0.0001263831
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
1,064 Processing Complex Aggregate Queries over Data Streams 2002 SIGMOD 0.00014356481
4,245 A Disk-Based Join With Probabilistic Guarantees* 2005 SIGMOD 6.3272687e-05
3,991 Beyond Simple Aggregates: Indexing for Summary Queries 2011 PODS 6.5553055e-05
1,674 Adaptive Parallel Aggregation Algorithms 1995 SIGMOD 0.0001094787
4,093 Distributed Online Aggregations 2009 VLDB 6.4558147e-05
217 Ripple Joins for Online Aggregation 1999 SIGMOD 0.00033536712
4,896 Online Feedback for Nested Aggregate Queries with Multi-Threading 1999 VLDB 5.8469503e-05
12,567 Online Estimation For Subset-Based SQL Queries 2005 VLDB 4.1945683e-05
4,962 Online Query Processing: A Tutorial 2001 SIGMOD 5.7977169e-05
1,464 Online Aggregation for Large MapReduce Jobs 2011 VLDB 0.00011865546