District problem decision-making method and device based on multi-source heterogeneous data

Abstract

The invention discloses a transformer area problem decision-making method based on multi-source heterogeneous data, and the method comprises the steps: obtaining the problem data of transformer area distribution transformers through a plurality of preposed data systems, building a problem evaluation standard, obtaining a problem transformer area distribution transformer set through data standardization and multi-source heterogeneous data fusion, and carrying out the decision-making of the problem transformer area distribution transformers. Therefore, the problem decision strategy is determined by identifying the problem type according to the preset identification rule, the whole-process unified management of the problems of automatic analysis, planning, capital construction, production, marketing and the like of the distribution transformer problem of the transformer area is realized, the data connection of different systems of a power grid is realized, and the distribution network planning work is better supported.

Description

Technical Field

[0001] The present invention belongs to the field of data processing technology, and in particular to a method and device for making decisions on field problems based on multi-source heterogeneous data. Background Art

[0002] With the popularization of technologies such as smart meters, IoT sensors, and distribution automation equipment, the power system can collect more detailed and real-time multi-source data. Operating parameters such as current, voltage, power, and frequency, as well as external information such as geographic information and weather data can be collected in a timely manner. The digital transformation of the power system is accelerating, and more substations and substations have the ability to monitor and upload data in real time, laying the foundation for decision-making based on multi-source data.

[0003] Although there has been significant progress in the research on decision-making of substation problems with multi-source data, deficiencies such as insufficient data standardization and missing data still affect accurate decision-making. Data from different sources have differences in format, timeliness, accuracy, sampling frequency, etc., which makes it impossible to analyze them synchronously. In addition, data from different sources have different time scales, spatial scales, and accuracy requirements. How to integrate data from different physical devices and external environmental information to ensure accurate and reliable analysis results is a major challenge. There may be complex nonlinear relationships between different types of data, and current algorithms are still insufficient in modeling and understanding these complex relationships. Summary of the invention

[0004] Based on this, the present invention aims to propose a substation problem decision-making method and device based on multi-source heterogeneous data, which performs multi-dimensional distribution network planning problem analysis, monitoring, and multi-dimensional post-evaluation on multi-source heterogeneous data.

[0005] In a first aspect, the present invention provides a method for making decisions on a substation problem based on multi-source heterogeneous data, comprising:

[0006] Obtain measurement data, business data and external data of distribution transformers in the substation area;

[0007] Standardize measurement data, business data and external data into a unified data model and store them as a multi-source data set for distribution and transformation problems in the substation area;

[0008] The multi-source datasets of distribution transformer problems in the substation are merged based on the equipment identification and event type of the substation distribution transformer as the merging rule to obtain the problem substation distribution transformer set.

[0009] According to the preset identification rules, the problem types in the problem distribution transformer set are identified to determine the distribution transformer problem in the distribution transformer area, and the solution strategy is determined according to the distribution transformer problem in the distribution transformer area.

[0010] Further, problem information in the problem distribution transformer set is identified according to a preset identification rule to determine the distribution transformer problem in the distribution transformer area, and a solution strategy is determined according to the distribution transformer problem in the distribution transformer area, including:

[0011] Identify the distribution transformer problem in the substation according to the data source of the problem information. The problem information comes from the load data of the dispatching system, which is determined as a heavy overload problem of the distribution transformer in the substation. The problem information comes from the three-phase unbalance alarm of the metering system, which is determined as a three-phase unbalance problem. The problem information comes from the low voltage alarm of the metering system, which is determined as a low voltage problem.

[0012] According to the distribution and transformation problems in the substation, solution strategies are matched from the solution library and recommended.

[0013] Furthermore, when the distribution transformer problem in the substation is confirmed to be a heavy overload problem of the distribution transformer in the substation, the solution strategy determined according to the distribution transformer problem in the substation includes:

[0014] According to the historical load curve of each distribution transformer, the cross-area load adjustment strategy is matched from the solution library.

[0015] Furthermore, when the distribution transformer problem in the substation is confirmed to be a heavy overload problem of the distribution transformer in the substation, and the cross-substation load adjustment strategy cannot be matched in the solution library, the solution strategy determined according to the distribution transformer problem in the substation includes:

