Multi-modal power data processing method and device, terminal equipment and storage medium

Abstract

The invention discloses a multi-modal power data processing method and device, terminal equipment and a storage medium, and the method comprises the steps: carrying out the data level adjustment and missing value processing of power transmission state data, power transformation state data and power equipment account data, matching the adjusted power transmission state data, power transformation state data and power equipment account data with a preset defect knowledge base to obtain power defect data; judging whether the power defect data are all associated with the corresponding main equipment or not; matching is carried out according to the power transmission data type code of the adjusted power transmission state data, the power transformation data type code of the adjusted power transformation state data, the account type code of the electrical equipment account data and a preset equipment type association database until all the power defect data are associated with the corresponding main equipment; and storing the data with the same type code in a preset to-be-processed system database. By implementing the method and the device, the maintenance processing of the multi-modal data is realized.

Description

Technical Field

[0001] The present invention relates to the technical field of power data processing, and in particular to a multimodal power data processing method, device, terminal equipment and storage medium. Background Art

[0002] With the continuous development of power systems and the improvement of their intelligence level, the application of multimodal power data generated by power systems has become a research hotspot. The role of power data is mainly reflected in promoting economic and social development, improving user service quality, promoting power grid transformation and upgrading, strengthening social governance and urban environmental governance, and maintaining urban energy security. Power data has the characteristics of multi-form and multi-physical structure, that is, the form and physical meaning of the data are different. Due to the different forms and physical meanings of multimodal power data, there are many difficulties in directly applying it to power system operation and maintenance. On the one hand, there are differences in storage and processing of multimodal power data in different forms, which makes it difficult to directly compare and analyze; on the other hand, multimodal power data with different physical meanings have different focuses when reflecting the state of the power system, and the data meanings of the power system represented are also different. These multimodal data reduce the efficiency of manual maintenance operations and increase the difficulty of maintaining power data in the power system. Summary of the invention

[0003] The embodiments of the present invention provide a multimodal power data processing method, apparatus, terminal equipment and storage medium, which can effectively solve the problem of difficulty in maintaining power data of a power system in the prior art.

[0004] An embodiment of the present invention provides a multi-modal power data processing method, comprising:

[0005] Obtain the transmission status data, substation status data and power equipment inventory data of the power system to be processed;

[0006] According to the power transmission status data, the power transformation status data and the power equipment inventory data, respectively, data hierarchy adjustment and missing value processing are performed to obtain adjusted power transmission status data, adjusted power transformation status data and adjusted power equipment inventory data;

[0007] Matching the adjusted power transmission status data, the adjusted substation status data and the adjusted power equipment inventory data with a preset defect knowledge base to obtain power defect data;

[0008] According to the power defect data and the adjusted power equipment ledger data, determining whether the power defect data are all associated with the corresponding main equipment;

[0009] In the case where the power defect data is not associated with the corresponding main device, recursively traverse the power defect according to the adjusted power equipment ledger data so that all power defect data are associated with the corresponding main device;

[0010] When the power defect data is associated with the corresponding main equipment, matching is performed according to the adjusted transmission data type code of the transmission status data, the adjusted substation data type code of the substation status data, the adjusted inventory type code of the power equipment inventory data and a preset equipment type association database, and the data with the same type code is stored in a preset system database to be processed.

[0011] Further, data hierarchy adjustment and missing value processing are performed respectively according to the power transmission status data, the substation status data and the electric power equipment ledger data to obtain adjusted power transmission status data, adjusted substation status data and adjusted electric power equipment ledger data, including:

[0012] Determine the data hierarchy of each data type of the power system to be processed according to the equipment-related data in the power equipment ledger data;

[0013] Deleting the data hierarchy according to the power transmission status data, the substation status data, the electric power equipment inventory data, the data hierarchy of each data type and the preset data hierarchy, and obtaining the first power transmission status data, the first substation status data and the first electric power equipment inventory data retaining the preset data hierarchy;

[0014] The missing values ​​of the first power transmission status data, the first power transformation status data and the first electric power equipment inventory data are deleted to obtain adjusted power transmission status data, adjusted power transformation status data and adjusted electric power equipment inventory data.

[0015] Further, the first power transmission status data, the first power transformation status data and the first electric power equipment ledger data are deleted for missing values ​​to obtain adjusted power transmission status data, adjusted power transformation status data and adjusted electric power equipment ledger data, including:

[0016] Compare the preset equipment model database with the equipment model in the first power equipment ledger data to determine whether the preset equipment model database contains a corresponding equipment model;

[0017] If the corresponding device model does not exist in the preset device model database, the device model in the first power device account data is updated to the preset device model database.

[0018] When the corresponding equipment model exists in the preset equipment model database, the data items with empty numerical data in the first transmission status data, the first substation status data and the first electric power equipment inventory data are deleted to obtain adjusted transmission status data, adjusted substation status data and adjusted electric power equipment inventory data.

[0019] Furthermore, the adjusted transmission status data, the adjusted substation status data and the adjusted power equipment ledger data are matched with a preset defect knowledge base to obtain power defect data, including:

[0020] Extract data features from the adjusted power transmission state data, the adjusted power substation state data and the adjusted power equipment inventory data to obtain power transmission features, power substation features and inventory features;

