Model of Summary Tables Selection for Data Warehouse

Authors:
Bogdan D. Czejdo;Malcolm C. Taylor;Catherine Putonti
Affiliations:
-;-;-
Venue:
ADVIS '00 Proceedings of the First International Conference on Advances in Information Systems
Year:
2000

Citing 6
Cited 0

InfoSleuth: agent-based semantic integration of information in open and dynamic environments

SIGMOD '97 Proceedings of the 1997 ACM SIGMOD international conference on Management of data
On-line warehouse view maintenance

SIGMOD '97 Proceedings of the 1997 ACM SIGMOD international conference on Management of data
Data warehouse: practical advice from the experts

Data warehouse: practical advice from the experts
Management of heterogeneous and autonomous database systems

Management of heterogeneous and autonomous database systems
Aggregate-Query Processing in Data Warehousing Environments

VLDB '95 Proceedings of the 21th International Conference on Very Large Data Bases
Answering Queries with Aggregation Using Views

VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases

Quantified Score

Hi-index	0.00

Visualization

Abstract

In this paper, we consider the problem of selecting summary tables for a Data Warehouse, in which aggregate queries are frequently posed. We introduce the concept of a complete aggregation graph for defining the possible summary tables. We present a model for determining an optimal set of summary tables. The selection algorithm based on the model takes into consideration query response time constraints and cost/benefit evaluation.