Citation: Pina, E.; Sá, F.; Bernardino, J. NewSQL Databases Assessment: CockroachDB, MariaDB Xpand, and VoltDB. Future Internet 2023, 15, 10. https://doi.org/10.3390/fi15010010 Academic Editor: Wolf-Tilo Balke Received: 11 November 2022 Revised: 19 December 2022 Accepted: 20 December 2022 Published: 26 December 2022 Copyright: © 2022 by the authors. Licensee MDPI, Basel, Switzerland. This article is an open access article distributed under the terms and conditions of the Creative Commons Attribution (CC BY) license (https:// creativecommons.org/licenses/by/ 4.0/). future internet Article NewSQL Databases Assessment: CockroachDB, MariaDB Xpand, and VoltDB Eduardo Pina 1 , Filipe Sá 1 and Jorge Bernardino 1,2, * 1 Polytechnic of Coimbra, Institute of Engineering of Coimbra—ISEC, Rua Pedro Nunes, 3030-199 Coimbra, Portugal 2 Centre for Informatics and Systems of the University of Coimbra (CISUC), Polo II, Pinhal de Marrocos, 3030-290 Coimbra, Portugal * Correspondence: jorge@isec.pt Abstract: Background: Relational databases have been a prevalent technology for decades, using SQL (Structured Query Language) to manage data. However, the emergence of new technologies, such as the web and the cloud, has brought the requirement to handle more complex data. NewSQL is the latest technology that incorporates the ability to scale and ensures the availability of NoSQL (Not Only SQL) without losing the ACID properties (Atomicity, Consistency, Isolation, Durability) associated with relational databases. Methods: We evaluated CockroachDB, MariaDB Xpand, and VoltDB with OSSpal methodology and experimentally using the Star Schema Benchmark (SSB). The scalability and performance capabilities of each database were assessed. Results: Applying the OSSpal methodology, the results showed that MariaDB Xpand outperformed CockroachDB and VoltDB. On the other hand, we concluded that with Star Schema Benchmark, CockroachDB had better scalability, while VoltDB had a faster query execution time. Conclusions: CockroachDB and VoltDB are the best performing databases in terms of scalability and performance. Keywords: SQL; NewSQL; OSSpal; SSB; CockroachDB; MariaDB Xpand; VoltDB 1. Introduction Today’s business world is accelerating, where advances in web technology and the creation of Internet-connected sensors and mobile devices have resulted in huge datasets that need to be processed and stored like never before. Relational Database Management Systems, also known as RDBMS, are one of the most successful technologies in computing, being the default choice for model adoption in business worldwide and its SQL standard language [13]. A DBMS consists of a collection of programs and services that allow the user to insert, update, delete, and query the stored data, making it easier to maintain and access the data [4]. With the huge volume and complex evolution of data, businesses have started to look for alternatives that allow them to work with high volume, velocity, and variety. SQL’s increased capacity allows the management of huge amounts of data but is not sufficient for the requirements of Big Data, which demands rapid response and high scalability. With such challenges, Not Only SQL (NoSQL) offers resources such as flexibility and horizontal scalability [5], but despite supporting the capability of highly available data volume technologies, NoSQL systems do not ensure ACID properties [6]. NewSQL emerged as a set of innovative SQL database engines with high perfor- mance and scalability. These engines seek to promote the same performance and scalability improvement of NoSQL systems and design solutions that have the advantages of the rela- tional model, and the benefit of using SQL language and fulfilling the ACID properties [7]. In 2011, Matthew Aslett first used the term NewSQL in a business analysis report [8], which discussed the advent of new database systems. NewSQL systems come in differ- ent types, targeting different workloads and practices, opening up new opportunities in business, where real-time decisions are critical. Among several use cases, we have Future Internet 2023, 15, 10. https://doi.org/10.3390/fi15010010 https://www.mdpi.com/journal/futureinternet