[0016] Obtain the candidate distribution transformer layout locations;

[0017] Calculate the distance between the candidate substation distribution transformer layout point and the current problem substation distribution transformer, and determine the candidate substation distribution transformer layout point closest to the current problem substation distribution transformer as the new substation distribution transformer layout point.

[0018] Furthermore, calculating the distance between the candidate distribution transformer layout point and the current problem distribution transformer includes:

[0019] Query all meter information associated with the distribution transformer in the current problem area based on the household-to-transformer relationship to obtain the daily power consumption of each meter;

[0020] Calculate the daily power consumption of each fire point of the distribution transformer in the current problem area based on the daily power consumption of each meter;

[0021] Perform cluster analysis using the daily electricity consumption of each fire point as weight, and calculate the location coordinates of the distribution transformer in the current problem area;

[0022] The distance between the candidate distribution transformer layout point and the current problem distribution transformer is calculated based on the location coordinates of the current problem distribution transformer.

[0023] Furthermore, the measurement data, business data and external data are standardized into a unified data model and stored as a multi-source data set of distribution and transformation problems in the substation area, including:

[0024] The measurement data, business data and external data are standardized according to the data format and stored as a multi-source data set of distribution and transformation problems in the substation area.

[0025] Furthermore, the multi-source datasets of the distribution transformer problem in the substation are merged based on the equipment identification and event type of the substation distribution transformer as the merging rule, and the problem substation distribution transformer set is obtained, including:

[0026] The data in the multi-source data set of the distribution transformer problem in the substation is grouped using the equipment identification and event type of the substation distribution transformer as the primary key to obtain several groups of data records;

[0027] Check whether there is a cancellation record for each group of data records. If there is no cancellation record, determine the earliest discovery time of the current group of data records, merge the current group of data records to retain the equipment identification, problem type and earliest discovery time of the distribution transformer in the substation area. Otherwise, take the earliest discovery time after the time corresponding to the cancellation record as the earliest discovery time of the current group of data records, and merge the current group of data records;

[0028] The output is a merged problem substation distribution transformer set. The output problem substation distribution transformer set uses the equipment identifier of the substation distribution transformer as the unique primary key, and each data record uniquely corresponds to a problem information.

[0029] In a second aspect, the present invention provides a station area problem decision-making device based on multi-source heterogeneous data, comprising:

[0030] Data acquisition module, used to obtain measurement data, business data and external data of the distribution transformer in the substation area;

[0031] Data unification module, used to standardize measurement data, business data and external data into a unified data model and store it as a multi-source data set of distribution and transformation problems in the substation area;

[0032] A multi-source data merging module is used to merge the multi-source data sets of the distribution transformer problem in the substation area based on the equipment identification and event type of the substation area distribution transformer as the merging rule to obtain the problem substation area distribution transformer set;

[0033] The problem decision module is used to identify the problem type in the problem distribution transformer set according to the preset identification rules to determine the distribution transformer problem in the distribution transformer area, and determine the solution strategy according to the distribution transformer problem in the distribution transformer area.

[0034] In a third aspect, the present invention provides an electronic device comprising a memory storing computer executable instructions and a processor, wherein when the computer executable instructions are executed by the processor, the device executes each step of the substation problem decision method based on multi-source heterogeneous data provided in the first aspect.

[0035] In a fourth aspect, the present invention provides a readable storage medium storing a computer executable program, which, when executed, can implement the various steps of the substation problem decision-making method based on multi-source heterogeneous data provided in the first aspect.

[0036] It can be seen from the above technical solutions that the present invention has the following beneficial effects:

[0037] The present invention provides a substation problem decision-making method based on multi-source heterogeneous data, which obtains problem data of substation distribution transformers through multiple front-end data systems, establishes problem evaluation standards, and obtains a set of problem substation distribution transformers through data standardization and multi-source heterogeneous data fusion, thereby identifying the problem type according to preset identification rules and determining the problem decision-making strategy, realizing automatic analysis of substation distribution transformer problems, unified management of the entire process of planning, infrastructure, production, marketing and other problems, and realizing data docking of different power grid systems, thereby better supporting distribution network planning work. BRIEF DESCRIPTION OF THE DRAWINGS

