Lightning database establishment method, device, equipment, medium and product

Abstract

The embodiment of the invention provides a lightning database establishment method, device and equipment, a medium and a product. The method comprises the following steps: acquiring multi-source lightning current characteristic data; creating a lightning current feature data table according to the second lightning current feature data, the third lightning current feature data and the fourth lightning current feature data; constructing a thunder and lightning positioning system data table according to the first thunder and lightning current characteristic data; and fusing the lightning current characteristic data table and the lightning positioning system data table to obtain a multiple lightning current characteristic database. According to the method, more multi-source lightning current characteristic data are obtained by combining a lightning positioning system statistical method, a high tower measurement method, a manual lightning triggering measurement method and a power transmission line lightning parameter inversion method, and a multi-source data fused multi-lightning stroke lightning current characteristic database is established; and a more sufficient and reliable data source basis can be provided for power grid protection multiple lightning stroke fault analysis and calculation analysis of insulation design.

Description

Technical Field

[0001] The present invention relates to the field of data processing technology, and in particular to a method, device, equipment, medium and product for establishing a lightning database. Background Art

[0002] In recent years, equipment failures in substations caused by multiple lightning strikes have occurred from time to time, such as circuit breakers, lightning arresters, and main transformer failures. The main reason for the above failures is that the existing insulation coordination design and verification of power transmission and transformation equipment are generally based on a single lightning strike, without considering the harsh working conditions of multiple lightning strikes, and cannot effectively protect against multiple lightning strikes. The basis of the insulation design of power transmission and transformation equipment to protect against multiple lightning strikes is the characteristic parameters of multiple lightning currents, which are the basic parameters and boundary conditions for carrying out lightning protection in lines and stations. Currently, the most widely used and largest database of characteristic parameters of multiple lightning currents is the database that comes with the lightning location system, which stores original data including the time, location, polarity, amplitude, etc. of each return stroke.

[0003] However, the current data sources of multiple lightning current characteristic parameters are relatively single, and there are few effective waveform data characteristic samples, which leads to application difficulties. In addition, no reasonable and effective analysis of the data has been made, and there is also the problem of incomplete database. Summary of the invention

[0004] The present invention provides a method, device, equipment, medium and product for establishing a lightning database, which establishes a multiple lightning current characteristic database with multi-source data fusion, and can provide a more sufficient and reliable data source basis for the calculation and analysis of multiple lightning fault analysis and insulation design of power grid protection.

[0005] In a first aspect, an embodiment of the present invention provides a method for establishing a lightning database, comprising:

[0006] Acquire lightning current characteristic data from multiple sources, wherein the lightning current characteristic data from multiple sources at least includes first lightning current characteristic data recorded by a lightning location system, second lightning current characteristic data obtained by high tower measurement, third lightning current characteristic data obtained by an artificial lightning induction test, and fourth lightning current characteristic data obtained by inversion of lightning parameters of a transmission line;

[0007] Creating a lightning current characteristic data table according to the second lightning current characteristic data, the third lightning current characteristic data and the fourth lightning current characteristic data;

[0008] Constructing a lightning location system data table according to the first lightning current characteristic data;

[0009] The lightning current characteristic data table and the lightning location system data table are merged to obtain a multiple lightning current characteristic database.

[0010] In a second aspect, an embodiment of the present invention provides a lightning database establishment device, comprising:

[0011] A data acquisition module is used to acquire lightning current characteristic data from multiple sources, wherein the lightning current characteristic data from multiple sources at least includes first lightning current characteristic data recorded by a lightning location system, second lightning current characteristic data obtained by high tower measurement, third lightning current characteristic data obtained by an artificial lightning induction test, and fourth lightning current characteristic data obtained by inversion of lightning parameters of a transmission line;

[0012] A first building module, configured to create a lightning current characteristic data table according to the second lightning current characteristic data, the third lightning current characteristic data and the fourth lightning current characteristic data;

[0013] A second construction module is used to construct a lightning location system data table according to the first lightning current characteristic data;

[0014] The data fusion module is used to fuse the lightning current characteristic data table with the lightning location system data table to obtain a multiple lightning current characteristic database.

[0015] In a third aspect, this embodiment provides an electronic device, including:

[0016] at least one processor; and

[0017] a memory communicatively connected to the at least one processor; wherein,

[0018] The memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can execute the lightning database establishment method described in any embodiment of the present invention.

[0019] In a fourth aspect, this embodiment provides a computer-readable storage medium, and the computer program is executed by the at least one processor, so that the at least one processor can execute the lightning database establishment method described in any embodiment of the present invention.

[0020] In a fifth aspect, an embodiment of the present invention further provides a computer program product, wherein the computer program product comprises a computer program, and when the computer program is executed by a processor, the method for establishing a lightning database as described in any embodiment of the present invention is implemented.

