Model Transformation and Data Migration from Relational Database to MongoDB

Abstract

With the data growing dramatically and the structure of data becoming increasingly flexible, MongoDB has replaced the relational database in many applications. However, not much work has been done to effectively transform the schema and migrate the data from relational database to MongoDB. In this paper, we propose an approach of model transformation and data migration from relational database to MongoDB. Our work i) considers the query characteristics and data characteristics of the relational database, ii) designs a model transformation algorithm based on description tags and action tags, iii) automatically migrates the data into MongoDB based on the result of model transformation, and iv) develops an useful tool. We have designed experiments to prove that using our approach can achieve a better read performance.