[0021] Compare the transmission characteristics, substation characteristics and ledger characteristics with the data defect range in the preset defect knowledge base to identify the transmission characteristic defects, substation characteristic defects and ledger characteristic defects;

[0022] According to the defect knowledge base, determine the equipment defect types corresponding to the transmission characteristic defects, substation characteristic defects and ledger characteristic defects;

[0023] The corresponding transmission characteristic defects, substation characteristic defects and inventory characteristic defects in the adjusted transmission status data, the adjusted substation status data and the adjusted electric power equipment inventory data are marked with corresponding equipment defect types to obtain electric power defect data.

[0024] Further, judging whether the power defect data are all associated with the corresponding main equipment according to the power defect data and the adjusted power equipment ledger data includes:

[0025] Determining, according to the power defect data, the type of equipment component corresponding to the power defect data;

[0026] According to the adjusted power equipment ledger data, a knowledge graph of main equipment and main equipment components in the power equipment ledger data is constructed;

[0027] According to the corresponding equipment component type and the knowledge graph of the main equipment and the main equipment components, it is determined whether the power defect data are all associated with the corresponding main equipment.

[0028] Further, matching is performed according to the adjusted transmission data type code of the transmission status data, the adjusted substation data type code of the substation status data, the adjusted account type code of the electric power equipment account data, and a preset equipment type association database, and storing data with the same type code in a preset system database to be processed, including:

[0029] According to the adjusted power transmission data type code of the power transmission status data, the adjusted power substation data type code of the power substation status data, and the adjusted account type code of the power equipment account data, the corresponding main type code is searched in the preset equipment type association database;

[0030] Searching in the equipment type association database according to the main type code, obtaining the grade area code, bay type code, function location code and equipment category code corresponding to the main type code;

[0031] According to the grade area code, interval type code, functional location code and equipment category code, the corresponding adjusted transmission status data, adjusted substation status data and adjusted power equipment inventory data are determined, and each data item is stored in a preset system database to be processed.

[0032] Furthermore, the power transmission status data includes: power transmission data type code, power transmission equipment basic data, power transmission line data and power transmission equipment monitoring data;

[0033] The substation status data includes: substation data type code, substation equipment basic data, substation line data and substation equipment monitoring data;

[0034] The electric power equipment ledger data includes: ledger type code, equipment related data and equipment components;

[0035] The transmission equipment monitoring data is obtained through a conductor temperature status monitoring device, a conductor sag status monitoring device, a conductor icing status monitoring device, a breeze vibration status monitoring device, a dancing status monitoring device, a tower tilt status monitoring device, a micro-meteorological status monitoring device and a wind deviation status monitoring device.

[0036] As an improvement of the above solution, another embodiment of the present invention provides a multi-modal power data processing device, including:

[0037] The power data acquisition module is used to obtain the power transmission status data, substation status data and power equipment ledger data of the power system to be processed;

[0038] A data hierarchy adjustment module, used to perform data hierarchy adjustment and missing value processing according to the power transmission status data, the substation status data and the electric power equipment ledger data, respectively, to obtain adjusted power transmission status data, adjusted substation status data and adjusted electric power equipment ledger data;

[0039] A data defect matching module is used to match the adjusted power transmission status data, the adjusted substation status data and the adjusted power equipment ledger data with a preset defect knowledge base to obtain power defect data;

[0040] An equipment association judgment module, used to judge whether the power defect data are all associated with the corresponding main equipment according to the power defect data and the adjusted power equipment ledger data;

[0041] A defect association module, used for recursively traversing the power defects according to the adjusted power equipment ledger data when the power defect data is not associated with the corresponding main equipment, so that all power defect data are associated with the corresponding main equipment;

[0042] A data processing module is used to match the power defect data with the same type code according to the adjusted power transmission status data type code, the adjusted substation status data type code, the adjusted power equipment inventory data and a preset equipment type association database when the power defect data is associated with the corresponding main equipment, and store the data with the same type code in the preset system database to be processed.

[0043] Another embodiment of the present invention provides a terminal device, including a processor, a memory, and a computer program stored in the memory and configured to be executed by the processor, and when the processor executes the computer program, a multimodal power data processing method as described in the above embodiment is implemented.

[0044] Another embodiment of the present invention provides a computer-readable storage medium, which includes a stored computer program, wherein when the computer program is running, the device where the computer-readable storage medium is located is controlled to execute a multimodal power data processing method described in the above embodiment.

[0045] By implementing the present invention, at least the following beneficial effects are achieved:

