A Data Warehouse is defined as a time variant set of non-volatile data. This can be easily related to temporal database concepts (i.e. a database supporting Valid Time and Transaction Time is known as a bitemporal database). In this paper we analyze and compare the performance of four different bitemporal storage structures (i.e. Backlog based, Tuple timestamped, and Attribute timestamped against Current/Historical which consists of a Current table that reflects current data and a set of Historical tables that show the historical evolution of the data) in a data warehousing environment. From this analysis, we conclude that the Current/Historical structure is more suited than the others for such environment.
CitationMartín, C., Montero, O., Surroca, C. "Current/historical: An efficient bitemporal storage structure for data warehousing". 2005.
All rights reserved. This work is protected by the corresponding intellectual and industrial property rights. Without prejudice to any existing legal exemptions, reproduction, distribution, public communication or transformation of this work are prohibited without permission of the copyright holder. If you wish to make any use of the work not provided for in the law, please contact: email@example.com