ScholarLens Back to search
2021•Unpublished venueRequires access

A Model for Relational to NoSQL database Migration: Snapshot-Live Stream Db Migration Model

Basant Namdeo, Ugrasen Suman

Open publisher page 16 citations

Abstract

Data migration is simply a process of transforming data from a source database to target database. Companies are moving their database from one database (e.g., RDBMS) to another new one (e.g., NoSQL) because of many reason such as new database can handle more data, that could be fast, scalable etc. There are various tools and methods such as, mongify [1], mongoimport [2], sqoop [3] etc. These are available for database migration from RDBMS to NoSQL databases. NoSQL uses document model, graph model, key-value etc., as compared to RDBMS databases. NoSQL was primarily designed for storing and retrieving a large amount of data. In this paper, we have proposed a database migration model, which can migrate real-time as well as old data in a parallel way. The proposed model is implemented for MySQL (RDBMS) to MongoDB document database in Java. The prototype migrates database instance at a particular time (Snapshot of database) as well as live data in a parallel way. Finally, our experimental evaluation of snapshot and live data migration shows the higher performance as compared to other methods.

About this research paper

What this paper is about

Data migration is simply a process of transforming data from a source database to target database. Companies are moving their database from one database (e.g., RDBMS) to another new one (e.g., NoSQL) because of many reason such as new database can handle more data, that could be fast, scalable etc. There are various tools and methods such as, mongify [1], mongoimport [2], sqoop [3] etc. These are available for database migration from RDBMS to NoSQL databases. NoSQL uses document model, graph model, key-value etc., as compared to RDBMS databases. NoSQL was primarily designed for storing and retrieving a large amount of data. In this paper, we have proposed a database migration model, which can migrate real-time as well as old data in a parallel way. The proposed model is implemented for MySQL (RDBMS) to MongoDB document database in Java. The prototype migrates database instance at a particular time (Snapshot of database) as well as live data in a parallel way. Finally, our experimental evaluation of snapshot and live data migration shows the higher performance as compared to other methods.

Why it matters

OpenAlex reports 16 citations for this work. Citation counts describe recorded attention and do not establish research quality.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

Data migration is simply a process of transforming data from a source database to target database. Companies are moving their database from one database (e.g., RDBMS) to another new one (e.g., NoSQL) because of many reason such as new database can handle more data, that could be fast, scalable etc. There are various tools and methods such as, mongify [1], mongoimport [2], sqoop [3] etc. These are available for database migration from RDBMS to NoSQL databases. NoSQL uses document model, graph model, key-value etc., as compared to RDBMS databases. NoSQL was primarily designed for storing and retrieving a large amount of data. In this paper, we have proposed a database migration model, which can migrate real-time as well as old data in a parallel way. The proposed model is implemented for MySQL (RDBMS) to MongoDB document database in Java. The prototype migrates database instance at a particular time (Snapshot of database) as well as live data in a parallel way. Finally, our experimental evaluation of snapshot and live data migration shows the higher performance as compared to other methods.

Key concepts: NoSQL, Computer science, Database, Relational database management system, Snapshot (computer storage), Database model, Scalability, Data migration

Related papers

Related paper 1Related paper 2Related paper 3
Back to paper searchBrowse research topicsOriginal source
A Model for Relational to NoSQL database Migration: Snapshot-Live Stream Db Migration Model — Research Paper | ScholarLens