Managing Late Measurements in Data Warehouses

View Sample PDF

Author(s): Matteo Golfarelli (University of Bologna, Italy)and Stefano Rizzi (University of Bologna, Italy)
Copyright: 2008
Pages: 17
Source title: Data Warehousing and Mining: Concepts, Methodologies, Tools, and Applications
Source Author(s)/Editor(s): John Wang (Montclair State University, USA)
DOI: 10.4018/978-1-59904-951-9.ch047

Keywords: Data Mining and Databases / Data Warehousing / Information Science Reference / Library & Information Science

Purchase

View Managing Late Measurements in Data Warehouses on the publisher's website for pricing and purchasing information.

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.

The IRMA Community

Research IRM

Managing Late Measurements in Data Warehouses

Purchase

Abstract

Related Content

IRMA Sponsors