基于云数据处理的分布式光纤应变远程监测系统设计
|
摘要
针对现有的分布式光纤应变监测系统数据采集量大、存储空间有限、无法远程监控等问题,设计了基于云数据处理的分布式光纤应变远程监测系统。首先,基于ADO数据库访问技术设计了数据库访问编程接口,使上位机程序可通过该编程接口将数据传输至远程云数据库,解决了上位机存储空间有限的问题;其次,利用多线程机制设计了上位机程序多线程并发访问数据库模块,实现了数据实时高效的传输;最后,基于ORACLE设计了数据库系统方案,将数据库搭建在云服务器端,用于存储和分析MFC程序采集处理的监控数据和异常信息,实现了云数据的实时处理和远程监控。实验测试结果表明,上位机与云数据库之间的数据交互速度满足并发和实时监测的需求。
In order to solve problems of existing strain monitoring system of distributed optical fiber,for example,large data collection,limited storage space and inconvenient remote monitoring,a strain remote monitoring system of distributed optical fiber was designed which was based on cloud data processing. Firstly,database access programming interface is designed based on ADO database access technology,which enables the upper computer program transmit data to the remote cloud database and solved the problem of limited storage space of the upper computer. Secondly,the multi-thread mechanism is used to design the upper computer program's multi-thread concurrent access database module,which realizes the real-time and efficient data transmission. Lastly,a cloud database system solution is designed and set up on the cloud server based on oracle database,which is used to store and analyze monitoring data and abnormal information collected and processed by the MFC program,realizing real-time processing and remote monitoring of cloud data. The experimental test results show that the speed of data interaction between the upper computer and the cloud database meets the requirements of concurrent and real-time monitoring.
In order to solve problems of existing strain monitoring system of distributed optical fiber,for example,large data collection,limited storage space and inconvenient remote monitoring,a strain remote monitoring system of distributed optical fiber was designed which was based on cloud data processing. Firstly,database access programming interface is designed based on ADO database access technology,which enables the upper computer program transmit data to the remote cloud database and solved the problem of limited storage space of the upper computer. Secondly,the multi-thread mechanism is used to design the upper computer program's multi-thread concurrent access database module,which realizes the real-time and efficient data transmission. Lastly,a cloud database system solution is designed and set up on the cloud server based on oracle database,which is used to store and analyze monitoring data and abnormal information collected and processed by the MFC program,realizing real-time processing and remote monitoring of cloud data. The experimental test results show that the speed of data interaction between the upper computer and the cloud database meets the requirements of concurrent and real-time monitoring.
引文
[1] 张瑜,王东,白清,等.基于SOA脉冲调制的BOTDR应变检测系统[J].传感技术学报,2017,30(12):1954-1958.
[2] Mohamad H.Temperature and Strain Sensing Techniques Using Brillouin Optical Time Domain Reflectometry[J].Proceedings of SPIE—The International Society for Optical Engineering,2012,8346(14):1844-1864.
[3] 李永倩,翟丽娜,赵丽娟,等.基于BOTDR技术的OPGW在线监测研究[J].光通信研究,2013,39(5):30-33.
[4] 李永倩,赵丽娟,杨志,等.基于BOTDR的海缆3D立体监测系统设计与实现[J].仪器仪表学报,2014,35(5):1029-1036.
[5] 王真立,吴晓章,陈刚,等.地面点云处理系统集成研究与实现[J].测绘通报,2017(11):108-114.
[6] Bao Xiaoti,Chen Liang.Optical Fiber Sensors Based on Brillouin Scattering:Proceedings of the Photonics Society Summer Topical Meeting Series,F,2009[C].
[7] 隋海波,施斌,张丹,等.基坑工程BOTDR分布式光纤监测技术研究[J].防灾减灾工程学报,2008,28(2):184-191.
[8] 韩雪,李永倩,李晓娟,等.基于BOTDR系统的检测方法研究进展[J].光通信技术,2017,41(9):38-41.
[9] Bai Q,Zhang Y,Wang Y,et al.A Stable and Fast Approach for Measuring Brillouin Frequency Shift:Proceedings of the Progress in Electromagnetics Research Symposium-Fall,F,2017[C].
[10] 查修齐,吴荣泉,高元钧.C/S到B/S模式转换的技术研究[J].计算机工程,2014,40(1):263-267.
[11] 李哲哲,白清,张瑜,等.采空区沉降监测的BOTDR光纤传感技术[J].仪表技术与传感器,2017(12):12-15.
[12] 张旭苹,王峰,路元刚.基于布里渊效应的连续分布式光纤传感技术[J].激光与光电子学进展,2009,46(11):14-20.
[13] 王平,覃理矜.基于OLE DB的ADO数据访问技术[J].重庆邮电大学学报(自然科学版),2001,13(1):65-68.
[14] 秦靖,刘存勇.Oracle从入门到精通[M].北京:机械工业出版社,2011.
[15] 王珊,萨师煊.数据库系统概论[M].第3版.北京:高等教育出版社教学,2000.
[16] 张静,王永敏.数据库应用系统中LOB应用技术研究[J].计算机技术与发展,2011,21(2):166-169.闫伟(1993-),男,山西五台人,硕士研究生。主要研究方向为分布式光纤传感,yanwei051b@126.com;靳宝全(1972-),导师,通讯作者,男,山西代县人,博士,教授,主要研究方向为分布式光纤传感,jinbaoquan@tyut.edu.cn。
[2] Mohamad H.Temperature and Strain Sensing Techniques Using Brillouin Optical Time Domain Reflectometry[J].Proceedings of SPIE—The International Society for Optical Engineering,2012,8346(14):1844-1864.
[3] 李永倩,翟丽娜,赵丽娟,等.基于BOTDR技术的OPGW在线监测研究[J].光通信研究,2013,39(5):30-33.
[4] 李永倩,赵丽娟,杨志,等.基于BOTDR的海缆3D立体监测系统设计与实现[J].仪器仪表学报,2014,35(5):1029-1036.
[5] 王真立,吴晓章,陈刚,等.地面点云处理系统集成研究与实现[J].测绘通报,2017(11):108-114.
[6] Bao Xiaoti,Chen Liang.Optical Fiber Sensors Based on Brillouin Scattering:Proceedings of the Photonics Society Summer Topical Meeting Series,F,2009[C].
[7] 隋海波,施斌,张丹,等.基坑工程BOTDR分布式光纤监测技术研究[J].防灾减灾工程学报,2008,28(2):184-191.
[8] 韩雪,李永倩,李晓娟,等.基于BOTDR系统的检测方法研究进展[J].光通信技术,2017,41(9):38-41.
[9] Bai Q,Zhang Y,Wang Y,et al.A Stable and Fast Approach for Measuring Brillouin Frequency Shift:Proceedings of the Progress in Electromagnetics Research Symposium-Fall,F,2017[C].
[10] 查修齐,吴荣泉,高元钧.C/S到B/S模式转换的技术研究[J].计算机工程,2014,40(1):263-267.
[11] 李哲哲,白清,张瑜,等.采空区沉降监测的BOTDR光纤传感技术[J].仪表技术与传感器,2017(12):12-15.
[12] 张旭苹,王峰,路元刚.基于布里渊效应的连续分布式光纤传感技术[J].激光与光电子学进展,2009,46(11):14-20.
[13] 王平,覃理矜.基于OLE DB的ADO数据访问技术[J].重庆邮电大学学报(自然科学版),2001,13(1):65-68.
[14] 秦靖,刘存勇.Oracle从入门到精通[M].北京:机械工业出版社,2011.
[15] 王珊,萨师煊.数据库系统概论[M].第3版.北京:高等教育出版社教学,2000.
[16] 张静,王永敏.数据库应用系统中LOB应用技术研究[J].计算机技术与发展,2011,21(2):166-169.闫伟(1993-),男,山西五台人,硕士研究生。主要研究方向为分布式光纤传感,yanwei051b@126.com;靳宝全(1972-),导师,通讯作者,男,山西代县人,博士,教授,主要研究方向为分布式光纤传感,jinbaoquan@tyut.edu.cn。