• OmniMES logoOmniMES
  • Courses
  • Implementation
  • Blog
  • OmniMES News
  • About
  • Contact
All posts
  • OmniMES (26)
  • AI (16)
  • MES System (13)
  • Omnimes (7)
  • industry50 (6)
  • Smart Factory (6)
  • MES (6)
  • Industry 5.0 (6)
  • UE (5)
  • time-series data (4)
  • AGENT AI (4)
  • Sparkplug B (4)
  • robotics (3)
  • XGBoost (3)
  • Data Security (3)
  • Digital Twin (3)
  • IIoT (3)
  • Industry 4.0 (3)
  • MQTT (3)
  • EMS (2)
  • TimescaleDB (2)
  • nvidia (2)
  • AI local (2)
  • Data Visualization (2)
  • redash (2)
  • mongoDb (2)
  • Production efficiency (2)
  • Lean Manufacturing (2)
  • IoT Communication (2)
  • OmniEnergy (2)
  • energy consumption monitoring (2)
  • LLM Models (2)
  • HMI (2)
  • Data Analysis (2)
  • AI (2)
  • IoT (2)
  • TensorFlow (2)
  • LightGBM (2)
  • CatBoost (2)
  • industrial automation (2)
  • Communication Protocol (2)
  • CBAM (1)
  • Apache Iceberg (1)

  • PostgreSQL (1)
  • cyberbezpieczenstwo (1)
  • NIS2 (1)
  • DPP (1)
  • AI Act (1)
  • MCP (1)
  • przemysł50 (1)
  • Production Data (1)
  • Technologie MES (1)
  • omniverse (1)
  • deepseek (1)
  • UNS (1)
  • Data, (1)
  • digital factory (1)
  • IndustrialIoT (1)
  • IndustrialIT (1)
  • it-ot (1)
  • cybersecurity (1)
  • Production analysis (1)
  • renewable sources (1)
  • omnicloud (1)
  • saas (1)
  • on premise (1)
  • 7 Wastes of Muda (1)
  • energy efficiency (1)
  • ISO 50001 (1)
  • docker (1)
  • Micro Services (1)
  • Maintenance (1)
  • Micro-downtime (1)
  • Bigquery AI (1)
  • Google Cloud (1)
  • Database Vector (1)
  • Quality (1)
  • ROI (1)
  • OmniMES (1)
  • 5G (1)
  • langchain (1)
  • faiss (1)
  • gpt (1)
  • documentation (1)
  • ai-assistant (1)
  • OEE (1)
  • Green Energy (1)
  • Web3 (1)
  • blockchain (1)
  • RES (1)
  • renewable energy sources (1)
  • energy tokenization (1)
  • smart contracts (1)
  • automated settlements (1)
  • P2P energy trading (1)
  • sustainable energy (1)
  • InfluxDB (1)
  • time-series data analysis (1)
  • PyTorch (1)
  • industrial data (1)
  • algorithm comparison (1)
  • industrial data collection (1)
  • machine data (1)
  • machine learning in industry (1)
  • algorithm performance (1)
  • XGBoost (1)
  • LightGBM (1)
  • CatBoost (1)
  • MES Systems (1)
  • Fault Detection (1)
  • llama3 (1)
  • Meta (1)
  • Gemma (1)
  • Mistral (1)
  • GPT-4 (1)
  • GPT-3.5 (1)
  • big data (1)
  • Reports (1)
  • GPT-4 API (1)
  • OPC UA (1)
  • Client/Server Architecture (1)
  • Data Standardization (1)
  • QoS (1)
  • Communication Standards (1)
  • Published on
    June 16, 2026

    Industrial data lake with Apache Iceberg + DuckDB + TimescaleDB: how a modern MES bridges hot, warm and cold storage

    time-series dataTimescaleDBApache IcebergOmniMES
    TimescaleDB handles time-series from the last 1–90 days (hot) excellently, but at 5+ years of history the cost of PostgreSQL SSD and RAM grows faster than the business value. Apache Iceberg (a table format for the data lake) plus DuckDB (a local SQL engine) deliver a cheaper warm tier (90–730 days) and cold tier (>2 years) on S3 or MinIO. A 3-tier architecture cuts storage cost by 80–95% while keeping data queryable. This article shows how to build it for MES, where the limits are, what it costs, and how to migrate from a monolithic TimescaleDB.
OmniMES logoOmniMES

Innovative production execution system - Your eye on the production process

  • Home
  • Blog
  • About
  • function
  • Contact
  • FAQ
  • Offer
  • Privacy Policy
  • Tags
  • Terms
  • OmniMES News
x.com/OmnimesOfficialyoutube.com/@omni-mes
© 2021–2026 OmniMES™. All Rights Reserved.