城市污水排放实时监控界面及查询优化设计

作者：杨成成，汪雄海 日期：2008-12-26/span> 浏览：3838 查看PDF文档

城市污水排放实时监控界面及查询优化设计

杨成成，汪雄海
（浙江大学 电气自动化研究所，浙江 杭州 310027）

摘要：针对城市污水排放系统泵站多、地域跨度广、网络复杂、数据存储量大，传统实时监控人机界面制作难度大且查询效率低，提出一种新颖的基于C#与SQL Server 2000、利用开源控件ZedGraph绘制实时曲线实现监控的设计方法，并通过数据库和界面程序的查询优化讨论，给出了解决办法及优化查询的源代码，可达到高效的查询及良好的显示效果。使用结果表明，该方法实施成本低，对用户操作技术要求友好、符合国情实际，因而特别适合工程推广应用。
关键词：污水控制；实时监控；SQL Server数据库；查询优化；人机界面
中图分类号：TP277文献标识码：A文章编号：1001-4551(2008)12-0070-04

City drainage real-time monitoring interface and query optimization design
YANG Cheng-cheng, WANG Xiong-hai
(College of Electric Engineering, Zhejiang University, Hangzhou 310027, China)
Abstract: Urban drainage systems consists of lots of wide span pump stations which have plenty run data to store for monitoring and maintenance. However, the traditional man-machine interface for real-time monitoring was inefficient and difficult to be achieved, so a new method of interface design was proposed based on C# language and SQL Server 2000. Real-time curves for monitoring were drawn with an open-source control—ZedGraph by the method. By the query optimization of program and database, the man-machine interface is efficient for query and has good display performance. The test results indicate that the method has lower cost, better performance for the users, which is more suitable for the engineering applications.
Key words: sewage control; realtime monitoring; SQL Server database; query optimization; manmachine interface
参考文献(References):
［1］何中杰，汪昆，汪雄海.污水排放系统优化控制机理及策略［J］.电工技术学报，2006，21(5):117-121.
［2］YANG T C. Networked control system—a brief survey［J］. IEE Proc. Control Theory,2006，4（153）：45-56.
［3］李良,高章飞,朱善安.基于Internet的远程设备监控系统［J］.机电工程，2006，23（7）：37-40.
［4］SCOTT A. Beginning C# Databases［M］.北京：清华大学出版社，2003.
［5］WEHDE E. Microsoft to beef up SQL Server security［J］. Network Security,2000(2):12-14.
［6］王爱军.基于数据库查询过程优化设计［J］.电子科技大学学报,2003,32（2）:192-194.