Materialized view selection using genetic algorithms in a data warehouse system
Jorng‐Tzong Horng, Yu-Jan Chang, Baw‐Jhiune Liu, Cheng‐Yan Kao
Abstract
Jorng‐Tzong Horng, Yu-Jan Chang, Baw‐Jhiune Liu, Cheng‐Yan Kao
Abstract
A data warehouse stores lots of materialized views to provide efficient decision-support or OLAP queries. The view-selection problem addresses the selection of a fittest set of materialized views under the limitation of storage space forms a challenge in data warehouse research. In this paper, we present genetic algorithms to choose materialized views. We also use experiments to demonstrate the power of our approach.
OpenAlex reports 58 citations for this work. Citation counts describe recorded attention and do not establish research quality.
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 lots of materialized views to provide efficient decision-support or OLAP queries. The view-selection problem addresses the selection of a fittest set of materialized views under the limitation of storage space forms a challenge in data warehouse research. In this paper, we present genetic algorithms to choose materialized views. We also use experiments to demonstrate the power of our approach.
Key concepts: Materialized view, Data warehouse, Online analytical processing, Computer science, Selection (genetic algorithm), Genetic algorithm, Set (abstract data type), Data mining