大型建筑结构健康监测的海量数据处理与数据库开发研究
|
摘要
在大型建筑的结构健康监测中,要对大量不同类型的传感器采集到的数据信号进行处理。基于Oracle数据库开发平台,根据各传感器的分类、采集的时间,建立相应的数据库系统。该系统能有效地对采集到的海量数据进行存储、管理、查询及异常数据的预警处理。将着重介绍该数据库系统的功能、特点、结构以及系统的框架组成,并以振弦式应变传感器采集到的数据信号的实例描述该系统处理海量数据的特点。
In the structural health monitoring for large-scale constructions,a large number of different types of sensor data needs to be processed.Based on the Oracle database,according to the classification of sensors and the acquisition time,the corresponding database system was established.The system is effective for massive data storage,management and inquiry and can deal with the early warning of abnormal data.The article focuses on the function of database system,the characteristics of framework structure and the composition of system.The massive data acquired from a vibrating wire strain sensor were used as an example to describe the system characteristics.
In the structural health monitoring for large-scale constructions,a large number of different types of sensor data needs to be processed.Based on the Oracle database,according to the classification of sensors and the acquisition time,the corresponding database system was established.The system is effective for massive data storage,management and inquiry and can deal with the early warning of abnormal data.The article focuses on the function of database system,the characteristics of framework structure and the composition of system.The massive data acquired from a vibrating wire strain sensor were used as an example to describe the system characteristics.
引文
[1]Shi W Z,Ko J M,Zhao C Y,et al.Abridge structural healthmonitoring information system based on GIS and DBMS,SmartStructures and Materials 2005:Sensors and Smart StructuresTechnologies for Civil,Mechanical,and Aerospace Systems,Proc.of SPIE 2005,5765:1012-1020.
[2]Chan THT,Ko J M,Li Z X.Fatigue evaluation for Tsing MaBridge using structural health monitoring data[J].HealthMonitoring and Management of Civil Infrastructure Systems,Proc.of SPIE,2001,4337:335-346.
[3]陈一鸣,陈进,伍星.基于网络的远程监测和故障诊断系统的数据库系统[J].振动与冲击,2005,24(6):61-64.
[4]何旭辉,陈政清,黄方林.南京长江大桥安全监测和状态评估的初步研究[J].振动与冲击,2003,22(1):75-78.
[5]李惠,周文松,欧进萍.大型桥梁结构智能健康监测系统集成技术研究[J].土木工程学报,2006,39(2):46-52.
[6]李顺龙,李惠,欧进萍.考虑温度和风速影响的桥梁结构模态参数分析[J].土木工程学报,2009,42(4):100-106.
[7]孙宗光,倪一清,高赞明.基于斜拉索振动测量与神经网络技术的斜拉桥损伤位置识别方法[J].工程力学,2003,20(3):26-30.
[8]于哲峰,杨智春.基于互相关函数幅值向量的结构损伤定位方法研究[J].振动与冲击,2006,25(3):77-80.
[9]杨海峰,吴子燕,吴丹.基于加速度频率响应函数的结构损伤测量方法研究[J].振动与冲击,2007,26(2):91-97.
[10]袁万城,崔飞,张启伟.桥梁健康监测与状态评估的研究现状与发展[J].同济大学学报,1999,27(2):184-188.
[11]何浩祥,闫维明,马华.结构健康监测系统设计标准化评述与展望[J].地震工程与工程振动.2008,28(4):154-160.
[12]李宏男,高东伟,伊挺华.土木工程结构健康监测系统的研究状况与进展[J].力学进展,2008,38(2):151-164.
[13]王莹,吴佰建,李兆霞.特大跨缆索桥钢箱梁疲劳应力特性对比性研究[J].振动与冲击,2009,28(2):86-91.
[2]Chan THT,Ko J M,Li Z X.Fatigue evaluation for Tsing MaBridge using structural health monitoring data[J].HealthMonitoring and Management of Civil Infrastructure Systems,Proc.of SPIE,2001,4337:335-346.
[3]陈一鸣,陈进,伍星.基于网络的远程监测和故障诊断系统的数据库系统[J].振动与冲击,2005,24(6):61-64.
[4]何旭辉,陈政清,黄方林.南京长江大桥安全监测和状态评估的初步研究[J].振动与冲击,2003,22(1):75-78.
[5]李惠,周文松,欧进萍.大型桥梁结构智能健康监测系统集成技术研究[J].土木工程学报,2006,39(2):46-52.
[6]李顺龙,李惠,欧进萍.考虑温度和风速影响的桥梁结构模态参数分析[J].土木工程学报,2009,42(4):100-106.
[7]孙宗光,倪一清,高赞明.基于斜拉索振动测量与神经网络技术的斜拉桥损伤位置识别方法[J].工程力学,2003,20(3):26-30.
[8]于哲峰,杨智春.基于互相关函数幅值向量的结构损伤定位方法研究[J].振动与冲击,2006,25(3):77-80.
[9]杨海峰,吴子燕,吴丹.基于加速度频率响应函数的结构损伤测量方法研究[J].振动与冲击,2007,26(2):91-97.
[10]袁万城,崔飞,张启伟.桥梁健康监测与状态评估的研究现状与发展[J].同济大学学报,1999,27(2):184-188.
[11]何浩祥,闫维明,马华.结构健康监测系统设计标准化评述与展望[J].地震工程与工程振动.2008,28(4):154-160.
[12]李宏男,高东伟,伊挺华.土木工程结构健康监测系统的研究状况与进展[J].力学进展,2008,38(2):151-164.
[13]王莹,吴佰建,李兆霞.特大跨缆索桥钢箱梁疲劳应力特性对比性研究[J].振动与冲击,2009,28(2):86-91.
版权所有：© 2023 中国地质图书馆 中国地质调查局地学文献中心