[0021] The embodiment of the present invention provides a method, device, equipment, medium and product for establishing a lightning database, the method comprising: firstly obtaining lightning current characteristic data from multiple sources, the lightning current characteristic data from multiple sources at least including the first lightning current characteristic data recorded by the lightning location system, the second lightning current characteristic data obtained by high tower measurement, the third lightning current characteristic data obtained by artificial lightning induction test and the fourth lightning current characteristic data obtained by inversion of lightning parameters of transmission lines; secondly, creating a lightning current characteristic data table according to the second lightning current characteristic data, the third lightning current characteristic data and the fourth lightning current characteristic data; then constructing a lightning location system data table according to the first lightning current characteristic data; finally, merging the lightning current characteristic data table with the lightning location system data table to obtain a multiple lightning current characteristic database. The above technical scheme combines the lightning location system statistical method, the high tower measurement method, the artificial lightning induction measurement method and the transmission line lightning parameter inversion method to obtain more multiple lightning current characteristic data, and establishes a multiple lightning current characteristic database with multiple lightning strikes fused with multiple source data, which can provide a more sufficient and reliable data source basis for the calculation and analysis of multiple lightning strike faults analysis and insulation design of power grid protection.

[0022] It should be understood that the contents described in this section are not intended to identify the key or important features of the embodiments of the present invention, nor are they intended to limit the scope of the present invention. Other features of the present invention will become easily understood through the following description. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following briefly introduces the drawings required for use in the description of the embodiments. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.

[0024] Figure 1 A schematic diagram of a flow chart of a method for establishing a lightning database provided in the first embodiment of the present invention;

[0025] Figure 2 A schematic diagram of a flow chart of another method for establishing a lightning database provided in the second embodiment of the present invention;

[0026] Figure 3 A schematic diagram of the structure of a lightning database establishment device provided in Embodiment 3 of the present invention;

[0027] Figure 4 A schematic diagram of the structure of an electronic device provided in Embodiment 4 of the present invention. DETAILED DESCRIPTION

[0028] In order to enable those skilled in the art to better understand the scheme of the present invention, the technical scheme in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings 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 should fall within the scope of protection of the present invention.

[0029] It should be noted that the terms "original", "target", etc. in the specification and claims of the present invention and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments of the present invention described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device that includes a series of steps or units is not necessarily limited to those steps or units that are clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0030] Embodiment 1

[0031] Figure 1 This is a flow chart of a method for establishing a lightning database provided in the first embodiment of the present invention. The method can be applied to the case of establishing a lightning database. The method can be executed by a lightning database establishment device. The device can be implemented in the form of hardware and / or software and can be configured in an electronic device. Figure 1 As shown, the lightning database establishment method provided in the first embodiment may specifically include the following steps:

[0032] S101. Acquire lightning current characteristic data from multiple sources.

[0033] Among them, the multi-source lightning current characteristic data at least include the first lightning current characteristic data recorded by the lightning location system, the second lightning current characteristic data obtained by high tower measurement, the third lightning current characteristic data obtained by artificial lightning induction test and the fourth lightning current characteristic data obtained by inversion of lightning parameters of transmission lines.

[0034] It should be clear that the data sources of multiple lightning current characteristic parameters are relatively single, and there are few effective waveform data characteristic samples, which leads to application difficulties, and no reasonable and effective analysis of the data is made, such as the current lightning location system database, which contains the original data such as time, location, polarity, amplitude, order, etc. corresponding to each return stroke, but no further statistics are made. The multiple lightning current characteristic parameter database based on the lightning location system does not interact with the multiple lightning current waveform characteristic parameters, and there is a problem of incomplete database. Therefore, in this embodiment, it is considered to combine the lightning location system statistical method, the high tower measurement method, the artificial lightning measurement method and the transmission line lightning parameter inversion method to obtain more multi-source lightning current characteristic parameters, and establish a multi-source data fusion multiple lightning current characteristic parameter database, which can provide a more sufficient and reliable data source basis for the calculation and analysis of multiple lightning fault analysis and insulation design of power grid protection.

[0035] In this embodiment, more multi-source lightning current characteristic data are obtained through lightning location system, high tower measurement, artificial lightning induction measurement and transmission line lightning parameter inversion. Specifically, the detailed natural lightning current data of the lightning location system over the years, including time, longitude, latitude, amplitude, polarity, return stroke order, and number of positioning stations, are queried, and the lightning current data recorded by the lightning location system is recorded as the first lightning current characteristic data. The natural lightning current waveform data is obtained from the monitoring device of the high tower measurement, and the time and longitude and latitude coordinates are marked, and the lightning current data obtained from the high tower measurement is recorded as the second lightning current characteristic data. Through the artificial lightning induction test, the natural lightning current waveform data is measured, and the time and longitude and latitude coordinates are marked, and the lightning current characteristic data obtained by the artificial lightning induction test is recorded as the third lightning current characteristic data. The distributed fault precise location system is used to measure the current amplitude and waveform characteristics flowing through the transmission line. At the same time, a refined simulation model of the transmission line of the distributed fault precise location system is built in the electromagnetic transient simulation software. By adjusting the amplitude, wavefront time and wavetail time of the simulated lightning current source, the error between the simulation result and the actual result measured on the line is within a certain range. The lightning current waveform data can be inverted and the time and longitude and latitude coordinates are marked. The lightning parameters of the transmission line are inverted to obtain more multi-source lightning current data, which is recorded as the fourth lightning current characteristic data.

