| 引用本文: | 李会杰,姚建刚,谷林峰,姚鹏,李连结.基于关口表数据库的输电费用在线实时计算系统开发[J].电力自动化设备,2007,27(4):107-111 |
| .Online real-time transmission cost calculation system based on point meter database[J].Electric Power Automation Equipment,2007,27(4):107-111 |
|
|
| 摘要: |
| 基于关口表数据库,提出了一种简捷、易于编程实现的输电费用计算方法。输电服务中,输电网输送的总电量、每条输电线路在此次输电中输送的电量、每条输电线路的损耗以及总损耗均可通过关口表读数、计算后得到。所得数据传输到SQL Server数据库,再经过简单的数据处理后,进行成本分析、总费用计算和费用分摊。开发的输电费用在线实时计算系统利用关系数据库编程语言SQL Server 2000对数据库特别是关口表数据库进行管理,易维护、扩展,数据传输和计算均在服务器端完成,增强了系统安全性和易维护性;采用面向对象的编程语言Visual Basic 6.0开发人机互动界面,系统界面友好、简捷易操作。实际运行表明,输电费用在线实时计算系统可以对复杂电力系统的输电费用进行在线实时计算,计算速度快、操作透明度高,对历史数据和实时数据均能进行查询,结果准确。 |
| 关键词: 关口表数据库,输电费用,系统开发 |
| DOI： |
| 分类号:TM744 TP312 |
| 基金项目: |
|
| Online real-time transmission cost calculation system based on point meter database |
|
LI Hui-jie YAO Jian-gang GU Lin-feng YAO Peng LI Lian-jie
|
| Abstract: |
| A calculation method of transmission cost based on point meter database is presented and its programming is easy.The electric quantity and loss of every transmission line,as well as the total electric quantity and loss,can be calculated from the point meter readings for each transmission service,which are sent to SQL Server database and used for cost analysis,total cost calculation and cost allocation after simple processing.The developed online real-time transmission cost calculation system adopts SQL Server 2000 to manage the databases,especially the point meter database,with good maintainability and expansibility.Both the data transmission and computation are implemented in server for enhancing system security and maintainability.The object-oriented programming language Visual Basic 6.0 is used to develop the friendly and simple man-machine interface.Practical applications show that the system realizes online and real-time transmission cost calculation for complex electric power systems with high speed,and both the historical data and real-time data can be inquired accurately. |
| Key words: point meter database,transmission cost,system development |
