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
    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