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


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
PublisherSpringer Verlag
Number of pages15
ISBN (Print)9783540755623
StatePublished - 2007
Externally publishedYes
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


Other26th International Conference on Conceptual Modeling, ER 2007
Country/TerritoryNew Zealand

ASJC Scopus subject areas

  • Theoretical Computer Science
  • General Computer Science


Dive into the research topics of 'Schema exchange: A template-based approach to data and metadata translation'. Together they form a unique fingerprint.

Cite this