程少珠. Application of Microsoft Query Technology on Second Development of Power and Surroundings Monitoring System in Telecom Operator[J]. 2005, (5): 36-39.
程少珠. Application of Microsoft Query Technology on Second Development of Power and Surroundings Monitoring System in Telecom Operator[J]. 2005, (5): 36-39.DOI:
Microsoft Query技术在PSMS二次开发中的应用
摘要
动力及环境集中监控系统(PSMS
Power and Surroundings Monitoring System)的用户在使用过程中
往往会结合自身维护实践的需要提出一些特定的需求
但监控产品厂家目前所提供的软件却又不足以支持这些功能。本文结合实例
介绍了如何充分利用Microsoft Query技术并结合结构化查询语言(SQL
Structured Query Language)
自行定义报表
从动力监控系统的大型数据库中获取数据
自动生成报表的方法。实践证明该方法对于加强配线架的例行维护管理具有现实的重要意义。
Abstract
The users of power and surroundings monitoring system often need self-customized report to meet the requirement of maintenance and administration. In this paper
a design method which combine Microsoft query technology with SQL (Structured Query Language) is presented. The method can get data from the big database of power and surroundings monitoring system and make up these data into self-customized report automatically. Unquestionably
it is a kind of effective and simple design method. It has been proved that the method is very practicable and import to strengthen the routine maintenance of main distribution frame.