Business Intelligence

Cost Effective Approach for Materialized Views Selection in Data Warehousing Environment

Download Now Free registration required

Executive Summary

A data warehouse uses multiple materialized views to efficiently process a given set of queries. The materialization of all views is not possible because of the space constraint and maintenance cost constraint. Materialized views selection is one of the crucial decisions in designing a data warehouse for optimal efficiency. Selecting a suitable set of views that minimizes the total cost associated with the materialized views is the key objective of data warehousing. In this paper, the authors present a framework for selecting views to materialize so as to achieve the best combination of good query response, low query processing cost and low view maintenance cost in a given storage space constraints.

  • Format: PDF
  • Size: 160 KB