摘要
针对现有的分布式光纤应变监测系统数据采集量大、存储空间有限、无法远程监控等问题,设计了基于云数据处理的分布式光纤应变远程监测系统。首先,基于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.
作者
闫伟
白清
谷行
王东
王宇
靳宝全
YAN Wei;BAI Qing;GU Hang;WANG Dong;WANG Yu;JIN Baoquan(Key Laboratory of Advanced Transducers and Intelligent Control Systems, Ministry of Education and Shanxi Province, Taiyuan University of Technology, Taiyuan 030024, China;Coal and Coal Methane Simultaneous Extraction National Key Laboratory, Jincheng Shanxi 048012,Chinu)
出处
《传感技术学报》
CAS
CSCD
北大核心
2019年第6期950-955,共6页
Chinese Journal of Sensors and Actuators
基金
山西省重点研发计划(一般)社会发展项目(201703D321034)
山西省煤层气联合研究基金项目(2015012005,2016012011)
山西省自然科学基金项目(201601D021068)
作者简介
闫伟(1993-),男,山西五台人,硕士研究生。主要研究方向为分布式光纤传感,yanwei051b@126.com;通讯作者:靳宝全(1972-),导师,男,山西代县人,博士,教授,主要研究方向为分布式光纤传感,jinbaoquan@tyut.edu.cn。
