Performance evaluation of NewSQL databases

Karambir Kaur, Monika Sachdeva

2017 International Conference on Inventive Systems and Control (ICISC) · 2017 · 26 citations · 4 references

Concepts

TL;DR

Relational databases have dominated for decades, but growing demands for scalability and performance have spurred the rise of NewSQL systems that combine NoSQL‑style scalability with ACID guarantees, prompting numerous evaluations of popular engines such as VoltDB, Google Spanner, MemSQL, SAP HANA, NuoDB, and TokuDB. This study reviews NewSQL database systems, outlining their benefits, characteristics, and classification for OLTP in big‑data contexts, and presents a categorized list of popular NewSQL engines. The authors compare four NewSQL databases—NuoDB, VoltDB, MemSQL, and CockroachDB—on read, write, and update latency, execution time, and assess their ease of use and flexibility.

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.

References

4