- Data immediately available for query upon ingestion
- Ad-hoc queries across billions of records in a few milliseconds
- Hyper-fast aggregations using columnar storage
- No need to downsample or pre-aggregate data
- In-memory SQL query performance thanks to parallel query processing and distributed columnar field caches
- Fully distributed query engine leveraging the power of Apache Lucene®
"Working with CrateDB brings positive outcomes. The ingestion and throughput have very good performance, with 1 million values/sec, the horizontal scalability where we can add as many nodes as we need and the automatic query distribution across the whole cluster"
Lead, Digital Strategy and Business Development at ABB
CrateDB helped ABB achieve:
|1 Mill values/sec||30k to 120k event/sec|
|Data ingestion||Event retrieval|
"Thanks to CrateDB's great indexing, dedicated data types, and subsequent great performance, we could execute an event and data-driven architecture, with the performance and scalability necessary for storing time-series data over time. The SQL query syntax capability of CrateDB also played a part in achieving this great outcome, as it made it easy for the team to write good performing queries using existing know-how. CrateDB is now an integral part of our big data streaming architecture and it is delivering as promised."
Principal Solution Architect
Thomas Concrete Group
"Most of the cars in our customers' fleets are in use almost 24 hours a day, and we need to store and analyse the massive amounts of data they generate in real time. We tried a few different SQL and NoSQL databases, and CrateDB offered the best combination of high performance, scalability and ease of use."
"CrateDB was a better solution for our needs than any other SQL or NoSQL database we tried. It was easy to migrate code off of our legacy SQL database and onto CrateDB to immediately benefit from its data flexibility and scalable performance."
Director of Architecture
CrateDB at Berlin Buzzwords 2023
When ms matter: Maximizing query performance in CrateDB
Query Planning and Optimizations
Redefining warehouse intelligence with CrateDB
"Our distribution centers produce a lot of sensor data and we enable our customers to take data driven decisions. CrateDB allows us to operate on any Cloud and on-prem/Edge with simplicity and stellar performance, and significant cost advantages."
Owner Connected Warehouse Architecture
TGW Logistics Group