SQL server的分布式光纤温度传感器校准数据采集方法

A calibration of data gathered method based on SQL server for distributed optical fiber temperature sensor

利用Lab VIEW数据采集系统平台,提出了一种采用SQL server技术访问InterBase数据库的数据采集方法.该方法先将分布式光纤温度传感器自带的GDB格式数据,以数据表的形式存入SQL Server特定数据库中,然后通过Lab VIEW数据采集系统以数组形式显示,最后将数组数据保存在Excel文件中,以便数据分析处理.运行调试结果表明,该方法对被校分布式光纤温度传感器的校准数据采集保存快速,操作分析方便,可视化效果好.

For reserching metrological characteritics of distributed optical fiber temperature sensor,many experimental data should be saved according to its calibration requests for temperature measurement precision and spatial resolution.In order to improve efficiency of data collection and conserve,a method for data collection of the paper was put forward to using SQL server technology to get access to the InterBase database based on the platform of Lab VIEW.First,GDB format data of distributed optical fiber temperature sensor was saved into specific deposit SQL Server database in the form of data table,then it was shown an array form display on Lab VIEW data collection system.Finally the array data was saved into Excel files,so that the follow-up data could be processed.The program operation debugging indicated that data collection system platform of Lab VIEW worked on the distributed optical fiber temperature sensor is calibration data collection fast,experimental operation convenient and good visual effect.