[0036] S102: Create a lightning current characteristic data table according to the second lightning current characteristic data, the third lightning current characteristic data, and the fourth lightning current characteristic data.

[0037] In this embodiment, after obtaining lightning current characteristic data from multiple sources, data tables of data obtained from high tower measurement, artificial lightning induction, and transmission line lightning parameter inversion are created respectively, that is, a data table is established for the second lightning current characteristic data, the third lightning current characteristic data, and the fourth lightning current characteristic data, which is recorded as a lightning current characteristic data table. When creating a lightning current characteristic data table, corresponding row indexes and column indexes can be set. For example, the row index can be time, longitude, latitude, amplitude, wavefront time, and wave tail time. The values ​​corresponding to these row indexes can be obtained from the lightning current characteristic data. In addition, the row index of the lightning current characteristic data table can also include a serial number, which is temporarily empty and used for subsequent connection with other data tables. The column indexes are field names, data types, field descriptions, and constraints, etc.

[0038] Continuing with the above description, when creating a lightning characteristic data table, you can also use the structure of a parent table and a child table to create it. For example, create a corresponding child table based on the parent table, and the child table is used to store the waveform data corresponding to the measured lightning current. After determining the structure of the data table, you can create a lightning current characteristic data table based on a database management tool. For example, use the visualization software Navicat to create a lightning current characteristic data table in MySQL. Navicat is a database management tool that can create multiple connections. MySQL is the type of database.

[0039] S103: construct a lightning location system data table according to the first lightning current characteristic data.

[0040] In this embodiment, according to the first lightning current characteristic data, a lightning location system database is created, Python is used to connect to the database, and the raw data therein is further statistically analyzed to obtain a characteristic parameter data table. In this embodiment, by querying the lightning location system, detailed natural lightning data over the years are obtained, and a corresponding data table is created, which is recorded as a lightning location system data table. The row indexes of the lightning location system data table are time, longitude, latitude, amplitude, return stroke, and positioning station number column indexes. The column indexes of the lightning location system data table are field name, data type, field description, and constraint. According to the above table structure design, a lightning location system data table is created using a database management tool. Exemplarily, the visualization software navicat creates a lightning location system data table in MySQL.

[0041] Following the above description, Python is used to connect to the database, and the raw data in the lightning location data table obtained above is preprocessed to obtain a preprocessed lightning location system data table. The preprocessed lightning location system data table is statistically processed to obtain a processed lightning location system data table.

[0042] S104, merging the lightning current characteristic data table and the lightning location system data table to obtain a multiple lightning current characteristic database.

[0043] The above data tables are integrated and imported into MySQL to form a multi-source fusion database of multiple lightning current characteristic parameters. Specifically, according to the time and longitude corresponding to the data in the lightning current characteristic data table of the parameters obtained by high tower measurement, artificial lightning measurement and transmission line lightning parameter inversion, the data in the lightning location system database is queried, the corresponding serial number is found and entered into the table. Using the database management tool, the lightning current characteristic data table corresponding to the high tower measurement, artificial lightning measurement and transmission line lightning parameter inversion is connected with the data table of the lightning location system to obtain a database of multiple lightning current characteristic parameters.

[0044] The above technical scheme combines the statistical method of lightning location system, the high tower measurement method, the artificial lightning induction measurement method and the transmission line lightning parameter inversion method to obtain more multi-source lightning current characteristic data, and establishes a multi-source data fusion multiple lightning current characteristic database, which can provide a more sufficient and reliable data source basis for the calculation and analysis of multiple lightning faults analysis and insulation design of power grid protection.

[0045] Embodiment 2

[0046] Figure 2 A flow chart of another method for establishing a lightning database provided in Embodiment 2 of the present invention. This embodiment is a further optimization of the above-mentioned embodiment. In this embodiment, "creating a lightning current characteristic data table according to the second lightning current characteristic data, the third lightning current characteristic data and the fourth lightning current characteristic data" is further limited and optimized, and "building a lightning locating system data table according to the first lightning current characteristic data" is further limited and optimized, and "merging the lightning current characteristic data table and the lightning locating system data table to obtain a multiple lightning current characteristic database" is further limited and optimized.

[0047] like Figure 2 As shown, this embodiment 2 provides a method for establishing a lightning database, which specifically includes the following steps:

