Authors:
Elzbieta Malinowski
and
E. Zimányi
Affiliation:
Université Libre de Bruxelles, Belgium
Keyword(s):
Temporal data warehouses, time-varying measures, data warehouse design.
Related
Ontology
Subjects/Areas/Topics:
Data Warehouses and OLAP
;
Databases and Information Systems Integration
;
Deductive, Active, Temporal and Real-Time Databases
;
Enterprise Information Systems
Abstract:
Data Warehouses (DWs) integrate data from different source systems that may have temporal support. However, current DWs only allow to track changes for measures indicating the time when a specific measure value is valid. In this way, applications such as fraud detection cannot be easily implemented since they require to know the time when changes in source systems have occurred. In this work, based on the research related to Temporal Databases, we propose the inclusion of time-varying measures changing the current role of the time dimension. First, we refer to different temporal types that are allowed in our model. Then, we study different scenarios that show the usefulness of inclusion of different temporal types. Further, since measures can be aggregated before being inserted into DWs, we discuss the issues related to different time granularities between source systems and DWs and to measure aggregations.