Sciweavers

26 search results - page 2 / 6
» Improved Unnesting Algorithms for Join Aggregate SQL Queries
Sort
View
SIGMOD
2000
ACM
161views Database» more  SIGMOD 2000»
13 years 9 months ago
Answering Complex SQL Queries Using Automatic Summary Tables
We investigate the problem of using materialized views to answer SQL queries. We focus on modern decision-support queries, which involve joins, arithmetic operations and other (po...
Markos Zaharioudakis, Roberta Cochrane, George Lap...
VLDB
1995
ACM
132views Database» more  VLDB 1995»
13 years 9 months ago
Coloring Away Communication in Parallel Query Optimization
We address the problem of finding parallel plans for SQL queries using the two-phase approach of join ordering and query rewrite (JOQR) followed by parallelization. We focus on t...
Waqar Hasan, Rajeev Motwani
VLDB
2005
ACM
105views Database» more  VLDB 2005»
13 years 10 months ago
View Matching for Outer-Join Views
Prior work on computing queries from materialized views has focused on views defined by expressions consisting of selection, projection, and inner joins, with an optional aggrega...
Per-Åke Larson, Jingren Zhou
KDD
2004
ACM
624views Data Mining» more  KDD 2004»
13 years 10 months ago
Programming the K-means clustering algorithm in SQL
Using SQL has not been considered an efficient and feasible way to implement data mining algorithms. Although this is true for many data mining, machine learning and statistical a...
Carlos Ordonez
DOLAP
2003
ACM
13 years 10 months ago
Exploiting hierarchical clustering in evaluating multidimensional aggregation queries
Multidimensional aggregation queries constitute the single most important class of queries for data warehousing applications and decision support systems. The bottleneck in the ev...
Dimitri Theodoratos