[0048] S201. Acquire lightning current characteristic data from multiple sources.

[0049] Among them, the multi-source lightning current characteristic data at least include the first lightning current characteristic data recorded by the lightning location system, the second lightning current characteristic data obtained by high tower measurement, the third lightning current characteristic data obtained by artificial lightning induction test and the fourth lightning current characteristic data obtained by inversion of lightning parameters of transmission lines.

[0050] S202. Construct the structure of the parent table of lightning characteristic data.

[0051] This step is used to create the corresponding data parent table, which is recorded as the lightning characteristic data parent table. The row indexes of the lightning characteristic data parent table are time, longitude, latitude, amplitude, wavefront time, wave tail time and sequence number, and the sequence number is empty. The column indexes are field name, data type, field description and constraint, etc. For example, Table 1 is a parent table of lightning characteristic data in a certain application scenario. The first line is time, the second line is longitude, the third line is latitude, the fourth line is amplitude, the fifth line is wavefront time, the sixth line is wave tail time, and the seventh line is sequence number. The seventh line sequence number is temporarily null and is used to connect with other data tables in subsequent steps. The first column is the field name, the second column is the data type, the third column is the field description, and the fourth column is the constraint. For example, the field name in Table 1 is time, the data type is datetime, the field description is the time when the lightning strike occurs, and the constraint is not null. The contents in Table 1 are no longer listed one by one here.

[0052] Table 1

[0053]

[0054]

[0055] S203: According to the lightning characteristic data parent table, construct a structure of a lightning characteristic data child table corresponding to the lightning characteristic data parent table.

[0056] The lightning characteristic data sub-table is used to store the lightning waveform data in each lightning current characteristic data.

[0057] Following the above description, a corresponding sub-table is created according to the lightning characteristic data parent table, recorded as the lightning characteristic data sub-table. The table is used to store the waveform data corresponding to the measured lightning current, set the timestamp and the corresponding lightning current amplitude, and can be used to draw the lightning current waveform.

[0058] S204: Create a lightning current characteristic data table according to the second lightning current characteristic data, the third lightning current characteristic data and the fourth lightning current characteristic data in combination with the structure of the lightning characteristic data parent table and the structure of the lightning characteristic data child table.

[0059] Exemplarily, according to the structure of the parent table of lightning characteristic data and the structural design of the child table of lightning characteristic data, a data table is created in MySQL using the visualization software navicat, and the data of the second lightning current characteristic data, the third lightning current characteristic data and the fourth lightning current characteristic data are added to the corresponding rows and columns.

[0060] S205. Construct a lightning location system data table according to the first lightning current characteristic data.

[0061] In this embodiment, by querying the lightning location system, detailed natural lightning data over the years is obtained, and a corresponding data table is created, which is recorded as the lightning location system data table. The row indexes of the lightning location system data table are time, longitude, latitude, amplitude, return stroke, and location station number column indexes. The column indexes of the lightning location system data table are field name, data type, field description, and constraint. According to the above table structure design, a lightning location system data table is created using a database management tool. Exemplarily, the visualization software navicat creates a lightning location system data table in MySQL and adds the first lightning current characteristic data to the corresponding rows and columns.

[0062] For example, Table 2 is a data table of a lightning location system in a certain application scenario. The first line is time, the second line is longitude, the third line is latitude, the fourth line is amplitude, the fifth line is return stroke (this column is used to indicate the return stroke order), and the sixth line is the number of positioning stations. The first column is the field name, the second column is the data type, the third column is the field description, and the fourth column is the constraint. For example, the field name in Table 2 is time, the data type is datetime, the field description is the time when the lightning strike occurs, and the constraint is not null. The contents in Table 2 are not listed one by one here.

[0063] Table 2

[0064]

[0065] S206: Preprocess the first lightning characteristic data in the lightning location system data table to obtain a preprocessed lightning location system data table.

[0066] In this embodiment, Python is used to connect to the database, and the raw data in the lightning location data table is preprocessed to obtain a preprocessed lightning location system data table. The preprocessing may include reordering by time, grouping by return strike order, and adding new feature data.

[0067] As a specific implementation method, the step of preprocessing the first lightning characteristic data in the lightning location system data table to obtain the preprocessed lightning location system data table may be optimized, including:

[0068] a1) re-sorting all first lightning characteristic data by time, calculating the sorted time interval, and adding the time interval as a new row to the lightning location system data table.

[0069] In this embodiment, all first lightning characteristic data are first reordered by time, and the time interval is calculated. The time interval is added as a new row to the lightning location system data table. Exemplarily, continue to refer to Table 2 and add the time interval as the seventh row.

[0070] b1) Grouping the first lightning characteristic data according to the return stroke order, adding the frequency of multiple lightning strikes and the subsequent return stroke order as new rows to the lightning location system data table.

