Maintaining Temporal Warehouse Models
Johann Eder, Christian Koncilia, Karl Wiggisser · 2007
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. These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.