基于TDengine的桥梁群监测大数据平台研究  

Research on Big Data Platform of Bridge Group Monitoring based on TDengine

作　　者：辜晗光 刘洋[2] 刘振丘 顾思思 GU Han-guang;LIU Yang;LIU Zhen-qiu;GU Si-si(Jiangxi Provincial Communications Investment Group Co.Ltd,Nanchang 330025,China;CCCC Highway Consultants Co.Ltd.,Beijing 100010,China;Jiangxi Communications Construction Company Limited,Nanchang 330108,China)

机构地区：[1]江西省交通投资集团有限责任公司,南昌市330025 [2]中交公路规划设计院有限公司,北京市100010 [3]江西交通咨询有限公司,南昌市330108

出　　处：《公路》2023年第2期396-401,共6页Highway

基　　金：江西祁婺高速智慧交通设计专题研究项目,项目编号K21008AK;交通运输部:跨海桥梁长期性能交通运输行业野外科学观测研究基地。

摘　　要：桥梁监测系统对于保障桥梁结构安全性、耐久性,提升桥梁日常管养水平,服务桥梁应急管理发挥着重要作用。经过10余年的探索,桥梁监测系统逐步从单桥系统向桥梁群系统发展,一体化、集群化、规模化成为新的发展趋势。基于桥梁监测数据的高频、实时、单个数据价值低、超大规模的特点,分析了桥梁群监测面临的数据规模大、存储成本高、查询速度慢的问题。在对比分析文件存储、关系型数据库存储和时序数据库存储的适用场景基础上,提出了基于TDengine时序数据库的桥梁群监测大数据平台架构。TDengine具有分布式扩展、高可靠、高性能以及高效压缩的特点,能够满足千亿规模以上的时序数据存储,能够显著降低数据存储成本,提高数据检索效率。TDengine集群已经成功应用于国内多座桥梁监测系统的实时数据接入,验证了系统的可行性。Bridge monitoring system plays an important role in ensuring the safety and durability of bridge structure, improving the level of daily management and maintenance of bridges, and serving the emergency management of bridges. After more than ten years of exploration, the bridge monitoring system has gradually developed from single bridge system to bridge group system, thus integration, clustering and scale have become a new development trend. Based on the characteristics of high frequency, real-time, low value of single data and large scale of bridge monitoring data, in this paper the problems of large data scale, high storage cost and slow query speed in bridge group monitoring are analyzed.TDengine has the characteristics of distributed expansion, high reliability, high performance and efficient compression, which can meet the requirements for time series data storage of more than 100 billion scales and significantly reduce the cost of data storage and improve the efficiency of data retrieval.The TDengine cluster has been successfully applied to the real-time data access of many domestic bridge monitoring systems, which verifies the feasibility of the system.

关 键 词：桥梁监测 时序数据库 大数据平台 TDengine 

分 类 号：U446[建筑科学—桥梁与隧道工程] U495[交通运输工程—道路与铁道工程]