Past Indeterminacy in Data Warehouse Design

Traditional data warehouse design methods do not fully address some important challenges, particularly temporal ones. Among them past indeterminacy is not handled systematically and uniformly. Furthermore, most methods published until now present transformation approaches by providing examples rathe...

Full description

Saved in:
Bibliographic Details
Published inDatabase and Expert Systems Applications pp. 90 - 100
Main Authors Khnaisser, Christina, Lavoie, Luc, Burgun, Anita, Ethier, Jean-François
Format Book Chapter
LanguageEnglish
Published Cham Springer International Publishing
SeriesLecture Notes in Computer Science
Subjects
Data warehouse design
Missing information
Temporal data warehouse
Temporal indeterminacy
Online AccessGet full text

Cover

More Information
Summary:Traditional data warehouse design methods do not fully address some important challenges, particularly temporal ones. Among them past indeterminacy is not handled systematically and uniformly. Furthermore, most methods published until now present transformation approaches by providing examples rather than general and systematic transformation rules. As a result, real-world applications require manual adaptations and implementations. This hinders scalability, long-term maintenance and increases the risk of inconsistency in case of manual implementation. This article extends the Unified Bitemporal Historicization Framework with a set of specifications and a deterministic process that defines simple steps for transforming a non-historical database schema into a historical schema allowing data evolution and traceability, including past and future indeterminacy. The primary aim of this work is to help data warehouse designers to model historicized schema based on a sound theory ensuring a sound temporal semantic, data integrity and query expressiveness.
ISBN:331964470X
9783319644707
ISSN:0302-9743
1611-3349
DOI:10.1007/978-3-319-64471-4_9