基于时序数据库的煤矿数据中台研究与应用  

Research and Application of Coal Mine Data Middle Platform Based on Time Series Database

作　　者：陈运启 Chen Yunqi(Chongqing Research Institute,China Coal Technology and Engineering Group,Chongqing 400039,China;State Key Laboratory of Coal Mine Disaster Prevention and Control,Chongqing 400037,China)

机构地区：[1]中煤科工集团重庆研究院有限公司,重庆400039 [2]煤矿灾害防控全国重点实验室,重庆400037

出　　处：《煤矿机械》2024年第7期147-150,共4页Coal Mine Machinery

基　　金：中国煤炭科工集团科技创新项目(2023-TD-ZD001-005)。

摘　　要：随着各种物联网传感器设备在煤矿的快速推广使用,海量监测监控数据形成了爆发式的增长态势,在提升智能化矿山建设水平的同时,也为数据快速采集与高效存储带来了更大挑战。通过分析煤矿时序数据的特点,对比多种数据存储方案和不同时序数据库之间的性能差异,提出了基于TDengine时序数据库的煤矿数据中台架构,设计了煤矿时序数据超级表结构。现场工业性试验表明,面对海量监测监控数据的应用需求,时序数据库相比关系数据库具有更高的存储效率和更快的查询速率,为智能化矿山建设提供了更有力的数据支撑。With the rapid promotion and application of various internet of things sensor devices in coal mine,massive monitoring and monitoring data has formed an explosive growth trend.While improving the level of intelligent mine construction,it also brings greater challenges to the rapid collection and efficient storage of data.Through analyzing the characteristics of coal mine time series data,compared the performance of various data storage schemes and different time series databases,proposed a coal mine data middle platform architecture based on TDengine time series database,and designed a coal mine time series data super table structure.The on-site industrial test shows that in the face of the application requirements of massive monitoring and monitoring data,the time-series database has higher storage efficiency and faster query rate than the relational database,which provides more powerful data support for the construction of intelligent mine.

关 键 词：智能矿山 物联网 数据中台 时序数据库 TDengine 超级表 

分 类 号：TD67[矿业工程—矿山机电]