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

Tuning
Maintenance
Granularity
Intuitive
Update
Formulation
Alternatives
Range of data
Experience
Context

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.

On the importance of tuning in incremental view maintenance : an experience case study (Extended abstract). / O'gorman, K.; Agrawal, D.; El Abbadi, A.

Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). Vol. 1874 Springer Verlag, 2000. p. 77-82 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 1874).

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

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, Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), vol. 1874, Springer Verlag, pp. 77-82, 2nd International Conference on Data Warehousing and Knowledge Discovery, DaWaK 2000, London, United Kingdom, 4/9/00.
O'gorman K, Agrawal D, El Abbadi A. 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. Springer Verlag. 2000. p. 77-82. (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)).
O'gorman, K. ; Agrawal, D. ; El Abbadi, A. / On the importance of tuning in incremental view maintenance : an experience case study (Extended abstract). Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). Vol. 1874 Springer Verlag, 2000. pp. 77-82 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)).
@inproceedings{056010c04c284136abe86d5c0c4dd605,
title = "On the importance of tuning in incremental view maintenance: an experience case study (Extended abstract)",
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.",
author = "K. O'gorman and D. Agrawal and {El Abbadi}, A.",
year = "2000",
language = "English",
isbn = "3540679804",
volume = "1874",
series = "Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)",
publisher = "Springer Verlag",
pages = "77--82",
booktitle = "Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)",

}

TY - GEN

T1 - On the importance of tuning in incremental view maintenance

T2 - an experience case study (Extended abstract)

AU - O'gorman, K.

AU - Agrawal, D.

AU - El Abbadi, A.

PY - 2000

Y1 - 2000

N2 - 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.

AB - 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.

UR - http://www.scopus.com/inward/record.url?scp=84947600760&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=84947600760&partnerID=8YFLogxK

M3 - Conference contribution

SN - 3540679804

SN - 9783540679806

VL - 1874

T3 - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

SP - 77

EP - 82

BT - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

PB - Springer Verlag

ER -