Migrating from SQL to NOSQL Database: Practices and Analysis

Big data and data analytics require migrating from relational databases (SQL) to NoSQL data structures to represent the data. Such transformation is challenging because of the lack of automatic transformation process and the requirement of guaranteeing both performance and accurate representation. I...

Full description

Saved in:
Bibliographic Details
Published in:2018 International Conference on Innovations in Information Technology (IIT) pp. 58 - 62
Main Authors: Yassine, Fatima, Awad, Mamoun Adel
Format: Conference Proceeding
Language:English
Published: IEEE 01.11.2018
Subjects:
Benchmark testing
Big Data
Information technology
Java
MongoDB
NoSQL
Relational databases
Structured Query Language
Technological innovation
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:Big data and data analytics require migrating from relational databases (SQL) to NoSQL data structures to represent the data. Such transformation is challenging because of the lack of automatic transformation process and the requirement of guaranteeing both performance and accurate representation. In this paper, we analyze and implement commonly used mapping from SQL to NoSQL structures. We compare between these mappings in terms of retrieval time in an attempt to identify the best mapping. We use MySQL as DBMS for SQL structure and MongoDB for NoSQL structures. Our experiments showed promising results when using a mix of one level embedded document with a reference relationship with another document.
DOI:10.1109/INNOVATIONS.2018.8606019