Performance evaluation of NewSQL databases

Abstract

For over forty years, relational databases have been the leading model for data storage, retrieval and management. However, due to increasing needs for scalability and performance, alternative systems have emerged, namely NewSQL technology. NewSQL is a class of modern relational database management systems (RDBMS) that provide the same scalable performance of NoSQL systems for online transaction processing (OLTP) read-write workloads while still maintaining the ACID guarantees of a traditional database system. The rising interest in NewSQL technology, over the last few years resulted in an increasing number of evaluations and comparisons among competing NewSQL technologies. Some of the NewSQL databases currently used in various popular web applications are VoltDB, Google Spanner, MemSQL, SAP HANA, NuoDB, and TokuDB. This work is trying to comment on the various NewSQL database systems which describes benefits, characteristics, and classification of NewSQL databases for online transaction processing (OLTP) for Big data management. It also provides the list of popular NewSQL databases in categorized tables. This dissertation work mainly covers evaluation comparison between four NewSQL databases: NuoDB, VoltDB, MemSQL, and Cockroach DB on the basis of various parameters like read latency, write latency, update latency, and execution time. The experiments do not cover only performance (latency and execution time) but also focus on ease of use and flexibility of the used NewSQL databases.