CoDE Publications CoDE Publications
IRIDIA Publications IRIDIA Publications
SMG Publications
WIT Publications
WIT Publications
SMG Publications
Home People Research Activities Publications Teaching Resources
By Class By Topic By Year
By Class By Topic By Year
login
E. Malinowski and E. Zimányi. A Conceptual Solution for Representing Time in Data Warehouse Dimensions. Australian Computer Science Communications, 28(6):45-54, January 2006. Proceedings of the 3rd Asia-Pacific Conference on Conceptual Modelling, APCCM 2006.
© James Cook University 2006

Abstract

Data Warehouses (DWs) use an omnipresent time dimension for keeping track of changes in measure values. However, this dimension cannot be used to model changes in other dimensions. On the other hand, Temporal Databases (TDBs) have been successfully used for modelling time-varying information. Bringing together these two research areas, leading to Temporal Data Warehouses (TDWs), provides the necessary solutions for managing time-varying data in dimensions. In this paper, we introduce temporal extensions for the MultiDimER model, a conceptual multidimensional model. In our model we allow the inclusion of valid and transaction time, which are obtained from source systems, in addition to the data warehouse loading time. Our model allows a conceptual representation of time-varying levels, attributes, and hierarchies. For the latter, we discuss different cases depending on whether the changes in levels affect the relationships between them.


Updated: 2017-03-27