INCLUSION OF TIME-VARYING MEASURES IN TEMPORAL DATA WAREHOUSES

Elzbieta Malinowski, E. Zimányi

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.

References

  1. Bettini, C., Jajodia, S., and Wang, X. (2000). Time Granularities in Databases, Data Mining, and Temporal Reasoning. Springer.
  2. Body, M., Miquel, M., Bédard, Y., and Tchounikine, A. (2003). Handling evolution in multidimensional structures. In Proc. of the 19th Int. Conf. on Data Engineering, pages 581-592.
  3. Bruckner, R. and Tjoa, A. (2002). Capturing delays and valid times in data warehouses - towards timely consistent analyses. Journal of Intelligent Information Systems, 19(2):169-190.
  4. Dyrsen, C. (1994). Valid-Time Indeterminacy. PhD thesis, University of Arizona.
  5. Eder, J., Koncilia, C., and Morzy, T. (2002). The COMET metamodel for temporal data warehouses. In Proc. of the 14th Int. Conf. on Advanced Information Systems Engineering, pages 83-99.
  6. Jarke, M., Lenzerini, M., Y.Vassiluiou, and Vassiliadis, P., editors (2003). Fundamentals of Data Warehouse. Springer.
  7. Koncilia, C. (2003). A bi-temporal data warehouse model. In Proc. of Short Papers of the 15th Int. Conf. on Advanced Information Systems Engineering, pages 77- 80.
  8. Lenz, H. and Shoshani, A. (1997). Summarizability in OLAP and statistical databases. In Proc. of the 9th Int. Conf. on Scientific and Statistical Database Management, pages 132-143.
  9. Malinowski, E. and Zimányi, E. (2005). Hierarchies in a multidimensional model: from conceptual modeling to logical representation. Accepted for publication in Data & Knowledge Engineering.
  10. Malinowski, E. and Zimányi, E. (2006). A conceptual solution for representing time in data warehouse dimensions. In Proc. of the 3rd Asia-Pacific Conf. on Conceptual Modelling. Accepted.
  11. Martín, C. and Abelló, A. (2003). A temporal study of data sources to load a corporate data warehouse. In Proc. of the 5th Int. Conf. on Data Warehousing and Knowledge Discovery, pages 109-118.
  12. Mendelzon, A. and Vaisman, A. (2003). Time in multidimensional databases. In Rafanelli, M., editor, Multidimensional Databases: Problems and Solutions, pages 166-199. Idea Group Publishing.
  13. Merlo, I., Bertino, E., Ferrari, E., and Guerrini, G. (1999). A temporal object-oriented data model with multiple granularities. In 6th Int. Workshop on Temporal Representation and Reasoning, pages 73-81.
  14. Yang, J. and Widom, J. (1998). Mantaining temporal views over non-temporal information source for data warehousing. In Proc. of the 6th Int. Conf. on Extending Database Technology, pages 389-403.
Download


Paper Citation


in Harvard Style

Malinowski E. and Zimányi E. (2006). INCLUSION OF TIME-VARYING MEASURES IN TEMPORAL DATA WAREHOUSES . In Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-972-8865-41-2, pages 181-186. DOI: 10.5220/0002454301810186


in Bibtex Style

@conference{iceis06,
author={Elzbieta Malinowski and E. Zimányi},
title={INCLUSION OF TIME-VARYING MEASURES IN TEMPORAL DATA WAREHOUSES},
booktitle={Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2006},
pages={181-186},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002454301810186},
isbn={978-972-8865-41-2},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - INCLUSION OF TIME-VARYING MEASURES IN TEMPORAL DATA WAREHOUSES
SN - 978-972-8865-41-2
AU - Malinowski E.
AU - Zimányi E.
PY - 2006
SP - 181
EP - 186
DO - 10.5220/0002454301810186