基于结构化查询语言的电能计量接线校验计算系统及其应用  

Structured query language based electric energy metering wiring verification calculation system and its application

作　　者：敬兴东 黄拥 肖扬 赵文瑞 王盼盼 JING Xingdong;HUANG Yong;XIAO Yang;ZHAO Wenrui;WANG Panpan(State Grid Sichuan Provincial Electric Power Company Tianfu New Area Power Supply Company,Chengdu 610213)

机构地区：[1]国网四川省电力公司天府新区供电公司,成都610213

出　　处：《电气技术》2024年第8期65-70,共6页Electrical Engineering

摘　　要：在营销稽查工作中,常出现因电力计量装置接线错误造成用户电量错计及电费错收的情况,传统核查方法需耗费大量人工校验与现场核查时间,工作效率难以提升。本文围绕错误接线判断,开发一种基于用户数据库与结构化查询语言的电能计量接线校验计算系统,通过更正系数法与各相最大相位差搭建计算模型,实现错误接线异常的自动校验并计算差错电量,从而有效减轻了核查人员的工作负担,提高了错误接线排查效率,实现了异常用户处理流程化、智能化、专项化,同时为“反窃查违”现场检查与取证提供了必要的数据支撑。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) 

分 类 号：TM933.4[电气工程—电力电子与电力传动]