Design and selection of materialized views in a data warehousing environment: A case study

Goretti K.Y. Chan, Qing Li, Ling Feng

Research output: Chapter in book / Conference proceedingConference article published in proceeding or bookAcademic researchpeer-review

19 Citations (Scopus)

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. Copyright ACM 1999.

Original languageEnglish
Title of host publicationProceedings of the 2nd ACM International Workshop on Data Warehousing and OLAP, DOLAP 1999
PublisherAssociation for Computing Machinery
Pages42-47
Number of pages6
ISBN (Electronic)1581132204, 9781581132205
DOIs
Publication statusPublished - 6 Nov 1999
Externally publishedYes
Event2nd ACM International Workshop on Data Warehousing and OLAP, DOLAP 1999 - Kansas City, United States
Duration: 2 Nov 19996 Nov 1999

Publication series

NameDOLAP: Proceedings of the ACM International Workshop on Data Warehousing and OLAP
VolumePart F129191

Conference

Conference2nd ACM International Workshop on Data Warehousing and OLAP, DOLAP 1999
CountryUnited States
CityKansas City
Period2/11/996/11/99

ASJC Scopus subject areas

  • Computer Science(all)

Cite this