Automatic Translation of Heterogeneous Data Models

Abstract

Abstract-Schema translation is the process of transforming schemas in heterogeneous data models into a single target data model. Today there exist various data models to save useful data. The need of schema translation rises due to the existence of wide range of prominent, heterogeneous database applications. Due to the increasing requirement of interoperability of autonomous databases, multi database system which consists of homogenous or heterogeneous databases are required to work in a cooperative environment. In heterogeneous multi database system, the translation of one data model to another data model is critical. In this paper, we present a data model translation between heterogeneous models. Our approach translates the schema and data of one model to the target schema and data. We use the concept of metadictionary to achieve translation. We use XML as the standard to perform core translation. Our approach can adopt new upcoming models and can change them to old models easily.Index Terms-Data models, data translation, meta model, heterogeneous model.