[0038] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on the provided drawings without paying creative work.

[0039] Figure 1 It is a flowchart of an implementation method of a substation problem decision-making method based on multi-source heterogeneous data provided by an embodiment of the present invention;

[0040] Figure 2 It is a parsing architecture for integrating multi-source heterogeneous data processing provided by an embodiment of the present invention;

[0041] Figure 3 It is an architecture diagram of a unified model of station area objects provided by an embodiment of the present invention;

[0042] Figure 4 It is a schematic diagram of the structure of a substation problem decision-making device based on multi-source heterogeneous data provided by an embodiment of the present invention;

[0043] Figure 5 This is a diagram of the electronic device architecture provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0044] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0045] See also Figure 1 An embodiment of the present invention provides a method for making decisions on a substation problem based on multi-source heterogeneous data, comprising the following steps:

[0046] Step S110: Obtain measurement data, service data and external data of the distribution transformer in the substation area.

[0047] The measurement data, business data and external data obtained in this step come from various data platforms of the power grid system, including the power grid management platform, edge cluster system, voltage quality monitoring system, metering automation system, lightning analysis system, etc., with distribution transformer as the core, integrating topological data, dispatching, metering, IoT-related measurement data, business data and external data, to build a data model for distribution transformer objects.

[0048] Specifically, the measurement data reflects the operating status and load conditions of the substation distribution transformer, including electrical parameters, load data, operating status data and metering data; business data usually refers to the management and operation data related to the substation distribution transformer, which mainly comes from the internal information system of the power company, including equipment files, customer information, operation and maintenance records, historical loss data, etc.; external data comes from the external environment, policies and other factors that affect the operation of the substation distribution transformer, including meteorological data, geographic information, etc.

[0049] Step S120: Standardize the measurement data, business data and external data into a unified data model and store them as a multi-source data set of substation distribution and transformation problems.

[0050] This step processes the problem data of each system, associates each data with the distribution transformer, provides object information description from the dimensions of basic information, technical parameters, events, and subject services, and performs data fusion specifically according to the data format. A more preferred implementation method, for example, for numerical data, the problem data is determined by comparing the data value with the over-limit value. For text data, the problem information is determined by extracting keywords from the keyword library. The equipment identification, time, and problem description of the distribution transformer in the substation area can be used to better understand the type of problem.

[0051] In a further embodiment, a unified data model (such as based on a relational database or NoSQL) is designed to uniformly store various types of data. The model fields may include device identification, event type, time dimension, measurement parameters and other additional information. Data from different sources are preprocessed and stored as a multi-source data set for distribution and transformation problems in the substation area. A more preferred implementation method data preprocessing includes data cleaning, data format conversion, etc. Exemplary, Figure 2 It illustrates one of the analytical architectures for multi-source heterogeneous data processing and integration. Figure 3 The figure shows an architecture diagram of a unified model of substation objects.

[0052] Step S130: Merge the multi-source data sets of the distribution transformer problem in the substation using the equipment identification and event type of the distribution transformer in the substation as the merging rule to obtain a set of problem distribution transformers in the substation.

[0053] Specifically, step S130 includes the following steps:

[0054] The data in the multi-source data set of the distribution transformer problem in the substation is grouped using the equipment identification and event type of the substation distribution transformer as the primary key to obtain several groups of data records;

[0055] Check whether there is a cancellation record for each group of data records. If there is no cancellation record, determine the earliest discovery time of the current group of data records, merge the current group of data records to retain the equipment identification, problem type and earliest discovery time of the distribution transformer in the substation area. Otherwise, take the earliest discovery time after the time corresponding to the cancellation record as the earliest discovery time of the current group of data records, and merge the current group of data records;

[0056] The output is a merged problem substation distribution transformer set. The output problem substation distribution transformer set uses the equipment identifier of the substation distribution transformer as the unique primary key, and each data record uniquely corresponds to a problem information.