[0046] The present invention provides a multimodal power data processing method, device, terminal equipment and storage medium, wherein the method can obtain the power transmission status data, substation status data and power equipment inventory data of the power system to be processed; perform data hierarchy adjustment and missing value processing on the power transmission status data, substation status data and power equipment inventory data respectively to obtain adjusted power transmission status data, adjusted substation status data and adjusted power equipment inventory data; match the adjusted power transmission status data, adjusted substation status data and adjusted power equipment inventory data with a preset defect knowledge base to obtain power defect data; perform data hierarchy adjustment and missing value processing on the power transmission status data, adjusted substation status data and adjusted power equipment inventory data according to ... According to the power equipment inventory data, determine whether the power defect data are all associated with the corresponding main equipment; when the power defect data are not associated with the corresponding main equipment, recursively traverse the power defects according to the adjusted power equipment inventory data to make all power defect data associated with the corresponding main equipment; when the power defect data are associated with the corresponding main equipment, match them according to the adjusted transmission data type code of the transmission status data, the adjusted substation data type code of the substation status data, the adjusted inventory type code of the power equipment inventory data and the preset equipment type association database, and store the data with the same type code in the preset system database to be processed. Data hierarchy adjustment and missing value processing help eliminate errors and incomplete information in power data. Matching the adjusted data with the preset defect knowledge base can effectively identify defects in the power system. Storing the adjusted data in a unified system database to be processed can achieve centralized management and sharing of data. When it is necessary to introduce new modalities or new levels of power data or adjust the existing data structure, it is only necessary to update the associated database accordingly, which reduces the difficulty of system maintenance, realizes maintenance processing of multimodal data, improves the processing efficiency of multimodal data, and also improves the adaptability and flexibility of the system. BRIEF DESCRIPTION OF THE DRAWINGS

[0047] Figure 1 It is a flowchart of a multi-modal power data processing method provided by an embodiment of the present invention;

[0048] Figure 2 is a structural schematic diagram of a multi-modal power data processing device provided by an embodiment of the present invention;

[0049] Figure 3 It is a functional schematic diagram of a monitoring terminal of a multi-modal power data processing method provided by an embodiment of the present invention;

[0050] Figure 4 It is a schematic diagram of a defect handling process of a multi-modal power data processing method provided by an embodiment of the present invention;

[0051] Figure 5 This is a schematic diagram of modeling a substation equipment provided by an embodiment of the present invention;

[0052] Figure 6 is a schematic diagram of modeling of a power transmission device provided by an embodiment of the present invention;

[0053] Figure 7 It is a schematic diagram of asset parameter modeling provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0054] 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.

[0055] See also Figure 1 , is a flow chart of a multi-modal power data processing method provided by an embodiment of the present invention, comprising:

[0056] S1. Obtaining the transmission status data, substation status data and power equipment inventory data of the power system to be processed;

[0057] S2, performing data hierarchy adjustment and missing value processing on the power transmission status data, the substation status data and the electric power equipment ledger data, respectively, to obtain adjusted power transmission status data, adjusted substation status data and adjusted electric power equipment ledger data;

[0058] S3, matching the adjusted power transmission status data, the adjusted substation status data and the adjusted power equipment ledger data with a preset defect knowledge base to obtain power defect data;

[0059] S4. Determine whether the power defect data are all associated with the corresponding main equipment according to the power defect data and the adjusted power equipment ledger data;

[0060] S5. When the power defect data is not associated with the corresponding main device, recursively traverse the power defect data according to the adjusted power equipment ledger data so that all power defect data are associated with the corresponding main device;

[0061] S6. When the power defect data is associated with the corresponding main equipment, matching is performed according to the adjusted power transmission status data type code, the adjusted substation status data type code, the adjusted power equipment inventory data type code and the preset equipment type association database, and the data with the same type code is stored in the preset system database to be processed.

[0062] Specifically, data hierarchy adjustment can discard information of too many unnecessary nodes according to the preset hierarchy, such as directly accessing 110kV and above stations, voltage level areas, intervals, functional locations and their corresponding equipment and 110kV and above lines, and quickly locating equipment. Missing value processing means identifying and processing the data of the power system to be processed, such as unrecognizable voltage levels (such as voltage levels are empty, voltage levels do not exist), substation (interval, functional location) voltage levels and corresponding codes in the encoding that do not match, etc. Defects are uniformly associated with the main equipment, and defects that are only associated with components are associated with the main equipment through a recursive algorithm to ensure that the corresponding defects can be counted during a single equipment analysis.

[0063] In a preferred embodiment of the present invention, the transmission status data, substation status data and power equipment inventory data of the power system to be processed are first obtained; then, data hierarchy adjustment and missing value processing are performed according to the transmission status data, the substation status data and the power equipment inventory data, respectively, to obtain adjusted transmission status data, adjusted substation status data and adjusted power equipment inventory data; then, the adjusted transmission status data, adjusted substation status data and adjusted power equipment inventory data are matched with a preset defect knowledge base to obtain power defect data; then, according to the power defect data and the adjusted power equipment inventory data, the power defect data are judged. Determine whether the power defect data are all associated with the corresponding main equipment; when the power defect data are not associated with the corresponding main equipment, recursively traverse the power defects according to the adjusted power equipment inventory data to make all power defect data associated with the corresponding main equipment; when the power defect data are associated with the corresponding main equipment, match them according to the adjusted transmission data type code of the transmission status data, the adjusted substation data type code of the substation status data, the adjusted inventory type code of the power equipment inventory data and the preset equipment type association database, and store the data with the same type code in the preset system database to be processed.

[0064] Preferably, data hierarchy adjustment and missing value processing are performed respectively according to the power transmission status data, the substation status data and the electric power equipment ledger data to obtain adjusted power transmission status data, adjusted substation status data and adjusted electric power equipment ledger data, including:

[0065] Determine the data hierarchy of each data type of the power system to be processed according to the equipment-related data in the power equipment ledger data;

