UPM Institutional Repository

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


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


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.

Download File

Full text not available from this repository.

Additional Metadata

Item Type: Article
Divisions: Faculty of Computer Science and Information Technology
DOI Number: https://doi.org/10.20967/jcscm.2021.04.002
Publisher: SANDKRS
Keywords: DBMS; RDBMS; NoSQL; NewSQL; Acid; Base
Depositing User: Ms. Nuraida Ibrahim
Date Deposited: 21 Feb 2023 01:54
Last Modified: 21 Feb 2023 01:54
Altmetrics: http://www.altmetric.com/details.php?domain=psasir.upm.edu.my&doi=10.20967/jcscm.2021.04.002
URI: http://psasir.upm.edu.my/id/eprint/96124
Statistic Details: View Download Statistic

Actions (login required)

View Item View Item