DevOps Articles

Getting Started With Distributed SQL

In recent years, NoSQL distributed databases have become common, as they are built from the ground up to be distributed.

This Refcard serves as a reference to the key characteristics of distributed SQL databases and provides information on the benefits of these databases, as well as insights into query design and execution.

Distributed SQL databases, by contrast, offer the benefits of scale-out, while also providing consistency and an ANSI-compliant SQL interface.

Distributed SQL databases accomplish this by the use of an architecture that's made up of three layers: SQL API, distributed query execution, and distributed storage.

Distributed SQL architecture is fundamentally designed to efficiently execute any join query with a single sharded table and as many reference tables as you’d like.