Migrating from SQL to NOSQL Database: Practices and Analysis

Fatima Yassine, Mamoun Adel Awad

Research output: Chapter in Book/Report/Conference proceedingConference contribution

4 Citations (Scopus)

Abstract

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.

Original languageEnglish
Title of host publicationProceedings of the 2018 13th International Conference on Innovations in Information Technology, IIT 2018
PublisherInstitute of Electrical and Electronics Engineers Inc.
Pages58-62
Number of pages5
ISBN (Electronic)9781538666739
DOIs
Publication statusPublished - Jul 2 2018
Externally publishedYes
Event13th International Conference on Innovations in Information Technology, IIT 2018 - Al Ain, United Arab Emirates
Duration: Nov 18 2018Nov 19 2018

Publication series

NameProceedings of the 2018 13th International Conference on Innovations in Information Technology, IIT 2018

Conference

Conference13th International Conference on Innovations in Information Technology, IIT 2018
Country/TerritoryUnited Arab Emirates
CityAl Ain
Period11/18/1811/19/18

Keywords

  • Big Data
  • MongoDB
  • NoSQL

ASJC Scopus subject areas

  • Hardware and Architecture
  • Information Systems and Management
  • Information Systems

Fingerprint

Dive into the research topics of 'Migrating from SQL to NOSQL Database: Practices and Analysis'. Together they form a unique fingerprint.

Cite this