Back to first pageBack to first page Centre for Artificial Intelligence of UNL
Browse our site
You are here:

Publication details

Go back
Publication details
Main information
Using perspective schema and a reference model to design the ETL process
March 2011
Pequeno2011
For many years the database community has been wrestling with the problem of data integration. In short, this problem consists of combining data from different information sources, and providing the user with a unified view of these data. In dealing with the integration problem, the designer usually encounters incompatible data models, characterised by differences in structure and semantics. In this work, we propose a declarative approach based on the creation of a reference model and perspective schemata in order to make the relationship between schemata explicit. The reference model serves as a common semantic meta-model, while perspective schemata defines correspondence between schemata using correspondence assertions. Based on the proposed architecture, an inference mechanism was developed to allow the (semi-) automatic derivation of new mappings from previous ones. A Prolog-based proof-of-concept was implemented in order to demonstrate the feasibility of the proposed approach.
Ph. D. dissertation
Valéria Magalhães Pequeno
João Moura Pires
Universidade Nova de Lisboa
-
-
Publication files
- click here to download - pdf 2089 KB
Export formats
Valéria Magalhães Pequeno, Using perspective schema and a reference model to design the ETL process, João Moura Pires (superv.), Universidade Nova de Lisboa, March 2011.
<b><a href="/people/members/view.php?code=5a9fb983052d415072a984ee2a21e033" class="author">Valéria Magalhães Pequeno</a></b>, <u>Using perspective schema and a reference model to design the ETL process</u>, <a href="/people/members/view.php?code=542b14e1830dcf7566974fd36b6fccc7" class="supervisor">João Moura Pires</a> (superv.), Universidade Nova de Lisboa, March 2011.
@phdthesis {Pequeno2011, author = {Val{\'e}ria Magalh{\~a}es Pequeno}, title = {Using perspective schema and a reference model to design the ETL process}, school = {Universidade Nova de Lisboa}, note = {Jo{\~a}o Moura Pires (superv.); }, abstract = {For many years the database community has been wrestling with the problem of data integration. In short, this problem consists of combining data from different information sources, and providing the user with a unified view of these data. In dealing with the integration problem, the designer usually encounters incompatible data models, characterised by differences in structure and semantics. In this work, we propose a declarative approach based on the creation of a reference model and perspective schemata in order to make the relationship between schemata explicit. The reference model serves as a common semantic meta-model, while perspective schemata defines correspondence between schemata using correspondence assertions. Based on the proposed architecture, an inference mechanism was developed to allow the (semi-) automatic derivation of new mappings from previous ones. A Prolog-based proof-of-concept was implemented in order to demonstrate the feasibility of the proposed approach.}, keywords = {data integration, schema mapping, conceptual modelling, ETL process}, month = {March}, year = {2011}, }
Publication's urls
/publications/view.php?code=8f9d7c32d88b5648c3ed87c7281c72a9
/publications/view.php?code=Pequeno2011
Go back
Centre for Artificial Intelligence of UNL
Departamento de Informática, FCT/UNL
Quinta da Torre 2829-516 CAPARICA - Portugal
Tel. (+351) 21 294 8536 FAX (+351) 21 294 8541

Fundacao_FCT