research-article

NewSQL Through the Looking Glass

Authors:

Geomar A. Schreiner,

Patricia Vilain,

Ronaldo dos Santos MelloAuthors Info & Claims

iiWAS2019: Proceedings of the 21st International Conference on Information Integration and Web-based Applications & Services

Pages 361 - 369

https://doi.org/10.1145/3366030.3366080

Published: 22 February 2020 Publication History

Abstract

Several applications require to handle large and heterogeneous data volumes as well as thousands of OLTP transactions per second. Traditional relational databases are not suitable for these requirements. On the other hand, NoSQL databases are able to deal with Big Data, but lacks the support to the traditional ACID properties. NewSQL is a new class of databases that combines the support to OLTP transactions of relational databases with the high availability and scalability of NoSQL databases. However, few works in the literature explore the differences among different NewSQL solutions. In this paper, we discuss the main features of the most prominent NewSQL products, besides we present benchmarking results for analyzing their performance. We believe that both analysis can be useful as a guide to a future choice of NewSQL technologies.

References

[1]

Mohammed Al-Kateb, Paul Sinclair, Grace Au, and Carrie Ballinger. 2016. Hybrid Row-column Partitioning in Teradata®. Proc. VLDB Endow. 9, 13 (Sept. 2016), 1353--1364.

Digital Library

[2]

David J DeWitt, Randy H Katz, Frank Olken, Leonard D Shapiro, Michael R Stonebraker, and David A. Wood. 1984. Implementation Techniques for Main Memory Database Systems. SIGMOD Rec. 14, 2 (June 1984), 1--8. https://doi.org/10.1145/971697.602261

Digital Library

[3]

Djellel Eddine Difallah, Andrew Pavlo, Carlo Curino, and Philippe Cudre-Mauroux. 2013. OLTP-Bench: An Extensible Testbed for Benchmarking Relational Databases. Proc. VLDB Endow. 7, 4 (Dec. 2013). https://doi.org/10.14778/2732240.2732246

Digital Library

[4]

Katarina Grolinger, Wilson A. Higashino, Abhinav Tiwari, and Miriam AM Capretz. 2013. Data management in cloud environments: NoSQL and NewSQL data stores. JoCCASA (Dec 2013). https://doi.org/10.1186/2192-113X-2-22

[5]

Yuri Gurevich. 2015. Comparative Survey of NoSQL/NewSQL DB Systems. Ph.D. Dissertation. The Open University.

[6]

Omar Hajoui, Rachid Dehbi, Mohammed Talea, and Zouhair Ibn Batouta. 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 (2015).

[7]

NuoDB INC. 2018. NuoDB: Architecture (White Paper). http://go.nuodb.com/white-paper.html, Last access: 05/07/2019.

[8]

Robert Kallman, Hideaki Kimura, Jonathan Natkins, Andrew Pavlo, Alexander Rasin, Stanley Zdonik, Evan P. C. Jones, Samuel Madden, Michael Stonebraker, Yang Zhang, John Hugg, and Daniel J. Abadi. 2008. H-store: A High-performance, Distributed Main Memory Transaction Processing System. Proc. VLDB Endow. 1, 2 (Aug. 2008), 1496--1499. https://doi.org/10.14778/1454159.1454211

Digital Library

[9]

K. Kaur and M. Sachdeva. 2017. Performance evaluation of NewSQL databases. In 2017 International Conference on Inventive Systems and Control (ICISC). 1--5. https://doi.org/10.1109/ICISC.2017.8068585

[10]

Rakesh Kumar, Neha Gupta, Shilpi Charu, and Sunil Kumar Jangir. 2014. Manage Big Data through NewSQL. In National Conference on Innovation in Wireless Communication and Networking Technology-2014, Association with THE INSTITUTION OF ENGINEERS (INDIA).

[11]

Cochroach Labs. 2018. Architecture Overview. https://www.cockroachlabs.com/docs/stable/architecture/overview.html Último acesso em: 21/06/2018.

[12]

Patrick Valduriez (auth.) M. Tamer Özsu. 2011. Principles of Distributed Database Systems, Third Edition (3 ed.). Springer-Verlag New York.

[13]

