Materialized view selection using genetic algorithms in a data warehouse system

Jorng Tzong Horng; Yu Jan Chang; Baw Jhiune Liu; Cheng Yan Kao

doi:10.1109/CEC.1999.785551

Materialized view selection using genetic algorithms in a data warehouse system

Jorng Tzong Horng, Yu Jan Chang, Baw Jhiune Liu, Cheng Yan Kao

Department of Computer Science and Information Engineering

Research output: Contribution to conference › Paper › peer-review

57 Scopus citations

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.

Original language	English
Pages	2221-2227
Number of pages	7
DOIs	https://doi.org/10.1109/CEC.1999.785551
State	Published - 1999
Event	1999 Congress on Evolutionary Computation, CEC 1999 - Washington, DC, United States Duration: 6 Jul 1999 → 9 Jul 1999

Conference

Conference	1999 Congress on Evolutionary Computation, CEC 1999
Country/Territory	United States
City	Washington, DC
Period	6/07/99 → 9/07/99

Access to Document

10.1109/CEC.1999.785551

Cite this

@conference{eaaaf5a388e844b4a4c053f467ca31e3,

title = "Materialized view selection using genetic algorithms in a data warehouse system",

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.",

author = "Horng, {Jorng Tzong} and Chang, {Yu Jan} and Liu, {Baw Jhiune} and Kao, {Cheng Yan}",

year = "1999",

doi = "10.1109/CEC.1999.785551",

language = "???core.languages.en_GB???",

pages = "2221--2227",

note = "1999 Congress on Evolutionary Computation, CEC 1999 ; Conference date: 06-07-1999 Through 09-07-1999",

}

TY - CONF

T1 - Materialized view selection using genetic algorithms in a data warehouse system

AU - Horng, Jorng Tzong

AU - Chang, Yu Jan

AU - Liu, Baw Jhiune

AU - Kao, Cheng Yan

PY - 1999

Y1 - 1999

N2 - 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.

AB - 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.

UR - http://www.scopus.com/inward/record.url?scp=46749098678&partnerID=8YFLogxK

U2 - 10.1109/CEC.1999.785551

DO - 10.1109/CEC.1999.785551

M3 - 會議論文

AN - SCOPUS:46749098678

SP - 2221

EP - 2227

T2 - 1999 Congress on Evolutionary Computation, CEC 1999

Y2 - 6 July 1999 through 9 July 1999

ER -

Materialized view selection using genetic algorithms in a data warehouse system

Abstract

Conference

Access to Document

Fingerprint

Cite this