Ripple joins for online aggregation

PJ Haas, JM Hellerstein - ACM SIGMOD Record, 1999 - dl.acm.org
We present a new family of join algorithms, called ripple joins, for online processing of multi-
table aggregation queries in a relational database management system (DBMS). Such …

A scalable hash ripple join algorithm

G Luo, CJ Ellmann, PJ Haas, JF Naughton - Proceedings of the 2002 …, 2002 - dl.acm.org
Recently, Haas and Hellerstein proposed the hash ripple join algorithm in the context of
online aggregation. Although the algorithm rapidly gives a good estimate for many join …

Wander join: Online aggregation via random walks

F Li, B Wu, K Yi, Z Zhao - … of the 2016 International Conference on …, 2016 - dl.acm.org
Joins are expensive, and online aggregation over joins was proposed to mitigate the cost,
which offers users a nice and flexible tradeoff between query efficiency and accuracy in a …

Large-sample and deterministic confidence intervals for online aggregation

PJ Haas - … . Ninth International Conference on Scientific and …, 1997 - ieeexplore.ieee.org
The online aggregation system recently proposed by JM Hellerstein, et al.(1997) permits
interactive exploration of large, complex datasets stored in relational database management …

Online aggregation

JM Hellerstein, PJ Haas, HJ Wang - Proceedings of the 1997 ACM …, 1997 - dl.acm.org
Aggregation in traditional database systems is performed in batch mode: a query is
submitted, the system processes a large volume of data over a long period of time, and …

Continuous sampling for online aggregation over multiple queries

S Wu, BC Ooi, KL Tan - Proceedings of the 2010 ACM SIGMOD …, 2010 - dl.acm.org
In this paper, we propose an online aggregation system called COSMOS (Continuous
Sampling for Multiple queries in an Online aggregation System), to process multiple …

Distributed online aggregations

S Wu, S Jiang, BC Ooi, KL Tan - Proceedings of the VLDB Endowment, 2009 - dl.acm.org
In many decision making applications, users typically issue aggregate queries. To evaluate
these computationally expensive queries, online aggregation has been developed to …

A robust, optimization-based approach for approximate answering of aggregate queries

S Chaudhuri, G Das, V Narasayya - ACM SIGMOD Record, 2001 - dl.acm.org
The ability to approximately answer aggregation queries accurately and efficiently is of great
benefit for decision support and data mining tools. In contrast to previous sampling-based …

Adaptive parallel aggregation algorithms

A Shatdal, JF Naughton - Acm Sigmod Record, 1995 - dl.acm.org
Aggregation and duplicate removal are common in SQL queries. However, in the parallel
query processing literature, aggregate processing has received surprisingly little attention; …

Supporting streaming updates in an active data warehouse

N Polyzotis, S Skiadopoulos… - 2007 IEEE 23rd …, 2006 - ieeexplore.ieee.org
Active data warehousing has emerged as an alternative to conventional warehousing
practices in order to meet the high demand of applications for up-to-date information. In a …