Preprocessing for fast refreshing materialized views in DB2

Wugang Xu, Calisto Zuzarte, Dimitri Theodoratos, Ma Wenbin

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

1 Scopus citations

Abstract

Materialized views (MVs) are used in databases and data warehouses to greatly improve query performance. In this context, a great challenge is to exploit commonalities among the views and to employ multi-query optimization techniques in order to derive an efficient global evaluation plan for refreshing the MVs concurrently. IBM DB2® Universal Database™ (DB2 UDB) provides two query matching techniques, query stacking and query sharing, to exploit commonalities among the MVs, and to construct an efficient global evaluation plan. When the number of MVs is large, memory and time restrictions prevent us from using both query matching techniques in constructing efficient global plans. We suggest an approach that applies the query stacking and query sharing techniques in different steps. The query stacking technique is applied first, and the outcome is exploited to define groups of MVs. The number of MVs in each group is restricted. This allows the query sharing technique to be applied only within groups in a second step. Finally, the query stacking technique is used again to determine an efficient global evaluation plan. An experimental evaluation shows that the execution time of the plan generated by our approach is very close to that of the plan generated using both query matching techniques without restriction. This result is valid no matter how big the database is.

Original languageEnglish (US)
Title of host publicationData Warehousing and Knowledge Discovery - 8th International Conference, DaWaK 2006, Proceedings
PublisherSpringer Verlag
Pages55-64
Number of pages10
ISBN (Print)3540377360, 9783540377368
DOIs
StatePublished - 2006
Event8th International Conference on Data Warehousing and Knowledge Discovery, DaWaK 2006 - Krakow, Poland
Duration: Sep 4 2006Sep 8 2006

Publication series

NameLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume4081 LNCS
ISSN (Print)0302-9743
ISSN (Electronic)1611-3349

Other

Other8th International Conference on Data Warehousing and Knowledge Discovery, DaWaK 2006
CountryPoland
CityKrakow
Period9/4/069/8/06

All Science Journal Classification (ASJC) codes

  • Theoretical Computer Science
  • Computer Science(all)

Fingerprint Dive into the research topics of 'Preprocessing for fast refreshing materialized views in DB2'. Together they form a unique fingerprint.

Cite this