IoT Database - Fast, Scalable and Cost-efficient

In the world of Internet of Things, managing the volume, variety, and speed of data collected is a constant challenge. With its fast data ingestion, versatile data modeling, and real-time querying capabilities, CrateDB helps businesses harness the full value of high-volume data from thousands of sensors.

Traditional IoT database systems frequently struggle to keep up with the massive volumes of data generated by thousands of sensors. CrateDB overcomes this challenge by providing fast, scalable data ingestion, processing millions of IoT data points per second, while indexing and making data available for query in real-time. This enables businesses to achieve real-time monitoring, improved operational efficiency, and faster decision-making.

High performance

Data is available for query instantly after data ingestion
Response-time in milliseconds - even for complex ad-hoc queries across billions of records - thanks to a fully distributed query engine
Data aggregations on the fly thanks to columnar storage

Easy scaling

CrateDB's scalability ensures it can handle large volumes of IoT data continuously coming in from different sources, accommodating the demands of industrial environments.

Time-series

CrateDB offers all features of an advanced time-series database and you keep getting query results in milliseconds, even for complex queries, multiple data types and high ingest rates, while storing years of data.

Versatile data model

CrateDB offers a versatile data model that supports a wide range of data types, e.g., geospatial data, time-series data, and BLOB. The solution is particularly well-suited for industrial IoT projects that encounter the challenge of handling vast quantities of diverse data.

Dynamic schema

CrateDB's dynamic schema capability allows IoT projects to seamlessly incorporate new sensor types and data structures in real-time.

Fault tolerance built-in

CrateDB has built-in data replication and cluster rebalancing mechanisms, providing fault tolerance to ensure uninterrupted operations and high availability.

Easy and seamless integrations

CratDB offers a seamless integration process with popular IoT stack software such as Kafka, Grafana, Node-RED, and more.

View a sample list of integrations >

Know more about the product

Examples of IoT queries

        
        
/* Based on IoT devices reports, this query returns the voltage variation over time

   for a given meter_id */
WITH avg_voltage_all AS (
    SELECT meter_id,
           avg("Voltage") AS avg_voltage,
           date_bin('1 hour'::INTERVAL, ts, 0) AS time
    FROM iot.power_consumption
    WHERE meter_id = '840072572S'
    GROUP BY 1, 3
    ORDER BY 3
)
SELECT time,
       (avg_voltage - lag(avg_voltage) over (PARTITION BY meter_id ORDER BY time)) AS var_voltage
FROM avg_voltage_all
LIMIT 10;

        
        
+---------------+-----------------------+
|          time |           var_voltage |
+---------------+-----------------------+
| 1166338800000 | NULL                  |
| 1166479200000 |   -2.30999755859375   |
| 1166529600000 |    4.17999267578125   |
| 1166576400000 |   -0.3699951171875    |
| 1166734800000 |   -3.7100067138671875 |
| 1166785200000 |   -1.5399932861328125 |
| 1166893200000 |   -3.839996337890625  |
| 1166997600000 |    9.25               |
| 1167044400000 |    0.4499969482421875 |
| 1167174000000 |    3.220001220703125  |
+---------------+-----------------------+

        
        
/* Based on IoT devices reports, this query returns the voltage corresponding to

   the maximum global active power for each meter_id */
SELECT meter_id,
       max_by("Voltage", "Global_active_power") AS voltage_max_global_power
FROM iot.power_consumption
GROUP BY 1
ORDER BY 2 DESC
LIMIT 10;

        
        
+------------+--------------------------+
| meter_id   | voltage_max_global_power |
+------------+--------------------------+
| 840070437W |                   246.77 |
| 840073628P |                   246.69 |
| 840074265G |                   246.54 |
| 840070238E |                   246.35 |
| 840070335K |                   246.34 |
| 840075190M |                   245.15 |
| 840072876X |                   244.81 |
| 840070636M |                   242.98 |
| 84007B113A |                   242.93 |
| 840073250D |                   242.28 |
+------------+--------------------------+

        
        
/* Based on IoT devices reports, this query returns the voltage corresponding to

   the maximum global active power for each meter_id */
SELECT meter_id,
       MAX_BY("Voltage", "Global_active_power") AS voltage_max_global_power
FROM iot.power_consumption 
GROUP BY 1 
LIMIT 10;

        
        
+------------+--------------------------+
|   meter_id | voltage_max_global_power |
+------------+--------------------------+
| 840073190N |          233.57          |
| 840072401F |          233.53          |
| 840072655G |          234.1           |
| 840071893D |          234.47          |
| 840073950P |          231.73          |
| 840075260N |          235.51          | 
| 840076398A |          234.56          |
| 84007B071E |          231.94          |
| 840075959Y |          237.21          |
| 840072534A |          231.96          |
+------------+--------------------------+

Industrial IoT, Mining & Oil

SPGo! is part of PETROMIN, which has more than 23 years of experience in the mining and oil industries. They build applications for monitoring all material conveyor belt idlers every minute 24 hours a day through online sensors. They use CrateDB as a central database to capture and query data from 30,000 sensors per mine, representing 760 million records a day.

"With CrateDB, we can continue designing products that add value to our customers. We will continue to rely on CrateDB when we need a database that offers great scalability, reliability and speed."

Nixon Monge Calle
Head of IT Development and Projects
SPGo! Business Intelligence

