Tutorial 5: schema and data translation

  • Authors:
  • Paolo Atzeni

  • Affiliations:
  • Università Roma Tre

  • Venue:
  • ER'05 Proceedings of the 24th international conference on Perspectives in Conceptual Modeling
  • Year:
  • 2005

Quantified Score

Hi-index 0.00

Visualization

Abstract

Many application settings involve the need to exchange information between heterogeneous frameworks. In the database world, we often use different systems to handle data, following different models, and we therefore need to translate data and their description from one to another. The problem has been considered for decades in our field, but definitive solutions are not yet available. The problem is relevant at the schema level (for example, every designer works with a conceptual model, such as ER or UML, and then translates the conceptual schema into a logical model, usually relational), and at the data level, when we have databases, and we want to translate them into some other system, which may be similar (for example, with a slightly different version of the relational model) or completely different (for example, XML documents).