CrateDB for Industrial Time Series

The SQL database for complex, large scale time series workloads in industrial IoT.

CrateDB vs. InfluxDB Benchmark

Download the report

Time series data processing is critically important to most IoT and machine data use cases.

Industrial IoT presents an unusually challenging time series data use case. It is orders of magnitude larger in scale and complexity than other time series workloads, such as those found in IT systems monitoring.

Industrial Time Series Data in Smart Factories

Connected factories, energy networks, smart city infrastructure, and vehicle fleets generate a massive amount of complex time series data. Here are some real-life stats from manufacturing companies Crate.io works with:

  • Data flowing from 100+ factories and 1000+ production lines
  • 1,000 different sensor message data structures
  • 900,000 inserts per day
  • 100+ terabytes of retained data
  • Real-time dashboards executing ~ 1 million queries per day

If your time series data requirements look similar, then time series databases (TSDBs) like InfluxDB, and AWS Timestream may not be able to cope. They are built for smaller time series data use cases like IT monitoring.

Advantages

Using CrateDB for Industrial Time Series Data

CrateDB is built for industrial time series data. As an ANSI SQL DBMS, CrateDB is easy to learn, easy to integrate, and does not lock you into proprietary data access interfaces as so many TSDBs do. Here are some reasons people choose CrateDB to manage industrial time series data:

Real-time query performance

Partitioning, parallel processing and in-memory columnar indexes enable real-time, complex analytics & AI on time series data, not just simple aggregates.

Millions of data points per second

Distributed processing, data partitioning, and multi-threaded architecture enable fast, linearly scalable time series data ingestion.

Extensible time series data models

Elegant JSON handling and Dynamic Schema. Automatically adapts schema to new JSON structures.

Scales without limits

Elastic scaling, partitioning, sharding, & replication for fast, always-on performance that stays consistent as data volume and concurrent clients grow.

Time Series Data & SQL Interfaces

Built-in interfaces to MQTT, Azure IoT Hub, Azure Event Hubs, Prometheus, Telegraf, and most any SQL tool via Postgres wire protocol, JDBC, and REST.

Built-in high availability

Automatic replication & self-healing for non-stop performance

White Paper

CrateDB vs. Time Series DBs

In a benchmark querying 314 million rows of sensor readings, CrateDB executed 10x more queries per second under load than InfluxDB.

Resource Library

Industrial Time Series Data Resources

Icon CrateDB for IoT
White Paper

CrateDB Technical Overview

Designing a SQL DBMS for industrial time series data.

Writing Cloud and a Cloud Icon in Blue next to it on a white Background with lines and rectangles
Free Trial

CrateDB Cloud for Azure IoT

Get a free CrateDB trial account, hosted on Microsoft Azure.

Icon visualizing the Scalability of databases
Webinar

Time Series DB Design Techniques

Distributed SQL best practices for fast, scalable, always-on time series.

Silhouttes of bottles in different sizes
Customer Story

Industrial Time Series at ALPLA

Manufacturer modernizes 180 factories with industrial times series data in CrateDB-powered IIoT platform.