Validation of schema mappings with nested queries

With the emergence of the Web and the wide use of XML for representing data, the ability to map not only flat relational but also nested data has become crucial. The design of schema mappings is a semi-automatic process. A human designer is needed to guide the process, choose among mapping candidate...

ver descrição completa

Detalhes bibliográficos
Autores: Rull Fort, Guillem, Farré Tost, Carles|||0000-0001-5814-3782, Teniente López, Ernest|||0000-0001-8890-9638, Urpí Tubella, Antoni|||0000-0002-5900-1492
Formato: informe técnico
Fecha de publicación:2012
País:España
Recursos:Universitat Politècnica de Catalunya (UPC)
Repositorio:UPCommons. Portal del coneixement obert de la UPC
Idioma:inglés
OAI Identifier:oai:upcommons.upc.edu:2117/16746
Acesso em linha:https://hdl.handle.net/2117/16746
Access Level:acceso abierto
Palavra-chave:Schema mapping
Nested relational model
Nested query
Query equality
Query inclusion
Validation
Àrees temàtiques de la UPC::Informàtica::Sistemes d'informació
id ES_6b2b91277a40ca02b3fbc230a9e47ff7
oai_identifier_str oai:upcommons.upc.edu:2117/16746
network_acronym_str ES
network_name_str España
repository_id_str
spelling Validation of schema mappings with nested queriesRull Fort, GuillemFarré Tost, Carles|||0000-0001-5814-3782Teniente López, Ernest|||0000-0001-8890-9638Urpí Tubella, Antoni|||0000-0002-5900-1492Schema mappingNested relational modelNested queryQuery equalityQuery inclusionValidationÀrees temàtiques de la UPC::Informàtica::Sistemes d'informacióWith the emergence of the Web and the wide use of XML for representing data, the ability to map not only flat relational but also nested data has become crucial. The design of schema mappings is a semi-automatic process. A human designer is needed to guide the process, choose among mapping candidates, and successively refine the mapping. The designer needs a way to figure out whether the mapping is what was intended. Our approach to mapping validation allows the designer to check whether the mapping satisfies certain desirable properties. In this paper, we focus on the validation of mappings between nested relational schemas, in which the mapping assertions are either inclusions or equalities of nested queries. We focus on the nested relational setting since most XML’s Document Type Definitions (DTDs) can be represented in this model. We perform the validation by reasoning on the schemas and mapping definition. We take into account the integrity constraints defined on both the source and target schema.20122012-10-1120122012-10-17reporthttp://purl.org/coar/resource_type/c_93fcAOhttp://purl.org/coar/version/c_b1a7d7d4d402bcceinfo:eu-repo/semantics/reportapplication/pdfhttps://hdl.handle.net/2117/16746reponame:UPCommons. Portal del coneixement obert de la UPCinstname:Universitat Politècnica de Catalunya (UPC)Inglésengopen accesshttp://purl.org/coar/access_right/c_abf2Attribution-NonCommercial-NoDerivs 3.0 Spainhttp://creativecommons.org/licenses/by-nc-nd/3.0/es/info:eu-repo/semantics/openAccessoai:upcommons.upc.edu:2117/167462026-05-27T15:37:01Z
dc.title.none.fl_str_mv Validation of schema mappings with nested queries
title Validation of schema mappings with nested queries
spellingShingle Validation of schema mappings with nested queries
Rull Fort, Guillem
Schema mapping
Nested relational model
Nested query
Query equality
Query inclusion
Validation
Àrees temàtiques de la UPC::Informàtica::Sistemes d'informació
title_short Validation of schema mappings with nested queries
title_full Validation of schema mappings with nested queries
title_fullStr Validation of schema mappings with nested queries
title_full_unstemmed Validation of schema mappings with nested queries
title_sort Validation of schema mappings with nested queries
dc.creator.none.fl_str_mv Rull Fort, Guillem
Farré Tost, Carles|||0000-0001-5814-3782
Teniente López, Ernest|||0000-0001-8890-9638
Urpí Tubella, Antoni|||0000-0002-5900-1492
author Rull Fort, Guillem
author_facet Rull Fort, Guillem
Farré Tost, Carles|||0000-0001-5814-3782
Teniente López, Ernest|||0000-0001-8890-9638
Urpí Tubella, Antoni|||0000-0002-5900-1492
author_role author
author2 Farré Tost, Carles|||0000-0001-5814-3782
Teniente López, Ernest|||0000-0001-8890-9638
Urpí Tubella, Antoni|||0000-0002-5900-1492
author2_role author
author
author
dc.subject.none.fl_str_mv Schema mapping
Nested relational model
Nested query
Query equality
Query inclusion
Validation
Àrees temàtiques de la UPC::Informàtica::Sistemes d'informació
topic Schema mapping
Nested relational model
Nested query
Query equality
Query inclusion
Validation
Àrees temàtiques de la UPC::Informàtica::Sistemes d'informació
description With the emergence of the Web and the wide use of XML for representing data, the ability to map not only flat relational but also nested data has become crucial. The design of schema mappings is a semi-automatic process. A human designer is needed to guide the process, choose among mapping candidates, and successively refine the mapping. The designer needs a way to figure out whether the mapping is what was intended. Our approach to mapping validation allows the designer to check whether the mapping satisfies certain desirable properties. In this paper, we focus on the validation of mappings between nested relational schemas, in which the mapping assertions are either inclusions or equalities of nested queries. We focus on the nested relational setting since most XML’s Document Type Definitions (DTDs) can be represented in this model. We perform the validation by reasoning on the schemas and mapping definition. We take into account the integrity constraints defined on both the source and target schema.
publishDate 2012
dc.date.none.fl_str_mv 2012
2012-10-11
2012
2012-10-17
dc.type.none.fl_str_mv report
http://purl.org/coar/resource_type/c_93fc
AO
http://purl.org/coar/version/c_b1a7d7d4d402bcce
dc.type.openaire.fl_str_mv info:eu-repo/semantics/report
format report
dc.identifier.none.fl_str_mv https://hdl.handle.net/2117/16746
url https://hdl.handle.net/2117/16746
dc.language.none.fl_str_mv Inglés
eng
language_invalid_str_mv Inglés
language eng
dc.rights.none.fl_str_mv open access
http://purl.org/coar/access_right/c_abf2
Attribution-NonCommercial-NoDerivs 3.0 Spain
http://creativecommons.org/licenses/by-nc-nd/3.0/es/
dc.rights.openaire.fl_str_mv info:eu-repo/semantics/openAccess
rights_invalid_str_mv open access
http://purl.org/coar/access_right/c_abf2
Attribution-NonCommercial-NoDerivs 3.0 Spain
http://creativecommons.org/licenses/by-nc-nd/3.0/es/
eu_rights_str_mv openAccess
dc.format.none.fl_str_mv application/pdf
dc.source.none.fl_str_mv reponame:UPCommons. Portal del coneixement obert de la UPC
instname:Universitat Politècnica de Catalunya (UPC)
instname_str Universitat Politècnica de Catalunya (UPC)
reponame_str UPCommons. Portal del coneixement obert de la UPC
collection UPCommons. Portal del coneixement obert de la UPC
repository.name.fl_str_mv
repository.mail.fl_str_mv
_version_ 1869410164942045184
score 15,301603