Selection of Materialized View in Data Warehouse
Zuping Zhang
Abstract
Zuping Zhang
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.
A significance statement is not available in the OpenAlex record.
A contribution statement is not available in the OpenAlex record.
Method details are not available in the OpenAlex metadata.
Findings are not separately available in the OpenAlex metadata.
Limitations are not available in the OpenAlex metadata.
Application details are not available in the OpenAlex metadata.
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)