CrateDB
Read post

Anomaly Detection on Industrial Sensor Data: Beyond Threshold Alerts

Fixed vibration thresholds set years ago degrade over time as equipment changes, generating false alerts and missing real faults. Isolation Forest offers a better approach: trained only on healthy sensor readings, it produces a continuous anomaly score reflecting how statistically unusual a reading is relative to the current fleet baseline. Combined with an XGBoost fault classifier, the two scores create a four-quadrant decision framework — familiar faults, unfamiliar faults, novel anomalies, and normal operation — each mapping to a different operational response. The post walks through training the Isolation Forest with scikit-learn, persisting the model, writing scores to CrateDB alongside fault probabilities, and querying the four quadrants in SQL for Grafana dashboards or maintenance reports. The key insight is that threshold alerting, anomaly detection, and fault classification are complementary layers, not alternatives.

    #machine-learning#data-science#cratedb
Jun 15•9m read time•From cratedb.com
Post cover image
Table of contents
Why fixed thresholds degrade over timeWhat Isolation Forest learns insteadTwo scores, two different questionsThe four-quadrant interpretationHow each detection approach comparesTraining the anomaly detectorWriting anomaly scores to CrateDB and querying themWhere anomaly detection fits in the full ML pipeline
194 Impressions
CrateDB's image
CrateDB

CrateDB offers insights into distributed SQL database, IoT data management, and real-time analytics,...

26 Followers

•

250 Upvotes

Would you recommend this post?

Copy link
WhatsApp
Facebook
X
New Squad
  • © 2026 Daily Dev Ltd.
  • Guidelines
  • Explore
  • Tags
  • Sources
  • Squads
  • Leaderboard