Encyclopedia of Database Systems

Living Edition
| Editors: Ling Liu, M. Tamer Özsu

Temporal Datawarehousing

Living reference work entry
DOI: https://doi.org/10.1007/978-1-4899-7993-3_80809-1

Definition

A data warehouse (DW) collects large amounts of data from various data sources and transforms them to a form that can be used to analyze the behavior of an organization. DWs are based on the multidimensional model, which represents data as facts that can be analyzed along a collection of dimensions, composed of levels conforming aggregation hierarchies. The basic multidimensional model assumes that only facts evolve in time and this is materialized by the link(s) of the facts with the time dimension. However, dimension data may also vary across time, for instance, a product may change its price or its category. Furthermore, a measure itself can change its value, for instance, a client may request a change in the quantity of products of an order she previously placed. Temporal databases provide mechanisms for managing information that varies over time. The use of these mechanisms to provide built-in temporal semantics to DWs leads to the concept of temporal data warehouses.

Hi...

This is a preview of subscription content, log in to check access.

Recommended Reading

  1. 1.
    Ahmed W, Zimányi E, Wrembel R. Temporal data warehouses: logical models and querying. In: Proceedings of the Journées francophones sur les Entrepôts de Données et l’Analyse en ligne, EDA. Editions Hermann; 2015. p. 33–48.Google Scholar
  2. 2.
    Ahmed W, Zimányi E, Wrembel R. A logical model for multiversion data warehouses. In: Proceedings of the 16th International Conference on Data Warehousing and Knowledge Discovery, DaWaK’14. Lecture Notes in Computer Science 8646. Berlin/New York: Springer; 2014. p. 23–34.Google Scholar
  3. 3.
    Böhlen M, Gamper J, Jensen C. Towards general temporal aggregation. In: Proceedings of the 25th British National Conference on Databases, BNCOD 2008. Lecture Notes in Computer Science 5071. Berlin/New York: Springer; 2008. p. 257–69.Google Scholar
  4. 4.
    Bruckner R, Min Tjoa A. Capturing delays and valid times in data warehouses: towards timely consistent analyses. J Intell Inf Syst. 2002;19(2):169–90.CrossRefGoogle Scholar
  5. 5.
    Golfarelli M, Lechtenbörger J, Rizzi S, Vossen G. Schema versioning in data warehouses: enabling cross-version querying via schema augmentation. Data Knowl Eng. 2006;59:435–59.CrossRefGoogle Scholar
  6. 6.
    Golfarelli M, Rizzi S. Managing late measurements in data warehouses. Int J Data Wareh Min. 2007;3(4):51–67.CrossRefGoogle Scholar
  7. 7.
    Golfarelli M, Rizzi S. A survey on temporal data warehousing. Int J Data Wareh Min. 2009;5(1):1–17.CrossRefGoogle Scholar
  8. 8.
    Johnston T, Weis R. Managing time in relational databases: how to design, update and query temporal data. Burlington: Morgan Kaufmann; 2010.Google Scholar
  9. 9.
    Kimball R, Ross M. The data warehouse toolkit: the complete guide to dimensional modeling. 3rd ed. Hoboken: Wiley; 2013.Google Scholar
  10. 10.
    Kulkarni K, Michels J-E. Temporal features in SQL:2011. SIGMOD Rec. 2012;41(3):34–43.CrossRefGoogle Scholar
  11. 11.
    Malinowski E, Zimányi E. Advanced data warehouse design: from conventional to spatial and temporal applications. Berlin/Heidelberg: Springer; 2008.MATHGoogle Scholar
  12. 12.
    Mendelzon A, Vaisman A. Time in multidimensional databases. In: Rafanelli M, editor. Multidimensional databases: problems and solutions. Hershey: Idea Group; 2003. p. 166–99.CrossRefGoogle Scholar
  13. 13.
    Snodgrass R, editor. The TSQL2 temporal query language. Boston/London: Kluwer Academic; 1995.MATHGoogle Scholar
  14. 14.
    Snodgrass R. Developing time-oriented database applications in SQL. San Francisco: Morgan Kaufmann; 2000.Google Scholar
  15. 15.
    Tansel AU, Clifford J, Gadia S, Jajodia S, Segev A, Snodgrass RT, editors. Temporal databases: theory, design, and implementation. Redwood City: Benjamin-Cummings; 1993.Google Scholar

Copyright information

© Springer Science+Business Media LLC 2017

Authors and Affiliations

  1. 1.Instituto Tecnológico de Buenos AiresBuenos AiresArgentina
  2. 2.CoDEUniversité Libre de BruxellesBrusselsBelgium