[0071] Specifically, the data is then grouped according to the return order, each group includes the first return and subsequent return of multiple lightning strikes, and the frequency of multiple lightning strikes and the subsequent return order are added as new rows to the lightning location system data table. Exemplarily, continue to refer to Table 2, and add the frequency of multiple lightning strikes and the subsequent return order as the eighth row.

[0072] c1) Generate a unique serial number for each piece of data according to the time corresponding to each piece of data and add it as a new row to the lightning location system data table.

[0073] In this embodiment, finally, a unique serial number is generated for each piece of data according to the time corresponding to the data and added as a new row to the lightning location system data table. Exemplarily, referring to Table 2, a unique serial number is generated for each piece of data and added as the ninth row.

[0074] The above technical solution concretizes the step of preprocessing the first lightning characteristic data in the lightning location system data table.

[0075] S207: Perform statistical processing on the pre-processed lightning location system data table to obtain a processed lightning location system data table.

[0076] In this embodiment, statistical processing is performed on the pre-processed lightning location system data table to obtain a processed lightning location system data table.

[0077] As a specific implementation method, the steps of performing statistical analysis on the pre-processed lightning location system data table to obtain the lightning location system data table may be optimized, including:

[0078] The first lightning current characteristic data in the preprocessed lightning location system data table is statistically analyzed to obtain statistical results of all lightning current characteristic data for each year and / or all previous years to form a lightning location system data table.

[0079] Among them, the statistical analysis at least includes the proportion of multiple lightning, the frequency distribution of multiple lightning, the time interval distribution, the duration, and the amplitude distribution. Specifically, statistical analysis is performed on the data in the lightning location system data table after the above preprocessing to obtain the proportion of multiple lightning, the frequency distribution of multiple lightning, the time interval distribution, the duration, and the amplitude distribution, and the annual statistics and the overall statistics of all data in previous years are obtained to obtain the statistical characteristic parameter data table of multiple lightning currents, which is recorded as the lightning location system data table.

[0080] The above technical solution specifies the steps for constructing a lightning location system data table.

[0081] S208. According to the time and longitude and latitude corresponding to each data in the lightning current characteristic data table, query the data in the lightning location system data table, obtain the corresponding serial number and enter it into the lightning current characteristic data table.

[0082] In this embodiment, according to the time, longitude and latitude corresponding to each data in the lightning current characteristic data table of the parameters obtained by high tower measurement, artificial lightning induction measurement and transmission line lightning parameter inversion, the data in the lightning location system data table is queried, the corresponding serial number is found and entered into the table.

[0083] S209, connecting the lightning current characteristic data table with the lightning location system data table to obtain a multiple lightning current characteristic database.

[0084] In this embodiment, a database management tool is used to connect the lightning current characteristic data table corresponding to the high tower measurement, artificial lightning induction measurement and transmission line lightning parameter inversion with the data table of the lightning location system, thereby obtaining a multiple lightning current characteristic parameter database. Exemplarily, the INNER JOIN operation in the database management tool MySQL can be used to connect the two tables to obtain a multiple lightning current characteristic database.

[0085] The above technical solution specifies the steps of creating a lightning current characteristic data table, the steps of constructing a lightning location system data table, and the steps of merging the lightning current characteristic data table with the lightning location system data table to obtain a multiple lightning current characteristic database. Obtain more multi-source lightning current characteristic data through the lightning location system, high tower measurement, artificial lightning induction measurement, and transmission line lightning parameter inversion; create data tables of parameters obtained from high tower measurement, artificial lightning induction, and transmission line lightning parameter inversion respectively; create a lightning location system database, connect the database using a database management tool, and further statistically analyze the original data therein to obtain a characteristic parameter data table; integrate the above data tables and import them into a certain database type in the database management tool to form a multi-source fused multiple lightning current characteristic parameter database. Considering combining the statistical method of lightning location system, high tower measurement method, artificial lightning induction measurement method and transmission line lightning parameter inversion method to obtain more multi-source lightning current characteristic parameters, the problem of the current single source of multiple lightning current characteristic parameter data is solved. In this way, a multiple lightning current characteristic database with multi-source data fusion is established, making the database more comprehensive, which can provide more sufficient and reliable data source basis for the calculation and analysis of multiple lightning fault analysis and insulation design of power grid protection.

[0086] Embodiment 3

[0087] Figure 3This is a schematic diagram of the structure of a lightning database establishment device provided in Embodiment 3 of the present invention. The device can be applied to the situation of establishing a lightning database. The lightning database establishment device can be configured in an electronic device, such as Figure 3 As shown, the device includes: a data acquisition module 31, a first construction module 32, a second construction module 33 and a data fusion module 34; wherein,