[0066] Deleting the data hierarchy according to the power transmission status data, the substation status data, the electric power equipment inventory data, the data hierarchy of each data type and the preset data hierarchy, and obtaining the first power transmission status data, the first substation status data and the first electric power equipment inventory data retaining the preset data hierarchy;

[0067] The missing values ​​of the first power transmission status data, the first power transformation status data and the first electric power equipment inventory data are deleted to obtain adjusted power transmission status data, adjusted power transformation status data and adjusted electric power equipment inventory data.

[0068] In a preferred embodiment of the present invention, the data in the power system to be processed includes many data types, each data type has a corresponding data level (data hierarchy), and deleting some terminal data can reduce the data processing amount of the power system. The equipment-related data in the power equipment ledger data records the level of the equipment and the equipment or equipment components associated with the level. First, according to the equipment-related data in the power equipment ledger data, the data level of each data type of the power system to be processed is determined; then, according to the transmission status data, the substation status data, the power equipment ledger data, the data level of each data type and the preset data level, the data level is deleted to obtain the first transmission status data, the first substation status data and the first power equipment ledger data retaining the preset data level; finally, the first transmission status data, the first substation status data and the first power equipment ledger data are deleted for missing values ​​to obtain the adjusted transmission status data, the adjusted substation status data and the adjusted power equipment ledger data, so as to realize the data level adjustment of the power data.

[0069] In an illustrative manner, the first power transmission state data, the first power transformation state data, and the first electric power equipment ledger data are subjected to missing value deletion to obtain adjusted power transmission state data, adjusted power transformation state data, and adjusted electric power equipment ledger data, including:

[0070] Compare the preset equipment model database with the equipment model in the first power equipment ledger data to determine whether the preset equipment model database contains a corresponding equipment model;

[0071] If the corresponding device model does not exist in the preset device model database, the device model in the first power device account data is updated to the preset device model database.

[0072] When the corresponding equipment model exists in the preset equipment model database, the data items with empty numerical data in the first transmission status data, the first substation status data and the first electric power equipment inventory data are deleted to obtain adjusted transmission status data, adjusted substation status data and adjusted electric power equipment inventory data.

[0073] In a preferred embodiment of the present invention, a database of manufacturers and equipment models is established, and the manufacturer is judged and checked when the equipment is connected. A tracking log is provided for the equipment without manufacturer information. A fuzzy query is performed in the manufacturer and equipment model data for the equipment with manufacturer information. When the corresponding two types of information cannot be retrieved, the current manufacturer and equipment model are added. Otherwise, the inconsistent manufacturer information is statistically analyzed and provided to professional management personnel for adjustment to ensure the consistency of future manufacturer information, so as to provide the possibility of analyzing and evaluating the health status of the same manufacturer, the same batch, and the same equipment model using mathematical statistics theory. At the same time, it is judged whether the numerical data in the first transmission status data, the first substation status data, and the first power equipment ledger data is empty, for example, it is judged whether the commissioning date and voltage level are empty, and the date function and numerical function are used to check the validity, so as to provide a basis for the service life and equipment value of the equipment in the status evaluation and risk assessment. At the same time, for non-numerical data, if the equipment phase is checked, for equipment with unknown phase, it is identified by the equipment name, which provides the possibility for the significant difference analysis of the equipment.

[0074] Preferably, the adjusted transmission status data, the adjusted substation status data and the adjusted power equipment ledger data are matched with a preset defect knowledge base to obtain power defect data, including:

[0075] Extract data features from the adjusted power transmission state data, the adjusted power substation state data and the adjusted power equipment inventory data to obtain power transmission features, power substation features and inventory features;

[0076] Compare the transmission characteristics, substation characteristics and ledger characteristics with the data defect range in the preset defect knowledge base to identify the transmission characteristic defects, substation characteristic defects and ledger characteristic defects;

[0077] According to the defect knowledge base, determine the equipment defect types corresponding to the transmission characteristic defects, substation characteristic defects and ledger characteristic defects;

[0078] The corresponding transmission characteristic defects, substation characteristic defects and inventory characteristic defects in the adjusted transmission status data, the adjusted substation status data and the adjusted electric power equipment inventory data are marked with corresponding equipment defect types to obtain electric power defect data.

[0079] In a preferred embodiment of the present invention, the preset defect knowledge base records the data defect range and the corresponding equipment defect type. Extract data features from the adjusted transmission status data, the adjusted substation status data and the adjusted electric power equipment ledger data respectively to obtain transmission features, substation features and ledger features; compare the transmission features, substation features and ledger features with the data defect range in the preset defect knowledge base to identify transmission feature defects, substation feature defects and ledger feature defects; determine the equipment defect types corresponding to the transmission feature defects, substation feature defects and ledger feature defects according to the defect knowledge base; mark the corresponding transmission feature defects, substation feature defects and ledger feature defects in the adjusted transmission status data, the adjusted substation status data and the adjusted electric power equipment ledger data with the corresponding equipment defect type to obtain electric power defect data.

[0080] Preferably, judging whether the power defect data are all associated with the corresponding main equipment according to the power defect data and the adjusted power equipment ledger data includes:

[0081] Determining, according to the power defect data, the type of equipment component corresponding to the power defect data;

