Materialized View Selection in the Data Warehouse

Abstract:

Article Preview

A data warehouse stores materialized views of data from one or more sources, with the purpose of efficiently implementing decision-support or OLAP queries. Materialized view selection is one of the crucial decisions in designing a data warehouse for optimal efficiency. The goal is to select an appropriate set of views that minimizes sum of the query response time and the cost of maintaining the selected views, given a limited amount of resource, e.g., materialization time, storage space, etc. In this article, we present an improved PGA algorithm to accomplish the view selection problem; the experiments show that our proposed algorithm shows it’s superior.

Info:

Periodical:

Edited by:

Honghua Tan

Pages:

1133-1138

DOI:

10.4028/www.scientific.net/AMM.29-32.1133

Citation:

L. J. Zhou et al., "Materialized View Selection in the Data Warehouse", Applied Mechanics and Materials, Vols. 29-32, pp. 1133-1138, 2010

Online since:

August 2010

Export:

Price:

$35.00

In order to see related information, you need to Login.

In order to see related information, you need to Login.