Article Open Access Logo

APPLICATION OF THE GREEDY ALGORITHM FOR SELECTING MATERIALIZED VIEWS IN DATA WAREHOUSE

Nguyen Dang Cao 1
Volume & Issue: Vol. 6 No. 5&6 (2003) | Page No.: 13-21 | DOI: 10.32508/stdj.v6i3&4.3325
Published: 2003-06-30

Online metrics


Statistics from the website

  • Abstract Views: 2572
  • Galley Views: 730

Statistics from Dimensions

Copyright The Author(s) 2023. This article is published with open access by Vietnam National University, Ho Chi Minh city, Vietnam. This article is distributed under the terms of the Creative Commons Attribution License (CC-BY 4.0) which permits any use, distribution, and reproduction in any medium, provided the original author(s) and the source are credited. 

Abstract

A warehouse is a repository of integrated information drawn from remote data sources. Since a warehouse effectively implements materialized views, we must maintain the views as data sources are updated. A lattice framework is used to express dependencies among views. This paper introduces a greedy algorithm that works off this lattice and determines a good set of views to materialize. A program written by Java illustrated the algorithm.

Comments