loading
Papers Papers/2022 Papers Papers/2022

Research.Publish.Connect.

Paper

Paper Unlock

Authors: Valéria Pequeno 1 and Helena Galhardas 2

Affiliations: 1 INESC-ID, Portugal ; 2 Instituto Superior Técnico and INESC-ID, Portugal

Keyword(s): Schema Matching, Correspondence Assertions, Data Integration, Relational Model.

Related Ontology Subjects/Areas/Topics: Coupling and Integrating Heterogeneous Data Sources ; Databases and Information Systems Integration ; Enterprise Information Systems

Abstract: When dealing with the data integration problem, the designer usually encounters incompatible data models characterized by differences in structure and semantics, even in the context of the same organization. In this work, we propose a declarative and formal approach to specify 1-to-1, 1-m, and m-to-n correspondences between relational schema components. Differently from usual correspondences, our Correspondence Asser- tions (CAs) have semantics and can deal with joins, outer-joins, and data-metadata relationships. Finally, we demonstrate how we can generate mapping expressions in the form of SQL queries from CAs.

CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 54.242.22.247

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
Pequeno, V. and Galhardas, H. (2014). Specifying Complex Correspondences Between Relational Schemas in a Data Integration Environment. In Proceedings of the 16th International Conference on Enterprise Information Systems - Volume 3: ICEIS; ISBN 978-989-758-027-7; ISSN 2184-4992, SciTePress, pages 18-29. DOI: 10.5220/0004870200180029

@conference{iceis14,
author={Valéria Pequeno. and Helena Galhardas.},
title={Specifying Complex Correspondences Between Relational Schemas in a Data Integration Environment},
booktitle={Proceedings of the 16th International Conference on Enterprise Information Systems - Volume 3: ICEIS},
year={2014},
pages={18-29},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0004870200180029},
isbn={978-989-758-027-7},
issn={2184-4992},
}

TY - CONF

JO - Proceedings of the 16th International Conference on Enterprise Information Systems - Volume 3: ICEIS
TI - Specifying Complex Correspondences Between Relational Schemas in a Data Integration Environment
SN - 978-989-758-027-7
IS - 2184-4992
AU - Pequeno, V.
AU - Galhardas, H.
PY - 2014
SP - 18
EP - 29
DO - 10.5220/0004870200180029
PB - SciTePress