When Relational-Based Applications Go to NoSQL Databases: A Survey
Several data-centric applications today produce and manipulate a large volume of data, the so-called Big Data. Traditional databases, in particular, relational databases, are not suitable for Big Data management. As a consequence, some approaches that allow the definition and manipulation of large r...
Main Authors: | , , |
---|---|
Format: | Article |
Language: | English |
Published: |
MDPI AG
2019-07-01
|
Series: | Information |
Subjects: | |
Online Access: | https://www.mdpi.com/2078-2489/10/7/241 |
_version_ | 1811192885766258688 |
---|---|
author | Geomar A. Schreiner Denio Duarte Ronaldo dos Santos Mello |
author_facet | Geomar A. Schreiner Denio Duarte Ronaldo dos Santos Mello |
author_sort | Geomar A. Schreiner |
collection | DOAJ |
description | Several data-centric applications today produce and manipulate a large volume of data, the so-called Big Data. Traditional databases, in particular, relational databases, are not suitable for Big Data management. As a consequence, some approaches that allow the definition and manipulation of large relational data sets stored in NoSQL databases through an SQL interface have been proposed, focusing on scalability and availability. This paper presents a comparative analysis of these approaches based on an architectural classification that organizes them according to their system architectures. Our motivation is that wrapping is a relevant strategy for relational-based applications that intend to move relational data to NoSQL databases (usually maintained in the cloud). We also claim that this research area has some open issues, given that most approaches deal with only a subset of SQL operations or give support to specific target NoSQL databases. Our intention with this survey is, therefore, to contribute to the state-of-art in this research area and also provide a basis for choosing or even designing a relational-to-NoSQL data wrapping solution. |
first_indexed | 2024-04-11T23:58:27Z |
format | Article |
id | doaj.art-63ac140cd8834f65b877d4f60476b178 |
institution | Directory Open Access Journal |
issn | 2078-2489 |
language | English |
last_indexed | 2024-04-11T23:58:27Z |
publishDate | 2019-07-01 |
publisher | MDPI AG |
record_format | Article |
series | Information |
spelling | doaj.art-63ac140cd8834f65b877d4f60476b1782022-12-22T03:56:17ZengMDPI AGInformation2078-24892019-07-0110724110.3390/info10070241info10070241When Relational-Based Applications Go to NoSQL Databases: A SurveyGeomar A. Schreiner0Denio Duarte1Ronaldo dos Santos Mello2Departamento de Informática e Estatística, Federal University of Santa Catarina, 88040-900 Florianópolis - SC, BrazilCampus Chapecó, Federal University of Fronteira Sul, 89815-899 Chapecó - SC, BrazilDepartamento de Informática e Estatística, Federal University of Santa Catarina, 88040-900 Florianópolis - SC, BrazilSeveral data-centric applications today produce and manipulate a large volume of data, the so-called Big Data. Traditional databases, in particular, relational databases, are not suitable for Big Data management. As a consequence, some approaches that allow the definition and manipulation of large relational data sets stored in NoSQL databases through an SQL interface have been proposed, focusing on scalability and availability. This paper presents a comparative analysis of these approaches based on an architectural classification that organizes them according to their system architectures. Our motivation is that wrapping is a relevant strategy for relational-based applications that intend to move relational data to NoSQL databases (usually maintained in the cloud). We also claim that this research area has some open issues, given that most approaches deal with only a subset of SQL operations or give support to specific target NoSQL databases. Our intention with this survey is, therefore, to contribute to the state-of-art in this research area and also provide a basis for choosing or even designing a relational-to-NoSQL data wrapping solution.https://www.mdpi.com/2078-2489/10/7/241big datadata interoperabilityNoSQL databasesrelational-to-NoSQL mapping |
spellingShingle | Geomar A. Schreiner Denio Duarte Ronaldo dos Santos Mello When Relational-Based Applications Go to NoSQL Databases: A Survey Information big data data interoperability NoSQL databases relational-to-NoSQL mapping |
title | When Relational-Based Applications Go to NoSQL Databases: A Survey |
title_full | When Relational-Based Applications Go to NoSQL Databases: A Survey |
title_fullStr | When Relational-Based Applications Go to NoSQL Databases: A Survey |
title_full_unstemmed | When Relational-Based Applications Go to NoSQL Databases: A Survey |
title_short | When Relational-Based Applications Go to NoSQL Databases: A Survey |
title_sort | when relational based applications go to nosql databases a survey |
topic | big data data interoperability NoSQL databases relational-to-NoSQL mapping |
url | https://www.mdpi.com/2078-2489/10/7/241 |
work_keys_str_mv | AT geomaraschreiner whenrelationalbasedapplicationsgotonosqldatabasesasurvey AT denioduarte whenrelationalbasedapplicationsgotonosqldatabasesasurvey AT ronaldodossantosmello whenrelationalbasedapplicationsgotonosqldatabasesasurvey |