Jorng-Tzong Horng, Yu-Jan Chang, Baw-Jhiune Liu, Cheng-Yan Kao
{"title":"Materialized view selection using genetic algorithms in a data warehouse system","authors":"Jorng-Tzong Horng, Yu-Jan Chang, Baw-Jhiune Liu, Cheng-Yan Kao","doi":"10.1109/CEC.1999.785551","DOIUrl":null,"url":null,"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.","PeriodicalId":292523,"journal":{"name":"Proceedings of the 1999 Congress on Evolutionary Computation-CEC99 (Cat. No. 99TH8406)","volume":"34 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"1999-07-06","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"78","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"Proceedings of the 1999 Congress on Evolutionary Computation-CEC99 (Cat. No. 99TH8406)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/CEC.1999.785551","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 78
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.