Fault recording data processing method and device for direct current protection system

Abstract

The invention relates to the technical field of data storage, and provides a fault recording data processing method and device for a direct current protection system, and the method comprises the steps: generating a fault recording file through all control and protection hosts when a fault occurs in a direct current transmission line, and transmitting the fault recording file to a file server; whether a new fault recording file exists in a file server or not is inquired, if yes, the fault recording file is stored in a column database and analyzed, a main index in the column database is used for storing analysis process time data and corresponding data types, and a data column is used for integrating the analysis process data; after the column database stores the fault recording files corresponding to all the control and protection hosts in the converter station where the direct current transmission line is located in a set time period, comprehensively analyzing the analysis results of the fault recording files corresponding to all the control and protection hosts to obtain a comprehensive analysis result; the intelligent degree and the analysis efficiency of fault recording file data analysis are improved.

Description

Technical Field

[0001] This invention relates to the field of data storage technology, and specifically to a method and apparatus for processing fault recording data of a DC protection system. Background Technology

[0002] As an important component of the UHVDC power grid, the UHVDC transmission system has advantages such as long transmission distance, large transmission power, fast start-up and regulation speed, strong controllability, flexible active power regulation capability, and the ability to quickly improve the operating characteristics of AC systems. It can transmit clean energy efficiently, over a wide area, and with low loss, and is an important technical form for long-distance, large-capacity power transmission.

[0003] Ultra-high voltage (UHVDC) converter stations are core facilities in UHVDC transmission systems, enabling inter-regional grid interconnection and long-distance transmission of clean energy. Their safety and reliability directly affect the stable operation of the power grid. In existing technologies, UHVDC converter stations primarily maintain stable operation by monitoring grid data in real time through a DC control and protection system. When a fault occurs at a point in the grid, the control and protection host at the converter station where the DC transmission line is located generates a corresponding fault waveform file and transmits it to a file server. In a single fault, multiple control and protection hosts typically generate corresponding fault waveform files. Furthermore, the timing of each host sending the fault waveform file to the server is not entirely synchronized. Therefore, in existing technologies, technicians need to open each fault waveform file individually and parse it, which is time-consuming, inefficient, and the analysis results lack reusability. If a different technician needs to perform the analysis, the file parsing process must be repeated, resulting in wasted human resources and low analysis efficiency. Summary of the Invention

[0004] The purpose of this invention is to provide a method and apparatus for processing fault recording data of a DC protection system, so as to solve the problem that existing DC protection system data requires technicians to analyze and process it sequentially, resulting in low analysis efficiency.

[0005] To solve the above-mentioned technical problems, this invention provides a method for processing fault recording data in a DC protection system, the method comprising: When a fault occurs in a DC transmission line, each control and protection host generates a fault recording file and sends it to the file server; The system queries the file server to see if a new fault recording file exists. If it does, the fault recording file is stored in a columnar database and analyzed. The main index in the columnar database is used to store the process time data and corresponding data types of the fault recording file. The data columns are used to integrate the process data of the fault recording file. After the columnar database stores the fault waveform files corresponding to all control and protection hosts in the converter station where the DC transmission line is located within a set time period, a comprehensive analysis is performed on the analysis results of the fault waveform files corresponding to all control and protection hosts.

[0006] Furthermore, during the comprehensive analysis, the analog and digital quantities in the fault recording files corresponding to each control and protection host are analyzed to determine the fault category of each control and protection host's fault recording file, and the fault category, analysis process, and intermediate calculation results are stored in the columnar database.

[0007] Furthermore, the data column includes a column family and a column identifier. The column family is used to store the device number of the control and protection host to which the fault recording file belongs. The column identifier is used to store the data and analysis results in the fault recording file corresponding to the control and protection host. The data in the fault recording file is stored according to its data type.

[0008] Furthermore, the data types in the fault recording file include real-time values ​​of analog quantities, real-time values ​​of digital quantities, characteristic value determination results, and real-time values ​​corresponding to the characteristic values.

[0009] Furthermore, the data columns are stored according to a JSON structure.

