A runtime approach to model-generic translation of schema and data

  • Authors:

  • Paolo Atzeni;Luigi Bellomarini;Francesca Bugiotti;Fabrizio Celli;Giorgio Gianforme

  • Affiliations:

  • Dipartimento di Informatica e Automazione, Universití Roma Tre, Via della Vasca Navale 79, 00146 Roma, Italy;Dipartimento di Informatica e Automazione, Universití Roma Tre, Via della Vasca Navale 79, 00146 Roma, Italy;Dipartimento di Informatica e Automazione, Universití Roma Tre, Via della Vasca Navale 79, 00146 Roma, Italy;Dipartimento di Informatica e Automazione, Universití Roma Tre, Via della Vasca Navale 79, 00146 Roma, Italy;Dipartimento di Informatica e Automazione, Universití Roma Tre, Via della Vasca Navale 79, 00146 Roma, Italy

  • Venue:
  • Information Systems
  • Year:
  • 2012

Quantified Score

Hi-index 0.00

Visualization

Abstract

To support heterogeneity is a major requirement in current approaches to integration and transformation of data. This paper proposes a new approach to the translation of schema and data from one data model to another, and we illustrate its implementation in the tool MIDST-RT. We leverage on our previous work on MIDST, a platform conceived to perform translations in an off-line fashion. In such an approach, the source database (both schema and data) is imported into a repository, where it is stored in a universal model. Then, the translation is applied within the tool as a composition of elementary transformation steps, specified as Datalog programs. Finally, the result (again both schema and data) is exported into the operational system. Here we illustrate a new, lightweight approach where the database is not imported. MIDST-RT needs only to know the schema of the source database and the model of the target one, and generates views on the operational system that expose the underlying data according to the corresponding schema in the target model. Views are generated in an almost automatic way, on the basis of the Datalog rules for schema translation. The proposed solution can be applied to different scenarios, which include data and application migration, data interchange, and object-to-relational mapping between applications and databases.