Design and Selection of Materialized Views in a Data Warehousing Environment : A Case Study

Research output: Chapters, Conference Papers, Creative and Literary Works (RGC: 12, 32, 41, 45)32_Refereed conference paper (with ISBN/ISSN)peer-review

19 Scopus Citations
View graph of relations

Author(s)

Related Research Unit(s)

Detail(s)

Original languageEnglish
Title of host publicationDOLAP '99
Subtitle of host publicationProceedings of the 2nd ACM international workshop on Data warehousing and OLAP
PublisherACM
Pages42-47
ISBN (Print)1-58113-220-4
Publication statusPublished - Nov 1999

Conference

TitleEighth International Conference on Information and Knowledge Management
(CIKM)
PlaceUnited States
CityKansas City
Period2 - 6 November 1999

Abstract

In this paper, we describe the design of a data warehousing system for an engineering company 'R'. A cost model was developed for this system to enable the evaluation of the total costs and benefits involved in selecting each materialized view. Using the cost analysis methodology for evaluation, an adapted greedy algorithm has been implemented for the selection of materialized views. The algorithm and cost model were applied to a set of real-life database items extracted from company 'R'. By selecting the most cost effective set of materialized summary views, the total of the maintenance, storage and query costs of the system is optimized, thereby resulting in an efficient data warehousing system.

Citation Format(s)

Design and Selection of Materialized Views in a Data Warehousing Environment : A Case Study. / Chan, Goretti K.Y.; Li, Qing; Feng, Ling.

DOLAP '99: Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP. ACM, 1999. p. 42-47.

Research output: Chapters, Conference Papers, Creative and Literary Works (RGC: 12, 32, 41, 45)32_Refereed conference paper (with ISBN/ISSN)peer-review