[0057] The unified storage is carried out through the equipment identification of the distribution transformer, and the business relationship between the equipment object electricity and the business subject (grid, equipment, people, organization) is used to support the conceptual and logical integration of the physical grid and grid business.

[0058] Step S140: Identify the problem types in the problem distribution transformer set according to preset identification rules to determine the distribution transformer problem in the distribution transformer area, and determine a solution strategy according to the distribution transformer problem in the distribution transformer area.

[0059] In this step, we mainly analyze the problems of heavy overload, three-phase imbalance, low voltage, insufficient power supply capacity, etc. in the substation, and determine the corresponding substation problem based on the source of the problem information.

[0060] Specifically, the problem information comes from the load data of the dispatching system, which is determined to be a heavy overload problem of the substation distribution transformer; the problem information comes from the three-phase imbalance alarm of the metering system, which is determined to be a three-phase imbalance problem; the problem information comes from the low voltage alarm of the metering system, which is determined to be a low voltage problem. For the identified substation problems, the established solution library is used to match the corresponding strategy from the solution library according to the identified problem type; in a more preferred implementation mode, if the problem type is completely matched, the relevant strategy is directly recommended; if the problem type corresponds to multiple strategies, the recommendations are sorted by priority.

[0061] In a further embodiment, for the heavy overload problem, relevant data from the multi-source data set of the substation distribution transformer problem is extracted, and the cross-substation load adjustment strategy is matched from the solution library according to the historical load curve of each substation distribution transformer. If the cross-substation load adjustment strategy cannot be matched in the solution library, the substation distribution transformer is redistributed.

[0062] Specifically, the redistribution of distribution transformers in the substation area includes:

[0063] Obtain the candidate distribution transformer layout locations;

[0064] Calculate the distance between the candidate substation distribution transformer layout point and the current problem substation distribution transformer, and determine the candidate substation distribution transformer layout point closest to the current problem substation distribution transformer as the new substation distribution transformer layout point.

[0065] In a further embodiment, calculating the distance between the candidate distribution transformer layout point and the current problem distribution transformer includes:

[0066] Query all meter information associated with the distribution transformer in the current problem area based on the household-to-transformer relationship to obtain the daily power consumption of each meter;

[0067] Calculate the daily power consumption of each fire point of the distribution transformer in the current problem area based on the daily power consumption of each meter;

[0068] Perform cluster analysis using the daily electricity consumption of each fire point as weight, and calculate the location coordinates of the distribution transformer in the current problem area;

[0069] The distance between the candidate distribution transformer layout point and the current problem distribution transformer is calculated based on the location coordinates of the current problem distribution transformer.

[0070] Specifically, the daily electricity consumption of each user and the specific location of the user are collected from the smart meter of each user, the fire point information connected to each user's meter is obtained, and the network structure of the distribution transformer and the fire point is determined, including the length, path and connection relationship of the distribution line. The daily electricity consumption of the fire point of the distribution transformer in the substation can be obtained by summarizing the daily electricity consumption of each user. Specifically, the users are grouped according to the fire points to which they are connected. One user set corresponds to one fire point, and the daily electricity consumption of each fire point is the sum of the electricity consumption of its user set. Cluster analysis is performed with the location of each user as the feature input and the daily electricity consumption of each fire point as the weight. The cluster center point is used as the estimated value of the location coordinate of the distribution transformer in the substation. A more preferred implementation method cluster analysis can use K-means clustering, weighted clustering, DBSCAN clustering and other methods,

[0071] For example, the location of the distribution transformer in the substation is represented as (x, y), and the location of the candidate deployment point is represented as (a, b). The distance between the two is recorded as , take the minimum The corresponding candidate substation distribution transformer layout point is the new substation distribution transformer layout point.

[0072] In a further embodiment, for a set of problems such as three-phase imbalance and low voltage, the user can be triggered to fill in a treatment plan and calculate the health of the distribution transformer in the substation. Specifically, the number of problems that occur in the distribution transformer in the substation is calculated. When the health of the distribution transformer in the substation is lower than the set value, it triggers re-entry into the problem data set.

