Supporting ad-hoc ranking aggregates

C Li, K Chen-Chuan Chang, IF Ilyas - Proceedings of the 2006 ACM …, 2006 - dl.acm.org
This paper presents a principled framework for efficient processing of ad-hoc top-k (ranking)
aggregate queries, which provide the k groups with the highest aggregates as results …

Adaptive rank-aware query optimization in relational databases

IF Ilyas, WG Aref, AK Elmagarmid… - ACM Transactions on …, 2006 - dl.acm.org
Rank-aware query processing has emerged as a key requirement in modern applications. In
these applications, efficient and adaptive evaluation of top-k queries is an integral part of the …

New sampling-based estimators for OLAP queries

R Jin, L Glimcher, C Jermaine… - … Conference on Data …, 2006 - ieeexplore.ieee.org
One important way in which sampling for approximate query processing in a database
environment differs from traditional applications of sampling is that in a database, it is …

The sort-merge-shrink join

C Jermaine, A Dobra, S Arumugam, S Joshi… - ACM Transactions on …, 2006 - dl.acm.org
One of the most common operations in analytic query processing is the application of an
aggregate function to the result of a relational join. We describe an algorithm called the Sort …

Sliding window query processing over data streams

L Golab - 2006 - uwspace.uwaterloo.ca
Database management systems (DBMSs) have been used successfully in traditional
business applications that require persistent data storage and an efficient querying …

Sample-based quality estimation of query results in relational database environments

DP Ballou, ISN Chengalur-Smith… - IEEE transactions on …, 2006 - ieeexplore.ieee.org
The quality of data in relational databases is often uncertain, and the relationship between
the quality of the underlying base tables and the set of potential query results, a type of …

Method and apparatus for performing hash join

G Luo, CJ Ellmann, JF Naughton - US Patent 7,085,769, 2006 - Google Patents
(57) ABSTRACT A parallel hash ripple join algorithm partitions tuples of tWo relations for
localized processing. The algorithm is non blocking and may be performed in a parallel …

Partial materialized views

G Luo - 2007 IEEE 23rd International Conference on Data …, 2006 - ieeexplore.ieee.org
Early access to partial query results is highly desirable during exploration of massive data
sets. However, it is challenging to provide transactionally consistent, immediate partial …

ARGUS: Efficient Scalable Continuous Query Optimization for Large-Volume Data Streams

C Jin, J Carbonell - 2006 10th International Database …, 2006 - ieeexplore.ieee.org
We present the architecture of ARGUS, a stream processing system implemented atop
commercial DBMSs to support large-scale complex continuous queries over data streams …

Online random shuffling of large database tables

C Jermaine - IEEE transactions on knowledge and data …, 2006 - ieeexplore.ieee.org
Many applications require a randomized ordering of input data. Examples include
algorithms for online aggregation, data mining, and various randomized algorithms. Most …