Skip to Main content Skip to Navigation
Master Thesis

XeuTL : un outil ETL pour l'intégration de données

Abstract : Since Business companies have adopted databases, they have to deal with huge volumes of data. This data is often spread across heterogeneous systems. Integrating this data is necessary in order to exploit it in an efficient way. Semantic heterogeneity is The main issue in data integration . Two approaches exist to resolve this heterogeneity: - the virtual approach: the user sends his requests to a mediator in charge of transforming and translating a request in order to query the data sources; The data is only stored into the data sources. - The materialized approach: the user sends his query to a target database. This database contains a copy of the integrated data of the data sources. This paper presents the making of XeuTL, an ETL tool essential to the materialized approach. XeuTL extracts data from data sources, transforms this data and loads it into a target database. The user defines some mapping rules between the data sources physical schemas and that of the target database, thus resolving semantic heterogeneity.
Document type :
Master Thesis
Complete list of metadata

Cited literature [23 references]  Display  Hide  Download

https://dumas.ccsd.cnrs.fr/dumas-00523431
Contributor : Cnam - Service Commun De La Documentation - Bibliothèque Centrale Connect in order to contact the contributor
Submitted on : Tuesday, October 5, 2010 - 11:37:44 AM
Last modification on : Monday, February 21, 2022 - 3:38:12 PM
Long-term archiving on: : Thursday, January 6, 2011 - 2:46:46 AM

Identifiers

  • HAL Id : dumas-00523431, version 1

Collections

Citation

Cédric Gueydan. XeuTL : un outil ETL pour l'intégration de données. Base de données [cs.DB]. 2010. ⟨dumas-00523431⟩

Share

Metrics

Record views

271

Files downloads

533