Title :
Representing temporal data in non-temporal OLAP systems
Author :
J. Eder;C. Koncilia
Author_Institution :
Dep. of Informatics-Syst., Klagenfurt Univ., Austria
fDate :
6/24/1905 12:00:00 AM
Abstract :
Multidimensional data warehouses and OLAP systems do not provide adequate means for dealing with changes in dimension data, changes appearing frequently in dynamic application areas such as current business systems. As data warehouses and OLAP tools serve as decision support systems they have to reflect such changes. Temporal data warehouses propose sophisticated modelling tools for covering any changes in dimension data but cannot be used with current OLAP systems. In this paper we show some techniques to incorporate temporal dimension data into multidimensional OLAP systems. In particular we show how to superimpose conventional multidimensional data warehouses with temporal master data, enabling queries to span multiple periods and to return correct answers.
Keywords :
"Data warehouses","Multidimensional systems","Diseases","Geography","Decision support systems","Database systems","Aggregates","Cities and towns","Neoplasms","Diabetes"
Conference_Titel :
Database and Expert Systems Applications, 2002. Proceedings. 13th International Workshop on
Print_ISBN :
0-7695-1668-8
DOI :
10.1109/DEXA.2002.1045998