[0073] The above-disclosed embodiments describe in detail a substation problem decision-making method based on multi-source heterogeneous data. The above-disclosed method can be implemented using various forms of equipment. Therefore, the present invention also discloses a substation problem decision-making device based on multi-source heterogeneous data corresponding to the above-disclosed method. A specific embodiment is given below for detailed description.

[0074] like Figure 4 As shown, an embodiment of the present invention provides a station area problem decision-making device based on multi-source heterogeneous data, comprising:

[0075] The data acquisition module 402 is used to acquire the measurement data, business data and external data of the distribution transformer in the substation area;

[0076] The data unification module 404 is used to standardize the measurement data, business data and external data into a unified data model and store it as a multi-source data set of distribution and transformation problems in the substation area;

[0077] The multi-source data merging module 406 is used to merge the multi-source data sets of the distribution transformer problem in the substation area by using the equipment identification and event type of the distribution transformer in the substation area as the merging rule to obtain the problem distribution transformer set in the substation area;

[0078] The problem decision module 408 is used to identify the problem type in the problem substation distribution transformer set according to the preset identification rules to determine the substation distribution transformer problem, and determine the solution strategy according to the substation distribution transformer problem.

[0079] The implementation principle and technical effects of the device provided in the embodiments of the present application are the same as those of the aforementioned method embodiments. For the sake of brief description, for matters not mentioned in the device embodiment, reference may be made to the corresponding contents in the aforementioned method embodiments.

[0080] The methods and related devices mentioned in the above embodiments are described with reference to the method flow charts and / or structural diagrams provided in the embodiments of the present application. Specifically, each process and / or block in the method flow charts and / or structural diagrams, as well as the combination of processes and / or blocks in the flow charts and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the process in the process. Figure 1 Schematic diagram of one or more processes and / or structures Figure 1These computer program instructions can also be stored in a computer-readable memory that can guide a computer or other programmable data processing device to work in a specific way, so that the instructions stored in the computer-readable memory produce a product including an instruction device, which implements the functions specified in the process. Figure 1 Schematic diagram of one or more processes and / or structures Figure 1 These computer program instructions can also be loaded onto a computer or other programmable data processing device, so that a series of operation steps are executed on the computer or other programmable device to produce a computer-implemented process, so that the instructions executed on the computer or other programmable device provide for implementing the process in the process. Figure 1 A flow or multiple flows and / or structures illustrate the steps of the functions specified in one block or multiple blocks.

[0081] The following embodiments are described by taking the method applied to a computer device as an example. It can be understood that the computer device can be any device with computing and processing functions, and can be but not limited to a server or a personal laptop computer, etc. In one embodiment, the computer device can be an application server, and the application server can be a server for running an application to be tested.

[0082] See also Figure 5 , which shows a hardware block diagram of an electronic device, the electronic device is intended to represent various forms of digital computers, such as laptop computers, desktop computers, workstations, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The electronic device can also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable devices, and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely examples and are not intended to limit the implementation of the present application described and / or required herein.

[0083] like Figure 5 As shown, the electronic device includes: at least one processor 1, at least one communication interface 2, at least one memory 3 and at least one communication bus 4;

[0084] In the embodiment of the present application, the number of the processor 1, the communication interface 2, the memory 3, and the communication bus 4 is at least one, and the processor 1, the communication interface 2, and the memory 3 communicate with each other through the communication bus 4;

[0085] The processor 1 may be a central processing unit CPU, or an application-specific integrated circuit ASIC (Application Specific Integrated Circuit), or one or more integrated circuits configured to implement the embodiments of the present invention, etc.;

[0086] The memory 3 may include a high-speed RAM memory, and may also include a non-volatile memory (non-volatile memory), etc., such as at least one disk memory;

[0087] Among them, the memory stores a program, and the processor can call the program stored in the memory, and the program is used to: implement each processing flow of the aforementioned substation problem decision-making solution based on multi-source heterogeneous data.

[0088] An embodiment of the present invention also provides a readable storage medium having a computer program stored thereon. When the computer program is executed by a processor, the computer program implements the various processing flows of the substation problem decision-making solution based on multi-source heterogeneous data provided in the above embodiment and / or any possible implementation method in combination with the embodiment.