[0010] A fault recording data processing device for a DC protection system includes a file server for communicating with each control and protection host and for acquiring fault recording files sent by the control and protection host; it also includes a columnar database for receiving newly received fault recording files from the file server and analyzing the fault recording files; the main index of the columnar database is used to store the process time data and corresponding data type of the fault recording files being analyzed, and the data columns are used to integrate the process data of the fault recording files being analyzed. After the columnar database stores the fault waveform files corresponding to all control and protection hosts in the converter station where the DC transmission line is located within a set time period, a comprehensive analysis is performed on the analysis results of the fault waveform files corresponding to all control and protection hosts.

[0011] Furthermore, during the comprehensive analysis, the analog and digital quantities in the fault recording files corresponding to each control and protection host are analyzed to determine the fault category of each control and protection host's fault recording file, and the fault category, analysis process, and intermediate calculation results are stored in the columnar database.

[0012] Furthermore, the data column includes a column family and a column identifier. The column family is used to store the device number of the control and protection host to which the fault recording file belongs. The column identifier is used to store the data and analysis results in the fault recording file corresponding to the control and protection host. The data in the fault recording file is stored according to its data type.

[0013] Furthermore, the data types in the fault recording file include real-time values ​​of analog quantities, real-time values ​​of digital quantities, characteristic value determination results, and real-time values ​​corresponding to the characteristic values.

[0014] Furthermore, the data columns are stored according to a JSON structure.

[0015] The beneficial effects of this invention are as follows: As an improved invention, this invention utilizes a columnar database to store newly received fault waveform files in a file server and analyzes the data in these files. In practical operation, while analyzing the data in each fault waveform file in the columnar database, newly received files can be stored simultaneously. After the columnar database stores the fault waveform files corresponding to all control and protection hosts in the converter station where the DC transmission line is located within a set time period, the analysis results of the fault waveform files corresponding to all control and protection hosts can be comprehensively analyzed to obtain a comprehensive analysis result. The columnar database used in this invention not only stores the fault waveform files themselves but also records the analysis process of the fault waveform files (including the key intermediate files obtained from the analysis). Thus, when it is necessary to trace the source of the waveform files, technicians no longer need to analyze each fault waveform file separately; they only need to trace the source based on the analysis process of the waveform files recorded in the columnar database, thereby improving the intelligence and efficiency of fault waveform file data analysis. Attached Figure Description

[0016] Figure 1 This is a diagram of the database structure. Detailed Implementation

[0017] The specific embodiments of the present invention will be further described below with reference to the accompanying drawings.

[0018] This invention utilizes a columnar database to store fault waveform files received from a file server according to the columnar database format, and analyzes the data in the fault waveform files within the columnar database, enabling parallel operations for fault waveform file collection and analysis.

[0019] Implementation Method of Fault Recording Data Processing for DC Protection Systems To improve the efficiency of DC protection system data analysis, this invention proposes a method for processing fault waveform data of DC protection system. This method parses, stores, and analyzes fault waveform files received in a file server, thereby achieving efficient storage and analysis of fault waveform files.

[0020] When a fault occurs in a DC transmission line, each control and protection host sends its recorded fault waveform file to a file server. Newly received fault waveform files on the file server are then transferred to a columnar database for analysis. During comprehensive analysis, the analog and digital quantities in the fault waveform files corresponding to each control and protection host are analyzed to determine the fault category. The fault category, analysis process, and intermediate calculation results are then stored in the columnar database.

[0021] The columnar database mainly consists of a primary index (Rowksy) and data columns. The primary index is mainly used to store time data and corresponding data types during the analysis process, facilitating technical personnel to query and retrieve the corresponding data. In this implementation, the primary index mainly contains data types and time data (i.e., timestamps). The data type refers to the type of the air defense host, which includes protection type and control type. The time data refers to the time when the fault occurred corresponding to the fault recording file.

[0022] As one example, the primary index is: RowKsy:“BAOHU1:2025-02-25 19:48:00.000”, where “BAOHU1” indicates that the primary index's data type is protected, and “2025-02-25 19:48:00.000” is the timestamp in this primary index. The data column is encapsulated in a JSON structure, primarily used to integrate and analyze process data. This data column includes column families and corresponding column identifiers. The column families mainly store the device number for each protection host. The column identifier is set according to the data types recorded in the protection host during actual use.

