On the importance of tuning in incremental view maintenance: an experience case study (Extended abstract)

K. O'gorman, D. Agrawal, A. El Abbadi

Research output: Chapter in Book/Report/Conference proceedingConference contribution

3 Citations (Scopus)

Abstract

We describe the tuning of a gigabyte-scale TPC-D database for investigation of incremental maintenance of a materialized view. We find that incremental maintenance is feasible over a wide range of update sizes (granularities), that intuitive SQL formulations perform poorly, but that there are better alternatives. We show that these results can be meaningfully evaluated and presented only in the context of reasonable instance tuning.

Original languageEnglish
Title of host publicationLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
PublisherSpringer Verlag
Pages77-82
Number of pages6
Volume1874
ISBN (Print)3540679804, 9783540679806
Publication statusPublished - 2000
Externally publishedYes
Event2nd International Conference on Data Warehousing and Knowledge Discovery, DaWaK 2000 - London, United Kingdom
Duration: 4 Sep 20006 Sep 2000

Publication series

NameLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume1874
ISSN (Print)03029743
ISSN (Electronic)16113349

Other

Other2nd International Conference on Data Warehousing and Knowledge Discovery, DaWaK 2000
CountryUnited Kingdom
CityLondon
Period4/9/006/9/00

    Fingerprint

ASJC Scopus subject areas

  • Computer Science(all)
  • Theoretical Computer Science

Cite this

O'gorman, K., Agrawal, D., & El Abbadi, A. (2000). On the importance of tuning in incremental view maintenance: an experience case study (Extended abstract). In Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics) (Vol. 1874, pp. 77-82). (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 1874). Springer Verlag.