The Community for Technology Leaders
Informatics, Balkan Conference in (2009)
Thessaloniki, Greece
Sept. 17, 2009 to Sept. 19, 2009
ISBN: 978-0-7695-3783-2
pp: 107-112
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.
INDEX TERMS
Data Warehouse Versioning, Genetic Algorithms, Optimization
CITATION

G. Velinov, D. Sahpaski, B. Jakimovski and M. Kon-Popovska, "Dynamic Evolution and Improvement of Data Warehouse Design," Informatics, Balkan Conference in(BCI), Thessaloniki, Greece, 2009, pp. 107-112.
doi:10.1109/BCI.2009.34
79 ms
(Ver 3.3 (11022016))