电气技术2024，Vol.25Issue(8)：65-70,6.
基于结构化查询语言的电能计量接线校验计算系统及其应用
Structured query language based electric energy metering wiring verification calculation system and its application
敬兴东 1黄拥 1肖扬 1赵文瑞 1王盼盼1
作者信息
- 1. 国网四川省电力公司天府新区供电公司,成都 610213
- 折叠
摘要
Abstract
In marketing audit work,it is common to encounter situations where incorrect wiring of electricity metering devices results in incorrect billing of electricity usage and charges for users.The current traditional audit methods often lead to a large amount of manual verification and on-site inspection time for anomaly lists,and the efficiency of work is difficult to effectively improve.This article proposes a metering wiring verification calculation system based on user databases and structured query language(SQL),focusing on the judgment of wiring errors.By constructing calculation models based on correction coefficient methods and maximum phase angle difference of each phase,it achieves automatic verification of wiring errors and calculation of error electricity consumption.This effectively reduces the workload of audit personnel,improves the efficiency of wiring error investigation,and achieves process automation,intelligence,and specialization in handling abnormal users.At the same time,it provides necessary data support for on-site inspections and evidence collection in"anti-theft and anti-violation"activities.关键词
营销稽查/错误接线/更正系数法/自动校验/结构化查询语言(SQL)Key words
marketing audit/wrong wiring/correction coefficient method/automatic verification/structured query language(SQL)引用本文复制引用
敬兴东,黄拥,肖扬,赵文瑞,王盼盼..基于结构化查询语言的电能计量接线校验计算系统及其应用[J].电气技术,2024,25(8):65-70,6.
