Staff View: A survey of NewSQL DBMSs focusing on taxonomy, comparison and open issues

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

Full description

Saved in:

Bibliographic Details
Main Authors:	Abdullah, Muhammed, Abdullah, Zul Hilmi, Ismail, Waidah, Aldailamy, Ali Y., Radman, Abduljalil, Hendradi, Rimuljo, Afandi, Radhi Rafiee
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.211869

A survey of NewSQL DBMSs focusing on taxonomy, comparison and open issues

Similar Items