A runtime approach to model-independent schema and data translation

A runtime approach to model-generic translation of schema and data is proposed. It is based on our previous work on MIDST, a platform conceived to perform translations in an off-line fashion. In the original approach, the source database is imported into a dictionary, where it is stored according to 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 is exported into the operational system. Here we illustrate a new, lightweight approach where the database is not imported. The tool needs only to know the model and the schema of the source database and generates views on the operational system that transform the underlying data (stored in the source schema) 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.

• Type: Conference
• Year: 2009
• Where: EDBT
• Authors: Paolo Atzeni, Luigi Bellomarini, Francesca Bugiotti, Giorgio Gianforme
• Keywords: Database, EDBT 2009, Elementary Transformation Steps, Operational System, Source Database