CrateDB vs. Traditional RDBMS

Differences between CrateDB & traditional relational SQL databases

CrateDB –The SQL DBMS, Reinvented

CrateDB is a distributed SQL database built on top of a NoSQL foundation. Its unique design provides the familiarity and ease of SQL, combined with the data flexibility and scalability associated with NoSQL data stores.

Here’s how CrateDB compares to traditional, relational databases like Oracle, SQL Server, MySQL, and PostgresSQL:

Traditional SQL
Core architecture Masterless (no single point of failure) Monolithic or master/slave (single point of failure)
Data model Dynamic schema, structured & unstructured data Rigid schemas of tabular data
Consistency model Eventually consistent ACID
Scalability model Elastic scale-out with linearly scalable performance Scale up on expensive hardware (e.g., ORACLE Exadata)
Real-time query performance Yes, via columnar field caches and full-mesh distributed processing No
Partitioning Built-in with automatic data sharding, replication, and re-balancing as cluster changes size. Manual partitioning
High availability Always-on via automatic intra- and inter-cluster replication & failover with active replicas to increase performance General replication to a stand-by or read-only mirrored database
SQL Joins, Sub-queries, and Aggregations Yes Yes
Microservices architecture Yes, easy to operate via container platforms No
User-defined functions Yes Yes
Full-text search Built-in  (Lucene indexing) Not built-in
Time series analysis Built-in Not built-in
Geospatial queries Built-in Yes
Backup & Restore Full and incremental Full and incremental
Resource Library

CrateDB Comparison Resources

Words Vs standing for Comparison on a lightcyan background with rectangles on it
White Paper

CrateDB vs. PostgreSQL

How CrateDB query per­formance compares to a traditional SQL DBMS (PostgreSQL).

Words VS representing Comparison on a white background with lines and rectangles in different sizes
White Paper

Comparing SQL, NoSQL & CrateDB

How SQL and NoSQL technologies are coming together to form a new generation of databases.

Words Vs representing Comparison on a lightgrey background with lines and rectangles on it
White Paper

CrateDB vs.
Time Series DBS

Learn about functional differences between CrateDB time series and databases like InfluxDB.

Words VS representing a Comparison written on cyan background with lines and rectangles in different sizes

CrateDB vs. Elasticsearch

Let us guide you through the differences in the CrateDB and Elasticsearch experience.