A survey of NewSQL DBMSs focusing on taxonomy, comparison and open issues
Advancements in internet, cloud, and business intelligence technologies, as well as the emergence of big data, have caused massive traffic in online transaction processing (OLTP) systems.All these impose the needs for effective and efficient data storage and processing which is not available in conv...
Saved in:
Main Authors: | , , , , , , |
---|---|
Format: | Article |
Published: |
SANDKRS
2021
|
Online Access: | http://psasir.upm.edu.my/id/eprint/96124/ https://www.jcscm.net/cms/?action=showpaper&id=2211182 |
Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
id |
my.upm.eprints.96124 |
---|---|
record_format |
eprints |
spelling |
my.upm.eprints.961242023-02-21T01:54:27Z http://psasir.upm.edu.my/id/eprint/96124/ A survey of NewSQL DBMSs focusing on taxonomy, comparison and open issues Abdullah, Muhammed Abdullah, Zul Hilmi Ismail, Waidah Aldailamy, Ali Y. Radman, Abduljalil Hendradi, Rimuljo Afandi, Radhi Rafiee Advancements in internet, cloud, and business intelligence technologies, as well as the emergence of big data, have caused massive traffic in online transaction processing (OLTP) systems.All these impose the needs for effective and efficient data storage and processing which is not available in conventional Relational Database Management Systems (RDBMSs). In the year2000, a new generation of database management systems (DBMSs)called Not Only Structured Query Language (NoSQL) has emerged to address the scalability of OLTP workloads in a way that was impossible for conventional relational database management systems(RDBMSs). Despite adequately addressing issues linked to scalability and producing better read-write performance than RDBMS,NoSQL DBMSs appear to lack in providing definite assurance of data consistency. Hence, a newer DBMS alternative called NewSQLhas emerged. NewSQL DBMS has combined the advantages of both conventional RDBMS and NoSQL. They have the scalable performance of NoSQL DBMSs and the data consistency of traditional RDBMS. To date, there are tens of existing NewSQL-DBMSs,so it is difficult to understand the difference between them, andit is also quite challenging to decide the best solution for a specific task. Hence, this paper presents a comprehensive review concerning NewSQL-DBMSs by emphasizing the following purposes:(1) providing researchers and practitioners guidance that may assist in selecting the most appropriate NewSQL-DBMS, (2) classifying NewSQL-DBMSs based on internal implantation and number of tiers, (3) providing comparisons and analyses of query capabilities,technical characteristics, and security attributes of the prominent NewSQL-DBMSs, and finally, (4) identifying issues and challenges raised with the emergence of NewSQL-DBMSs. In conclusion,NewSQL DBMSs can offers solutions for fault tolerance, horizontal scalability features. SANDKRS 2021 Article PeerReviewed Abdullah, Muhammed and Abdullah, Zul Hilmi and Ismail, Waidah and Aldailamy, Ali Y. and Radman, Abduljalil and Hendradi, Rimuljo and Afandi, Radhi Rafiee (2021) A survey of NewSQL DBMSs focusing on taxonomy, comparison and open issues. Journal of Computer Science & Computational Mathematics, 11 (4). pp. 1-9. ISSN 2231-8879 https://www.jcscm.net/cms/?action=showpaper&id=2211182 10.20967/jcscm.2021.04.002 |
institution |
Universiti Putra Malaysia |
building |
UPM Library |
collection |
Institutional Repository |
continent |
Asia |
country |
Malaysia |
content_provider |
Universiti Putra Malaysia |
content_source |
UPM Institutional Repository |
url_provider |
http://psasir.upm.edu.my/ |
description |
Advancements in internet, cloud, and business intelligence technologies, as well as the emergence of big data, have caused massive traffic in online transaction processing (OLTP) systems.All these impose the needs for effective and efficient data storage and processing which is not available in conventional Relational Database Management Systems (RDBMSs). In the year2000, a new generation of database management systems (DBMSs)called Not Only Structured Query Language (NoSQL) has emerged to address the scalability of OLTP workloads in a way that was impossible for conventional relational database management systems(RDBMSs). Despite adequately addressing issues linked to scalability and producing better read-write performance than RDBMS,NoSQL DBMSs appear to lack in providing definite assurance of data consistency. Hence, a newer DBMS alternative called NewSQLhas emerged. NewSQL DBMS has combined the advantages of both conventional RDBMS and NoSQL. They have the scalable performance of NoSQL DBMSs and the data consistency of traditional RDBMS. To date, there are tens of existing NewSQL-DBMSs,so it is difficult to understand the difference between them, andit is also quite challenging to decide the best solution for a specific task. Hence, this paper presents a comprehensive review concerning NewSQL-DBMSs by emphasizing the following purposes:(1) providing researchers and practitioners guidance that may assist in selecting the most appropriate NewSQL-DBMS, (2) classifying NewSQL-DBMSs based on internal implantation and number of tiers, (3) providing comparisons and analyses of query capabilities,technical characteristics, and security attributes of the prominent NewSQL-DBMSs, and finally, (4) identifying issues and challenges raised with the emergence of NewSQL-DBMSs. In conclusion,NewSQL DBMSs can offers solutions for fault tolerance, horizontal scalability features. |
format |
Article |
author |
Abdullah, Muhammed Abdullah, Zul Hilmi Ismail, Waidah Aldailamy, Ali Y. Radman, Abduljalil Hendradi, Rimuljo Afandi, Radhi Rafiee |
spellingShingle |
Abdullah, Muhammed Abdullah, Zul Hilmi Ismail, Waidah Aldailamy, Ali Y. Radman, Abduljalil Hendradi, Rimuljo Afandi, Radhi Rafiee A survey of NewSQL DBMSs focusing on taxonomy, comparison and open issues |
author_facet |
Abdullah, Muhammed Abdullah, Zul Hilmi Ismail, Waidah Aldailamy, Ali Y. Radman, Abduljalil Hendradi, Rimuljo Afandi, Radhi Rafiee |
author_sort |
Abdullah, Muhammed |
title |
A survey of NewSQL DBMSs focusing on taxonomy, comparison and open issues |
title_short |
A survey of NewSQL DBMSs focusing on taxonomy, comparison and open issues |
title_full |
A survey of NewSQL DBMSs focusing on taxonomy, comparison and open issues |
title_fullStr |
A survey of NewSQL DBMSs focusing on taxonomy, comparison and open issues |
title_full_unstemmed |
A survey of NewSQL DBMSs focusing on taxonomy, comparison and open issues |
title_sort |
survey of newsql dbmss focusing on taxonomy, comparison and open issues |
publisher |
SANDKRS |
publishDate |
2021 |
url |
http://psasir.upm.edu.my/id/eprint/96124/ https://www.jcscm.net/cms/?action=showpaper&id=2211182 |
_version_ |
1758952030128308224 |
score |
13.18916 |