Schema exchange: A template-based approach to data and metadata translation

Paolo Papotti, Riccardo Torlone

Research output: Chapter in Book/Report/Conference proceedingConference contribution

4 Scopus citations

Abstract

In this paper we study the problem of schema exchange, a natural extension of the data exchange problem to an intensional level. To this end, we first introduce the notion of schema template, a tool for the representation of a class of schemas sharing the same structure. We then define the schema exchange notion as the problem of (i) taking a schema that matches a source template, and (ii) generating a new schema for a target template, on the basis of a set of dependencies defined over the two templates. This framework allows the definition, once for all, of generic transformations that work for several schemas. A method for the generation of a "correct" solution of the schema exchange problem is proposed and a number of general results are given. We also show how it is possible to generate automatically a data exchange setting from a schema exchange solution. This allows the definition of queries to migrate data from a source database into the one obtained as a result of a schema exchange.

Original languageEnglish (US)
Title of host publicationConceptual Modeling - ER 2007 - 26th International Conference on Conceptual Modeling, Proceedings
Pages323-337
Number of pages15
StatePublished - Dec 1 2007
Event26th International Conference on Conceptual Modeling, ER 2007 - Auckland, New Zealand
Duration: Nov 5 2007Nov 9 2007

Publication series

NameLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume4801 LNCS
ISSN (Print)0302-9743
ISSN (Electronic)1611-3349

Other

Other26th International Conference on Conceptual Modeling, ER 2007
CountryNew Zealand
CityAuckland
Period11/5/0711/9/07

    Fingerprint

ASJC Scopus subject areas

  • Theoretical Computer Science
  • Computer Science(all)

Cite this

Papotti, P., & Torlone, R. (2007). Schema exchange: A template-based approach to data and metadata translation. In Conceptual Modeling - ER 2007 - 26th International Conference on Conceptual Modeling, Proceedings (pp. 323-337). (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 4801 LNCS).