Lin Ma, Joy Arulraj, Sam Zhao, Andrew Pavlo, Subramanya R. Dulloor, Michael J. Giardino, Jeff Parkhurst, Jason L. Gardner, Kshitij Doshi, and Stanley Zdonik. 2016. Larger-than-memory Data Management on Modern Storage Hardware for In-memory OLTP Database Systems. In Proceedings of the 12th International Workshop on Data Management on New Hardware (DaMoN '16). ACM, New York, NY, USA, Article 9, 7 pages. https://doi.org/10.1145/2933349.2933358

Digital Library

[14]

MemSQL. 2018. MemSQL Architecture: Technology Innovations Power Convergence of Transactions and Analytics. https://www.memsql.com/content/architecture/Último acesso em: 06/10/2018.

[15]

C. Mohan, Don Haderle, Bruce Lindsay, Hamid Pirahesh, and Peter Schwarz. 1992. ARIES: A Transaction Recovery Method Supporting Fine-granularity Locking and Partial Rollbacks Using Write-ahead Logging. ACM Trans. Database Syst. 17, 1 (March 1992), 94--162. https://doi.org/10.1145/128765.128770

Digital Library

[16]

João Oliveira and Jorge Bernardino. 2017. NewSQL Databases-MemSQL and VoltDB Experimental Evaluation. In KEOD. 276--281.

[17]

Andrew Pavlo and Matthew Aslett. 2016. What's Really New with NewSQL? SIGMOD Rec. 45, 2 (Sept. 2016), 45--55. https://doi.org/10.1145/3003665.3003674

Digital Library

[18]

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

[19]

J. Valdes, H. Garcia-Molina, and R. Lipton. 1984. A Massive Memory Machine. IEEE Trans. Comput. 33, 05 (may 1984), 391--399. https://doi.org/10.1109/TC.1984.1676454

[20]

VoltDB. 2015. VoltDB Technical Overview. http://www.odbms.org/wp-content/uploads/2013/11/VoltDBTechnicalOverview.pdf, Last access: 05/07/2019.

Cited By

Nascimento BSantos RAbbasi MMartins PSilva JVáz P(2023)Scalability and Performance Evaluation of NewSQL and Relational Databases: A Comparative Benchmark Study2023 Second International Conference On Smart Technologies For Smart Nation (SmartTechCon)10.1109/SmartTechCon57526.2023.10391567(908-913)Online publication date: 18-Aug-2023
https://doi.org/10.1109/SmartTechCon57526.2023.10391567
Espinel Sarmiento DLebre ANussbaum LChari A(2021)Decentralized SDN Control Plane for a Distributed Cloud-Edge Infrastructure: A SurveyIEEE Communications Surveys & Tutorials10.1109/COMST.2021.305029723:1(256-281)Online publication date: Sep-2022
https://doi.org/10.1109/COMST.2021.3050297
Vicente AEtcheverry LSabiguero A(2021)An RDBMS-only architecture for web applications2021 XLVII Latin American Computing Conference (CLEI)10.1109/CLEI53233.2021.9640017(1-9)Online publication date: 25-Oct-2021
https://doi.org/10.1109/CLEI53233.2021.9640017
Show More Cited By

Index Terms

NewSQL Through the Looking Glass
1. Information systems
  1. Data management systems

Recommendations

A Hybrid Partitioning Strategy for NewSQL Databases: The VoltDB Case
iiWAS2019: Proceedings of the 21st International Conference on Information Integration and Web-based Applications & Services

Several application domains deal with the management of massive data volumes and thousands of OLTP transactions per second. Traditional relational databases cannot cope with these requirements. NewSQL is a new generation of databases that provides both ...
What's Really New with NewSQL?

A new class of database management systems (DBMSs) called NewSQL tout their ability to scale modern on-line transaction processing (OLTP) workloads in a way that is not possible with legacy systems. The term NewSQL was first used by one of the authors ...
An Open Source Cloud-Based NoSQL and NewSQL Database Benchmarking Platform for IoT Data
Benchmarking, Measuring, and Optimizing
Abstract
Internet of Things (IoT) is continually expanding, and the information being transmitted through IoT is often in large-scale in both volume and velocity. With its evolution, IoT raises new challenges such as throughput and scalability of software ...

Comments

Information & Contributors

Information

Published In

cover image ACM Other conferences

iiWAS2019: Proceedings of the 21st International Conference on Information Integration and Web-based Applications & Services

December 2019

709 pages

ISBN:9781450371797

DOI:10.1145/3366030

Copyright © 2019 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

In-Cooperation

JKU: Johannes Kepler Universität Linz
@WAS: International Organization of Information Integration and Web-based Applications and Services

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 22 February 2020

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Research-article
Research
Refereed limited

Funding Sources

Coordenação de Aperfeiçoamento de Pessoal de Nível Superior - Brasil (CAPES)

Conference

iiWAS2019

iiWAS2019: The 21st International Conference on Information Integration and Web-based Applications & Services

December 2 - 4, 2019

Munich, Germany

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

4
Total Citations
View Citations
358
Total Downloads

Downloads (Last 12 months)26
Downloads (Last 6 weeks)3

Reflects downloads up to 03 Feb 2025

Other Metrics

View Author Metrics

Citations

Cited By

Nascimento BSantos RAbbasi MMartins PSilva JVáz P(2023)Scalability and Performance Evaluation of NewSQL and Relational Databases: A Comparative Benchmark Study2023 Second International Conference On Smart Technologies For Smart Nation (SmartTechCon)10.1109/SmartTechCon57526.2023.10391567(908-913)Online publication date: 18-Aug-2023
https://doi.org/10.1109/SmartTechCon57526.2023.10391567
Espinel Sarmiento DLebre ANussbaum LChari A(2021)Decentralized SDN Control Plane for a Distributed Cloud-Edge Infrastructure: A SurveyIEEE Communications Surveys & Tutorials10.1109/COMST.2021.305029723:1(256-281)Online publication date: Sep-2022
https://doi.org/10.1109/COMST.2021.3050297
Vicente AEtcheverry LSabiguero A(2021)An RDBMS-only architecture for web applications2021 XLVII Latin American Computing Conference (CLEI)10.1109/CLEI53233.2021.9640017(1-9)Online publication date: 25-Oct-2021
https://doi.org/10.1109/CLEI53233.2021.9640017
Chaudhry NYousaf M(2020)Architectural assessment of NoSQL and NewSQL systemsDistributed and Parallel Databases10.1007/s10619-020-07310-1Online publication date: 26-Aug-2020
https://doi.org/10.1007/s10619-020-07310-1

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Figures

Tables

Media

View Table of Conten