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.
- 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.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; 2014. p. 23–34.Google Scholar
- 3.Böhlen M, Gamper J, Jensen C. Towards general temporal aggregation. In: Proceedings of the 25th British National Conference on Databases; 2008. p. 257–69.Google Scholar
- 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.Kimball R, Ross M. The data warehouse toolkit: the complete guide to dimensional modeling. 3rd ed. Hoboken: Wiley; 2013.Google Scholar
- 14.Snodgrass R. Developing time-oriented database applications in SQL. San Francisco: Morgan Kaufmann; 2000.Google Scholar
- 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