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
2945
Venue
SIGMOD
Year
1997
Pagerank
0.0010813443
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.00092569117
43 Models and Issues in Data Stream Systems 2002 PODS 0.00072660894
118 Answering Queries using Humans, Algorithms and Databases 2011 CIDR 0.00045860394
169 MAD Skills: New Analysis Practices for Big Data 2009 VLDB 0.00038967371
184 New Sampling-Based Summary Statistics for Improving Approximate Query Answers 1998 SIGMOD 0.00036655704
191 The Design of the Borealis Stream Processing Engine 2005 CIDR 0.00035714897
204 Monitoring Streams – A New Class of Data Management Applications 2002 VLDB 0.00034696955
212 Join Synopses for Approximate Query Answering 1999 SIGMOD 0.00033997204
216 Ripple Joins for Online Aggregation 1999 SIGMOD 0.00033560137
275 Approximate Computation of Multidimensional Aggregates of Sparse Data Using Wavelets 1999 SIGMOD 0.00029381206
316 Distinct Sampling for Highly-Accurate Answers to Distinct Values Queries and Event Reports 2001 VLDB 0.00027981848
322 MCDB: A Monte Carlo Approach to Managing Uncertain Data 2008 SIGMOD 0.00027523667
325 The History of Histograms (abridged) 2003 VLDB 0.00027398081
360 Histogram-Based Approximation of Set-Valued Query Answers 1999 VLDB 0.00025768448
387 Graph Summarization with Bounded Error 2008 SIGMOD 0.00024682268
416 Approximate Query Processing Using Wavelets 2000 VLDB 0.00023773968
423 Tuning Database Configuration Parameters with iTuned 2009 VLDB 0.00023628474
430 Approximate Query Processing: Taming the TeraBytes! A Tutorial 2001 VLDB 0.00023406426
477 Model-Driven Data Acquisition in Sensor Networks 2004 VLDB 0.00022205608
550 Tracking Join and Self-Join Sizes in Limited Storage 1999 PODS 0.00020346247
617 On Computing Correlated Aggregates Over Continual Data Streams 2001 SIGMOD 0.00019048986
694 BlazeIt: Optimizing Declarative Aggregation and Limit Queries for Neural Network-Based Video Analytics 2020 VLDB 0.00018031141
736 Congressional Samples for Approximate Answering of Group-By Queries 2000 SIGMOD 0.00017414831
941 Wander Join: Online Aggregation via Random Walks 2016 SIGMOD 0.00015147831
960 Aqua: A Fast Decision Support System Using Approximate Query Answers 1999 VLDB 0.00015031055
1,025 Query Steering for Interactive Data Exploration 2013 CIDR 0.00014600179
1,161 VerdictDB: Universalizing Approximate Query Processing 2018 SIGMOD 0.00013579831
1,229 Toward a Progress Indicator for Database Queries 2004 SIGMOD 0.00013153898
1,257 Dynamic Sample Selection for Approximate Query Processing 2003 SIGMOD 0.00013002384
1,320 Quickr: Lazily Approximating Complex AdHoc Queries in BigData Clusters 2016 SIGMOD 0.00012606067
1,331 ICICLES: Self-tuning Samples for Approximate Query Answering 2000 VLDB 0.00012553948
1,339 SkewTune: Mitigating Skew in MapReduce Applications 2012 SIGMOD 0.00012492978
1,354 Northstar: An Interactive Data Science System 2018 VLDB 0.00012424105
1,372 Random Sampling over Joins Revisited 2018 SIGMOD 0.0001233325
1,425 Scalable Approximate Query Processing With The DBO Engine 2007 SIGMOD 0.00012044433
1,427 Towards Scalable Dataframe Systems 2020 VLDB 0.00012033503
1,451 Online Aggregation for Large MapReduce Jobs 2011 VLDB 0.00011925842
1,507 Overview of Data Exploration Techniques 2015 SIGMOD 0.00011594294
1,509 Estimating Progress of Execution for SQL Queries 2004 SIGMOD 0.0001158945
1,531 Online Dynamic Reordering for Interactive Data Processing 1999 VLDB 0.00011467334
1,574 Approximate Query Processing: No Silver Bullet 2017 SIGMOD 0.00011289028
1,605 Incremental Distance Join Algorithms for Spatial Databases 1998 SIGMOD 0.00011180126
1,609 Exploratory Mining and Pruning Optimizations of Constrained Association Rules 1998 SIGMOD 0.00011166163
1,768 ParaTimer: A Progress Indicator for MapReduce DAGs 2010 SIGMOD 0.00010608933
1,771 Offering a Precision-Performance Tradeoff for Aggregation Queries over Replicated Data 2000 VLDB 0.00010606967
1,798 Online Processing Algorithms for Influence Maximization 2018 SIGMOD 0.00010500792
1,845 dbTouch: Analytics at your Fingertips 2013 CIDR 0.00010339281
1,849 Combining User Interaction, Speculative Query Execution and Sampling in the DICE System 2014 VLDB 0.00010331082
1,867 Knowing When You’re Wrong: Building Fast and Reliable Approximate Query Processing Systems 2014 SIGMOD 0.00010264932
1,930 Reusing Invariants: A New Strategy for Correlated Queries 1998 SIGMOD 0.00010052743
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.0040465394
9 Implementation Techniques For Main Memory Database Systems 1984 SIGMOD 0.001426258
30 Hashing Methods and Relational Algebra Operations 1984 VLDB 0.00078665259
37 Statistical Estimators for Relational Algebra Expressions 1988 PODS 0.00075597514
133 Processing Aggregate Relational Queries with Hard Time Constraints 1989 SIGMOD 0.00043220055
218 Aggregate-Query Processing in Data Warehousing Environments 1995 VLDB 0.00033489004
247 On the Computation of Multidimensional Aggregates 1996 VLDB 0.00030923842
249 Eager Aggregation and Lazy Aggregation 1995 VLDB 0.00030773137
291 Error-Constrained COUNT Query Evaluation in Relational Databases 1991 SIGMOD 0.00028778973
699 Query Execution Techniques for Caching Expensive Methods 1996 SIGMOD 0.0001794078
1,313 Cost-Based Optimization for Magic: Algebra and Implementation 1996 SIGMOD 0.00012629432
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
1,065 Processing Complex Aggregate Queries over Data Streams 2002 SIGMOD 0.00014344675
4,244 A Disk-Based Join With Probabilistic Guarantees* 2005 SIGMOD 6.3228453e-05
3,989 Beyond Simple Aggregates: Indexing for Summary Queries 2011 PODS 6.5545373e-05
1,675 Adaptive Parallel Aggregation Algorithms 1995 SIGMOD 0.00010937908
4,083 Distributed Online Aggregations 2009 VLDB 6.4583812e-05
216 Ripple Joins for Online Aggregation 1999 SIGMOD 0.00033560137
12,576 Online Estimation For Subset-Based SQL Queries 2005 VLDB 4.1905499e-05
4,902 Online Feedback for Nested Aggregate Queries with Multi-Threading 1999 VLDB 5.8415033e-05
4,963 Online Query Processing: A Tutorial 2001 SIGMOD 5.7979792e-05
1,451 Online Aggregation for Large MapReduce Jobs 2011 VLDB 0.00011925842