[0088] The data acquisition module 31 is used to acquire lightning current characteristic data from multiple sources, wherein the lightning current characteristic data from multiple sources at least includes first lightning current characteristic data recorded by a lightning location system, second lightning current characteristic data obtained by high tower measurement, third lightning current characteristic data obtained by an artificial lightning induction test, and fourth lightning current characteristic data obtained by inversion of lightning parameters of a transmission line;

[0089] A first building module 32 is used to create a lightning current characteristic data table according to the second lightning current characteristic data, the third lightning current characteristic data and the fourth lightning current characteristic data;

[0090] A second construction module 33 is used to construct a lightning location system data table according to the first lightning current characteristic data;

[0091] The data fusion module 34 is used to fuse the lightning current characteristic data table with the lightning location system data table to obtain a multiple lightning current characteristic database.

[0092] The above technical scheme combines the statistical method of lightning location system, high tower measurement method, artificial lightning induction measurement method and transmission line lightning parameter inversion method to obtain more multi-source lightning current characteristic parameters, and establishes a database of multiple lightning current characteristic parameters with multi-source data fusion, which can provide more sufficient and reliable data source basis for the calculation and analysis of multiple lightning fault analysis and insulation design of power grid protection.

[0093] Optionally, the first building module 32 is specifically configured to:

[0094] Construct the structure of the parent table of lightning characteristic data. The row indexes of the parent table of lightning characteristic data are time, longitude, latitude, amplitude, wavefront time, wavetail time and sequence number. The sequence number is empty.

[0095] According to the lightning characteristic data parent table, a structure of a lightning characteristic data sub-table corresponding to the lightning characteristic data parent table is constructed, and the lightning characteristic data sub-table is used to store lightning waveform data in each lightning current characteristic data;

[0096] A lightning current characteristic data table is created according to the second lightning current characteristic data, the third lightning current characteristic data and the fourth lightning current characteristic data in combination with the structure of the lightning characteristic data parent table and the structure of the lightning characteristic data child table.

[0097] Optionally, the second building module 33 includes:

[0098] A data table construction unit is used to construct a lightning location system data table according to the first lightning current characteristic data, wherein the row indexes of the lightning location system data table are time, longitude, latitude, amplitude, return stroke, and number of location stations;

[0099] A preprocessing unit, used for preprocessing the first lightning characteristic data in the lightning location system data table to obtain a preprocessed lightning location system data table;

[0100] The statistical processing unit is used to perform statistical processing on the pre-processed lightning location system data table to obtain a processed lightning location system data table.

[0101] Optionally, the preprocessing unit is specifically configured to:

[0102] Re-sorting all first lightning characteristic data by time, calculating the sorted time interval, and adding the time interval as a new row to the lightning location system data table;

[0103] The first lightning characteristic data is grouped according to the return stroke sequence, and the frequency of multiple lightning strikes and the subsequent return stroke sequence are added as new rows to the lightning location system data table;

[0104] According to the time corresponding to each piece of data, a unique serial number is generated for each piece of data and added as a new row to the lightning location system data table.

[0105] Optionally, the statistical processing unit is specifically configured to:

[0106] A statistical analysis is performed on the first lightning current characteristic data in the preprocessed lightning location system data table to obtain statistical results of all lightning current characteristic data for each year and / or all previous years to form a lightning location system data table. The statistical analysis includes at least the proportion of multiple lightnings, the frequency distribution of multiple lightnings, the time interval distribution, the duration, and the amplitude distribution.

[0107] Optionally, the data fusion module 34 is specifically used for:

[0108] According to the time and longitude corresponding to each data in the lightning current characteristic data table, query the data in the lightning location system data table, obtain the corresponding serial number and enter it into the lightning current characteristic data table;

[0109] The lightning current characteristic data table is connected with the lightning location system data table to obtain a multiple lightning current characteristic database.

[0110] The lightning database establishment device provided in the embodiment of the present invention can execute the lightning database establishment method provided in any embodiment of the present invention, and has the corresponding functional modules and beneficial effects of the execution method.

[0111] Embodiment 4

[0112] Figure 4 A schematic diagram of the structure of an electronic device provided for Embodiment 4 of the present invention. 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 components shown herein, their connections and relationships, and their functions are merely examples and are not intended to limit the implementation of the present invention described and / or claimed herein.

[0113] like Figure 4 As shown, the electronic device 40 includes at least one processor 41, and a memory connected to the at least one processor 41, such as a read-only memory (ROM) 42, a random access memory (RAM) 43, etc., wherein the memory stores a computer program that can be executed by at least one processor, and the processor 41 can perform various appropriate actions and processes according to the computer program stored in the read-only memory (ROM) 42 or the computer program loaded from the storage unit 48 to the random access memory (RAM) 43. In the RAM 43, various programs and data required for the operation of the electronic device 40 can also be stored. The processor 41, the ROM 42, and the RAM 43 are connected to each other through a bus 44. An input / output (I / O) interface 45 is also connected to the bus 44.

