2004Computing Technology and AutomationRequires access

Selection of Materialized View in Data Warehouse

Zuping Zhang

Open publisher page 0 citations

Abstract

A data warehouse stores large amounts of materialized views to accelerate OLAP queries. The selection of materialized view is an important decision in designing data warehouse. The paper presents an efficient algorithm for materialized views selection based on searching view in the layer of data cube. The analysis and experimental study show that the algorithm has better solution and high efficiency.

About this research paper

What this paper is about

A data warehouse stores large amounts of materialized views to accelerate OLAP queries. The selection of materialized view is an important decision in designing data warehouse. The paper presents an efficient algorithm for materialized views selection based on searching view in the layer of data cube. The analysis and experimental study show that the algorithm has better solution and high efficiency.

Why it matters

A significance statement is not available in the OpenAlex record.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

A data warehouse stores large amounts of materialized views to accelerate OLAP queries. The selection of materialized view is an important decision in designing data warehouse. The paper presents an efficient algorithm for materialized views selection based on searching view in the layer of data cube. The analysis and experimental study show that the algorithm has better solution and high efficiency.

Key concepts: Materialized view, Data warehouse, Online analytical processing, Computer science, Selection (genetic algorithm), Data cube, Database, Cube (algebra)

Related papers

Back to paper searchBrowse research topicsOriginal source
Selection of Materialized View in Data Warehouse — Research Paper | ScholarLens