基于SQL Server的PLC远程监控参数配置方法及其实现

Design and Realization of Parameter Configuration for PLC Equipments’ Remote Monitoring Based on SQL Server

摘要: 远程监控系统会有接收来自底层设备不同协议数据的要求。为了提高远程监控网站数据解析程序的适应性，本文基于SQL Server 2005数据库管理系统设计了监控参数动态配置方法，及参数解析、计算方法。根据模块化思想，基于VS2010 Asp.net开发平台，设计SQLHelp类，实现了对ADO.NET数据库操作方法的封装；采用SQL语句和存储过程设计的数据库接口简化了数据库操作。针对监控数据量大的情况，设计了网页数据缓存机制，加快了浏览器的响应速度。通过测试，网站能方便、高效地对底层不同设备的PLC数据进行参数配置，并能正确监控数据。

Abstract: Remote monitoring system will receive data with different protocol from underlying equipment. In order to enhance the Remote Monitoring Website’s adaptation to the software of data analysis, the parameter configuration method and the method of data calculation are introduced in this paper based on SQL Server 2005. This paper presents the encapsulation of the database operation methods of ADO.NET to design the SQLHelp class with the help of VS2010 Asp.net integral pro-gramming environment according to the modular design concept. In addition, SQL statement and procedures are designed to simplify the operation of the database. Caching mechanism of data is designed to deal with the large amount of monitoring data which speed up the response of the browser. Through the test, parameter of different equipment can be configured and the data can be monitored conveniently and efficiently.