CrateDB is a distributed SQL database that is built on a NoSQL basis. It combines the familiarity of SQL with the scalability and data flexibility of NoSQL.
Customers often use CrateDB to store and query machine data. This is because CrateDB makes the handling of speed, volume, and variety of machine and log data easy and economical. Customers have reported that CrateDB captures millions of data points per second while querying terabytes of data in real-time – 20 times faster than their previous database and with 75% less database hardware. Growing a database should be easy, just like CrateDB. With the automatic
redistribution of data and a shared-nothing architecture, you can easily scale. Simply add new machines to create and expand a CrateDB cluster. You don‘t need to know how to redistribute data in the cluster because CrateDB does it for you.
Openness and flexibility
Run CrateDB anywhere in your data center or in the cloud Connect to CrateDB from almost any language, SQL application or SQL BI tool Expand the CrateDB functionality by writing your plug-ins Deploy CrateDB as a container on Docker, Kubernetes or other systems.
Distributed SQL queries
CrateDB‘s distributed SQL query engine has column field caches and a more modern query planner.
Even if something goes wrong in your data center, CrateDB continues to run. Automatic replication of data in your cluster ensures that errors do not interrupt data access. Also, CrateDB clusters are self-healing.
Real-time data acquisition
Analytical data is often loaded in batches with transaction locks and other overhead. In contrast, CrateDB eliminates locking overhead to allow massive write performance.
CrateDB can store incremental snapshots of your database in memory. Snapshots contain the status of the tables in a CrateDB cluster at the time the snapshot was taken.
Any data and BLOBs
CrateDB supports both relational data and nested JSON documents. All nested JSON attributes can be included in any SQL command. Also, CrateDB offers BLOB storage.
Time Series Analysis
With CrateDB, time series can be analyzed quickly and easily. These are automatic table partitions that can be queried,
moved or deleted like virtual tables.
Spatial data queries
The location is important for many machine data to analyze. CrateDB can store and query geographic information with the types of geo_point and geo_shape.
In contrast to many other SQL databases, CrateDB schemes are completely flexible. You can add columns at any time without affecting performance or downtime. This is ideal for agile development and rapid deployment.
CrateDB is consistent but offers transaction semantics. CrateDB is consistent at the row level, so each row is either fully written or not. Thanks to the read-after-write consistency, we enable synchronously real-time access to individual data records immediately after they have been written.