Representing Temporal Data in Non-Temporal OLAP Systems

Representing Temporal Data in Non-Temporal OLAP Systems

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 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.

Grafik Top
Authors
  • Eder, Johann
  • Koncilia, Christian
Grafik Top
  • © IEEE Computer Society Press (<a href='http://doi.ieeecomputersociety.org/10.1109/DEXA.2002.1045998'>WWW</a>)
Grafik Top
Shortfacts
Category
Paper in Conference Proceedings or in Workshop Proceedings
Event Title
13th International Workshop on Database and Expert Systems Applications (DEXA 2002)
Divisions
Workflow Systems and Technology
Event Location
Aix-en-Provence, France
Event Type
Conference
Event Dates
2002-08-02
Publisher
IEEE Computer Society
Page Range
pp. 817-821
Date
September 2002
Official URL
http://www.pri.univie.ac.at/Publications/2002/Eder...
Export
Grafik Top