Data Migration Model and Algorithm between Heterogeneous Databases based on Web Service

Abstract—To solve the problems of data conversion between heterogeneous databases that arising from the progress of data migration, the paper presents an improved model of data migration and a data conversion algorithm based on the research on data synchronization via web service. The data migration model is divided into legacy data tier, middle tier and target data tier, which respectively provides data extracting, data converting and data loading functions. By establishing the corresponding relationships of different data fields between heterogeneous legacy database and target database, the data conversion algorithm converts data formats of legacy database into required data formats of target database according to the relationships, then writes the converted XML document to target database to achieve data migration. Experiments show that the model and algorithm can effectively realize data migration.