Construction and Maintenance of Heterogeneous Data Warehouses - Data Warehousing Design and Advanced Engineering Applications - page 203

An heterogeneous data integration tool (HDIM
prototype) and procedures of incremental main-
tenance are under development. We plan now to
compare our measure on different DBMS (Oracle,
DB2 and SqlServer) (see Figure 9).

A,NULL,V_PRIM.A, (V_PRIM.S + V.S)/
(V_PRIM.C + V.C))) as A
FROM V FULL OUTER JOIN V_prim ON
V.y10=V_prim.y10 ORDER BY 1;

CONCLUSION REFERENCES

Badri, M. (2008). Maintenance des entrepôts de
données issus de sources hétérogènes . PhD thesis,
University Paris Descartes.

In this work, we propose a formal framework
which treats integration of heterogeneous data
sources from various categories. This approach
is based on the definition of an integration envi-
ronment . This last is seen as a set of data sources
associated with a set of “ integration relationships ”
between the sources components.
The originality of our work, contrary to various
works on integration, lies in the fact of covering
the integration of all the categories of data con-
sidered at the same time and in the proposition
of a theoretical approach of the data integration.
Our approach is general and is applicable to any
type of integration. For instance, it is possible to
duplicate databases or to create several versions
of one or many databases at the same time. We
propose to implement a heterogeneous DW in two
possible physical architectures.We give method
to rewrite computing aggregates functions for
incremental maintenance of MV.

Badri, M., Boufarès, F., Ducateau, C. F., &
Gargouri, F. (2005). Etat de l'art de la mainte-
nance des entrepôts de données issus des systèmes
d'information hétérogènes. Cinquièmes Journées
Scientifiques GEI (pp. 13-18).

Badri, M., Boufarès, F., Ducateau, C. F., &
Nefoussi, R. (2006). Maintenance des vues ma-
térialisées hétérogènes sous oracle. In Workshop
SID Systèmes d'Information Décisionnels . IN-
FORSID , 2006 , 8-14.

Badri, M., Boufarès, F., & Heiwy, V. (2007). Des
critères pour choisir l'architecture physique d'un
entrepôt de données hétérogènes. In Workshop
ASD Atelier des systèmes décisionnels.

Figure 9. Comparison performance between HDIM MV maintenance and Oracle MV refreshing