Supporting top-k join queries in relational databases

IF Ilyas, WG Aref, AK Elmagarmid - The VLDB journal, 2004 - Springer
Ranking queries, also known as top-k queries, produce results that are ordered on some
computed score. Typically, these queries involve joins, where users are usually interested …

Load shedding for aggregation queries over data streams

B Babcock, M Datar, R Motwani - … . 20th international conference …, 2004 - ieeexplore.ieee.org
Systems for processing continuous monitoring queries over data streams must be adaptive
because data streams are often bursty and data characteristics may vary over time. We focus …

Database tuning principles, experiments, and troubleshooting techniques

D Shasha, P Bonnet, NH Bercich - ACM SIGMOD Record, 2004 - dl.acm.org
As our reliance on computers and computerized data has increased, we have come to
expect more from our computers. We no longer expect our computers to act as large …

Online amnesic approximation of streaming time series

T Palpanas, M Vlachos, E Keogh… - … Conference on Data …, 2004 - ieeexplore.ieee.org
The past decade has seen a wealth of research on time series representations, because the
manipulation, storage, and indexing of large volumes of raw time series data is impractical …

Dynamic plan migration for continuous queries over data streams

Y Zhu, EA Rundensteiner, GT Heineman - Proceedings of the 2004 ACM …, 2004 - dl.acm.org
Dynamic plan migration is concerned with the on-the-fly transition from one continuous
query plan to a semantically equivalent yet more efficient plan. Migration is important for …

Estimating progress of execution for SQL queries

S Chaudhuri, V Narasayya… - Proceedings of the 2004 …, 2004 - dl.acm.org
Today's database systems provide little feedback to the user/DBA on how much of a SQL
query's execution has been completed. For long running queries, such feedback can be very …

Hash-merge join: A non-blocking join algorithm for producing fast and early join results

MF Mokbel, M Lu, WG Aref - Proceedings. 20th International …, 2004 - ieeexplore.ieee.org
We introduce the hash-merge join algorithm (HMJ, for short); a new nonblocking join
algorithm that deals with data items from remote sources via unpredictable, slow, or bursty …

Rank-aware query optimization

IF Ilyas, R Shah, WG Aref, JS Vitter… - Proceedings of the 2004 …, 2004 - dl.acm.org
Ranking is an important property that needs to be fully supported by current relational query
engines. Recently, several rank-join query operators have been proposed based on rank …

Static optimization of conjunctive queries with sliding windows over infinite streams

AM Ayad, JF Naughton - Proceedings of the 2004 ACM SIGMOD …, 2004 - dl.acm.org
We define a framework for static optimization of sliding window conjunctive queries over
infinite streams. When computational resources are sufficient, we propose that the goal of …

Toward a progress indicator for database queries

G Luo, JF Naughton, CJ Ellmann… - Proceedings of the 2004 …, 2004 - dl.acm.org
Many modern software systems provide progress indicators for long-running tasks. These
progress indicators make systems more user-friendly by helping the user quickly estimate …