Efficient materialization and use of views in data warehouses

  • Authors:
  • Márcio Farias de Souza;Marcus Costa Sampaio

  • Affiliations:
  • Federal University of Paraíba, Department of Computer Science, 58.109-970 Campina Grande Paraíba Brazil;Federal University of Paraíba, Department of Computer Science, 58.109-970 Campina Grande Paraíba Brazil

  • Venue:
  • ACM SIGMOD Record
  • Year:
  • 1999

Quantified Score

Hi-index 0.00

Visualization

Abstract

Given the complexity of many queries over a Data Warehouse (DW), it is interesting to precompute and store in the DW the answer sets of some demanding operations, so called materialized views. In this paper, we present an algorithm, including its experimental evaluation, which allows the materialization of several views simultaneously without losing sight of processing costs for queries using these materialized views.