Distributed Database Systems: The Case for NewSQL - Inria - Institut national de recherche en sciences et technologies du numérique Access content directly
Journal Articles Transactions on Large-Scale Data- and Knowledge-Centered Systems Year : 2021

Distributed Database Systems: The Case for NewSQL

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.
Fichier principal
Vignette du fichier
Newsql case-TLDKS 2021.pdf (455.39 Ko) Télécharger le fichier
Origin Files produced by the author(s)

Dates and versions

lirmm-03228968 , version 1 (18-05-2021)

Identifiers

Cite

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

Altmetric

Share

Gmail Mastodon Facebook X LinkedIn More