Webinar: Building a Real-Time Platform for Millions of Smart Meter Events

Register Now
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

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

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

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

Why Industrial IoT Data Breaks Traditional Databases

Why Industrial IoT Data Breaks Traditional Databases

Discover why traditional databases struggle with industrial IoT data and how CrateDB's architecture addresses challenges like velocity, schema changes, and high cardinality.

Read more

Beyond Time-Series: Why Modern IIoT Architectures Demand High-Cardinality Analytics, Flexible JSON, and Unified Observability

Beyond Time-Series: Why Modern IIoT Architectures Demand High-Cardinality Analytics, Flexible JSON, and Unified Observability

CrateDB enables high-cardinality IoT analytics, flexible JSON and search, edge-to-cloud IIoT, and unified machine-data observability in one distributed SQL engine.

Read more

Why Time Series Data Without Context Is Just Noise

Why Time Series Data Without Context Is Just Noise

Context transforms time series data into actionable insights. Discover how integrating metrics with metadata overcomes common analytics challenges and enables real-time, intelligent decision-making.

Read more

High-Cardinality Database for Time Series Analytics: Why Dimensions Matter and Where CrateDB Excels

High-Cardinality Database for Time Series Analytics: Why Dimensions Matter and Where CrateDB Excels

Discover how CrateDB excels in high-cardinality time series analytics, offering real-time, flexible, and scalable SQL-based solutions for modern data challenges.

Read more

IoT Analytics - Query Live Device data

IoT Analytics: Turning Real Time Device Data into Actionable Insights

Discover how IoT analytics transforms real-time device data into actionable insights, optimizing operations and enhancing decision-making across industries.

Read more