[0082] According to the adjusted power equipment ledger data, a knowledge graph of main equipment and main equipment components in the power equipment ledger data is constructed;

[0083] According to the corresponding equipment component type and the knowledge graph of the main equipment and the main equipment components, it is determined whether the power defect data are all associated with the corresponding main equipment.

[0084] In a preferred embodiment of the present invention, the power defect data may be generated by different levels of equipment types, such as equipment components or main equipment composed of equipment components. Figure 4 As shown, first, based on the power defect data, the type of equipment component corresponding to the power defect data is determined; then, based on the adjusted power equipment inventory data, a knowledge graph of main equipment and main equipment components in the power equipment inventory data is constructed; finally, based on the corresponding equipment component type and the knowledge graph of main equipment and main equipment components, it is determined whether the power defect data are all associated with the corresponding main equipment.

[0085] Preferably, matching is performed according to the adjusted transmission data type code of the transmission status data, the adjusted substation data type code of the substation status data, the adjusted ledger type code of the electric power equipment ledger data, and a preset equipment type association database, and storing data with the same type code in a preset system database to be processed, including:

[0086] According to the adjusted power transmission data type code of the power transmission status data, the adjusted power substation data type code of the power substation status data, and the adjusted account type code of the power equipment account data, the corresponding main type code is searched in the preset equipment type association database;

[0087] Searching in the equipment type association database according to the main type code, obtaining the grade area code, bay type code, function location code and equipment category code corresponding to the main type code;

[0088] According to the grade area code, interval type code, functional location code and equipment category code, the corresponding adjusted transmission status data, adjusted substation status data and adjusted power equipment inventory data are determined, and each data item is stored in a preset system database to be processed.

[0089] In a preferred embodiment of the present invention, the main type codes corresponding to transmission status data, substation status data and electric power equipment inventory data of different modes are different, so the corresponding main type code is searched in a preset equipment type association database according to the transmission data type code of the adjusted transmission status data, the substation data type code of the adjusted substation status data and the inventory type code of the adjusted electric power equipment inventory data; then, the equipment type association database is searched according to the main type code to obtain the level area code, interval type code, function location code and equipment category code corresponding to the main type code; then, according to the level area code, interval type code, function location code and equipment category code, each data item of the corresponding adjusted transmission status data, adjusted substation status data and adjusted electric power equipment inventory data is determined, and each data item is stored in a preset system database to be processed.

[0090] In another preferred embodiment of the present invention, by establishing a physical table of voltage level area codes, interval type codes, functional position codes and equipment category codes, when accessed, accurate matching is performed through structured query statements according to coding specifications, and according to the power transmission and transformation equipment, the transformer area (T), transformer interval (AB), transformer functional position (BAB), main transformer equipment (A001) and its corresponding nameplate information, technical parameters, defect information and test data corresponding to the main transformer are retrieved and filtered out. These data can be stored in a preset system database to be processed, avoiding the impact of a large amount of equipment information on system performance in tree structure display, query statistics, status evaluation and even future data mining.

[0091] In a preferred embodiment of the present invention, the transmission data type coding of the adjusted transmission status data and the substation data type coding of the adjusted substation status data are uniformly modeled in the commercial library Oracle and placed in the datarun table space. All tables begin with "EHV_", and the modeling method is modeled in accordance with the CIM hierarchical method. The adjusted transmission status data and the adjusted substation status data cover all data content required for the construction of the ultra-high voltage transmission and transformation and wind power equipment information integration platform, including: model data: transmission lines, tower equipment and geographical location information, ancillary equipment; substation and geographical information, substation main primary equipment model (transformer, switch, bushing, capacitive equipment, insulator, etc.); defect data; inspection data; maintenance data; test data; power grid operation measurement data: SCADA measurement data; secondary device online monitoring data; protection device operation status data; alarm information; third-party system integration data. The data that need to be modeled for substation equipment include ledger information, inspection and test information, online monitoring data and EMS system data in the PM IS system. The unified modeling design of substation equipment is as follows: Figure 5 The data that need to be modeled in the transmission equipment include the ledger, inspection and test data in the PM IS system, the ice warning system data and the EMS system data. The unified modeling design of the transmission equipment is as follows: Figure 6 The asset parameters include substation equipment and assets, transmission lines and assets, and tower assets. The specific asset parameter modeling design is as follows: Figure 7 shown.

[0092] Schematically, the power transmission status data includes: power transmission data type code, power transmission equipment basic data, power transmission line data and power transmission equipment monitoring data;

[0093] The substation status data includes: substation data type code, substation equipment basic data, substation line data and substation equipment monitoring data;

[0094] The electric power equipment ledger data includes: ledger type code, equipment related data and equipment components;

[0095] The transmission equipment monitoring data is obtained through a conductor temperature status monitoring device, a conductor sag status monitoring device, a conductor icing status monitoring device, a breeze vibration status monitoring device, a dancing status monitoring device, a tower tilt status monitoring device, a micro-meteorological status monitoring device and a wind deviation status monitoring device.

