Mod\'elisation et manipulation de donn\'ees historis\'ees et archiv\'ees dans un entrep\^ot orient\'e objet

TL;DR

This paper introduces a new object-oriented data warehouse model that captures complex temporal data and provides a specialized query algebra with temporal and analytical operators.

Contribution

It presents a novel data model for temporal and archive data in object-oriented warehouses and a dedicated query algebra with temporal and transformation operators.

Findings

Defines a warehouse object with current, past, and archive states

Develops a query algebra with temporal and analytical operators

Provides methods for transforming warehouse objects into temporal series

Abstract

This paper deals with temporal and archive object-oriented data warehouse modelling and querying. In a first step, we define a data model describing warehouses as central repositories of complex and temporal data extracted from one information source. The model is based on the concepts of warehouse object and environment. A warehouse object is composed of one current state, several past states (modelling value changes) and several archive states (summarising some value changes). An environment defines temporal parts in a warehouse schema according to a relevant granularity (attribute, class or graph). In a second step, we provide a query algebra dedicated to data warehouses. This algebra, which is based on common object algebras, integrates temporal operators and operators for querying object states. An other important contribution concerns dedicated operators allowing users to transform warehouse objects in temporal series as well as operators facilitating analytical treatments.