监控系统中数据交换技术的研究与实现  

Research and realization of data exchange technology in monitoring system

作　　者：王斌[1] 陈兴林[1] 陈昊[1] 强盛[1] 

机构地区：[1]哈尔滨工业大学控制科学与工程系,哈尔滨150001

出　　处：《电子测量技术》2013年第6期93-96,共4页Electronic Measurement Technology

摘　　要：针对远程监控系统的监控数据报表生成操作复杂、不统一问题,研究了Excel、MySQL与LabWindows/CVI数据交换技术。利用MySQL的C API和ActiveX技术解决了数据交换问题,设计了报表数据输入/输出、数据库数据输入/输出函数,将其封装成动态链接库,各函数通用性强、相互独立,形成了规范的数据交换方案。使用此链接库,能够保证数据保存和传输的实时性,实现统一的数据传输流程控制,数据交换得以快速方便的进行,大大简化了程序的开发;在监控系统中对其进行了验证。For monitoring data report is generated with complex operation and non-standard format in monitoring system.The data exchange is solved depending on the C API of MySQL and ActiveX technology,the function about Excel data import or export and MySQL data import or export are designed and encapsulated into dynamic link library.All functions are relatively dependent,forming a standard data exchange scheme.With this link library,it is able to keep the real-time operation of the data transmission and preservation,simplifying the development software.Data exchange is able to quickly and easily,and it is verified in the monitoring and control system.

关 键 词：LABWINDOWS CVI MYSQL数据库 EXCEL报表 数据交换 

分 类 号：TP311.1[自动化与计算机技术—计算机软件与理论]