Skip to content
Blog

Articles about Time series

Time Series Forecasting with SQL

Time Series Forecasting with SQL: DATE_BIN, Window Functions, and Rolling Aggregations

Transform time series data processing by leveraging SQL for feature engineering, eliminating latency and enhancing real-time analysis with effective aggregation techniques.

Read more

Anomaly Detection on Industrial Sensor Data: Beyond Threshold Alerts

Anomaly Detection on Industrial Sensor Data: Beyond Threshold Alerts

Discover how Isolation Forest anomaly detection can enhance industrial sensor data analysis, moving beyond static thresholds to provide context and insights for predictive maintenance.

Read more

SQL feature engineering for time series ML

How to Use SQL for ML Feature Engineering on Time-Series Sensor Data

Discover how to leverage SQL for efficient feature engineering on time-series sensor data, enhancing machine learning model accuracy without memory bottlenecks.

Read more

Why Industrial Teams Are Moving from Flux and InfluxQL to Standard SQL

Why Industrial Teams Are Moving from Flux and InfluxQL to Standard SQL

Explore the challenges of migrating between InfluxDB query languages and discover the advantages of standard SQL for industrial IoT analytics.

Read more

Comparing MongoDB, TimescaleDB, InfluxDB, and CrateDB for an IIoT Use-case

Comparing MongoDB, TimescaleDB, InfluxDB, and CrateDB for an IIoT Use-case

In this blog post, we compare how MongoDB, TimescaleDB, InfluxDB, and CrateDB perform for an industrial IoT use-case.

Read more

IoT Analytics at Scale: Architecture Guide for Industrial Data

IoT Analytics at Scale: Architecture Guide for Industrial Data

Build real-time industrial IoT analytics with Telegraf, CrateDB, and Grafana. SQL examples, architecture patterns, and proof from ALPLA, ABB, and TGW. Learn more.

Read more

OEE Analytics on Live Data: How to Move from Nightly Exports to Real-Time Dashboards

OEE Analytics on Live Data: How to Move from Nightly Exports to Real-Time Dashboards

Learn why batch export architectures make OEE dashboards too slow for shift supervisors, and how manufacturing teams cut query times from 3 to 5 minutes to milliseconds with a real-time analytics database

Read more

Data historian vs time series database

Data Historian vs. Time Series Database: Which Belongs in Your Industrial Stack

Compare data historians and time series databases on OT connectivity, query language, and analytics depth. Learn why most industrial stacks benefit from both.

Read more

The InfluxDB Cardinality Problem: Why High-Cardinality Industrial Data Breaks It

The InfluxDB Cardinality Problem: Why High-Cardinality Industrial Data Breaks It

Learn why InfluxDB's TSM storage model hits a cardinality wall at industrial scale, and how CrateDB stores 900 sensor types in a single table without a series ceiling.

Read more

The New Industrial Data Stack: Managing Billions of IoT Events in Real Time

The New Industrial Data Stack: Managing Billions of IoT Events in Real Time

Managing billions of IoT events requires a new data architecture. Discover how CrateDB enables real-time analytics for industrial systems.

Read more