[0089] The above-mentioned embodiments have described the present invention in particular detail with respect to possible scenarios, and those skilled in the art will recognize that the present invention can be practiced through other embodiments. The specific naming of components, the capitalization of terms, attributes, data structures, or any other programming or structural aspects are not mandatory or important, and the mechanisms or features of the present invention may have different names, forms, or procedures. The system may be implemented by a combination of hardware and software (as described), entirely by hardware elements, or entirely by software elements. The specific division of functions between the various system components described herein is exemplary only and not mandatory; on the contrary, the functions performed by a single system component may be performed by multiple components, or the functions performed by multiple components may be performed by a single component.

[0090] Those skilled in the art should understand that the various steps of the above disclosed method can be implemented by a general computing device, they can be concentrated on a single computing device, or distributed on a network composed of multiple computing devices, optionally, they can be implemented with program codes executable by the computing device, so that they can be stored in a storage device and executed by the computing device, or they can be made into individual integrated circuit modules, or multiple modules or steps therein can be made into a single integrated circuit module for implementation. Thus, the embodiments of the present invention are not limited to any specific combination of hardware and software.

[0091] These computing device executable programs (also referred to as programs, software, software applications, or code) include machine instructions for programmable processors, and these computing programs can be implemented using high-level procedural and / or object-oriented programming languages, and / or assembly / machine languages. As used herein, the terms "machine-readable medium" and "computer-readable medium" refer to any computer program product, device, and / or device (e.g., disk, optical disk, memory, programmable logic device (PLD)) for providing machine instructions and / or data to a programmable processor, including a machine-readable medium that receives machine instructions as a machine-readable signal. The term "machine-readable signal" refers to any signal for providing machine instructions and / or data to a programmable processor.

[0092] Certain aspects of the present invention include process steps and instructions described herein in the form of algorithms. It should be noted that the process steps and instructions of the present invention can be implemented in software, firmware and / or hardware, and when implemented by software, it can be downloaded, stored on different platforms used by various operating systems and operated from the platforms.

[0093] Those skilled in the art will understand that the structures shown in the accompanying drawings are merely block diagrams of partial structures related to the scheme of the present application, and do not constitute a limitation on the terminal device to which the scheme of the present application is applied. The specific terminal device may include more or fewer components than shown in the figures, or combine certain components, or have a different arrangement of components.

[0094] In the description of this specification, the description with reference to the terms "one embodiment", "some embodiments", "example", "specific example", or "possible design" etc. means that the specific features, structures, materials or characteristics described in conjunction with the embodiment or example are included in at least one embodiment or example of the present application. In this specification, the schematic representations of the above terms do not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials or characteristics described may be combined in any one or more embodiments or examples in a suitable manner. In addition, those skilled in the art may combine and combine the different embodiments or examples described in this specification and the features of the different embodiments or examples, without contradiction.

[0095] The above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit the same. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that the technical solutions described in the aforementioned embodiments may still be modified, or some of the technical features thereof may be replaced by equivalents. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A method for decision-making on substation problems based on multi-source heterogeneous data, characterized in that: include: Obtain measurement data, business data and external data of distribution transformers in the substation area; Standardize measurement data, business data and external data into a unified data model and store them as a multi-source data set for distribution and transformation problems in the substation area; The multi-source datasets of distribution transformer problems in the substation are merged based on the equipment identification and event type of the substation distribution transformer as the merging rule to obtain the problem substation distribution transformer set. According to the preset identification rules, the problem types in the problem distribution transformer set are identified to determine the distribution transformer problem in the distribution transformer area, and the solution strategy is determined according to the distribution transformer problem in the distribution transformer area.

2. The method according to claim 1, characterized in that The step of identifying the problem information in the problem distribution transformer set according to the preset identification rules to determine the distribution transformer problem in the distribution transformer area, and determining the solution strategy according to the distribution transformer problem in the distribution transformer area includes: Identify the distribution transformer problem in the substation according to the data source of the problem information. The problem information comes from the load data of the dispatching system, which is determined as a heavy overload problem of the distribution transformer in the substation. The problem information comes from the three-phase unbalance alarm of the metering system, which is determined as a three-phase unbalance problem. The problem information comes from the low voltage alarm of the metering system, which is determined as a low voltage problem. According to the distribution and transformation problems in the substation, solution strategies are matched from the solution library and recommended.