[0023] like Figure 1 As shown in the example, the data column format in the JSON structure is as follows: { "Control and Protection Host A": { "analog1": 12.33, "analog2": 15.67, … "status1": 0, "status2": 1, … "tezheng1RES":1, "tezheng1Value":15, "tezheng2RES":0, "tezheng2Value":15, "result": "analysis result A" }, "Control and Protection Host B": { "analog1": 12.33, "analog2": 15.67, … "status1": 0, "status2": 1, … "tezheng1RES":1, "tezheng1Value":15, "tezheng2RES":0, "tezheng2Value":15, "result": "analysis result B" }, "Control and Protection Host C": { "analog1": 12.33, "analog2": 15.67, … "status1": 0, "status2": 1, … "tezheng1RES":1, "tezheng2RES":0, ... "tezheng1Value":15.00, "tezheng2Value":15.00, … "result": "analysis result C" }, … "Result": "Comprehensive Analysis Results" } Among them, "Control and Protection Host A, Control and Protection Host B, and Control and Protection Host C" are column families. The column identifiers under each column family include "analog1, analog2, status1, status2, tezheng1RES, tezheng1Value, tezheng2RES, tezheng2Value, and result". Here, analog1 and analog2 represent the real-time values ​​of analog quantities at this moment; status1 and status2 represent the real-time values ​​of switch quantities; tezheng1RES and tezheng2RES represent the judgment results of characteristic value 1 and characteristic value 2; tezheng1Value and tezheng2Value represent the real-time values ​​of characteristic value 1 and characteristic value 2; and result represents the analysis result corresponding to the control and protection host.

[0024] After storing the fault waveform files corresponding to all control and protection hosts in the converter station where the DC transmission line is located in the columnar database within a set time period (e.g., 2 seconds), the analysis results of the fault waveform files corresponding to all control and protection hosts are comprehensively analyzed, and the comprehensive analysis results are combined and packaged with the identifier "Result". As one embodiment, this invention determines whether the fault waveform files uploaded by each control and protection host belong to the same fault based on the switch quantity in the analysis results corresponding to each control and protection host. If it is found that the fault waveform files are not data under the same fault, it needs to be marked in the comprehensive analysis results.

[0025] This columnar database stores data columns containing column families, column identifiers, and comprehensive analysis results, along with their corresponding master indexes. This allows technicians to readily access data from fault recording files generated by all control and protection hosts at the converter station during each power grid fault, providing data support for protection, control, or inversion operations. For example, when it is necessary to trace fault data, the fault can be inverted based on the fault recording files stored in the columnar database, the analysis process, and the analysis results.

[0026] Implementation Method of Fault Recording Data Processing Device for DC Protection System This invention proposes a fault waveform data processing device for a DC protection system. The system includes a file server, which is used to communicate with each control and protection host to obtain fault waveform files sent by the control and protection host. It also includes a columnar database, which is used to receive newly received fault waveform files from the file server and analyze the fault waveform files. The main index in the columnar database is used to store the analysis process time data and the corresponding data type, and the data columns are used to integrate the analysis process data. After the columnar database stores the fault waveform files corresponding to all control and protection hosts in the converter station where the DC transmission line is located within a set time period, the analysis results of the fault waveform files corresponding to all control and protection hosts are comprehensively analyzed to obtain the comprehensive analysis results.

[0027] Specifically, when a fault occurs in a DC transmission line, each control and protection host will send its recorded fault waveform file to the file server. The newly received fault waveform file in the file server will be transferred to the columnar database and analyzed in the columnar database.

[0028] The columnar database mainly consists of a primary index (Rowksy) and data columns. The primary index is mainly used to store time data and corresponding data types during the analysis process, facilitating technical personnel to query and retrieve the corresponding data. In this implementation, the primary index mainly contains data types and time data (i.e., timestamps). The data type refers to the type of the air defense host, which includes protection type and control type. The time data refers to the time when the fault occurred corresponding to the fault recording file.

[0029] As one example, the primary index is: RowKsy:“BAOHU1:2025-02-25 19:48:00.000”, where “BAOHU1” indicates that the primary index's data type is protected, and “2025-02-25 19:48:00.000” is the timestamp in this primary index. The data column is encapsulated in a JSON structure, primarily used to integrate and analyze process data. This data column includes column families and corresponding column identifiers. The column families mainly store the device number for each protection host. The column identifier is set according to the data types recorded in the protection host during actual use.

