Welcome to the InfoSci Platform
Reference Hub7
Managing Late Measurements in Data Warehouses

Managing Late Measurements in Data Warehouses

Matteo Golfarelli, Stefano Rizzi
Copyright: © 2007 |Volume: 3 |Issue: 4 |Pages: 17
ISSN: 1548-3924|EISSN: 1548-3932|ISSN: 1548-3924|EISBN13: 9781615202065|EISSN: 1548-3924|DOI: 10.4018/jdwm.2007100103
Cite Article Cite Article

MLA

Golfarelli, Matteo, and Stefano Rizzi. "Managing Late Measurements in Data Warehouses." IJDWM vol.3, no.4 2007: pp.51-67. http://doi.org/10.4018/jdwm.2007100103

APA

Golfarelli, M. & Rizzi, S. (2007). Managing Late Measurements in Data Warehouses. International Journal of Data Warehousing and Mining (IJDWM), 3(4), 51-67. http://doi.org/10.4018/jdwm.2007100103

Chicago

Golfarelli, Matteo, and Stefano Rizzi. "Managing Late Measurements in Data Warehouses," International Journal of Data Warehousing and Mining (IJDWM) 3, no.4: 51-67. http://doi.org/10.4018/jdwm.2007100103

Export Reference

Mendeley
Favorite Full-Issue Download

Abstract

Though in most data warehousing applications no relevance is given to the time when events are recorded, some domains call for a different behavior. In particular, whenever late measurements of events take place, and particularly when the events registered are subject to further updates, the traditional design solutions fail in preserving accountability and query consistency. In this article, we discuss the alternative design solutions that can be adopted, in presence of late measurements, to support different types of queries that enable meaningful historical analysis. These solutions are based on the enforcement of the distinction between transaction time and valid time within the schema that represents the fact of interest. Besides, we provide a qualitative and quantitative comparison of the solutions proposed, aimed at enabling wellinformed design decisions.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.