3. The method according to claim 2, characterized in that When the distribution transformer problem in the substation area is confirmed to be a heavy overload problem of the distribution transformer in the substation area, the solution strategy determined according to the distribution transformer problem in the substation area includes: According to the historical load curve of each distribution transformer, the cross-area load adjustment strategy is matched from the solution library.

4. The method according to claim 3, characterized in that When the distribution transformer problem in the substation area is confirmed to be a heavy overload problem of the distribution transformer in the substation area, and the cross-substation area load adjustment strategy cannot be matched in the solution library, the solution strategy determined according to the distribution transformer problem in the substation area includes: Obtain the candidate distribution transformer layout locations; Calculate the distance between the candidate substation distribution transformer layout point and the current problem substation distribution transformer, and determine the candidate substation distribution transformer layout point closest to the current problem substation distribution transformer as the new substation distribution transformer layout point.

5. The method according to claim 4, characterized in that The calculation of the distance between the candidate distribution transformer layout point and the current problem distribution transformer includes: Query all meter information associated with the distribution transformer in the current problem area based on the household-to-transformer relationship to obtain the daily power consumption of each meter; Calculate the daily power consumption of each fire point of the distribution transformer in the current problem area based on the daily power consumption of each meter; Perform cluster analysis using the daily electricity consumption of each fire point as weight, and calculate the location coordinates of the distribution transformer in the current problem area; The distance between the candidate distribution transformer layout point and the current problem distribution transformer is calculated based on the location coordinates of the current problem distribution transformer.

6. The method according to claim 1, characterized in that The standardization of the measurement data, business data and external data into a unified data model and storage as a multi-source data set of distribution and transformation problems in the substation area includes: The measurement data, business data and external data are standardized according to the data format and stored as a multi-source data set of distribution and transformation problems in the substation area.

7. The method according to claim 1, characterized in that The problem distribution transformer set is obtained by merging the multi-source data set of the distribution transformer problem in the distribution transformer area using the equipment identification and event type of the distribution transformer area as the merging rule, and includes: The data in the multi-source data set of the distribution transformer problem in the substation is grouped using the equipment identification and event type of the substation distribution transformer as the primary key to obtain several groups of data records; Check whether there is a cancellation record for each group of data records. If there is no cancellation record, determine the earliest discovery time of the current group of data records, merge the current group of data records to retain the equipment identification, problem type and earliest discovery time of the distribution transformer in the substation area. Otherwise, take the earliest discovery time after the time corresponding to the cancellation record as the earliest discovery time of the current group of data records, and merge the current group of data records; The output is a merged problem substation distribution transformer set. The output problem substation distribution transformer set uses the equipment identifier of the substation distribution transformer as the unique primary key, and each data record uniquely corresponds to a problem information.

8. A station area problem decision-making device based on multi-source heterogeneous data, characterized in that: include: Data acquisition module, used to obtain measurement data, business data and external data of the distribution transformer in the substation area; Data unification module, used to standardize measurement data, business data and external data into a unified data model and store it as a multi-source data set of distribution and transformation problems in the substation area; A multi-source data merging module is used to merge the multi-source data sets of the distribution transformer problem in the substation area based on the equipment identification and event type of the substation area distribution transformer as the merging rule to obtain the problem substation area distribution transformer set; The problem decision module is used to identify the problem type in the problem distribution transformer set according to the preset identification rules to determine the distribution transformer problem in the distribution transformer area, and determine the solution strategy according to the distribution transformer problem in the distribution transformer area.

9. An electronic device, characterized in that: The device comprises a memory storing computer executable instructions and a processor. When the computer executable instructions are executed by the processor, the device executes the substation problem decision method based on multi-source heterogeneous data as described in any one of claims 1 to 7.

10. A readable storage medium, characterized in that: A computer executable program is stored, and when the program is executed, the substation problem decision-making method based on multi-source heterogeneous data as described in any one of claims 1 to 7 can be implemented.

Images