Performance evaluation of NewSQL databases
Karambir Kaur, Monika Sachdeva
Abstract
Karambir Kaur, Monika Sachdeva
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.
OpenAlex reports 26 citations for this work. Citation counts describe recorded attention and do not establish research quality.
A contribution statement is not available in the OpenAlex record.
Method details are not available in the OpenAlex metadata.
Findings are not separately available in the OpenAlex metadata.
Limitations are not available in the OpenAlex metadata.
Application details are not available in the OpenAlex metadata.
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.
Key concepts: Computer science, NoSQL, Online transaction processing, Database, Scalability, Relational database management system, Transaction processing, Relational database