COSC 6340

COSC 6340 - Project 2
Group Presentation - H

Introduction:

Iceberg queries compute one or more aggregate functions to find aggregate values above a specified threshold. A typical iceberg query
would be

SELECT a, count(a)
    FROM tab
    GROUP BY a
    HAVING count(a) >= 100;

This base form can easily be made more complicated by doing self joins and the like.

We call such queries iceberg queries because the number of above-threshold results is often very small (the tip of an iceberg), relative to the large amount of input data (the iceberg).

Applications: This type of query is often found in market research, data
warehousing and search engines.

Group Info

Name:

Iceberg_Queries

Email:

iceberg_queries@yahoogroups.com