Industrial Data¶
Today’s industrial and logistics data acquisition and processing systems are complex and distributed, with a very high degree of automation.
In the realm of Industrial IoT, dealing with diverse data, ranging from slow-moving structured data, to high-frequency measurements, presents unique challenges. The complexities of industrial big data are characterized by its high variety, unstructured features, different data sampling rates, and how these attributes influence data storage, retention, and integration.
Learn how to use CrateDB in long term storage and analytics scenarios for industrial / IIoT / Industry 4.0 application scenarios within engineering, manufacturing, production, and logistics, as well as other operational domains, or within similar environments where billions of data records from any kinds of machines or devices need to be processed, stored, and queried.
With CrateDB, compatible to PostgreSQL, you can do all of that using plain SQL. Other than integrating well with commodity systems using standard database access interfaces like ODBC or JDBC, it provides a proprietary HTTP interface on top.
- Tags:
Data Historian Industrial IoT SCADA MDE
- Technologies:
DAQ PLC SPS
- Product:
- Related:
Document Store • Geospatial Search • Full-Text Search • Raw-Data Analytics • Time Series Data • Machine Learning
ABB Insights¶
Advanced Analytics Platform for Industrial Data.
- Industry:
Engineering Manufacturing Production
- Tags:
Multi Tenancy Data Platform
- Related:
ABB Genix is improving industrial productivity and operational excellence
ABB Genix: Advanced Analytics Platform
Learn how ABB recommends tangible actions to optimize operations and increase asset availability in industrial use cases by analyzing vast amounts of data in real time with CrateDB, in the range of 30k to 120k events/sec, boiling down to a processing rate of roughly 1 million values per second.
ABB Ability™ Genix Industrial Analytics and AI Suite is an advanced analytics platform and application portfolio that unlocks value from industrial data and drives better business results.
With high scalability and easy integration, CrateDB is a strategic database component of ABB Ability™ Genix across industries.
2023
Rauch Insights¶
Scaling a high-speed production environment with CrateDB, to ensure real-time production quality control.
- Industry:
Beverage Food FMCG Packaging Production
- Tags:
Unstructured Data PostgreSQL compatibility Excellency in Support
- Related:
Rauch: High-Speed Production Lines
CrateDB helps Rauch to identify and predict production issues and gives access to production data for many years, with no need for additional infrastructure.
Rauch is filling 33 cans per second and how that adds up to 400 data records per second which are being processed, stored, and analyzed. In total, they are within the range of one to ten billion records persisted in CrateDB.
The use-case of Rauch demonstrates why traditional databases weren’t capable to deal with so many data records and unstructured data. The benefits of CrateDB made Rauch choose it over other databases, such as PostgreSQL compatibility, the support for unstructured data, and its excellent customer support.
2022
SPGo! Insights¶
Monitoring conveyor belts in the mining industry.
- Industry:
Engineering Mining Production
- Tags:
Sensor Data Acquisition Machine Monitoring Predictive Maintenance
- Technologies:
BLE Wireless MQTT
- Related:
SPGo!’s digital inspection of conveyor belts revolutionizes the market with CrateDB
SPGo!: Monitoring and Predictive Maintenance
SPGo!, by PETROMIN, has developed a system that allows monitoring mining material conveyor belts with more than 40,000 sensors in real-time and 760 million records per day. SPGo! trusts CrateDB as a partner on this journey.
120 billion records each years
You will learn about many details of this solution, including real-time component monitoring, predictive failure analysis, management of operations, data-driven predictive maintenance, large daily data intakes, and KPIs that help the mining businesses save resources, workforce, and losses, due to decreased downtime.
2023
TGW Insights¶
Today’s warehouses are complex systems with a very high degree of automation. TGW simplifies aggregating massive volumes of diverse data with CrateDB.
- Industry:
Logistics Shipping Warehouse Intelligence
- Tags:
Sensor Data Acquisition Digital Twin
- Related:
TGW: Connected Warehouses
CrateDB’s support for unstructured data, its fast query engine, scalability, and excellent support, is unparalleled.
TGW Logistics Group implements advanced analytics for automated warehouses they are operating across the globe for customers like Amazon, Coop, and Zalando. Their systems collect a vast amount of data, apply AI to them, and support all kinds of data-driven applications.
TGW removed data silos with all different kinds of data formats, data structures from PLCs, databases, sensor information, etc.
NoSQL databases weren’t a sustainable solution for their use case. On the migration path, it was easy to start with CrateDB, and now it is at the heart of everything they are doing, and gives them peace of mind.
2023
TGW: Data acquisition in high-speed logistics
Storing, querying, and analyzing industrial IoT data and metadata without much hassle.
TGW Logistics Group implements key factors to the successful operation of these warehouses, by having a holistic view on the entire system acquiring data from various components like sensors, PLCs, embedded controllers, and software systems.
TGW states that all these components can be seen as “data silos”, distributed across the entire site, each of them storing just some pieces of information in various data structures and different ways to access it.
After trying multiple database systems, TGW Logistics moved to CrateDB for its ability to aggregate different data formats and the ability to query this information without further ado.
2022
TGW: Challenges in storing and analyzing industrial data
Not All Time Series Are Equal: Challenges in Storing and Analyzing Industrial Data.
In the second presentation, you will learn how TGW leverages CrateDB to build digital twins of physical warehouses around the world, by using its unique set of features suitable for storing and querying complex industrial big data with high variety, unstructured features, and at different data frequencies.
What’s inside
The Complexity of IoT Data: An examination of the unique properties of industrial IoT data, including slow-moving structured information and high-frequency measurements.
Challenges and Solutions: Discussion of the difficulties in data storage, retention, and integration posed by this complexity, and how CrateDB provides a targeted solution.
Real-World Applications: Exploration of actual customer use cases to illustrate how CrateDB can be applied in various industrial scenarios.
2023