A NewSQL Solution Analysis

• Ronan Knob UFSC
• Geomar Schreiner UFSC
• Angelo Frozza UFSC / IFC
• Ronaldo Mello UFSC

DOI: https://doi.org/10.5753/erbd.2019.8475

Abstract

Several applications have as requirements the need to handle large and heterogeneous data volumes as well as the support to handle thousands of OLTP transactions per second. Traditional relational databases (DBRs) are not suitable for these requirements. On the other hand, NoSQL DBs are able to deal with Big Data, but lacks the support to ACID properties. NewSQL is a new class of DBs that combines the support to OLTP transactions of BDRs with the high availability and scalability of NoSQL DBs. However, few works in the literature explore the differences among different NewSQL solutions. In this paper, we execute benchmark software to compare the most prominent NewSQL products analyzing the results. This analysis can be useful as a guide to future use of NewSQL technology.

Keywords: NewSQL, Benchmark, Big Data

References

Difallah, D. E., Pavlo, A., Curino, C., and Cudre-Mauroux, P. (2013). Oltp-bench: An extensible testbed for benchmarking relational databases. Proc. VLDB Endow., 7(4).

Grolinger, K., Higashino,W. A., Tiwari, A., and Capretz, M. A. (2013). Data management in cloud environments: Nosql and newsql data stores. JoCCASA.

Gurevich, Y. (2015). Comparative Survey of NoSQL/NewSQL DB Systems. PhD thesis, The Open University.

Hajoui, O., Dehbi, R., Talea, M., and Batouta, Z. I. (2015). An advanced comparative study of the most promising nosql and newsql databases with a multi-criteria analysis method. Journal of Theoretical & Applied Information Technology, 81(3).

Kaur, K. and Sachdeva, M. (2017). Performance evaluation of newsql databases. In 2017 International Conference on Inventive Systems and Control (ICISC), pages 1–5.

Knob, R. R. (2018). Análise e benchmarking das soluções newsql cockroachdb, memsql, nuodb e voltdb. TCC, Universidade Federal de Santa Catarina.

Labs, C. (2018). Architecture overview. https://www.cockroachlabs.com/docs/stable/architecture/overview.html#goals-of-cockroachdb. Último acesso em: 21/06/2018.

MemSQL (2018). Memsql architecture: Technology innovations power convergence of transactions and analytics. https://www.memsql.com/content/architecture/. Último acesso em: 06/10/2018.

Oliveira, J. and Bernardino, J. (2017). Newsql databases-memsql and voltdb experimental evaluation. In KEOD, pages 276–281.

Pavlo, A. and Aslett, M. (2016). What’s really new with newsql? SIGMOD Rec., 45(2).

Stonebraker, M. (2012). Newsql: An alternative to nosql and old sql for new oltp apps. Communications of the ACM. Retrieved, pages 07–06.

VoltDB (2013). Using voltdb. http://downloads.voltdb.com/documentation/UsingVoltDB.pdf. Último acesso em: 05/06/2018.

VoltDB (2015). Voltdb technical overview. http://www.odbms.org/wp-content/uploads/2013/11/VoltDBTechnicalOverview.pdf. Último acesso em: 05/06/2018.