[0114] A number of components in the electronic device 40 are connected to the I / O interface 45, including: an input unit 46, such as a keyboard, a mouse, etc.; an output unit 47, such as various types of displays, speakers, etc.; a storage unit 48, such as a disk, an optical disk, etc.; and a communication unit 49, such as a network card, a modem, a wireless communication transceiver, etc. The communication unit 49 allows the electronic device 40 to exchange information / data with other devices through a computer network such as the Internet and / or various telecommunication networks.

[0115] The processor 41 may be a variety of general and / or special processing components with processing and computing capabilities. Some examples of the processor 41 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various special artificial intelligence (AI) computing chips, various processors running machine learning model algorithms, a digital signal processor (DSP), and any appropriate processor, controller, microcontroller, etc. The processor 41 executes the various methods and processes described above, such as a lightning database establishment method.

[0116] In some embodiments, the lightning database establishment method can be implemented as a computer program, which is tangibly contained in a computer-readable storage medium, such as a storage unit 48. In some embodiments, part or all of the computer program can be loaded and / or installed on the electronic device 40 via the ROM 42 and / or the communication unit 49. When the computer program is loaded into the RAM 43 and executed by the processor 41, one or more steps of the lightning database establishment method described above can be performed. Alternatively, in other embodiments, the processor 41 can be configured to execute the lightning database establishment method in any other appropriate manner (for example, by means of firmware).

[0117] Various implementations of the systems and techniques described above herein can be implemented in digital electronic circuit systems, integrated circuit systems, field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chips (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various implementations can include: being implemented in one or more computer programs that can be executed and / or interpreted on a programmable system including at least one programmable processor, which can be a special purpose or general purpose programmable processor that can receive data and instructions from a storage system, at least one input device, and at least one output device, and transmit data and instructions to the storage system, the at least one input device, and the at least one output device.

[0118] Computer programs for implementing the methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general-purpose computer, a special-purpose computer, or other programmable data processing device, so that when the computer program is executed by the processor, the functions / operations specified in the flow chart and / or block diagram are implemented. The computer program may be executed entirely on the machine, partially on the machine, partially on the machine and partially on a remote machine as a stand-alone software package, or entirely on a remote machine or server.

[0119] In the context of the present invention, a computer-readable storage medium may be a tangible medium that may contain or store a computer program for use by or in combination with an instruction execution system, device or equipment. A computer-readable storage medium may include, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, devices or equipment, or any suitable combination of the foregoing. Alternatively, a computer-readable storage medium may be a machine-readable signal medium. A more specific example of a machine-readable storage medium may include an electrical connection based on one or more lines, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0120] To provide interaction with a user, the systems and techniques described herein may be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user; and a keyboard and a pointing device (e.g., a mouse or trackball) through which the user can provide input to the electronic device. Other types of devices may also be used to provide interaction with the user; for example, the feedback provided to the user may be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form (including acoustic input, voice input, or tactile input).

[0121] The systems and techniques described herein may be implemented in a computing system that includes backend components (e.g., as a data server), or a computing system that includes middleware components (e.g., an application server), or a computing system that includes frontend components (e.g., a user computer with a graphical user interface or a web browser through which a user can interact with implementations of the systems and techniques described herein), or a computing system that includes any combination of such backend components, middleware components, or frontend components. The components of the system may be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: a local area network (LAN), a wide area network (WAN), a blockchain network, and the Internet.

[0122] A computing system may include a client and a server. The client and the server are generally remote from each other and usually interact through a communication network. The client and server relationship is generated by computer programs running on the corresponding computers and having a client-server relationship with each other. The server may be a cloud server, also known as a cloud computing server or cloud host, which is a host product in the cloud computing service system to solve the defects of difficult management and weak business scalability in traditional physical hosts and VPS services.

[0123] An embodiment of the present invention further provides a computer program product, including a computer program, which, when executed by a processor, implements the lightning database establishment method provided in any embodiment of the present invention.

[0124] In the process of implementation, the computer program product can be written in one or more programming languages ​​or a combination thereof to perform the computer program code for the operation of the present disclosure, including but not limited to object-oriented programming languages ​​such as Java, Smalltalk, C++, and conventional procedural programming languages ​​such as "C" language or similar programming languages. The program code can be executed entirely on the user's computer, partially on the user's computer, as a separate software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In the case of a remote computer, the remote computer can be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or can be connected to an external computer (for example, using an Internet service provider to connect through the Internet).

[0125] It should be understood that the various forms of processes shown above can be used to reorder, add or delete steps. For example, the steps described in the present invention can be executed in parallel, sequentially or in different orders, as long as the desired results of the technical solution of the present invention can be achieved, and this document does not limit this.

[0126] The above specific implementations do not constitute a limitation on the protection scope of the present invention. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions can be made according to design requirements and other factors. Any modification, equivalent substitution and improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims

1. A method for establishing a lightning database, characterized in that: include: Acquire lightning current characteristic data from multiple sources, wherein the lightning current characteristic data from multiple sources at least includes first lightning current characteristic data recorded by a lightning location system, second lightning current characteristic data obtained by high tower measurement, third lightning current characteristic data obtained by an artificial lightning induction test, and fourth lightning current characteristic data obtained by inversion of lightning parameters of a transmission line; Creating a lightning current characteristic data table according to the second lightning current characteristic data, the third lightning current characteristic data and the fourth lightning current characteristic data; Constructing a lightning location system data table according to the first lightning current characteristic data; The lightning current characteristic data table and the lightning location system data table are merged to obtain a multiple lightning current characteristic database.

2. The method according to claim 1, characterized in that The step of creating a lightning current characteristic data table according to the second lightning current characteristic data, the third lightning current characteristic data, and the fourth lightning current characteristic data includes: Constructing the structure of a parent table of lightning characteristic data, wherein the row indexes of the parent table of lightning characteristic data are time, longitude, latitude, amplitude, wavefront time, wavetail time and sequence number, respectively, and the sequence number is empty; According to the lightning characteristic data parent table, constructing a structure of a lightning characteristic data sub-table corresponding to the lightning characteristic data parent table, wherein the lightning characteristic data sub-table is used to store lightning waveform data in each lightning current characteristic data; A lightning current characteristic data table is created according to the second lightning current characteristic data, the third lightning current characteristic data and the fourth lightning current characteristic data in combination with the structure of the lightning characteristic data parent table and the structure of the lightning characteristic data child table.

3. The method according to claim 1, characterized in that The step of constructing a lightning location system data table according to the first lightning current characteristic data comprises: According to the first lightning current characteristic data, a lightning location system data table is constructed, wherein the row indexes of the lightning location system data table are time, longitude, latitude, amplitude, return stroke, and number of location stations; Preprocessing the first lightning characteristic data in the lightning location system data table to obtain a preprocessed lightning location system data table; The preprocessed lightning location system data table is statistically processed to obtain a processed lightning location system data table.

4. The method according to claim 3, characterized in that: The preprocessing of the first lightning characteristic data in the lightning location system data table to obtain the preprocessed lightning location system data table comprises: Re-sorting all first lightning characteristic data by time, calculating the sorted time interval, and adding the time interval as a new row to the lightning location system data table; Grouping the first lightning characteristic data according to the return stroke order, and adding the frequency of multiple lightning strikes and the subsequent return stroke order as new rows to the lightning location system data table; According to the time corresponding to each piece of data, a unique serial number is generated for each piece of data and added as a new row to the lightning locating system data table.

5. The method according to claim 3, characterized in that: The statistical analysis of the pre-processed lightning location system data table is performed to obtain the lightning location system data table, including: A statistical analysis is performed on the first lightning current characteristic data in the preprocessed lightning location system data table to obtain statistical results of all lightning current characteristic data for each year and / or all previous years to form a lightning location system data table, wherein the statistical analysis includes at least the proportion of multiple lightnings, the frequency distribution of multiple lightnings, the time interval distribution, the duration, and the amplitude distribution.

6. The method according to claim 1, characterized in that The step of fusing the lightning current characteristic data table with the lightning location system data table to obtain a multiple lightning current characteristic database includes: According to the time and longitude corresponding to each data in the lightning current characteristic data table, query the data in the lightning location system data table, obtain the corresponding serial number and enter it into the lightning current characteristic data table; The lightning current characteristic data table is connected with the lightning location system data table to obtain a multiple lightning current characteristic database.

7. A lightning database establishment device, characterized in that: include: A data acquisition module is used to acquire lightning current characteristic data from multiple sources, wherein the lightning current characteristic data from multiple sources at least includes first lightning current characteristic data recorded by a lightning location system, second lightning current characteristic data obtained by high tower measurement, third lightning current characteristic data obtained by an artificial lightning induction test, and fourth lightning current characteristic data obtained by inversion of lightning parameters of a transmission line; A first building module, configured to create a lightning current characteristic data table according to the second lightning current characteristic data, the third lightning current characteristic data and the fourth lightning current characteristic data; A second construction module is used to construct a lightning location system data table according to the first lightning current characteristic data; The data fusion module is used to fuse the lightning current characteristic data table with the lightning location system data table to obtain a multiple lightning current characteristic database.

8. An electronic device, characterized in that: include: at least one processor; as well as a memory communicatively connected to the at least one processor; wherein, The memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can execute the lightning database establishment method according to any one of claims 1 to 6.

9. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a processor to implement the lightning database establishment method according to any one of claims 1 to 6 when executed.

10. A computer program product, characterized in that The computer program product comprises a computer program, and when the computer program is executed by a processor, the method for establishing a lightning database according to any one of claims 1 to 6 is implemented.

Images