Year: 2009
Type: Proceeding article
Title: Dynamic Evolution and Improvement of Data Warehouse Design
Author: Sahpaski, Dragan
Author: Velinov, Goran
Author: Jakimovski, Boro
Author: Kon-popovska, Margita
Abstract: Frequently changing business requirements result not only in changesto the data warehouse (DW) workload but also in changes to the schemastructure. These schema changes introduce new DW versions and so theproblem of optimization of all of its versions becomes a very challengingone.In this paper we present a new approach for dynamically evolving thedesign of the implementation schema spanning across its multiple versions.A new derivation procedure for self improvement of the design andthe performance of the model is applied in several steps. We alsodefine a system for optimization of the design of the multiversionDW schema and its particular instances and include other factors relevantfor optimization of the system i.e. view selection, vertical viewfragmentation and index selection. The self improvement of the multiversionschema design is shown by performing large set of experiments.
Publisher: IEEE
Relation: Fourth Balkan Conference in Informatics
Identifier: oai:repository.ukim.mk:20.500.12188/284
Identifier: http://hdl.handle.net/20.500.12188/284Identifier: 10.1109/bci.2009.34
Identifier: http://xplorestaging.ieee.org/ielx5/5358991/5358992/05359313.pdf?arnumber=5359313Identifier: 107
Identifier: 112