[0096] In a preferred embodiment of the present invention, the power transmission equipment monitoring data includes conductor temperature data, conductor sag data, conductor icing data, breeze vibration data, conductor dancing data, tower tilt data, micro-meteorological data, and conductor wind deviation data, such as Figure 3As shown. Conductor temperature status monitoring devices are installed on important lines where the line transmission capacity needs to be improved and on important spans across trunk railways, highways, bridges, rivers or sea areas; conductor sag status monitoring devices are installed on line sections where the sag characteristics of new conductors need to be verified and on line sections that have experienced frequent failures due to insufficient safety distances; conductor icing status monitoring devices are installed on lines in some sections of heavy ice areas and on special geographical environments prone to icing near windward slopes, passes, wind ducts, and large water surfaces, or on lines prone to ice and dancing where the angle with the dominant winter wind direction is greater than 45°; breeze vibration status monitoring devices are installed on large spans across navigable rivers, lakes or straits and in spans where large vibrations can be observed or where strands have broken due to vibrations; dancing status monitoring devices are installed in areas where dancing has occurred before, or installed For transmission lines with an angle greater than 45° to the prevailing wind direction in winter, transmission lines with a large span, or transmission lines with large spans or installed in micro-topography or micro-meteorological areas prone to wind sway; tower inclination status monitoring devices are installed in goaf areas, subsidence areas or poor geological sections; micro-meteorological status monitoring devices are installed in special areas with large spans, easy icing areas or strong wind areas, or in line sections where failures frequently occur due to meteorological factors, or in areas where there are no meteorological monitoring stations at the junction of administrative regions, sparsely populated areas or high mountains and ridges in traditional meteorological monitoring blind spots; wind deviation status monitoring devices are installed on straight tower suspension strings or tension tower jumpers where wind deviation discharges have occurred, or on lines with spans that are perpendicular to the prevailing wind direction all year round or in areas where wind speeds are too high all year round, or in areas where wind deviation discharges to the ground occur. In addition, there are pollution status monitoring devices installed at pollution level points, or at the most polluted locations within the range, or in areas where pollution flashover accidents have occurred or the existing creepage distance does not meet the requirements; image and video status monitoring devices are installed in areas prone to external force damage, fire prone areas, ice prone areas, passage tree growth areas, remote and difficult to reach areas or other line dangerous points, defect prone sections. The ice monitoring terminal is installed on the power tower to complete the collection and transmission of various sensors and image information. The ice monitoring terminal mainly collects environmental parameters, including wind speed, wind direction, temperature, humidity and air pressure. The above meteorological parameters are used to analyze the ice conditions of the ice system and participate in the calculation of the ice thickness model. The ice monitoring terminal also collects the tension borne by the insulator string and the angle of tension change of the insulator string, directly participates in the calculation of the ice model, and can directly give the severity of ice through the change of tension.

[0097] Substation equipment includes oil-immersed transformers, GIS / HG IS equipment, circuit breakers, switches, capacitive equipment, electromagnetic transformers, dry-type reactors, metal oxide arresters, insulators, and lightning protection grounding devices.

[0098] In a preferred embodiment of the present invention, the online monitoring data of power transmission and transformation equipment is used as an example to illustrate the model design. Table 1 below is the type information of online monitoring measurement points of power transmission and transformation equipment, which describes the definition of online monitoring measurement point types. For online monitoring data of power transformation equipment, refer to Table 2 below, and for online monitoring data of power transmission equipment, refer to Table 3 below.

[0099] Table 1

[0100]

[0101]

[0102] Table 2

[0103]

[0104]

[0105]

[0106]

[0107]

[0108] Table 3

[0109]

[0110]

[0111] By implementing this embodiment, the transmission status data, substation status data and power equipment inventory data of the power system to be processed are obtained; data hierarchy adjustment and missing value processing are performed according to the transmission status data, the substation status data and the power equipment inventory data, respectively, to obtain adjusted transmission status data, adjusted substation status data and adjusted power equipment inventory data; the adjusted transmission status data, adjusted substation status data and adjusted power equipment inventory data are matched with a preset defect knowledge base to obtain power defect data; according to the power defect data and the adjusted power equipment inventory data, the power defect data is judged. The power defect data is associated with the corresponding main equipment; in the case that the power defect data is not associated with the corresponding main equipment, the power defect data is recursively traversed according to the adjusted power equipment ledger data until all power defect data are associated with the corresponding main equipment; in the case that the power defect data is associated with the corresponding main equipment, the transmission data type coding of the adjusted transmission status data, the substation data type coding of the adjusted substation status data, the ledger type coding of the adjusted power equipment ledger data and the preset equipment type association database are matched, and the data with the same type coding is stored in the preset system database to be processed. Data hierarchy adjustment and missing value processing are helpful to eliminate errors and incomplete information in power data, match the adjusted data with the preset defect knowledge base, effectively identify defects in the power system, store the adjusted data in a unified system database to be processed, and realize centralized management and sharing of data. When it is necessary to introduce new modal or new level power data or adjust the existing data structure, it is only necessary to update the associated database accordingly, which reduces the difficulty of system maintenance, realizes maintenance processing of multimodal data, improves the processing efficiency of multimodal data, and also improves the adaptability and flexibility of the system.

[0112] See also Figure 2 , is a schematic diagram of the structure of a multi-modal power data processing device provided by an embodiment of the present invention, comprising:

[0113] The power data acquisition module is used to obtain the power transmission status data, substation status data and power equipment ledger data of the power system to be processed;

