RELATIONSHIPS BETWEEN ATTRIBUTES TO INTEGRATE HETEROGENEOUS DATA SOURCES: AN SQL METHODOLOGY

摘要

In this paper we present our manner to build a data warehouse using heterogeneous data sources. Nowadays, information systems are constructed thanks to the use of internal data within an organization and also some of the numerous data sources available on the web. Thus, the challenge is to integrate all these kinds of data which may be heterogeneous. Our work is to present a methodology to construct a set of views (a data warehouse) based on the extraction of the inter-schema relationships between sources. We define three types of relationships between attributes: the synonymy, the inclusion and the disjunction. To illustrate these relationships we consider two relational and/or object-relational databases. All the different stages proposed in this work are implemented by the use of a functional prototype.