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

Celý popis

Uloženo v:
Podrobná bibliografie
Vydáno v:2018 International Conference on Innovations in Information Technology (IIT) s. 58 - 62
Hlavní autoři: Yassine, Fatima, Awad, Mamoun Adel
Médium: Konferenční příspěvek
Jazyk:angličtina
Vydáno: IEEE 01.11.2018
Témata:
Benchmark testing
Big Data
Information technology
Java
MongoDB
NoSQL
Relational databases
Structured Query Language
Technological innovation
On-line přístup:Získat plný text
Tagy: Přidat tag
Žádné tagy, Buďte první, kdo vytvoří štítek k tomuto záznamu!
Popis
Shrnutí: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