New database aims to enhance resilience, performance, interoperability, compliance, and security for IoT

Johannes Moser of Crate.io

Crate.io, developer and supplier of CrateDB IoT-optimised database technology, released CrateDB 4.0. With updates that address several components of the highly scalable open source database, 4.0 is said to make it easier, faster, and more cost-effective for IoT- and IIoT-fueled organisations to put their machine and sensor data to work.

CrateDB is a distributed SQL database based on a NoSQL architecture that takes advantage of the convenience of SQL for processing any structured or unstructured data type. Dynamic schemas make it extremely easy to add new data types or indexes, and the architecture allows horizontal scaling by interconnecting servers to capture millions of IoT and IIoT data inputs per second (totaling hundreds of terabytes in cluster size). Distributed processing, data partitioning, and in-memory indexes return millisecond responses to time-series requests – even when many clients are working in the database simultaneously.

Benefits of what’s new in CrateDB 4.0 include:

  • Easier to work with time-series data via improvements to the options for specifying a frame for window functions.
  • Better clustering and node discovery by moving to Zen 2 to stay in sync with Elasticsearch.
  • More PosgreSQL interoperability with synced data types names, synced timestamp formatting, the addition of the pg_catalog schema with its associated tables, and new functions that some tools require when connecting.
  • Improved ANSI SQL compliance through new support for the default clause in the CRATE TABLE statement, among other changes.
  • Stricter access controls with the introduction of a dedicated privilege type for administrative tasks; masking of sensitive information has also been added to further bolster security when handling Azure and AWS credentials.

CrateDB has consistently proven valuable to organisations where vast amounts of sensor and machine data (in a variety of formats) need to be instantly and continually captured, stored, and analysed. Deployed and trusted by large enterprises including Nokia, Gantner Instruments, Qualtrics, Comcast, and ALPLA, CrateDB handles millions of data points per second with fast, linearly-scalable data ingestion.

“CrateDB 4.0 is an important release for our userbase,” said Johannes Moser, head of Product at Crate.io. “Fast access to secure data – massive, massive volumes of data – is so crucial to IoT and IIoT applications, and we’re proud to continue to find new ways to improve our core database to meet customer requirements.”

Comment on this article below or via Twitter: @IoTNow_OR @jcIoTnow

Recent Articles

What private blockchain means to telcos

Posted on: August 2, 2021

While the telecoms sector is yet to fully embrace blockchain technology, Jonas Lundqvist, CEO at Haidrun, says that the arrival of private blockchain may change that and unlock a massive potential for telecom service providers to create new businesses and revenue streams.

Read more

The Chinese market is expected to lead the development of V2X

Posted on: August 2, 2021

According to a new research report from the IoT analyst firm Berg Insight, there were about 0.7 million cars with V2X capabilities on the roads at the end of 2020. This number is expected to grow to 35.1 million by 2025. Communications between vehicles has been discussed for more than two decades, but with few

Read more