Industrial IoT, Time-series, Construction

Thomas Concrete Group is the world- leader organization in the construction industry with 150+ concrete plants and 2,100+ employees. They use CrateDB both for tracking of their delivery trucks and tracking the curing of the concrete in real-time.

"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."

Kristoffer Axelsson
Principal Solution Architect
Thomas Concrete Group

Industrial IoT, Electronics

Roomonitor specializes in IoT climate control systems that monitor and control air conditioning for the hospitality industry. They use CrateDB as an IoT database able to give property managers real-time insight to monitor air conditioning costs and tenant comfort.

"CrateDB's unmatched concurrency capabilities and simple scaling made it the best solution for us. We tried other solutions, including MongoDB, but it was difficult and expensive to scale for our needs. Plus, CrateDB is SQL, which 90 percent of today's developers know well, and that makes hiring new developers easier."

Waseem Javid Nasiri
Senior developer
Roomonitor

Industrial IoT, Manufacturing

"We collect continuous production data on the shopfloor and capture huge volumes of raw data long-tern for advanced data science going forward. CrateDB makes this very easy for us."

Philipp Lehner
CEO
ALPLA

White Paper

Industrial IoT in 2023 and beyond

In this whitepaper, we will explore three real-life use cases demonstrating the power of IoT technology based on CrateDB.

White Paper

Data and industrial IoT

In order for IIoT projects to succeed, it is crucial to use technologies that have been specifically optimized for this use case. The IIoT implies considerable complexities and particularities in terms of data, and it is unlikely that a database not specialized in IIoT will provide all the necessary requirements.

White Paper

Common misconceptions about Industry 4.0 that manufacturers still believe

While IIoT adoption does require a new approach to managing and analyzing data collected in real-time, this isn’t as difficult as many manufacturers believe.

Webinar

IIoT technology. How SPGo! builds apps for monitoring and predictive maintenance

This webinar showcases how CrateDB facilitated SPGo! in achieving a 30% increase in data-driven predictive maintenance by effectively managing vast amounts of IIoT data from over 40,000 sensors and processing 760 million records daily.

Webinar

How to improve supply chain management with loT data

Learn how Thomas Concrete Group is using Create DB to monitor crucial processes of their supply chain, such as the concrete delivery to the customer on-site or the concrete curing process.

Webinar

Why IIoT needs its own database?

In order to bring IIoT projects to success, it is crucial to use the right technology - including the database. In this webinar, you will learn about the potential of IIoT, the characteristics and requirements of IIoT workloads, and a real-life example, showing how success is possible.

Data types

Explore the full list of data types supported by CrateDB.

Logical replication setup between CrateDB clusters

Learn about logical replication, a method of data replication between multiple clusters.

CrateDB on Azure IoT

Read about the reference architecture of CrateDB on Azure IoT.

Optimistic Concurrency Control

Learn how CrateDB achieves Optimistic Concurrency Control using internal system columns (_seq_no and _primary_term), allowing users to understand how to handle optimistic updates and deletes.

How the Thomas Concrete Group is adding value to its customers with IoT projects powered by CrateDB (Part I)

Find out how Thomas Concrete, a world-leader in the concrete business, is adding value to their customers thanks to industrial IoT.

How the Thomas Concrete Group is adding value to its customers with IoT projects powered by CrateDB (Part II)

Thomas Concrete keeps implementing digitalization projects to improve its service. Now, their customers can track the curing of their concrete in real-time, monitoring its strength and temperature through sensor data stored in CrateDB.

Why are IIoT projects failing?

The industrial IoT implies huge advantages for manufacturers. However, to fully implement IIoT projects is being challenging for many industries.

Making Sense of IIoT, Big Data, and Time Series Databases with CrateDB Cloud

Confused about IIoT, time series, and what it all means? We explain the fundamentals, introducing CrateDB Cloud.

4 Myths About IIoT Data Strategy That Manufacturers Still Believe

Myths around the challenges of implementing IIoT systems and building smart factories have made the prospect of adoption unnecessarily intimidating. Let’s take a look at some of the realities behind them.

IoT Database that truly Scales

High performance

Easy scaling

Time-series

Versatile data model

Dynamic schema

Fault tolerance built-in

Easy and seamless integrations

Hybrid Edge Deployment

Interested?

Examples of IoT queries

Want to know more?

Other Industrial IoT resources

White Paper

Industrial IoT in 2023 and beyond

White Paper

Data and industrial IoT

White Paper

Common misconceptions about Industry 4.0 that manufacturers still believe

Webinar

IIoT technology. How SPGo! builds apps for monitoring and predictive maintenance

Webinar

How to improve supply chain management with loT data

Webinar

Why IIoT needs its own database?

Product documentation

Data types

Logical replication setup between CrateDB clusters

CrateDB on Azure IoT

Optimistic Concurrency Control

Blog

How the Thomas Concrete Group is adding value to its customers with IoT projects powered by CrateDB (Part I)

How the Thomas Concrete Group is adding value to its customers with IoT projects powered by CrateDB (Part II)

Why are IIoT projects failing?

Making Sense of IIoT, Big Data, and Time Series Databases with CrateDB Cloud

4 Myths About IIoT Data Strategy That Manufacturers Still Believe

Company

Ecosystem

Contact