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

Abstract
Figure/Table
References
Related Citation (2)

Download: PDF (1999 KB) HTML (1 KB)
Export: BibTeX | EndNote (RIS)

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.

Key words： marketing audit wrong wiring correction coefficient method automatic verification structured query language (SQL)

Received: 15 April 2024

	Service

	E-mail this article
	Add to my bookshelf
	Add to citation manager
	E-mail Alert
	RSS
	Articles by authors
	JING Xingdong
	HUANG Yong
	XIAO Yang
	ZHAO Wenrui
	WANG Panpan

Cite this article:

JING Xingdong,HUANG Yong,XIAO Yang等. Structured query language based electric energy metering wiring verification calculation system and its application[J]. Electrical Engineering, 2024, 25(8): 65-70.

URL:

http://dqjs.cesmedia.cn/EN/Y2024/V25/I8/65

[1] 徐振兴, 钟汉亭, 沈华. 电能计量差错退补电量核算方法的研究及实践[J]. 中国计量, 2019(7): 31-35.
[2] 邓得政, 李利刚. 三相三线表在A相或C相保险熔断时追补电量的计算方法[J]. 电气技术, 2022, 23(12): 85-88, 89.
[3] 陈钟炜, 冯睿. 装表接电错误接线的成因、危害与预防措施[J]. 光源与照明, 2022(7): 137-139.
[4] 邓得政, 赵若阳. 电压互感器二次断线对三相三线计量的影响分析[J]. 电气技术, 2020, 21(5): 98-102.
[5] 黄昌元. 电能计量装置运行工况对10kV配网线损的影响[J]. 电工技术, 2023(22): 122-125.
[6] 王海涛, 胡元璐. 基于用电信息采集系统的电能表失压断相后电量追补的分析[J]. 电气技术, 2017, 18(8): 56-58, 64.
[7] 董立锋, 党丽敏, 陈少军. 断路器二次接线正确性检测装置设计[J]. 电气技术, 2019, 20(7): 48-51.
[8] 刘含筱, 张迪. 关口表接线错误检测方法的研究[J]. 电气技术, 2018, 19(1): 29-33, 39.
[9] 钟明祥. 基于现场实例的计量断相退补电量分析[D]. 北京: 华北电力大学, 2015.
[10] 张永建, 娄延旭, 康慈云. 二元件电能表计量三相三线有功电能的原理[J]. 农村电工, 2021, 29(3): 52.
[11] 田俊华. 应用更正系数法计算退补电量方法[J]. 云南电力技术, 2019, 47(5): 118-120.
[12] 张二峰, 王晓鹏. 结构化查询语言(SQL)的使用方法[J]. 开封大学学报, 2001, 15(2): 75-80.
[13] 李学伟, 张思维, 王亚男, 等. 使用SQL实现数字电视业务计费算法与仿真[J]. 计算机仿真, 2007, 24(11): 262-265.
[14] 练金栋, 陈志, 岳文静, 等. 面向多源异构数据库的SQL解析与转换方法研究[J]. 软件导刊, 2023, 22(12): 124-131.
[15] 林自立, 陈正著. 商业银行向新成立企业违规发放贷款问题的审计模型研究: 基于SQL语言工具的数据分析模型应用[J]. 企业改革与管理, 2023(20): 113-115.