Research on Materialized View Selection in the Data Warehouse

Abstract:

Article Preview

Materialized view is an effective method for improving the efficiency of queries in data warehouse system, and the problem of materialized view selection is one of the most important decisions. In this paper, an algorithm was proposed to select a set of materialized views under maintenance cost constraints for the purpose of minimizing the total query processing cost; the algorithm adopts the dynamic penalty function to solve the resource constraints view selection. The experimental study shows that the algorithm has better solutions and high efficiency.

Info:

Periodical:

Edited by:

Qi Luo

Pages:

361-366

DOI:

10.4028/www.scientific.net/AMM.55-57.361

Citation:

L. J. Zhou et al., "Research on Materialized View Selection in the Data Warehouse", Applied Mechanics and Materials, Vols. 55-57, pp. 361-366, 2011

Online since:

May 2011

Export:

Price:

$35.00

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

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