Overview

Multiple Data Formats

CrateDB offers support for multiple data formats within a single database and even within a single table, thanks to its dynamic data schema.

• The Multi-model Approach
• Time Series Data
• JSON Data
• Vector Data
• Full-Text Data
• BLOB Data
• Relational Data

Native SQL

CrateDB provides native SQL support, ensuring ease of use, flexibility, and seamless data integration across diverse ecosystems. It supports a broad spectrum of operations, including joins, aggregations, indexes, subqueries, and more, all accessible through SQL. CrateDB's implementation of the PostgreSQL Wire Protocol ensures compatibility with many other solutions.

• Native SQL Syntax
• PostgreSQL Wire Protocol

Distributed Shared-Nothing Architecture

CrateDB employs a distributed shared-nothing architecture, allowing seamless scalability up to hundreds of nodes with minimal operational effort. Each node in the cluster is capable of executing every operation, ensuring equality across all nodes. This promotes high availability, even during data center outages or upgrades.

• Distributed Database
• Node Architecture
• Cluster State Management
• Horizontal Scalability
• High Availability

Data Storage

CrateDB optimizes data storage by partitioning and sharding large tables, ensuring balanced data distribution and improved query performance. It also combines the Lucene Engine and columnar storage to facilitate instant aggregations, advanced indexing strategies, and data replication at the table level for enhanced fault tolerance and read performance.

• Data Storage
• Partitioning
• Sharding
• Replication
• Atomicity, Durability, and Consistency
• Advanced Indexing and Columnar Storage
• Data Tiering: Hot, Warm, and Cold Data 

High-Volume Reads and Writes

CrateDB delivers superior performance by executing complex SQL queries on large datasets in milliseconds. Its distributed execution engine supports high-volume concurrent reads and writes, ensuring robust performance even under heavy loads.

• Query performance
• Distributed Query Engine
• Distributed Reads and Writes

Security

CrateDB ensures secure data management with its encryption and authentication mechanisms. With ISO 27001 certification, CrateDB Cloud meets international standards for information security management systems. CrateDB is also SOC 2 Type 2 compliant on Azure and AWS.

• Security
• Data encryption
• Authorization
• Auditing
• ISO 27001 Certification
• SOC 2 Type 2 Certification

Open Source Licensing Model

CrateDB is an open-source database under the Apache 2.0 License, promoting transparency and flexibility. Its source code is accessible on GitHub, fostering community contributions. Users can customize CrateDB according to their needs or utilize it as a service through the CrateDB Cloud offering.