CN112435001A - Multi-source data checking method and device for power distribution network - Google Patents
Multi-source data checking method and device for power distribution network Download PDFInfo
- Publication number
- CN112435001A CN112435001A CN202011270495.1A CN202011270495A CN112435001A CN 112435001 A CN112435001 A CN 112435001A CN 202011270495 A CN202011270495 A CN 202011270495A CN 112435001 A CN112435001 A CN 112435001A
- Authority
- CN
- China
- Prior art keywords
- power object
- data
- standing book
- book data
- power
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000009826 distribution Methods 0.000 title claims abstract description 36
- 238000000034 method Methods 0.000 title claims abstract description 35
- 238000012545 processing Methods 0.000 claims abstract description 21
- 238000004519 manufacturing process Methods 0.000 claims abstract description 19
- 238000007726 management method Methods 0.000 claims abstract description 18
- 238000004458 analytical method Methods 0.000 claims abstract description 17
- 230000001502 supplementing effect Effects 0.000 claims abstract description 16
- 238000012937 correction Methods 0.000 claims abstract description 15
- 238000010586 diagram Methods 0.000 description 11
- 238000004891 communication Methods 0.000 description 10
- 230000005611 electricity Effects 0.000 description 10
- 238000003860 storage Methods 0.000 description 7
- 238000005516 engineering process Methods 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 230000008859 change Effects 0.000 description 2
- 238000007405 data analysis Methods 0.000 description 2
- 230000003247 decreasing effect Effects 0.000 description 2
- 230000001419 dependent effect Effects 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000004927 fusion Effects 0.000 description 2
- 238000013516 source data verification Methods 0.000 description 2
- 230000003068 static effect Effects 0.000 description 2
- 239000013589 supplement Substances 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000009434 installation Methods 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000011835 investigation Methods 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000001737 promoting effect Effects 0.000 description 1
- 150000003839 salts Chemical class 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Entrepreneurship & Innovation (AREA)
- Marketing (AREA)
- General Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- Public Health (AREA)
- Primary Health Care (AREA)
- General Health & Medical Sciences (AREA)
- Data Mining & Analysis (AREA)
- Water Supply & Treatment (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The specification provides a multi-source data checking method and device for a power distribution network, and the method comprises the steps of obtaining first account data in a marketing system, second account data in a production management system and third account data in a geographic information system; performing object consistency analysis on the first, second and third standing book data to determine a complete power object and a missing power object, and supplementing the missing power object into the complete power object to obtain the first, second and third standing book data with complete objects; merging the same power object and corresponding power object information based on first, second and third standing book data with complete objects to obtain merged standing book data; and checking the combined ledger data, determining the electric power object with the wrong incidence relation, and performing relation correction on the electric power object with the wrong incidence relation to obtain corrected ledger data. The complete and accurate standing book data can be obtained by processing the standing book data from different systems.
Description
Technical Field
One or more embodiments of the present disclosure relate to the field of data processing technologies, and in particular, to a multi-source data checking method and device for a power distribution network.
Background
At present, account data, production operation information and the like of a power distribution network are mainly stored in a marketing system (a comprehensive management system for services such as power distribution network customer service, electric energy calculation, electric charge management, business development and installation) of a power company, a production management system (a system for equipment management and resource scheduling in the production process of the power distribution network) and a geographic information system (a comprehensive display system for geographic information and topological information of the power distribution network), and each system is used for maintaining and managing.
Disclosure of Invention
In view of this, one or more embodiments of the present disclosure provide a method and an apparatus for checking multi-source data of a power distribution network, so as to solve the problem of checking and integrating ledger data from different systems.
In view of the above, one or more embodiments of the present specification provide a multi-source data checking method for a power distribution network, including:
acquiring first standing book data in a marketing system, second standing book data in a production management system and third standing book data in a geographic information system; the first standing book data, the second standing book data and the third standing book data comprise at least one electric power object and corresponding electric power object information;
performing object consistency analysis on the first standing book data, the second standing book data and the third standing book data to determine a complete power object and a missing power object, and supplementing the missing power object to the complete power object to obtain the first standing book data, the second standing book data and the third standing book data of which the objects are complete; the complete power object is a power object included in the first standing book data, the second standing book data and the third standing book data, and the missing power object is one or two power objects not included in the first standing book data, the second standing book data and the third standing book data;
merging the same power object and corresponding power object information based on the first account data, the second account data and the third account data with complete objects to obtain merged account data;
and checking the combined machine account data, determining the electric power object with the wrong incidence relation, and performing relation correction on the electric power object with the wrong incidence relation to obtain corrected machine account data.
Optionally, supplementing the missing power object as the complete power object, including:
and supplementing the missing power object into the complete power object according to the marketing and distribution through result data.
Optionally, based on the first standing book data, the second standing book data, and the third standing book data with complete objects, the same power object and the corresponding power object information are merged to obtain merged standing book data, including:
determining the same power object and corresponding power object information in the first standing book data, the second standing book data and the third standing book data of which the object is complete;
judging whether the power object information of the same power object is the same;
if not, the power object information of the same power object is subjected to unification processing to obtain combined ledger data.
Optionally, determining whether the power object information of the same power object is the same includes:
judging whether all information items of the power object information of the same power object are the same or not; and/or the presence of a gas in the gas,
judging whether all information items of the power object information of the same power object are complete or not; and/or the presence of a gas in the gas,
judging whether the power objects having the association relation with the same power object are complete or not;
unifying the power object information of the same power object to obtain merged ledger data, including:
if at least one information item is different, unifying different information items according to the marketing and distribution run-through result data to obtain a unified information item; and/or the presence of a gas in the gas,
if at least one information item is incomplete, combining all the information items to obtain a complete information item; and/or the presence of a gas in the gas,
if the power objects associated with the same power object are not complete, all the power objects associated with the same power object are combined to obtain a complete relationship between the same power object and the power objects associated with the same power object.
Optionally, the power object having the association relationship is a substation and a line; checking the combined machine account data, determining the power object with the wrong incidence relation, and performing relation correction on the power object with the wrong incidence relation to obtain corrected machine account data, wherein the method comprises the following steps:
checking the merged ledger data to determine the transformer substation and the line with one-to-many relationship;
according to the transformer substation and the line with the one-to-many relationship, the first machine account data, the second machine account data or the third machine account data are traced, and according to the tracing result, the transformer substation and the line with the one-to-one relationship are determined;
and modifying the transformer substation and the line in the one-to-many relationship into the transformer substation and the line in the one-to-one relationship.
Optionally, the step of checking the combined ledger data by using the power objects with the association relationship as the user and the transformer to determine the power object with the incorrect association relationship, and performing relationship correction on the power object with the incorrect association relationship to obtain the corrected ledger data includes:
according to the line loss data of the transformer area, checking the relation between the user and the transformer area in the combined machine account data, determining the user and the transformer area with wrong relation, and determining the user and the transformer with wrong relation;
and correcting the users with the wrong relation and the transformer according to the transformer area line loss data to obtain the correlation relation between the corrected users and the transformer.
The embodiment of this specification still provides a multisource data of distribution network and checks device, includes:
the acquisition module is used for acquiring first standing book data in the marketing system, second standing book data in the production management system and third standing book data in the geographic information system; the first standing book data, the second standing book data and the third standing book data comprise at least one electric power object and corresponding electric power object information;
the analysis module is used for carrying out object consistency analysis on the first standing book data, the second standing book data and the third standing book data to determine a complete power object and a missing power object, and supplementing the missing power object into the complete power object to obtain the first standing book data, the second standing book data and the third standing book data which are complete in object; the complete power object is a power object included in the first standing book data, the second standing book data and the third standing book data, and the missing power object is one or two power objects not included in the first standing book data, the second standing book data and the third standing book data;
the merging module is used for merging the same power object and corresponding power object information based on the first account data, the second account data and the third account data with complete objects to obtain merged account data;
and the checking module is used for checking the combined machine account data, determining the electric power object with the wrong incidence relation, and performing relation correction on the electric power object with the wrong incidence relation to obtain the corrected machine account data.
Optionally, the analysis module is configured to supplement the missing power object with the complete power object according to marketing and distribution through result data.
Optionally, the merging module is configured to determine the same power object and corresponding power object information in the first standing book data, the second standing book data, and the third standing book data of which the object is complete; judging whether the power object information of the same power object is the same; if not, the power object information of the same power object is subjected to unification processing to obtain combined ledger data.
Optionally, the merging module includes a judgment submodule and a merging submodule;
the judgment submodule is used for judging whether all information items of the electric power object information of the same electric power object are the same or not; and/or judging whether all information items of the power object information of the same power object are complete or not; and/or judging whether the power objects having the association relation with the same power object are complete or not;
the merging submodule is used for unifying different information items according to the marketing and distribution run-through result data to obtain unified information items when at least one information item is judged to be different; and/or, when at least one information item is judged to be incomplete, combining all the information items to obtain a complete information item; and/or when the power objects having the association relation with the same power object are judged to be incomplete, combining all the power objects having the association relation with the same power object to obtain the complete relation between the same power object and the power objects having the association relation with the same power object.
As can be seen from the above, the multi-source data checking method and apparatus for a power distribution network provided in one or more embodiments of the present specification obtain first account data in a marketing system, second account data in a production management system, and third account data in a geographic information system; carrying out object consistency analysis on the three types of ledger data to determine a complete power object and a missing power object, and supplementing the missing power object into the complete power object to obtain three types of ledger data with complete objects; merging the same power object and corresponding power object information based on three types of account data with complete objects to obtain merged account data; and checking the combined ledger data, determining the electric power object with the wrong incidence relation, and performing relation correction on the electric power object with the wrong incidence relation to obtain corrected ledger data. According to the multi-source data checking method and device, complete and accurate account data can be obtained by processing account data from different systems, and then electric power data analysis processing can be performed based on the complete and accurate account data.
Drawings
In order to more clearly illustrate one or more embodiments or prior art solutions of the present specification, the drawings that are needed in the description of the embodiments or prior art will be briefly described below, and it is obvious that the drawings in the following description are only one or more embodiments of the present specification, and that other drawings may be obtained by those skilled in the art without inventive effort from these drawings.
FIG. 1 is a schematic flow chart of a method according to one or more embodiments of the present disclosure;
FIG. 2 is a schematic diagram of an electrical power object and its electrical power object information in accordance with one or more embodiments of the present disclosure;
FIG. 3 is a diagram of merging information items in one or more embodiments of the present disclosure;
FIG. 4 is a schematic diagram of a relationship between error lines according to one or more embodiments of the present disclosure;
FIG. 5A is a diagram illustrating a merged error user-variant relationship according to one or more embodiments of the present disclosure;
FIG. 5B is a schematic representation of a user-dependent relationship in the field in accordance with one or more embodiments of the disclosure;
FIG. 6 is a grid diagram of a relationship between error users according to one or more embodiments of the present disclosure;
fig. 7 is a schematic diagram of a grid element model according to one or more embodiments of the present disclosure;
FIG. 8 is a schematic diagram of an apparatus according to one or more embodiments of the present disclosure;
fig. 9 is a schematic structural diagram of an electronic device according to one or more embodiments of the present disclosure.
Detailed Description
For the purpose of promoting a better understanding of the objects, aspects and advantages of the present disclosure, reference is made to the following detailed description taken in conjunction with the accompanying drawings.
It is to be noted that unless otherwise defined, technical or scientific terms used in one or more embodiments of the present specification should have the ordinary meaning as understood by those of ordinary skill in the art to which this disclosure belongs. The use of "first," "second," and similar terms in one or more embodiments of the specification is not intended to indicate any order, quantity, or importance, but rather is used to distinguish one element from another. The word "comprising" or "comprises", and the like, means that the element or item listed before the word covers the element or item listed after the word and its equivalents, but does not exclude other elements or items. The terms "connected" or "coupled" and the like are not restricted to physical or mechanical connections, but may include electrical connections, whether direct or indirect. "upper", "lower", "left", "right", and the like are used merely to indicate relative positional relationships, and when the absolute position of the object being described is changed, the relative positional relationships may also be changed accordingly.
As shown in fig. 1, one or more embodiments of the present specification provide a multi-source data verification method for a power distribution network, including:
s101: acquiring first standing book data in a marketing system, second standing book data in a production management system and third standing book data in a geographic information system; the first standing book data, the second standing book data and the third standing book data comprise at least one electric power object and corresponding electric power object information;
in this embodiment, first account data stored and maintained in the marketing system is first acquired from the marketing system, second account data stored and maintained in the marketing system is acquired from the production management system, and third account data stored and maintained in the production management system is acquired from the geographic information system, so that the first, second, and third account data are checked and integrated in the following process.
In some embodiments, the ledger data includes at least one power object and power object information corresponding to the power object. The power object comprises various power equipment in a power distribution network such as stations, lines, transformers, households, metering points and electric meters, and the power object information comprises information items such as object types, object identifications, object names, object specifications, affiliated units and running time; for example, the power object is a feeder, and the power object information of the feeder includes information items such as a line ID, a line name, a voltage class, a feeder type, a rated current, a line length, a line model, a property attribute, a maintenance unit, an affiliated unit ID, an affiliated substation ID, a life cycle, and a commissioning date.
Because the marketing system, the production management system and the geographic information system respectively maintain and manage respective account data, the data standards of the first account data, the second account data and the third account data are inconsistent, the data updating periods are different, the data quality problems of incomplete data, incorrect data and the like exist in the first account data, the second account data and the third account data, the three account data need to be processed into complete and accurate account data in a unified mode, and subsequent electric power data analysis processing can be conveniently carried out based on the complete and accurate account data.
S102: performing object consistency analysis on the first standing book data, the second standing book data and the third standing book data to determine a complete power object and a missing power object, and supplementing the missing power object into the complete power object to obtain the first standing book data, the second standing book data and the third standing book data of which the objects are complete; the complete power object is a power object included in the first standing book data, the second standing book data and the third standing book data, and the missing power object is one or two power objects not included in the first standing book data, the second standing book data and the third standing book data;
in this embodiment, through traversing all power objects in the first standing book data, the second standing book data, and the third standing book data, a complete power object included in the first standing book data, the second standing book data, and the third standing book data, and a missing power object included in the first standing book data, the second standing book data, and the third standing book data are determined. For example, if the first standing book data, the second standing book data, and the third standing book data all include the power object a and the power object information thereof, the power object a is a complete power object; as shown in fig. 2, the first ledger data and the second ledger data include the power object B and the power object information thereof, and the third ledger data does not include the power object B and the power object information thereof, so that the power object B is a missing power object.
After the missing power object is determined, the missing power object needs to be supplemented to be a complete power object, so that the power objects in the first standing book data, the second standing book data and the third standing book data are all complete power objects.
In some embodiments, the missing power object may be supplemented as a complete power object according to the marketing and distribution through-production data. The marketing and distribution through result data is obtained by implementing marketing and distribution through projects, comprises correct power objects and power object information thereof determined through field investigation and examination, and can reflect accurate association relationship among site stations, lines, transformers and households. For the missing power object, determining power object information corresponding to the missing power object by searching the operation and distribution through result data, and supplementing the found missing power object and the power object information thereof into a complete power object, for example, if the third account data does not have the power object B, supplementing the power object B and the power object information thereof into the third account data, so that the first, second and third account data all include the power object B and the power object information thereof.
S103: merging the same power object and corresponding power object information based on the first account data, the second account data and the third account data with complete objects to obtain merged account data;
in this embodiment, based on the first, second, and third standing book data with complete objects, the same power object in the first, second, and third standing book data and the power object information corresponding thereto are merged to obtain merged standing book data with multi-source standing book data fusion.
S104: and checking the combined ledger data, determining the electric power object with the wrong incidence relation, and performing relation correction on the electric power object with the wrong incidence relation to obtain corrected ledger data.
In this embodiment, after the first, second, and third standing book data are merged, the merged standing book data are checked to determine the power object with an erroneous association, and the erroneous association is corrected to obtain corrected standing book data, where the corrected standing book data is not only complete in the power object, but also complete and accurate in the power object information of the power object.
The multi-source data checking method for the power distribution network comprises the steps of obtaining first account data in a marketing system, second account data in a production management system and third account data in a geographic information system; performing object consistency analysis on the first standing book data, the second standing book data and the third standing book data to determine a complete power object and a missing power object, and supplementing the missing power object into the complete power object to obtain the first standing book data, the second standing book data and the third standing book data of which the objects are complete; merging the same power object and corresponding power object information based on the first account data, the second account data and the third account data with complete objects to obtain merged account data; and checking the combined ledger data, determining the electric power object with the wrong incidence relation, and performing relation correction on the electric power object with the wrong incidence relation to obtain corrected ledger data. According to the method, the multi-source data fusion is carried out on the standing book data from the marketing system, the production management system and the geographic information system, the fused standing book data are complete and accurate, and the fused standing book data can be used for analyzing and processing the power data of the power distribution network.
In some embodiments, merging the same power object and corresponding power object information based on the first ledger data, the second ledger data, and the third ledger data with complete objects to obtain merged ledger data includes:
determining the same power object and corresponding power object information in the first standing book data, the second standing book data and the third standing book data with complete objects;
judging whether the power object information of the same power object is the same;
if not, the power object information of the same power object is subjected to unification processing to obtain combined ledger data.
In this embodiment, when the three types of ledger data are merged, the same power object and the power object information thereof in the three types of ledger data are determined, then whether the power object information of the same power object is the same or not is determined, and if not, the power object information of the same power object is unified, so that the merged ledger data can be obtained after the power object information of all the power objects in the three types of ledger data is unified.
In some embodiments, determining whether the power object information of the same power object is the same includes:
judging whether all information items of the power object information of the same power object are the same or not; and/or the presence of a gas in the gas,
judging whether all information items of the power object information of the same power object are complete or not; and/or the presence of a gas in the gas,
judging whether the power objects having the association relation with the same power object are complete or not;
if not, the power object information of the same power object is subjected to unification processing to obtain merged ledger data, and the method comprises the following steps:
if at least one information item is different, unifying different information items according to the marketing and distribution run-through result data to obtain a unified information item. And/or the presence of a gas in the gas,
if at least one information item is incomplete, combining all the information items to obtain a complete information item; and/or the presence of a gas in the gas,
if the power objects associated with the same power object are not complete, all the power objects associated with the same power object are combined to obtain a complete relationship between the same power object and the power objects associated with the same power object.
In this embodiment, when three types of ledger data are merged, it is determined whether each information item of electric power object information in the three types of ledger data is the same for the same electric power object in the three types of ledger data, if at least one information item is different, the information item has an error and needs to be corrected, when the correction is performed, the information item corresponding to the electric power object is searched and determined according to the marketing and distribution through result data, and the information item corresponding to the electric power object in the three types of ledger data is unified according to the searched information item, so that the merging of the electric power object and the electric power object information thereof is realized.
Meanwhile, for the same electric power object in the three types of ledger data, whether each information item of the electric power object information in the three types of ledger data is complete or not needs to be judged, and if the information items are incomplete, all the information items of the same electric power object in the three types of ledger data are combined to obtain the complete electric power object information of the electric power object. And judging whether the power objects having the association relation with the same power object in the three types of ledger data are complete, and if not, combining the relations of the same power object and the power objects having the association relation with the same power object into a complete relation. In this way, by correcting the error information items of the power object and combining all the information items, the power object and the power object information thereof are combined, and the combination processing of the three types of ledger data is realized.
For example, as shown in fig. 2, after the object consistency analysis and processing, the first standing book data, the second standing book data, and the third standing book data of the complete object all include the power object B, when the three types of standing book data are merged, it is determined whether each information item of the power object B in the three types of standing book data is the same, and after comparison, it is determined that the power supply unit of the power object B in the first standing book data is the power company in the west ampere city, the power supply unit of the power object B in the second standing book data is the power company in the salt yang city, and the power supply unit of the power object B in the third standing book data is the power company in the west ampere city. Optionally, the power supply unit of the power object B is searched and determined by means of the marketing and distribution through result data, and the power supply units of the power object B in the three types of ledger data are unified into the searched power supply unit according to the searched power supply unit, so that the unification of all information items of the power object B is realized.
As shown in fig. 3, when the three types of standing book data are merged, it is further necessary to determine whether each information item of the same power object in the three types of standing book data is complete. For example, the power object included in the first ledger data is a substation, the power object information of the substation includes a name, a power supply unit, and an address, the power object having an association relationship with the substation is a line, and the power object information of the line includes a name, a power supply unit, and an address; the second account data comprises a transformer substation, and the electric power object information of the transformer substation comprises a name, a power supply unit and commissioning time; the method comprises the steps of determining that the first account data comprises the address of the transformer substation through judging information items of the transformer substation shared by the two kinds of account data, determining that the second account data does not comprise the address of the transformer substation, determining that the second account data comprises the commissioning time of the transformer substation, and determining that the first account data does not comprise the commissioning time of the transformer substation, and merging all information items related to the transformer substation when the first account data and the second account data are merged to obtain complete power object information related to the transformer substation.
In some embodiments, the checking the merged ledger data to determine an electric power object with a wrong association relation, and performing relation correction on the electric power object with the wrong association relation to obtain corrected ledger data includes:
checking the combined ledger data to determine the transformer substation and the line with one-to-many relationship;
tracing the first account data, the second account data or the third account data according to the transformer substations and the lines with one-to-many relationship, and determining the transformer substations and the lines with one-to-one relationship according to the tracing result;
and modifying the transformer substation and the line in one-to-many relationship into the transformer substation and the line in one-to-one relationship.
In this embodiment, after the ledger data is merged, the merged ledger data needs to be checked, and an electric power object with an incorrect association relationship is determined. As shown in fig. 4, because the transformer substation and the line should be in a one-to-one association relationship, in the checking process, if a transformer substation and a line having a one-to-many relationship are found, it may be determined that an error exists in the association relationship between the transformer substation and the line, the source account data (the first account data, the second account data, or the third account data) of the transformer substation and the line is further traced, the transformer substation and the line having a one-to-one relationship are determined by tracing the source account data, and the transformer substation and the line having a one-to-many relationship in the merged account data are corrected to be in a one-to-one relationship, so as to obtain corrected account data.
In some embodiments, the step of checking the combined ledger data by using the power objects having the association relationship as the user and the transformer to determine the power object with the incorrect association relationship, and performing relationship correction on the power object with the incorrect association relationship to obtain the corrected ledger data includes:
according to the line loss data of the transformer area, the relationship between the users and the transformer area in the combined machine account data is checked, the users and the transformer area with the wrong relationship are determined, and the users and the transformer with the wrong relationship are determined;
and according to the line loss data of the transformer area, correcting the users with wrong relation and the transformer to obtain the correlation relation between the corrected users and the transformer.
In this embodiment, after the ledger data is merged, the account-change relationship in the merged ledger data needs to be checked, and if the account-change relationships recorded in the systems are consistent, the actual account-change relationship needs to be checked in combination. With reference to fig. 5A and 5B, in some embodiments, in the consolidated ledger data, since the house-to-house relationship in each system is the transformer a corresponding to the user a, the consolidated ledger data is also the transformer a corresponding to the user a, and the house-to-house relationship is the transformer B corresponding to the user a according to the actual house-to-house relationship in the field, so that the house-to-house relationship needs to be corrected to the actual house-to-house relationship in the field.
Referring to fig. 6, the user a should belong to the platform area 2, but in the consolidated account data, the user a belongs to the platform area 1, so that the electricity sales of the platform area 1 includes the electricity consumption of the user a, that is, the electricity sales of the platform area 1 is increased, but the electricity supply of the platform area 1 is not changed, the line loss of the platform area 1 is increased, and similarly, the electricity sales of the platform area 2 is decreased, the electricity supply is not changed, and the line loss is decreased, so that the error relationship between the user a and the platform area can be determined by the electricity sales, electricity supply and line loss data of the platform area 1 and the electricity sales, electricity supply and line loss data of the platform area 2. Furthermore, by analyzing the change curve of the station area daily line loss, the time point when the station area line loss changes from normal to abnormal is determined, the newly added or modified user variable relationship at the time point is searched, the possible error in the relationship between the user A and the transformer is determined, and then the wrong user variable relationship is modified into the user variable relationship according with the field situation.
In a specific embodiment, the method includes first obtaining account data in a marketing system, a production management system and a geographic information system, and performing data standardization on the account data of each system to facilitate subsequent merging and checking, where the data standardization may be standardization of power object dimensions and unification of dictionary codes. Then, the three types of standardized ledger data are respectively imported into a graph database, the graph database is used for processing the ledger data, the power objects are used as nodes, relationships among the nodes are established based on the incidence relationships among the power objects, and a power grid meta-model (an example shown in fig. 7) of each system is generated. And then, carrying out object consistency analysis, merging processing and checking processing on the basis of the grid meta-model of each system, and finally obtaining comprehensive and accurate account data with complete and accurate electric power objects, complete and accurate electric power object information and complete and accurate incidence relation among the electric power objects by processing the three account data from the three systems.
It should be noted that the method of one or more embodiments of the present disclosure may be performed by a single device, such as a computer or server. The method of the embodiment can also be applied to a distributed scene and completed by the mutual cooperation of a plurality of devices. In such a distributed scenario, one of the devices may perform only one or more steps of the method of one or more embodiments of the present disclosure, and the devices may interact with each other to complete the method.
The foregoing description has been directed to specific embodiments of this disclosure. Other embodiments are within the scope of the following claims. In some cases, the actions or steps recited in the claims may be performed in a different order than in the embodiments and still achieve desirable results. In addition, the processes depicted in the accompanying figures do not necessarily require the particular order shown, or sequential order, to achieve desirable results. In some embodiments, multitasking and parallel processing may also be possible or may be advantageous.
As shown in fig. 8, the present embodiment further provides a multi-source data verification apparatus for a power distribution network, including:
the acquisition module is used for acquiring first standing book data in the marketing system, second standing book data in the production management system and third standing book data in the geographic information system; the first standing book data, the second standing book data and the third standing book data comprise at least one electric power object and corresponding electric power object information;
the analysis module is used for carrying out object consistency analysis on the first standing book data, the second standing book data and the third standing book data, determining a complete power object and a missing power object, supplementing the missing power object into the complete power object, and obtaining the first standing book data, the second standing book data and the third standing book data of which the objects are complete; the complete power object is a power object included in the first standing book data, the second standing book data and the third standing book data, and the missing power object is one or two power objects not included in the first standing book data, the second standing book data and the third standing book data;
the merging module is used for merging the same power object and corresponding power object information based on the first account data, the second account data and the third account data with complete objects to obtain merged account data;
and the checking module is used for checking the combined machine account data, determining the electric power object with the wrong association relation, and correcting the relation of the electric power object with the wrong association relation to obtain the corrected machine account data.
In some embodiments, the analysis module is configured to supplement the missing power object with a complete power object according to the marketing and distribution through-production data.
In some embodiments, the merging module is configured to determine a same power object and corresponding power object information in first ledger data, second ledger data, and third ledger data in which an object is complete; judging whether the power object information of the same power object is the same; if not, the power object information of the same power object is subjected to unification processing to obtain combined ledger data.
In some embodiments, the merge module includes a judge submodule and a merge submodule;
the judgment submodule is used for judging whether all information items of the electric power object information of the same electric power object are the same or not; and/or judging whether all information items of the power object information of the same power object are complete or not; and/or judging whether the power objects having the association relation with the same power object are complete or not;
the merging submodule is used for unifying different information items according to the marketing and distribution run-through result data to obtain unified information items when at least one information item is judged to be different; and/or, when at least one information item is judged to be incomplete, combining all the information items to obtain a complete information item; and/or when the power objects having the association relation with the same power object are judged to be incomplete, combining the power objects having the association relation with the same power object to obtain the complete relation between the same power object and the power objects having the association relation with the same power object.
For convenience of description, the above devices are described as being divided into various modules by functions, and are described separately. Of course, the functionality of the modules may be implemented in the same one or more software and/or hardware implementations in implementing one or more embodiments of the present description.
The apparatus of the foregoing embodiment is used to implement the corresponding method in the foregoing embodiment, and has the beneficial effects of the corresponding method embodiment, which are not described herein again.
Fig. 9 is a schematic diagram illustrating a more specific hardware structure of an electronic device according to this embodiment, where the electronic device may include: a processor 1010, a memory 1020, an input/output interface 1030, a communication interface 1040, and a bus 1050. Wherein the processor 1010, memory 1020, input/output interface 1030, and communication interface 1040 are communicatively coupled to each other within the device via bus 1050.
The processor 1010 may be implemented by a general-purpose CPU (Central Processing Unit), a microprocessor, an Application Specific Integrated Circuit (ASIC), or one or more Integrated circuits, and is configured to execute related programs to implement the technical solutions provided in the embodiments of the present disclosure.
The Memory 1020 may be implemented in the form of a ROM (Read Only Memory), a RAM (Random Access Memory), a static storage device, a dynamic storage device, or the like. The memory 1020 may store an operating system and other application programs, and when the technical solution provided by the embodiments of the present specification is implemented by software or firmware, the relevant program codes are stored in the memory 1020 and called to be executed by the processor 1010.
The input/output interface 1030 is used for connecting an input/output module to input and output information. The i/o module may be configured as a component in a device (not shown) or may be external to the device to provide a corresponding function. The input devices may include a keyboard, a mouse, a touch screen, a microphone, various sensors, etc., and the output devices may include a display, a speaker, a vibrator, an indicator light, etc.
The communication interface 1040 is used for connecting a communication module (not shown in the drawings) to implement communication interaction between the present apparatus and other apparatuses. The communication module can realize communication in a wired mode (such as USB, network cable and the like) and also can realize communication in a wireless mode (such as mobile network, WIFI, Bluetooth and the like).
It should be noted that although the above-mentioned device only shows the processor 1010, the memory 1020, the input/output interface 1030, the communication interface 1040 and the bus 1050, in a specific implementation, the device may also include other components necessary for normal operation. In addition, those skilled in the art will appreciate that the above-described apparatus may also include only those components necessary to implement the embodiments of the present description, and not necessarily all of the components shown in the figures.
Computer-readable media of the present embodiments, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), Static Random Access Memory (SRAM), Dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), Read Only Memory (ROM), Electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), Digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device.
Those of ordinary skill in the art will understand that: the discussion of any embodiment above is meant to be exemplary only, and is not intended to intimate that the scope of the disclosure, including the claims, is limited to these examples; within the spirit of the present disclosure, features from the above embodiments or from different embodiments may also be combined, steps may be implemented in any order, and there are many other variations of different aspects of one or more embodiments of the present description as described above, which are not provided in detail for the sake of brevity.
In addition, well-known power/ground connections to Integrated Circuit (IC) chips and other components may or may not be shown in the provided figures, for simplicity of illustration and discussion, and so as not to obscure one or more embodiments of the disclosure. Furthermore, devices may be shown in block diagram form in order to avoid obscuring the understanding of one or more embodiments of the present description, and this also takes into account the fact that specifics with respect to implementation of such block diagram devices are highly dependent upon the platform within which the one or more embodiments of the present description are to be implemented (i.e., specifics should be well within purview of one skilled in the art). Where specific details (e.g., circuits) are set forth in order to describe example embodiments of the disclosure, it should be apparent to one skilled in the art that one or more embodiments of the disclosure can be practiced without, or with variation of, these specific details. Accordingly, the description is to be regarded as illustrative instead of restrictive.
While the present disclosure has been described in conjunction with specific embodiments thereof, many alternatives, modifications, and variations of these embodiments will be apparent to those of ordinary skill in the art in light of the foregoing description. For example, other memory architectures (e.g., dynamic ram (dram)) may use the discussed embodiments.
It is intended that the one or more embodiments of the present specification embrace all such alternatives, modifications and variations as fall within the broad scope of the appended claims. Therefore, any omissions, modifications, substitutions, improvements, and the like that may be made without departing from the spirit and principles of one or more embodiments of the present disclosure are intended to be included within the scope of the present disclosure.
Claims (10)
1. A multi-source data checking method for a power distribution network is characterized by comprising the following steps:
acquiring first standing book data in a marketing system, second standing book data in a production management system and third standing book data in a geographic information system; the first standing book data, the second standing book data and the third standing book data comprise at least one electric power object and corresponding electric power object information;
performing object consistency analysis on the first standing book data, the second standing book data and the third standing book data to determine a complete power object and a missing power object, and supplementing the missing power object to the complete power object to obtain the first standing book data, the second standing book data and the third standing book data of which the objects are complete; the complete power object is a power object included in the first standing book data, the second standing book data and the third standing book data, and the missing power object is one or two power objects not included in the first standing book data, the second standing book data and the third standing book data;
merging the same power object and corresponding power object information based on the first account data, the second account data and the third account data with complete objects to obtain merged account data;
and checking the combined machine account data, determining the electric power object with the wrong incidence relation, and performing relation correction on the electric power object with the wrong incidence relation to obtain corrected machine account data.
2. The method of claim 1, wherein supplementing the missing power object as the full power object comprises:
and supplementing the missing power object into the complete power object according to the marketing and distribution through result data.
3. The method of claim 1, wherein merging the same power object and corresponding power object information based on the first, second, and third account data of the complete object to obtain merged account data comprises:
determining the same power object and corresponding power object information in the first standing book data, the second standing book data and the third standing book data of which the object is complete;
judging whether the power object information of the same power object is the same;
if not, the power object information of the same power object is subjected to unification processing to obtain combined ledger data.
4. The method of claim 3, wherein determining whether the power object information of the same power object is the same comprises:
judging whether all information items of the power object information of the same power object are the same or not; and/or the presence of a gas in the gas,
judging whether all information items of the power object information of the same power object are complete or not; and/or the presence of a gas in the gas,
judging whether the power objects having the association relation with the same power object are complete or not;
unifying the power object information of the same power object to obtain merged ledger data, including:
if at least one information item is different, unifying different information items according to the marketing and distribution run-through result data to obtain a unified information item; and/or the presence of a gas in the gas,
if at least one information item is incomplete, combining all the information items to obtain a complete information item; and/or the presence of a gas in the gas,
if the power objects associated with the same power object are not complete, all the power objects associated with the same power object are combined to obtain a complete relationship between the same power object and the power objects associated with the same power object.
5. The method according to claim 1, wherein the electric power object having the association relationship is a substation and a line; checking the combined machine account data, determining the power object with the wrong incidence relation, and performing relation correction on the power object with the wrong incidence relation to obtain corrected machine account data, wherein the method comprises the following steps:
checking the merged ledger data to determine the transformer substation and the line with one-to-many relationship;
according to the transformer substation and the line with the one-to-many relationship, the first machine account data, the second machine account data or the third machine account data are traced, and according to the tracing result, the transformer substation and the line with the one-to-one relationship are determined;
and modifying the transformer substation and the line in the one-to-many relationship into the transformer substation and the line in the one-to-one relationship.
6. The method of claim 1, wherein the power objects with the association relationship are a user and a transformer, the merged ledger data is checked to determine a power object with a wrong association relationship, and the relation correction is performed on the power object with the wrong association relationship to obtain corrected ledger data, and the method comprises:
according to the line loss data of the transformer area, checking the relation between the user and the transformer area in the combined machine account data, determining the user and the transformer area with wrong relation, and determining the user and the transformer with wrong relation;
and correcting the users with the wrong relation and the transformer according to the transformer area line loss data to obtain the correlation relation between the corrected users and the transformer.
7. A multisource data of distribution network checks device which characterized in that includes:
the acquisition module is used for acquiring first standing book data in the marketing system, second standing book data in the production management system and third standing book data in the geographic information system; the first standing book data, the second standing book data and the third standing book data comprise at least one electric power object and corresponding electric power object information;
the analysis module is used for carrying out object consistency analysis on the first standing book data, the second standing book data and the third standing book data to determine a complete power object and a missing power object, and supplementing the missing power object into the complete power object to obtain the first standing book data, the second standing book data and the third standing book data which are complete in object; the complete power object is a power object included in the first standing book data, the second standing book data and the third standing book data, and the missing power object is one or two power objects not included in the first standing book data, the second standing book data and the third standing book data;
the merging module is used for merging the same power object and corresponding power object information based on the first account data, the second account data and the third account data with complete objects to obtain merged account data;
and the checking module is used for checking the combined machine account data, determining the electric power object with the wrong incidence relation, and performing relation correction on the electric power object with the wrong incidence relation to obtain the corrected machine account data.
8. The apparatus of claim 7,
and the analysis module is used for supplementing the missing power object into the complete power object according to the marketing and distribution through result data.
9. The apparatus of claim 7,
the merging module is used for determining the same power object and corresponding power object information in the first standing book data, the second standing book data and the third standing book data of which the object is complete; judging whether the power object information of the same power object is the same; if not, the power object information of the same power object is subjected to unification processing to obtain combined ledger data.
10. The apparatus of claim 9, wherein the merge module comprises a decision sub-module and a merge sub-module;
the judgment submodule is used for judging whether all information items of the electric power object information of the same electric power object are the same or not; and/or judging whether all information items of the power object information of the same power object are complete or not; and/or judging whether the power objects having the association relation with the same power object are complete or not;
the merging submodule is used for unifying different information items according to the marketing and distribution run-through result data to obtain unified information items when at least one information item is judged to be different; and/or, when at least one information item is judged to be incomplete, combining all the information items to obtain a complete information item; and/or when the power objects having the association relation with the same power object are judged to be incomplete, combining all the power objects having the association relation with the same power object to obtain the complete relation between the same power object and the power objects having the association relation with the same power object.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011270495.1A CN112435001A (en) | 2020-11-13 | 2020-11-13 | Multi-source data checking method and device for power distribution network |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011270495.1A CN112435001A (en) | 2020-11-13 | 2020-11-13 | Multi-source data checking method and device for power distribution network |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112435001A true CN112435001A (en) | 2021-03-02 |
Family
ID=74701219
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011270495.1A Pending CN112435001A (en) | 2020-11-13 | 2020-11-13 | Multi-source data checking method and device for power distribution network |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112435001A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113205431A (en) * | 2021-07-07 | 2021-08-03 | 广东电网有限责任公司佛山供电局 | Multi-source account data abnormity monitoring system and method for distribution network line |
| CN113282594A (en) * | 2021-07-26 | 2021-08-20 | 广东电网有限责任公司佛山供电局 | Automatic extraction and analysis method and system for basic data of distribution transformer |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110008254A (en) * | 2019-04-02 | 2019-07-12 | 云南电网有限责任公司电力科学研究院 | A kind of transformer equipment account verification processing method |
| CN111160868A (en) * | 2019-12-31 | 2020-05-15 | 国网北京市电力公司 | Unified distribution network frame topology construction method based on graph fusion technology |
| CN111192010A (en) * | 2019-12-25 | 2020-05-22 | 国网北京市电力公司 | Standing book data processing method and device |
-
2020
- 2020-11-13 CN CN202011270495.1A patent/CN112435001A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110008254A (en) * | 2019-04-02 | 2019-07-12 | 云南电网有限责任公司电力科学研究院 | A kind of transformer equipment account verification processing method |
| CN111192010A (en) * | 2019-12-25 | 2020-05-22 | 国网北京市电力公司 | Standing book data processing method and device |
| CN111160868A (en) * | 2019-12-31 | 2020-05-15 | 国网北京市电力公司 | Unified distribution network frame topology construction method based on graph fusion technology |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113205431A (en) * | 2021-07-07 | 2021-08-03 | 广东电网有限责任公司佛山供电局 | Multi-source account data abnormity monitoring system and method for distribution network line |
| CN113282594A (en) * | 2021-07-26 | 2021-08-20 | 广东电网有限责任公司佛山供电局 | Automatic extraction and analysis method and system for basic data of distribution transformer |
| CN113282594B (en) * | 2021-07-26 | 2021-12-10 | 广东电网有限责任公司佛山供电局 | Automatic extraction and analysis method and system for basic data of distribution transformer |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106897205B (en) | Test data generation method and device | |
| CN102750406B (en) | Multi-version management method for model set and difference model-based power grid model | |
| CN111177400B (en) | Knowledge graph-based equipment, business and data associated display method and device | |
| US20140039818A1 (en) | Determining a connectivity model in smart grids | |
| CN103955789A (en) | Power supply path analyzing method based on integrated model for allocation | |
| CN103077212A (en) | Transformer substation configuration file control method and system | |
| CN112435001A (en) | Multi-source data checking method and device for power distribution network | |
| CN111625964B (en) | Method, system and equipment for constructing transformer substation graph model based on logical relationship | |
| Kim et al. | QVT-based model transformation to support unification of IEC 61850 and IEC 61970 | |
| CN104698374A (en) | Method for improving testing efficiency and accuracy of automatic relay protecting tester | |
| CN112181967B (en) | Method, device, computer equipment and medium for monitoring quality of source data | |
| CN111509706A (en) | Power supply topology information correction method, system, device and storage medium | |
| CN105704184A (en) | Power grid organization analysis system based on level framework and analysis method | |
| CN114757478A (en) | Monitoring method, monitor, system and electronic equipment for electric energy collection abnormity | |
| CN111198891A (en) | Data source fusion method, electronic device and non-transitory computer readable storage medium | |
| CN103268568A (en) | Method for determining relay protection device definite value by utilizing formula editor self-defined template | |
| CN105488293A (en) | Method and system for configuring virtual terminator connection wires in SCD | |
| CN112910086B (en) | Intelligent substation data verification method and system | |
| CN104299065A (en) | Dispatching automation host and backup model correctness checking method | |
| CN116316538A (en) | Main-distribution cooperative distribution network power supply security capability analysis method, system, equipment and medium | |
| CN112463785B (en) | Data quality monitoring method and device, electronic equipment and storage medium | |
| CN114095492A (en) | Data transmission method and system for main and sub-stations of power system and electronic equipment | |
| CN109741594B (en) | Configuration method and device for equipment data acquisition | |
| KR20150128267A (en) | Apparatus for data integration of heterogeneous system | |
| CN104008159A (en) | Power grid project database system and management method |
Legal Events
| 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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210302 |
|
| RJ01 | Rejection of invention patent application after publication |