[0114] A data hierarchy adjustment module, used to perform data hierarchy adjustment and missing value processing according to the power transmission status data, the substation status data and the electric power equipment ledger data, respectively, to obtain adjusted power transmission status data, adjusted substation status data and adjusted electric power equipment ledger data;

[0115] A data defect matching module is used to match the adjusted power transmission status data, the adjusted substation status data and the adjusted power equipment ledger data with a preset defect knowledge base to obtain power defect data;

[0116] An equipment association judgment module, used to judge whether the power defect data are all associated with the corresponding main equipment according to the power defect data and the adjusted power equipment ledger data;

[0117] A defect association module, used for recursively traversing the power defects according to the adjusted power equipment ledger data when the power defect data is not associated with the corresponding main equipment, so that all power defect data are associated with the corresponding main equipment;

[0118] A data processing module is used to match the power defect data with the same type code according to the adjusted power transmission status data type code, the adjusted substation status data type code, the adjusted power equipment inventory data and a preset equipment type association database when the power defect data is associated with the corresponding main equipment, and store the data with the same type code in the preset system database to be processed.

[0119] The present invention provides a multimodal power data processing device, which acquires the transmission status data, substation status data and power equipment inventory data of the power system to be processed according to the power data acquisition module; in the data hierarchy adjustment module, data hierarchy adjustment and missing value processing are performed according to the transmission status data, the substation status data and the power equipment inventory data, respectively, to obtain the adjusted transmission status data, the adjusted substation status data and the adjusted power equipment inventory data; through the data defect matching module, the adjusted transmission status data, the adjusted substation status data and the adjusted power equipment inventory data are matched with the preset defect knowledge base to obtain the power defect data; in the equipment association judgment module, according to the power defect data and the adjusted According to the adjusted power equipment inventory data, it is determined whether the power defect data are all associated with the corresponding main equipment; through the defect association module, when the power defect data is not associated with the corresponding main equipment, the power defects are recursively traversed according to the adjusted power equipment inventory data, so that all power defect data are associated with the corresponding main equipment; through the data processing module, when the power defect data is associated with the corresponding main equipment, the transmission data type code of the adjusted transmission status data, the substation data type code of the adjusted substation status data, the inventory type code of the adjusted power equipment inventory data and the preset equipment type association database are matched, and the data with the same type code is stored in the preset system database to be processed. Data hierarchy adjustment and missing value processing help eliminate errors and incomplete information in power data. Matching the adjusted data with the preset defect knowledge base can effectively identify defects in the power system. Storing the adjusted data in a unified system database to be processed can achieve centralized management and sharing of data. When it is necessary to introduce new modalities or new levels of power data or adjust the existing data structure, it is only necessary to update the associated database accordingly, which reduces the difficulty of system maintenance, realizes maintenance processing of multimodal data, improves the processing efficiency of multimodal data, and also improves the adaptability and flexibility of the system.

[0120] The above is a preferred embodiment of the present invention. It should be pointed out that a person skilled in the art can make several improvements and modifications without departing from the principle of the present invention. These improvements and modifications are also considered to be within the scope of protection of the present invention.

Claims

1. A multi-modal power data processing method, characterized in that: include: Obtain the transmission status data, substation status data and power equipment inventory data of the power system to be processed; According to the power transmission status data, the power transformation status data and the power equipment inventory data, respectively, data hierarchy adjustment and missing value processing are performed to obtain adjusted power transmission status data, adjusted power transformation status data and adjusted power equipment inventory data; Matching the adjusted power transmission status data, the adjusted substation status data and the adjusted power equipment inventory data with a preset defect knowledge base to obtain power defect data; According to the power defect data and the adjusted power equipment ledger data, determining whether the power defect data are all associated with the corresponding main equipment; In the case where the power defect data is not associated with the corresponding main device, recursively traverse the power defect according to the adjusted power equipment ledger data so that all power defect data are associated with the corresponding main device; When the power defect data is associated with the corresponding main equipment, matching is performed according to the adjusted transmission data type code of the transmission status data, the adjusted substation data type code of the substation status data, the adjusted inventory type code of the power equipment inventory data and a preset equipment type association database, and the data with the same type code is stored in a preset system database to be processed.

2. A multi-modal power data processing method according to claim 1, characterized in that: According to the power transmission status data, the power transformation status data and the power equipment ledger data, data hierarchy adjustment and missing value processing are performed respectively to obtain adjusted power transmission status data, adjusted power transformation status data and adjusted power equipment ledger data, including: Determine the data hierarchy of each data type of the power system to be processed according to the equipment-related data in the power equipment ledger data; Deleting the data hierarchy according to the power transmission status data, the substation status data, the electric power equipment inventory data, the data hierarchy of each data type and the preset data hierarchy, and obtaining the first power transmission status data, the first substation status data and the first electric power equipment inventory data retaining the preset data hierarchy; The missing values ​​of the first power transmission status data, the first power transformation status data and the first electric power equipment inventory data are deleted to obtain adjusted power transmission status data, adjusted power transformation status data and adjusted electric power equipment inventory data.

