Skip to Main content Skip to Navigation
Journal articles

Distributed Database Systems: The Case for NewSQL

Patrick Valduriez 1 Ricardo Jimenez-Peris 2 M. Tamer Özsu 3
1 ZENITH - Scientific Data Management
LIRMM - Laboratoire d'Informatique de Robotique et de Microélectronique de Montpellier, CRISAM - Inria Sophia Antipolis - Méditerranée
Abstract : Until a decade ago, the database world was all SQL, distributed, sometimes replicated, and fully consistent. Then, web and cloud applications emerged that need to deal with complex big data, and NoSQL came in to address their requirements, trading consistency for scalability and availability. NewSQL has been the latest technology in the big data management landscape, combining the scalability and availability of NoSQL with the consistency and usability of SQL. By blending capabilities only available in different kinds of database systems such as fast data ingestion and SQL queries and by providing online analytics over operational data, NewSQL opens up new opportunities in many application domains where real-time decisions are critical. NewSQL may also simplify data management, by removing the traditional separation between NoSQL and SQL (ingest data fast, query it with SQL), as well as between operational database and data warehouse / data lake (no more ETLs!). However, a hard problem is scaling out transactions in mixed operational and analytical (HTAP) workloads over big data, possibly coming from different data stores (HDFS, SQL, NoSQL). Today, only a few NewSQL systems have solved this problem. In this paper, we make the case for NewSQL, introducing their basic principles from distributed database systems and illustrating with Spanner and LeanXcale, two of the most advanced systems in terms of scalable transaction management.
Document type :
Journal articles
Complete list of metadata

https://hal-lirmm.ccsd.cnrs.fr/lirmm-03228968
Contributor : Patrick Valduriez <>
Submitted on : Tuesday, May 18, 2021 - 3:18:11 PM
Last modification on : Wednesday, May 19, 2021 - 3:33:29 AM

File

Newsql case-TLDKS 2021.pdf
Files produced by the author(s)

Identifiers

Collections

Citation

Patrick Valduriez, Ricardo Jimenez-Peris, M. Tamer Özsu. Distributed Database Systems: The Case for NewSQL. Transactions on Large-Scale Data- and Knowledge-Centered Systems, Springer Berlin / Heidelberg, 2021, Lecture Notes in Computer Science, 12670, pp.1-15. ⟨10.1007/978-3-662-63519-3_1⟩. ⟨lirmm-03228968⟩

Share

Metrics

Record views

27

Files downloads

76