Maintaining temporal warehouse models

Abstract

DWT is a tool for the maintenance of data warehouse structures based on the temporal data warehouse model COMET. Data warehouse systems do not provide support for maintaining changes in dimension data. DWT allows keeping track of modifications made in the dimension-structure of multidimensional cubes stored in an OLAP (On-Line Analytical Processing) system. We present the overall structure of the DWT system, which allows to upload and download warehouse models in different modeling notations in a time conscious manner, load edit scripts describing changes between versions of warehouse models and apply these edit scripts. We present the workflows for maintenance of warehouse models and discuss how maintenance can be supported with the various integrated tools of DWT.