A Framework for Migrating Relational Datasets to NoSQL 1

Abstract

In software development, migration from a Data Base Management System (DBMS) to another, especially with distinct characteristics, is a challenge for programmers and database administrators. Changes in the application code in order to comply with new DBMS are usually vast, causing migrations infeasible. In order to tackle this problem, we present NoSQLayer, a framework capable to support conveniently migrating from relational (i.e., MySQL) to NoSQL DBMS (i.e., MongoDB). This framework is presented in two parts: (1) migration module; and, (2) mapping module. The first one is a set of methods enabling seamless migration between DBMSs (i.e. MySQL to MongoDB). The latter provides a persistence layer to process database requests, being capable to translate and execute these requests in any DBMS, returning the data in a suitable format as well. Experiments show NoSQLayer as a handful solution suitable to handle large volume of data (e.g., Web scale) in which traditional relational DBMS might be inept in the duty.

Approaches used in efficient migration from Relational Database to NoSQL Database

“…the MySQL) to NoSQL database (MongoDB NoSQL database) while keeping the semantic of the original database w.r.t manner the data is modelled and the way programmer write the source code to retrieve data from database [1]. A method presented by author which creates semi-automatically two logical levels over physical data [2].…”

“…Next step is creating new schema for NoSQL database. the NoSQLayer supports MongoDB [1] and the MongoDB is document store. So, the records which are retrieved previously stored in document format in MongoDB database.…”

“…Table 1 shows the comparative analysis of the five approaches In paper [1] the NoSQLayer framework is used which preserves the semantics of original database and suitable to handle large volume of data. The authors [2] provided multiple nested approaches to improve the query performance and also contain migration of index for faster query execution.…”

SaaS Level based Middleware Database Integrator Platform

“…To simplify the query evaluation, data adapter system integrates and handles the transformation from SQL to NoSQL approach is accessed. In [2], a framework is introduced to support migration from relational database to NOSQL database. The framework is modularised into two parts.…”

“…Those are, data migration technique and single query approach. In data migration technique the data transformation form relational database to NoSQL database has been focused [1] [2]. But this technique suffers from extra space utilisation for storing duplicate data, and excess time for data migration.…”