Validation of Schema Mappings with Nested Queries

Guillem Rull¹, Carles Farré¹, Ernest Teniente¹ and Toni Urpí¹

Departament d’Enginyeria de Serveis i Sistemes d’Informació, Universitat Politècnica de Catalunya (UPC)—BarcelonaTech
1-3 Jordi Girona, 08034 Barcelona, Spain
{grull, farre, teniente, urpi}@essi.upc.edu

Abstract

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. We consider constraints and mapping’s queries which may contain arithmetic comparisons and negations. This class of mapping scenarios is significantly more expressive than the ones addressed by previous work on nested relational mapping validation. We encode the given mapping scenario into a single flat database schema, so we can take advantage of our previous work on validating flat relational mappings, and reformulate each desirable property check as a query satisfiability problem.

Key words

schema mapping, nested relational model, nested query, query equality, query inclusion, validation

Digital Object Identifier (DOI)

https://doi.org/10.2298/CSIS120713042R

Publication information

Volume 10, Issue 1 (Januar 2013)
Year of Publication: 2013
ISSN: 2406-1018 (Online)
Publisher: ComSIS Consortium

Full text

Download Available in PDF
Portable Document Format

How to cite

Rull, G., Farré, C., Teniente, E., Urpí, T.: Validation of Schema Mappings with Nested Queries. Computer Science and Information Systems, Vol. 10, No. 1, 79-104. (2013), https://doi.org/10.2298/CSIS120713042R