[0030] After storing the fault waveform files corresponding to all control and protection hosts in the converter station where the DC transmission line is located in the columnar database within a set time period (e.g., 2 seconds), the analysis results of the fault waveform files corresponding to all control and protection hosts are comprehensively analyzed, and the comprehensive analysis results are combined and packaged with the identifier "Result". As one embodiment, this invention determines whether the fault waveform files uploaded by each control and protection host belong to the same fault based on the switch quantity in the analysis results corresponding to each control and protection host. If it is found that the fault waveform files are not data under the same fault, it needs to be marked in the comprehensive analysis results.

[0031] By storing such data columns containing column families, column identifiers, and comprehensive analysis results, along with their corresponding master indexes, in a columnar database, technicians can easily access data from fault recording files issued by all control and protection hosts of the converter station during each power grid fault, providing data support for technicians' protection, control, or inversion operations.

Claims

1. A method for processing fault recording data in a DC protection system, characterized in that, The method includes: When a fault occurs in a DC transmission line, each control and protection host generates a fault recording file and sends it to the file server; The system queries the file server to see if a new fault recording file exists. If it does, the fault recording file is stored in a columnar database and analyzed. The main index in the columnar database is used to store the process time data and corresponding data types of the fault recording file. The data columns are used to integrate the process data of the fault recording file. After the columnar database stores the fault waveform files corresponding to all control and protection hosts in the converter station where the DC transmission line is located within a set time period, a comprehensive analysis is performed on the analysis results of the fault waveform files corresponding to all control and protection hosts.

2. The method for processing fault recording data of a DC protection system according to claim 1, characterized in that, During the comprehensive analysis, the analog and digital quantities in the fault recording files corresponding to each control and protection host are analyzed to determine the fault category of each control and protection host's fault recording file, and the fault category, analysis process, and intermediate calculation results are stored in the columnar database.

3. The method for processing fault recording data of a DC protection system according to claim 1, characterized in that, The data column includes column families and column identifiers. The column families are used to store the device number of the control and protection host to which the fault recording file belongs. The column identifiers are used to store the data and analysis results in the fault recording file corresponding to the control and protection host. The data in the fault recording file is stored according to its data type.

4. The method for processing fault recording data of a DC protection system according to claim 3, characterized in that, The data types in the fault recording file include real-time values ​​of analog quantities, real-time values ​​of digital quantities, characteristic value determination results, and real-time values ​​corresponding to characteristic values.

5. The method for processing fault recording data in a DC protection system according to claim 1, characterized in that, The data columns are stored according to a JSON structure.

6. A fault recording data processing device for a DC protection system, comprising a file server, wherein the file server is used for communication connection with each control and protection host, and for acquiring fault recording files sent by the control and protection host, characterized in that, It also includes a columnar database, which is used to receive newly received fault recording files from the file server and analyze the fault recording files. The main index in the columnar database is used to store the process time data and corresponding data types of the fault recording files, and the data columns are used to integrate the process data of the fault recording files. After the columnar database stores the fault waveform files corresponding to all control and protection hosts in the converter station where the DC transmission line is located within a set time period, a comprehensive analysis is performed on the analysis results of the fault waveform files corresponding to all control and protection hosts.

7. The fault recording data processing device for a DC protection system according to claim 6, characterized in that, During the comprehensive analysis, the analog and digital quantities in the fault recording files corresponding to each control and protection host are analyzed to determine the fault category of each control and protection host's fault recording file, and the fault category, analysis process, and intermediate calculation results are stored in the columnar database.

8. The DC protection system fault recording data processing device according to claim 6, characterized in that, The data column includes column families and column identifiers. The column families are used to store the device number of the control and protection host to which the fault recording file belongs. The column identifiers are used to store the data and analysis results in the fault recording file corresponding to the control and protection host. The data in the fault recording file is stored according to its data type.

9. The fault recording data processing device for a DC protection system according to claim 8, characterized in that, The data types in the fault recording file include real-time values ​​of analog quantities, real-time values ​​of digital quantities, characteristic value determination results, and real-time values ​​corresponding to characteristic values.

10. The DC protection system fault recording data processing device according to claim 6, characterized in that, The data columns are stored according to a JSON structure.

Images