技术领域Technical field
本发明涉及电力计量行业的电能表质量领域，特别是一种电能表质量数据格式核查方法及系统。The invention relates to the field of electric energy meter quality in the electric power metering industry, in particular to a method and system for checking the data format of electric energy meter quality.
背景技术Background technique
随着“大云物移智”等信息通信新技术的日新月异和计量技术的融合应用，以智能电能表和用电信息采集系统数据资源业务为基础，实现提升电力计量的影响力和形象，更好地服务公司质量强网和高质量发展，全面支撑公司以客户为中心的现代服务体系。作为国家能源计量中心（电力）的一项重点建设任务，搭建电力行业国家质量基础（NQI）服务云平台，为政府决策和质量监管提供数据统计分析支持，为企业质量提升提供数据分析应用服务。With the rapid development of new information and communication technologies such as "Big Cloud Things Move Intelligence" and the integration and application of metering technology, based on the data resource business of smart electric energy meters and power consumption information collection systems, the influence and image of electric power metering can be improved, and the influence and image of electric power metering can be improved. Haodi Service Company's strong network of quality and high-quality development fully support the company's modern customer-centered service system. As a key construction task of the National Energy Metering Center (Electricity), the National Quality Infrastructure (NQI) service cloud platform for the power industry is built to provide data statistical analysis support for government decision-making and quality supervision, and to provide data analysis application services for enterprise quality improvement.
面对众多的计量设备生产企业、电力公司、监管机构、公众使用电力行业国家质量基础（NQI）服务云平台。为更好地支撑智能量测上下游产业链计量设备生产方（生产企业）、使用方（电力公司）、服务方（公众）、监管方（监管机构）的应用场景工作开展，形成良好、健康、持续的泛在电力物联网智能量测计量设备质量服务生态圈，为更好地落实国家市场监督管理总局和国网公司的任务要求，迫切需要建设计量设备质量数据服务基础设施能力，如何提供更完整、更准确、更统一的电能表质量数据是电力计量行业待解决的关键问题。In the face of numerous metering equipment manufacturers, power companies, regulatory agencies, and the public using the National Quality Infrastructure (NQI) service cloud platform in the power industry. In order to better support the application scenarios of metering equipment manufacturers (manufacturing companies), users (power companies), service parties (public), and regulators (regulatory agencies) in the upstream and downstream industrial chain of intelligent measurement, a good and healthy In order to better implement the mission requirements of the State Administration for Market Regulation and the State Grid Corporation of China, there is an urgent need to build a measurement equipment quality data service infrastructure capability and how to provide it. More complete, more accurate and more unified energy meter quality data is a key issue to be solved in the power metering industry.
发明内容Contents of the invention
本发明的目的在于提供一种电能表质量数据格式核查方法及系统，其基于多角度的电能表质量数据格式核查，对生产企业测的智能电能表质量相关数据进行全方位多角度的验证核查，为全景质量监测、质量分析与预警、全过程质量评价、远程监造等功能数据服务提供更完整、更准确数据支持。The purpose of the present invention is to provide a method and system for checking the quality data format of electric energy meters, which is based on multi-angle verification of the quality data format of electric energy meters and conducts all-round and multi-angle verification and verification of the quality-related data of smart electric energy meters measured by production enterprises. Provide more complete and accurate data support for functional data services such as panoramic quality monitoring, quality analysis and early warning, full-process quality evaluation, and remote manufacturing supervision.
为此，本发明采用的技术方案为：一种电能表质量数据格式核查方法，其基于数据库层面，通过SQL脚本根据制定好的规则标准验证比对相关数据是否符合要求，以提高电能表质量数据的完整性和准确性，包括：To this end, the technical solution adopted by the present invention is: a method for checking the quality data format of electric energy meters, which is based on the database level and uses SQL scripts according to established rules and standards to verify whether the relevant data meets the requirements to improve the quality data of electric energy meters. completeness and accuracy, including:
步骤一、数据量核查：对所接入的每张表的数据量进行核查统计；Step 1. Data volume verification: Verify and count the data volume of each connected table;
步骤二、非空字段核查：对有数据的表，验证其各必填字段是否有内容；Step 2. Non-empty field verification: For tables with data, verify whether each required field has content;
步骤三、标准代码核查：通过与码表比对验证标准代码值是否正确；Step 3. Standard code verification: Verify whether the standard code value is correct by comparing it with the code table;
步骤四、数据重复问题核查：根据某一字段或者某行记录对表中所有数据进行比对，来查询已有数据表中是否有重复的数据；Step 4. Check for data duplication issues: Compare all the data in the table based on a certain field or row of records to check whether there is duplicate data in the existing data table;
步骤五、数据类型核查：根据标准数据格式对某些特殊类型字段进行核查。Step 5. Data type verification: Verify certain special types of fields according to standard data formats.
进一步地，步骤二中，所述有数据的表为产品信息表时，根据生产企业编码分组，查询在数据模型里面定义的所有为非空的字段，包括产品编码、企业编码、产品型号、产品名称、产品类别、产品设计依据、通知号，如果有任何一列为空，统计值加1，查询结果如果企业编号的统计值大于零，则数据不合格。Further, in step two, when the table with data is a product information table, group according to the production enterprise code, and query all non-empty fields defined in the data model, including product code, enterprise code, product model, product Name, product category, product design basis, notification number. If any column is empty, the statistical value is increased by 1. If the statistical value of the enterprise number in the query result is greater than zero, the data is unqualified.
进一步地，步骤四中，所述有数据的表为产品信息表时，首先根据产品编码分组，查询在数据模型里面定义的主键字段的最小值；然后根据企业编码分组，查询主键字段不等于最小值，统计值加1，查询结果如果是企业编号的统计值大于零，则数据不合格。Further, in step 4, when the table with data is a product information table, first group according to the product code and query the minimum value of the primary key field defined in the data model; then group according to the enterprise code and query whether the primary key field is not equal to the minimum value, the statistical value is increased by 1. If the query result is that the statistical value of the enterprise number is greater than zero, the data is unqualified.
进一步地，步骤五中，所述的某些特殊类型字段为日期类型字段和时间类型字段。Further, in step five, some of the special types of fields are date type fields and time type fields.
本发明采用的另一种技术方案为：一种电能表质量数据格式核查系统，其包括：Another technical solution adopted by the present invention is: an electric energy meter quality data format verification system, which includes:
数据量核查单元：对所接入的每张表的数据量进行核查统计；Data volume verification unit: Verifies and counts the data volume of each connected table;
非空字段核查单元：对有数据的表，验证其各必填字段是否有内容；Non-empty field verification unit: For tables with data, verify whether each required field has content;
标准代码核查单元：通过与码表比对验证标准代码值是否正确；Standard code verification unit: Verify whether the standard code value is correct by comparing it with the code table;
数据重复问题核查单元：根据某一字段或者某行记录对表中所有数据进行比对，来查询已有数据表中是否有重复的数据；Data duplication problem verification unit: compares all data in the table based on a certain field or row of records to query whether there is duplicate data in the existing data table;
数据类型核查单元：根据标准数据格式对某些特殊类型字段进行核查。Data type checking unit: Checks certain special types of fields according to standard data formats.
进一步地，所述的非空字段核查单元中，所述有数据的表为产品信息表时，根据生产企业编码分组，查询在数据模型里面定义的所有为非空的字段，包括产品编码、企业编码、产品型号、产品名称、产品类别、产品设计依据、通知号，如果有任何一列为空，统计值加1，查询结果如果企业编号的统计值大于零，则数据不合格。Further, in the non-empty field checking unit, when the table with data is a product information table, group according to the production enterprise code, and query all non-empty fields defined in the data model, including product code, enterprise Code, product model, product name, product category, product design basis, notification number. If any column is empty, the statistical value will be increased by 1. In the query result, if the statistical value of the enterprise number is greater than zero, the data is unqualified.
进一步地，所述的数据重复问题核查单元中，所述有数据的表为产品信息表时，首先根据产品编码分组，查询在数据模型里面定义的主键字段的最小值；然后根据企业编码分组，查询主键字段不等于最小值，统计值加1，查询结果如果是企业编号的统计值大于零，则数据不合格。Further, in the data duplication problem checking unit, when the table with data is a product information table, first group according to the product code, query the minimum value of the primary key field defined in the data model; then group according to the enterprise code, If the query primary key field is not equal to the minimum value, the statistical value will be increased by 1. If the query result is that the statistical value of the enterprise number is greater than zero, the data is unqualified.
进一步地，所述的数据类型核查单元中，所述的某些特殊类型字段为日期类型字段和时间类型字段。Further, in the data type checking unit, some of the special types of fields are date type fields and time type fields.
本发明具有以下优点：The invention has the following advantages:
1.通过对电能表质量数据格式核查，使数据的完整性和准确性大幅提高。1. By checking the quality data format of the electric energy meter, the integrity and accuracy of the data are greatly improved.
2.本发明整个核查过程只需少量的人工参与，节约了大量的人力资源。2. The entire verification process of the present invention requires only a small amount of manual participation, saving a large amount of human resources.
3.本发明核查过程SQL脚本由计算机执行，使核查结果更加科学。3. The SQL script of the verification process of the present invention is executed by the computer, making the verification results more scientific.
本发明基于多角度的电能表质量数据格式核查，对生产企业测的智能电能表质量相关数据进行全方位多角度的验证核查，为全景质量监测、质量分析与预警、全过程质量评价、远程监造等功能数据服务提供更完整、更准确数据支持。This invention is based on multi-angle verification of electric energy meter quality data format, and conducts all-round multi-angle verification and verification on the quality-related data of smart electric energy meters measured by production enterprises. It provides panoramic quality monitoring, quality analysis and early warning, whole-process quality evaluation, and remote monitoring. Functional data services such as manufacturing provide more complete and accurate data support.
具体实施方式Detailed ways
实施例1Example 1
本发明提供一种电能表质量数据格式核查方法，其基于数据库层面，通过SQL脚本根据制定好的规则标准验证比对相关数据是否符合要求，以提高电能表质量数据的完整性和准确性，包括：The present invention provides a method for checking the quality data format of electric energy meters, which is based on the database level and uses SQL scripts to verify whether the relevant data meets the requirements according to established rules and standards to improve the integrity and accuracy of the quality data of electric energy meters, including :
步骤一、数据量核查：对所接入的每张表的数据量进行核查统计；Step 1. Data volume verification: Verify and count the data volume of each connected table;
步骤二、非空字段核查：对有数据的表，验证其各必填字段是否有内容；Step 2. Non-empty field verification: For tables with data, verify whether each required field has content;
步骤三、标准代码核查：通过与码表比对验证标准代码值是否正确；Step 3. Standard code verification: Verify whether the standard code value is correct by comparing it with the code table;
步骤四、数据重复问题核查：根据某一字段或者某行记录对表中所有数据进行比对，来查询已有数据表中是否有重复的数据；Step 4. Check for data duplication issues: Compare all the data in the table based on a certain field or row of records to check whether there is duplicate data in the existing data table;
步骤五、数据类型核查：根据标准数据格式对某些特殊类型字段进行核查。Step 5. Data type verification: Verify certain special types of fields according to standard data formats.
步骤二中，所述有数据的表为产品信息表时，根据生产企业编码分组，查询在数据模型里面定义的所有为非空的字段，包括产品编码、企业编码、产品型号、产品名称、产品类别、产品设计依据、通知号，如果有任何一列为空，统计值加1，查询结果如果企业编号的统计值大于零，则数据不合格。In step two, when the table with data is a product information table, group it according to the production enterprise code and query all non-empty fields defined in the data model, including product code, enterprise code, product model, product name, product Category, product design basis, notification number, if any column is empty, the statistical value is increased by 1. If the statistical value of the enterprise number in the query result is greater than zero, the data is unqualified.
步骤四中，所述有数据的表为产品信息表时，首先根据产品编码分组，查询在数据模型里面定义的主键字段的最小值；然后根据企业编码分组，查询主键字段不等于最小值，统计值加1，查询结果如果是企业编号的统计值大于零，则数据不合格。In step four, when the table with data is a product information table, first group according to the product code and query the minimum value of the primary key field defined in the data model; then group according to the enterprise code and query whether the primary key field is not equal to the minimum value. Statistics The value is increased by 1. If the query result is that the statistical value of the enterprise number is greater than zero, the data is unqualified.
步骤五中，所述的某些特殊类型字段为日期类型字段和时间类型字段。In step five, some of the special types of fields mentioned are date type fields and time type fields.
本发明实施时的具体过程如下：The specific process when implementing the present invention is as follows:
1.收到“产品信息表”的数据时，会验证各必填字段是否有内容。1. When receiving the data from the "Product Information Form", it will be verified whether each required field contains content.
2.收到“产品详细信息表”的数据时，2. When receiving the data of "Product Details Form",
21.会验证各必填字段是否有内容；21. Will verify whether each required field has content;
22.根据“产品编码”去“产品信息表”里验证是否存在对应的数据。22. According to the "Product Code", go to the "Product Information Table" to verify whether the corresponding data exists.
3.收到“产品检测报告表”的相关数据时，3. When receiving relevant data from the "Product Test Report Form",
31.会验证各必填字段是否有内容；31. Will verify whether each required field has content;
32.根据“产品编码”去“产品信息表”里验证是否存在对应的数据；32. According to the "Product Code", go to the "Product Information Table" to verify whether the corresponding data exists;
33.如果相关数据中，存在“产品详细编码”的情况下，根据“产品详细编码”去“产品详细信息表”里验证是否存在对应的数据。33. If there is a "Product Detailed Code" in the relevant data, go to the "Product Detailed Information Table" based on the "Product Detailed Code" to verify whether the corresponding data exists.
4.收到“产品元器件清单表”的相关数据时，4. When receiving the relevant data of the "Product Component List",
41.会验证各必填字段是否有内容；41. Will verify whether each required field has content;
42.根据“产品编码”去“产品信息表”里验证是否存在对应的数据；42. According to the "product code", go to the "product information table" to verify whether there is corresponding data;
43.根据“产品详细信息编码”去“产品详细信息表”里验证是否存在对应的数据；43. According to the "Product Details Code", go to the "Product Details Table" to verify whether the corresponding data exists;
44.根据“研发方案编号”去“研发方案信息表”里验证是否存在对应的数据；44. According to the "R&D Plan Number", go to the "R&D Plan Information Table" to verify whether the corresponding data exists;
45.根据“元器件编号”去“元器件信息表”里验证是否存在对应的数据。45. According to the "Component Number", go to the "Component Information Table" to verify whether the corresponding data exists.
5.收到“环境温湿度检测表”的相关数据时，5. When receiving the relevant data from the "Environmental Temperature and Humidity Test Form",
51.会验证各必填字段是否有内容；51. Will verify whether each required field has content;
52.根据“生产工序”去“生产工序表”里验证是否存在对应的数据。52. According to the "Production Process", go to the "Production Process Table" to verify whether the corresponding data exists.
6.收到“电能表资产信息表”的相关数据时，6. When receiving the relevant data of the "Energy Meter Asset Information Form",
61.会验证各必填字段是否有内容；61. Will verify whether each required field has content;
62.根据“计划单号”去“生产计划表”里验证是否存在对应的数据。62. According to the "planning order number", go to the "production schedule" to verify whether the corresponding data exists.
7.收到“模块光学检测表”的相关数据时，7. When receiving relevant data from the "Module Optical Inspection Form",
71.会验证各必填字段是否有内容；71. Will verify whether each required field has content;
72.根据“PCB板号”去“电能表PCB板号和厂内编码绑定表”里验证是否存在对应的数据。72. According to the "PCB board number", go to the "Energy meter PCB board number and factory coding binding table" to verify whether the corresponding data exists.
8.收到“单板检测表”的相关数据时，8. When receiving relevant data from the "Single Board Test Form",
81.会验证各必填字段是否有内容；81. Will verify whether each required field has content;
82.根据“PCB板号”去“电能表PCB板号和厂内编码绑定表”里验证是否存在对应的数据。82. According to the "PCB board number", go to the "Energy meter PCB board number and factory coding binding table" to verify whether the corresponding data exists.
9.收到“模块老化检测表”的相关数据时，9. When receiving relevant data from the "Module Aging Detection Form",
91.会验证各必填字段是否有内容；91. Will verify whether each required field has content;
92.根据“PCB板号”去“电能表PCB板号和厂内编码绑定表”里验证是否存在对应的数据。92. According to the "PCB board number", go to the "Energy meter PCB board number and factory coding binding table" to verify whether the corresponding data exists.
10.收到“整机老化检测表”的相关数据时，10. When receiving the relevant data from the "Complete Machine Aging Detection Form",
101.会验证各必填字段是否有内容；101. Will verify whether each required field has content;
102.根据“厂内编号”去“电能表资产信息表”里验证是否存在对应的数据。102. According to the "factory number", go to the "Energy Meter Asset Information Table" to verify whether the corresponding data exists.
11.收到“外观检测表”的相关数据时，11. When receiving the relevant data of the "Appearance Inspection Form",
111.会验证各必填字段是否有内容；111. Will verify whether each required field has content;
112.根据“厂内编号”去“电能表资产信息表”里验证是否存在对应的数据。112. According to the "factory number", go to the "Energy Meter Asset Information Table" to verify whether the corresponding data exists.
12.收到“交流耐压测试表”的相关数据时，12. When receiving the relevant data from the "AC Withstand Voltage Test Table",
121.会验证各必填字段是否有内容；121. Will verify whether each required field has content;
122.根据“厂内编号”去“电能表资产信息表”里验证是否存在对应的数据；122. According to the "factory number", go to the "Energy Meter Asset Information Table" to verify whether the corresponding data exists;
13.收到“起动试验表”的相关数据时，13. When receiving relevant data from the "Starting Test Table",
131.会验证各必填字段是否有内容；131. Will verify whether each required field has content;
132.根据“厂内编号”去“电能表资产信息表”里验证是否存在对应的数据；132. According to the "factory number", go to the "Energy Meter Asset Information Table" to verify whether the corresponding data exists;
14.收到“电能表常数试验表”的相关数据时，14. When receiving the relevant data of the "Energy Meter Constant Test Table",
141.会验证各必填字段是否有内容；141. Will verify whether each required field has content;
142.根据“厂内编号”去“电能表资产信息表”里验证是否存在对应的数据。142. According to the "factory number", go to the "Energy Meter Asset Information Table" to verify whether the corresponding data exists.
15.收到“计度器总电能示值组合误差表”的相关数据时，15. When receiving the relevant data of the "Combined Error Table of the Total Electric Energy Indication of the Meter",
151.会验证各必填字段是否有内容；151. Will verify whether each required field has content;
152.根据“厂内编号”去“电能表资产信息表”里验证是否存在对应的数据。152. According to the "factory number", go to the "Energy Meter Asset Information Table" to verify whether the corresponding data exists.
16.收到“日计时误差表”的相关数据时，16. When receiving the relevant data of the "Daily Timing Error Table",
161.会验证各必填字段是否有内容；161. Will verify whether each required field has content;
162.根据“厂内编号”去“电能表资产信息表”里验证是否存在对应的数据。162. According to the "factory number", go to the "Energy Meter Asset Information Table" to verify whether the corresponding data exists.
17.收到“起动时段投切误差表”的相关数据时，17. When receiving the relevant data of the "Starting Period Switching Error Table",
171.会验证各必填字段是否有内容；171. Will verify whether each required field has content;
172.根据“厂内编号”去“电能表资产信息表”里验证是否存在对应的数据。172. According to the "factory number", go to the "Energy Meter Asset Information Table" to verify whether the corresponding data exists.
18.收到“功能检测表”的相关数据时，18. When receiving relevant data from the "Function Test Form",
181.会验证各必填字段是否有内容；181. Will verify whether each required field has content;
182.根据“厂内编号”去“电能表资产信息表”里验证是否存在对应的数据。182. According to the "factory number", go to the "Energy Meter Asset Information Table" to verify whether the corresponding data exists.
19.收到“费控试验表”的相关数据时，19. When receiving the relevant data of the "Fee Control Test Form",
191.会验证各必填字段是否有内容；191. Will verify whether each required field has content;
192.根据“厂内编号”去“电能表资产信息表”里验证是否存在对应的数据。192. According to the "factory number", go to the "Energy Meter Asset Information Table" to verify whether the corresponding data exists.
20.收到“电子标签检测表”的相关数据时，20. When receiving the relevant data of the "Electronic Label Test Form",
201.会验证各必填字段是否有内容；201. Will verify whether each required field has content;
202.根据“厂内编号”去“电能表资产信息表”里验证是否存在对应的数据。202. According to the "factory number", go to the "Energy Meter Asset Information Table" to verify whether the corresponding data exists.
21.收到“规约一致性检查表”的相关数据时，21. When receiving relevant data from the "Protocol Consistency Checklist",
211.会验证各必填字段是否有内容；211. Will verify whether each required field has content;
212.根据“厂内编号”去“电能表资产信息表”里验证是否存在对应的数据。212. According to the "factory number", go to the "Energy Meter Asset Information Table" to verify whether the corresponding data exists.
22.收到“误差一致性试验表”的相关数据时，22. When receiving the relevant data of the "Error Consistency Test Table",
221.会验证各必填字段是否有内容；221. Will verify whether each required field has content;
222.根据“厂内编号”去“电能表资产信息表”里验证是否存在对应的数据。222. According to the "factory number", go to the "Energy Meter Asset Information Table" to verify whether the corresponding data exists.
通过核查A、B两家生产企业的研发环节相关业务数据，发现“产品信息表”数据量：A企业有8条数据，B企业有85条数据；非空字段问题：2家企业均不存在；标准代码问题：A企业的产品类别“8”不在码表中，B企业的产品类别“76”不在码表中；数据重复问题：2家企业均不存在。“产品详细信息表”数据量：A企业有10条数据，B企业有76条数据；非空字段问题：A企业‘研发方案编号’为空有3条数据，B企业则没有该类问题数据；标准代码问题：2家企业均无该类问题数据；数据重复问题：2家企业也均无重复数据。By checking the business data related to the R&D link of two production companies, A and B, it was found that the data volume of the "Product Information Table": Company A has 8 pieces of data, and Company B has 85 pieces of data; non-empty field problem: neither company exists. ;Standard code problem: Company A's product category "8" is not in the code table, and Company B's product category "76" is not in the code table; Data duplication problem: Neither company exists. Data volume of "Product Details Table": Company A has 10 pieces of data, Company B has 76 pieces of data; non-empty field problem: Company A's 'R&D Plan Number' is empty and has 3 pieces of data, while Company B has no such problem data ; Standard code problem: neither company has data on this type of problem; data duplication problem: neither company has duplicate data.
实施例2Example 2
本实施例提供一种电能表质量数据格式核查系统，其包括：This embodiment provides an electric energy meter quality data format verification system, which includes:
数据量核查单元：对所接入的每张表的数据量进行核查统计；Data volume verification unit: Verifies and counts the data volume of each connected table;
非空字段核查单元：对有数据的表，验证其各必填字段是否有内容；Non-empty field verification unit: For tables with data, verify whether each required field has content;
标准代码核查单元：通过与码表比对验证标准代码值是否正确；Standard code verification unit: Verify whether the standard code value is correct by comparing it with the code table;
数据重复问题核查单元：根据某一字段或者某行记录对表中所有数据进行比对，来查询已有数据表中是否有重复的数据；Data duplication problem verification unit: compares all data in the table based on a certain field or row of records to query whether there is duplicate data in the existing data table;
数据类型核查单元：根据标准数据格式对某些特殊类型字段进行核查。Data type checking unit: Checks certain special types of fields according to standard data formats.
所述的非空字段核查单元中，所述有数据的表为产品信息表时，根据生产企业编码分组，查询在数据模型里面定义的所有为非空的字段，包括产品编码、企业编码、产品型号、产品名称、产品类别、产品设计依据、通知号，如果有任何一列为空，统计值加1，查询结果如果企业编号的统计值大于零，则数据不合格。In the non-empty field verification unit, when the table with data is a product information table, it is grouped according to the production enterprise code and queries all non-empty fields defined in the data model, including product code, enterprise code, product Model, product name, product category, product design basis, notification number. If any column is empty, the statistical value is increased by 1. If the statistical value of the enterprise number in the query result is greater than zero, the data is unqualified.
所述的数据重复问题核查单元中，所述有数据的表为产品信息表时，首先根据产品编码分组，查询在数据模型里面定义的主键字段的最小值；然后根据企业编码分组，查询主键字段不等于最小值，统计值加1，查询结果如果是企业编号的统计值大于零，则数据不合格。In the data duplication problem checking unit, when the table with data is a product information table, first group according to the product code and query the minimum value of the primary key field defined in the data model; then group according to the enterprise code and query the primary key field If it is not equal to the minimum value, the statistical value is increased by 1. If the query result is that the statistical value of the enterprise number is greater than zero, the data is unqualified.
所述的数据类型核查单元中，所述的某些特殊类型字段为日期类型字段和时间类型字段。In the data type checking unit, some of the special types of fields are date type fields and time type fields.
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010705440.2ACN111858646B (en) | 2020-07-21 | 2020-07-21 | A method and system for checking quality data format of electric energy meter |
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010705440.2ACN111858646B (en) | 2020-07-21 | 2020-07-21 | A method and system for checking quality data format of electric energy meter |
| Publication Number | Publication Date |
|---|---|
| CN111858646A CN111858646A (en) | 2020-10-30 |
| CN111858646Btrue CN111858646B (en) | 2023-11-07 |
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010705440.2AActiveCN111858646B (en) | 2020-07-21 | 2020-07-21 | A method and system for checking quality data format of electric energy meter |
| Country | Link |
|---|---|
| CN (1) | CN111858646B (en) |
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112417841B (en)* | 2020-11-20 | 2023-09-05 | 浪潮卓数大数据产业发展有限公司 | Data verification method |
| CN113792033A (en)* | 2021-08-12 | 2021-12-14 | 北京中交兴路信息科技有限公司 | Spark-based data quality checking method and device, storage medium and terminal |
| CN113888029B (en)* | 2021-10-27 | 2025-04-18 | 上海倍通医药科技咨询有限公司 | A channel data inspection and auditing method and system |
| CN117078192B (en)* | 2023-08-18 | 2024-06-28 | 索罗曼(广州)新材料有限公司 | Titanium flat bar manufacturing tool mold management system and method |
| CN117591508B (en)* | 2024-01-19 | 2024-05-28 | 云筑信息科技(成都)有限公司 | Data quality guarantee method under big data scene |
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA1288164C (en)* | 1988-04-20 | 1991-08-27 | Stanley M. Josephson | Financial data processing system |
| CN101441256A (en)* | 2008-12-25 | 2009-05-27 | 黑龙江省电工仪器仪表工程技术研究中心有限公司 | Computer detection system of electrical energy meter production line |
| CN102571403A (en)* | 2010-12-31 | 2012-07-11 | 北京亿阳信通软件研究院有限公司 | Realization method and device for general data quality control adapter |
| CN103064909A (en)* | 2012-12-19 | 2013-04-24 | 武汉虹翼信息有限公司 | Base station database inspection method based on Drools rule engine |
| CN103414601A (en)* | 2013-07-19 | 2013-11-27 | 广东电网公司电力调度控制中心 | Method and system for detecting data for communication resource management system |
| CN105678646A (en)* | 2016-03-24 | 2016-06-15 | 国网辽宁省电力有限公司电力科学研究院 | Production management system distribution network equipment machine account intelligent inspection system |
| CN105976120A (en)* | 2016-05-17 | 2016-09-28 | 全球能源互联网研究院 | Electric power operation monitoring data quality assessment system and method |
| CN106022666A (en)* | 2016-07-28 | 2016-10-12 | 国网上海市电力公司 | Measuring asset full life cycle management data quality checking method |
| CN109213986A (en)* | 2018-09-06 | 2019-01-15 | 中国疾病预防控制中心环境与健康相关产品安全所 | A kind of automation method for reporting that the Environmental Health quality of data is verified |
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA1288164C (en)* | 1988-04-20 | 1991-08-27 | Stanley M. Josephson | Financial data processing system |
| CN101441256A (en)* | 2008-12-25 | 2009-05-27 | 黑龙江省电工仪器仪表工程技术研究中心有限公司 | Computer detection system of electrical energy meter production line |
| CN102571403A (en)* | 2010-12-31 | 2012-07-11 | 北京亿阳信通软件研究院有限公司 | Realization method and device for general data quality control adapter |
| CN103064909A (en)* | 2012-12-19 | 2013-04-24 | 武汉虹翼信息有限公司 | Base station database inspection method based on Drools rule engine |
| CN103414601A (en)* | 2013-07-19 | 2013-11-27 | 广东电网公司电力调度控制中心 | Method and system for detecting data for communication resource management system |
| CN105678646A (en)* | 2016-03-24 | 2016-06-15 | 国网辽宁省电力有限公司电力科学研究院 | Production management system distribution network equipment machine account intelligent inspection system |
| CN105976120A (en)* | 2016-05-17 | 2016-09-28 | 全球能源互联网研究院 | Electric power operation monitoring data quality assessment system and method |
| CN106022666A (en)* | 2016-07-28 | 2016-10-12 | 国网上海市电力公司 | Measuring asset full life cycle management data quality checking method |
| CN109213986A (en)* | 2018-09-06 | 2019-01-15 | 中国疾病预防控制中心环境与健康相关产品安全所 | A kind of automation method for reporting that the Environmental Health quality of data is verified |
| Title |
|---|
| survey on synchrophasor data quality and cybersecurity challenges and evaluation of their interdependencies;Aditya Sundararajan等;journal of modern power systems and clean energy;第7卷(第3期);449-467* |
| 深化用电信息采集系统数据分析及应用研究;黄乐媛;雷乾;徐钦华;谭旎栗;王月霞;;中国新通信;第22卷(第01期);117-118* |
| 电网地理信息移动采集数据质量控制技术研究;李源林;刘行波;;测绘与空间地理信息;第39卷(第08期);9-11+16* |
| Publication number | Publication date |
|---|---|
| CN111858646A (en) | 2020-10-30 |
| Publication | Publication Date | Title |
|---|---|---|
| CN111858646B (en) | A method and system for checking quality data format of electric energy meter | |
| CN110659273B (en) | Data abnormity monitoring and repairing method of distributed big data acquisition platform | |
| CN104330759B (en) | The magnitude tracing method of low-voltage current mutual inductor automatic calibration system | |
| WO2021135177A1 (en) | Construction method and apparatus for energy data warehouse system | |
| CN108830437A (en) | An Evaluation Method for Smart Energy Meter Operation | |
| CN103824148A (en) | Power marketing risk pre-warning method and system | |
| CN108776856B (en) | Electric power standing book data verification method and device based on traceability relation | |
| CN112701790A (en) | Transformer substation and main station intelligent joint debugging platform and joint debugging method | |
| CN108446885A (en) | A kind of automatic collecting method of review comment | |
| CN110570083A (en) | An Inter-regional Spot Market Technical Support System | |
| CN107741577A (en) | A method and system for on-line monitoring and analysis of gateway meter accuracy | |
| CN103107914A (en) | Detection method and detection system for remote power acquisition terminal | |
| WO2025001430A1 (en) | System and method for carbon emission monitoring in highway construction period | |
| CN107607811A (en) | A kind of analysis system of electricity quality evaluation and on-line early warning | |
| CN110687494A (en) | Method and system for fault monitoring of remote gateway electric energy meter | |
| CN113590607A (en) | Electric power marketing report realization method and system based on report factor | |
| CN109685684A (en) | A kind of low-voltage network topological structure method of calibration of knowledge based map | |
| CN115097376A (en) | Processing method and device for check data of metering equipment and computer equipment | |
| CN104766180A (en) | Method for improving power failure information submission accuracy | |
| CN118174812A (en) | Time-frequency synchronization method, device, medium and equipment for power system | |
| CN116244280A (en) | Quality management, measurement and test model and method for data | |
| CN114779154B (en) | Smart electric meter data time scale calibration method and device based on temporal analysis | |
| CN104880690B (en) | A kind of evaluation method of electric energy meter operation | |
| CN112132457A (en) | 95598 data quality inspection and evaluation method and system based on data center platform | |
| CN116664095B (en) | Security inspection prediction method based on deep learning |
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |