Sciweavers

Share
VLDB
1995
ACM

Aggregate-Query Processing in Data Warehousing Environments

10 years 2 months ago
Aggregate-Query Processing in Data Warehousing Environments
In this paper we introduce generalized projections (GPs), an extension of duplicateeliminating projections, that capture aggregations, groupbys, duplicate-eliminating projections (distinct), and duplicate-preserving projections in a common uni ed framework. Using GPs we extend well known and simple algorithms for SQL queries that use distinct projections toderive algorithmsfor queries using aggregations like sum, max, min, count, and avg. We develop powerful query rewrite rules for aggregate queries that unify and extend rewrite rules previously known in the literature. We then illustrate the power of our approach by solving a very practical and important problem in data warehousing: how to answer an aggregate query on base tables using materialized aggregate views (summary tables).
Ashish Gupta, Venky Harinarayan, Dallan Quass
Added 26 Aug 2010
Updated 26 Aug 2010
Type Conference
Year 1995
Where VLDB
Authors Ashish Gupta, Venky Harinarayan, Dallan Quass
Comments (0)
books