基于SQL Server的PLC远程监控参数配置方法及其实现
Design and Realization of Parameter Configuration for PLC Equipments’ Remote Monitoring Based on SQL Server
作者: 黄飞燕 :东南大学自动化学院,南京; 仰燕兰 , 陈洪俊 , 叶 桦 :东南大学自动化学院,南京 ;
关键词: PLC设备; SQL Server; 参数配置; 远程监控; 网站; PLC Equipment; SQL Server; Parameter Configuration; Remote Monitoring; Website
摘要: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.
文章引用: 黄飞燕 , 仰燕兰 , 陈洪俊 , 叶 桦 (2014) 基于SQL Server的PLC远程监控参数配置方法及其实现。 计算机科学与应用, 4, 225-233. doi: 10.12677/CSA.2014.410031
参考文献
[1] 刘暾东, 郭敏, 陈力 (2008) 基于GIS的智能路灯监控网站设计.照明工程学报, 4, 70-74.
[2] 叶霞, 李俊山, 韦素媛 (2009) 数据库原理及应用.吉林省教育学院学报.学术版, 39-41.
[3] 潘瑞芳 (2012) 数据库技术与应用. 清华大学出版社, 北京.
[4] 郭文波 (2012) ASP.NET GridView控件的高级数据绑定与应用. 电脑开发与应用, 7, 54-58.
[5] 肖健 (2002) ASP.NET编程基础. 清华大学出版社, 北京.
[6] Duthie, G.A., 李万伦 (2002) Mi-crosoft ASP.Net程序设计. 清华大学出版社, 北京.