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:
|Access||ANSI SQL||ANSI 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|
|Full-text search||Built-in (Lucene indexing)||Not built-in|
|Time series analysis||Built-in||Not built-in|
|Backup & Restore||Full and incremental||Full and incremental|
CrateDB Comparison Resources
CrateDB vs. PostgreSQL
How CrateDB query performance compares to a traditional SQL DBMS (PostgreSQL).
Comparing SQL, NoSQL & CrateDB
How SQL and NoSQL technologies are coming together to form a new generation of databases.
Time Series DBS
Learn about functional differences between CrateDB time series and databases like InfluxDB.