Crate.io debuts CrateDB 4.1 database built to support IoT, IIoT businesses; deliver expanded functionality, improved ease-of-use

Crate.io announced immediate availability of CrateDB 4.1 that primarily utilized for customers’ industrial IoT use cases where particularly large volumes of sensor and machine data in various formats have to be collected, stored, and analyzed in real time. 

CrateDB, a distributed SQL database built on top of a NoSQL foundation, enables the development of complex data management solutions that make manufacturing automation work more effectively and cost-efficiently. It combines the familiarity of SQL with the scalability and data flexibility of NoSQL, enabling developers to use SQL to process any type of data, structured or unstructured; perform SQL queries at real-time speed, even JOINs and aggregates; and scale simply.

Crate.io develops data management solutions that help companies put IoT and machine data to work. CrateDB is an open source distributed database offering the scalability and performance of NoSQL with the power and ease of standard SQL. Crate.io is headquartered in San Francisco with offices in Berlin, New York City, and Dornbirn, Austria.

CrateDB supports both relational data, as well as nested JSON-documents. All nested JSON attributes can be included in any SQL command. In addition, CrateDB provides BLOB storage so as to store and retrieve BLOBs like pictures, videos, or large unstructured files – providing a fully distributed cluster solution for BLOB storage.

Customers often use CrateDB to store and query machine data. This is because CrateDB makes it easy and economical to handle the velocity, volume, and diversity of machine and log data. In fact, customers have reported CrateDB ingesting millions of data points per second, while also querying terabytes of data in real time. It delivers 20 times faster than their previous database and on 75 percent less database hardware.

The release of CrateDB 4.1 introduces a number of additions and improved functionalities designed to meet customer requirements for easily storing and analyzing real-time data. It also enhances window functions for continuous IIoT and time-series data. To facilitate IIoT use cases built on time-series data, CrateDB continues to focus on the implementation of window functions. 

With CrateDB 4.1, customers are now able to fill gaps in their data – a crucial capability as sensors do not always send data. Windows in the query can also now be defined not only by the range, but also via rows. 

Doing so allows CrateDB users to define the window more precisely, making it easier to work with continuous and interval-based data. Additionally, the new window functions now simplify statements for otherwise-complicated windows that are used several times within a query.

The new version handles time-series data gets easier. IoT applications with time-series data continue to be popular CrateDB use cases. One of the major challenges is the transformation of random data into a clean stream of data with a constant interview. CrateDB 4.1 introduces more simplification around this to benefit users.

CrateDB 4.1 adds a number of popular scalar functions for working with strings. It also delivers faster database performance. Crate.io customers often use SELECT DISTINCT on large volumes of data. Queries now run 200 percent faster and require less memory with CrateDB 4.1.

“CrateDB 4.1 focuses on the cutting of data, time-series, stability, and performance enhancements,” explains Johannes Moser, head of product at Crate.io. “Listening to our customers, we have succeeded in making a number of improvements that make the complexity of industrial applications easier to handle for the user and thus contribute to increased efficiency.”

CrateDB 4.1 is now available for download.


IoT Innovator Newsletter

Get the latest updates and industry news in your inbox! Enter your email address and name below to be the first to know.

Name