基于时序数据库的海洋装备监控数据存储系统

Monitoring Data Storage System for Marine Equipment Based on Time Series Database

目前在海洋装备上通常使用关系数据库存储海量监控数据,存在空间占用大、查询性能差的问题。文章提出了基于时序数据库的海洋装备监控数据存储解决方案,并基于国产数据库TDEngine完成了系统工程实现,实现了监控数据的自动建表、自动存储以及快速可视化。经测试表明,该系统的数据压缩和查询性能相比于传统关系型数据库具有明显优势,为解决海洋装备海量监控数据存储的难题提供了良好的解决方法。

At present,relational database is usually used to store massive monitoring data on marine equipment,which has the problems of large space occupation and poor query performance.This paper proposes a solution of monitoring data storage for marine equipment based on time series database,and completes the system engineering implementation based on the domestic database TDEngine,which realizes automatic table building,automatic storage and rapid visualization of monitoring data.The tests show that the data compression and query performance of the system has obvious advantages over traditional relational database,which provides a good solution to the difficult problem of massive monitoring data storage for marine equipment.