SingleStore logo
refcard

Getting Started With Distributed SQL

Book IconDownload Now
Getting Started with Distributed SQL Cover

What You'll Learnwhat-youll-learn

In recent years, the use of NoSQL databases has become widespread, because there is a great need for distributed databases. NoSQL databases - unlike traditional relational databases - are built from the ground up to be distributed. Yet NoSQL has significant negatives, such as the lack of data consistency, vulnerabilities around data integrity, and slow and hard-to-write queries, due to the inherent lack of SQL support. Now there is a new class of databases: distributed SQL databases, also known as NewSQL.

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 optimal query design, to get the most out of this architectural pattern.

Database Icon
The Need for Distributed SQL

Distributed SQL databases offer advantages for new, modern, cloud-native applications.

Server Icon
Sharding Middleware

A precursor to distributed SQL that supports the distribution of a single-server database, such as MySQL, across multiple independent servers.

Clipboard List Check Icon
Distributed SQL Architecture

Can run both transactional and analytical workloads by the use of an architecture that's made up of three layers: (i) distributed storage, (ii) distributed query execution, and (iii) SQL API.

Table Icon
Comparing Architectures of Distributed SQL Databases

Shared-everything (e.g. MySQL, PostgreSQL); shared-storage (e.g. Oracle Exadata, Snowflake, Google BigQuery); shared-nothing (e.g. SingleStore, VoltDB)

Code Icon
Query Execution Architecture

How the Data Definition Language (DDL) and Data Manipulation Language (DML) affect query design.

Book Icon
Distributed DDL, Distributed DML, and Distributed Joins

Insights into query design and execution for optimal performance at scale

Get This Free Refcard Todayget-this-free-refcard-today

Learn key characteristics of distributed SQL databases, benefits of these databases, as well as insights into query design and execution.

Ref card trifold

Download Refcard

Submit the form below to receive a copy of the Refcard.
By clicking the button below you understand SingleStore will retain and process your personal information in accordance with our Privacy Policy.

SingleStoreDB is The Real-Time Distributed SQL Database, designed for data-intensive applications.single-store-db-is-the-real-time-distributed-sql-database-designed-for-data-intensive-applications

The cloud-native operational database built for speed and scale

real-time-alt
SPEED

Accelerate business with instant insights delivered by the world’s fastest database for operational analytics

singlestore-database
SCALE

Create your future on a platform made for the demands of the data revolution, including machine learning and AI

sql-scale
SQL

Transform on your terms - with the familiarity and efficiency of SQL, and an architecture that bursts through limits