3. A multi-modal power data processing method as claimed in claim 2, characterized in that: The first power transmission state data, the first power transformation state data and the first power equipment ledger data are deleted for missing values ​​to obtain adjusted power transmission state data, adjusted power transformation state data and adjusted power equipment ledger data, including: Compare the preset equipment model database with the equipment model in the first power equipment ledger data to determine whether the preset equipment model database contains a corresponding equipment model; If the corresponding device model does not exist in the preset device model database, the device model in the first power device account data is updated to the preset device model database. When the corresponding equipment model exists in the preset equipment model database, the data items with empty numerical data in the first transmission status data, the first substation status data and the first electric power equipment inventory data are deleted to obtain adjusted transmission status data, adjusted substation status data and adjusted electric power equipment inventory data.

4. A multi-modal power data processing method according to claim 1, characterized in that: The adjusted transmission status data, the adjusted substation status data and the adjusted power equipment inventory data are matched with the preset defect knowledge base to obtain power defect data, including: Extract data features from the adjusted power transmission state data, the adjusted power substation state data and the adjusted power equipment inventory data to obtain power transmission features, power substation features and inventory features; Compare the transmission characteristics, substation characteristics and ledger characteristics with the data defect range in the preset defect knowledge base to identify the transmission characteristic defects, substation characteristic defects and ledger characteristic defects; According to the defect knowledge base, determine the equipment defect types corresponding to the transmission characteristic defects, substation characteristic defects and ledger characteristic defects; The corresponding transmission characteristic defects, substation characteristic defects and inventory characteristic defects in the adjusted transmission status data, the adjusted substation status data and the adjusted electric power equipment inventory data are marked with corresponding equipment defect types to obtain electric power defect data.

5. A multi-modal power data processing method according to claim 1, characterized in that: According to the power defect data and the adjusted power equipment ledger data, determining whether the power defect data are all associated with the corresponding main equipment includes: Determining, according to the power defect data, the type of equipment component corresponding to the power defect data; According to the adjusted power equipment ledger data, a knowledge graph of main equipment and main equipment components in the power equipment ledger data is constructed; According to the corresponding equipment component type and the knowledge graph of the main equipment and the main equipment components, it is determined whether the power defect data are all associated with the corresponding main equipment.

6. A multi-modal power data processing method according to claim 1, characterized in that: According to the adjusted transmission data type code of the transmission status data, the adjusted substation data type code of the substation status data, the adjusted account type code of the power equipment account data and the preset equipment type association database, the data with the same type code is stored in the preset system database to be processed, including: According to the adjusted power transmission data type code of the power transmission status data, the adjusted power substation data type code of the power substation status data, and the adjusted account type code of the power equipment account data, the corresponding main type code is searched in the preset equipment type association database; Searching in the equipment type association database according to the main type code, obtaining the grade area code, bay type code, function location code and equipment category code corresponding to the main type code; According to the grade area code, interval type code, functional location code and equipment category code, the corresponding adjusted transmission status data, adjusted substation status data and adjusted power equipment inventory data are determined, and each data item is stored in a preset system database to be processed.

7. A multi-modal power data processing method according to claim 1, characterized in that: The power transmission status data includes: power transmission data type code, power transmission equipment basic data, power transmission line data and power transmission equipment monitoring data; The substation status data includes: substation data type code, substation equipment basic data, substation line data and substation equipment monitoring data; The electric power equipment ledger data includes: ledger type code, equipment related data and equipment components; The transmission equipment monitoring data is obtained through a conductor temperature status monitoring device, a conductor sag status monitoring device, a conductor icing status monitoring device, a breeze vibration status monitoring device, a dancing status monitoring device, a tower tilt status monitoring device, a micro-meteorological status monitoring device and a wind deviation status monitoring device.

8. A multi-modal power data processing device, characterized in that: include: The power data acquisition module is used to obtain the power transmission status data, substation status data and power equipment ledger data of the power system to be processed; A data hierarchy adjustment module, used to perform data hierarchy adjustment and missing value processing according to the power transmission status data, the substation status data and the electric power equipment ledger data, respectively, to obtain adjusted power transmission status data, adjusted substation status data and adjusted electric power equipment ledger data; A data defect matching module is used to match the adjusted power transmission status data, the adjusted substation status data and the adjusted power equipment ledger data with a preset defect knowledge base to obtain power defect data; An equipment association judgment module, used to judge whether the power defect data are all associated with the corresponding main equipment according to the power defect data and the adjusted power equipment ledger data; A defect association module, used for recursively traversing the power defect data according to the adjusted power equipment ledger data when the power defect data is not associated with the corresponding main equipment, until all the power defect data are associated with the corresponding main equipment; A data processing module is used to match the power defect data with the same type code according to the adjusted power transmission status data type code, the adjusted substation status data type code, the adjusted power equipment inventory data and a preset equipment type association database when the power defect data is associated with the corresponding main equipment, and store the data with the same type code in the preset system database to be processed.

9. A terminal device, characterized in that: It comprises a processor, a memory, and a computer program stored in the memory and configured to be executed by the processor, and when the processor executes the computer program, it implements a multimodal power data processing method as described in any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium includes a stored computer program, wherein when the computer program is executed, the device where the computer-readable storage medium is located is controlled to execute a multi-modal power data processing method as described in any one of claims 1 to 7.

Images