Broadband measurement data processing method and device, equipment and storage medium

Abstract

The invention provides a broadband measurement data processing method and device, equipment and a storage medium, and relates to the technical field of power systems, the method comprises the steps that broadband measurement data of a power system, such as power frequency, harmonic wave and inter-harmonic wave measurement, are acquired, and different types of broadband measurement data correspond to different standardized data structures; determining a spectrum analysis result and a clustering analysis result based on the broadband measurement data; a target query data interface is called to perform data query in a target table of a target database, the target table of the target database comprises broadband measurement data, a spectrum analysis result and a clustering analysis result, and a table structure corresponding to the target table is predetermined based on different types of broadband measurement data by adopting a standard SQL grammar. The target database is a file database and is a database with a self-description table structure; the target query data interface is determined based on different types of broadband measurement data. According to the invention, the flexibility of broadband measurement data application and data exchange is improved.

Description

Technical Field

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

[0002] With the massive access of new energy sources (such as wind power, photovoltaics, etc.) in modern power systems, more high-order harmonics and interharmonics have appeared in the power grid, which have an adverse effect on the stability and power quality of the system.

[0003] The existing broadband measurement data management system mainly uses traditional relational databases (such as MySQL or PostgreSQL) for storage. However, due to the fixed table structure of relational databases and the lack of self-description function, it is impossible to intuitively express the specific content and structure of the data. Especially in multi-business scenarios, the traditional table structure design is difficult to meet the needs of rapid exchange and reuse of data between different business systems in the power system, resulting in inconvenient application and difficulty in data exchange. Summary of the invention

[0004] In view of the technical problems in the prior art, the present invention provides a method, device, equipment and storage medium for processing broadband measurement data, so as to solve the defects of broadband measurement data in the prior art, such as inconvenient application and difficult data exchange, and improve the flexibility of broadband measurement data application and data exchange.

[0005] In a first aspect, the present invention provides a method for processing broadband measurement data, the method comprising the following steps: Acquire broadband measurement data of the power system; the broadband measurement data includes at least one of the following types: power frequency measurement, harmonic measurement and interharmonic measurement, and different types of broadband measurement data correspond to different standardized data structures; Determining spectrum analysis results and cluster analysis results based on the broadband measurement data; A general target query data interface is called to perform data query in a target table of a target database; the target table of the target database includes the broadband measurement data, the spectrum analysis results and the cluster analysis results; the table structure corresponding to the target table of the target database is predetermined based on different types of broadband measurement data using standard SQL syntax; the target database is a file database, and the file database is a database with a self-describing table structure; the target query data interface is predetermined based on different types of broadband measurement data.

[0006] According to a method for processing broadband measurement data provided by the present invention, before calling a universal target query data interface and performing data query in a target table of a target database, the method further includes: Calling a general target insertion data interface to write the broadband measurement data, the spectrum analysis result and the cluster analysis result into a target table of a target database; The target insertion data interface is predetermined based on different types of broadband measurement data.

[0007] According to a method for processing broadband measurement data provided by the present invention, any type of broadband measurement data is a broadband measurement and analysis extended structure WMAX structure, the main structure of the WMAX structure includes a device name field, a start time field, an end time field and a structure of the broadband measurement data of the type; the target table includes a plant table, an equipment table, a line table, a raw data measurement table, a broadband oscillation analysis record table, and a broadband oscillation statistics record table; the target insertion data interface includes a first insertion data interface, a second insertion data interface and a third insertion data interface.

[0008] According to a method for processing broadband measurement data provided by the present invention, the calling of a universal target insertion data interface to write the broadband measurement data, the spectrum analysis result and the cluster analysis result into a target table of a target database comprises: Calling the first data insertion interface to write the broadband measurement data into the corresponding raw data measurement table in the target database and the plant station table, equipment table and line table corresponding to the broadband measurement data; calling the second data insertion interface to write the spectrum analysis result into the broadband oscillation analysis record table in the target database; The third data insertion interface is called to write the cluster analysis result into the broadband oscillation statistical record table in the target database.

[0009] According to a method for processing broadband measurement data provided by the present invention, the target query data interface includes a first query data interface, a second query data interface and a third query data interface; calling the universal target query data interface to perform data query in a target table of the target database includes: Calling the first data insertion interface to query the broadband measurement data in the corresponding original measurement data table in the target database; Calling the second data insertion interface to query the spectrum analysis result in the wide-band oscillation analysis record table; The third insertion data interface is called to query the cluster analysis result in the broadband oscillation statistical record table.

[0010] According to a method for processing broadband measurement data provided by the present invention, the method further includes: Visually displaying the broadband measurement data within a preset time period; Perform trend analysis based on the results of the visual display.

[0011] According to a method for processing broadband measurement data provided by the present invention, visually displaying the broadband measurement data within a preset time period includes: Using the first timing curve to display the power frequency measurement data within a preset time period; Using the second timing curve and the first spectrum analysis diagram to display the harmonic measurement data within the preset time period; The interharmonic measurement data within the preset time period is displayed using the third timing curve, the second spectrum analysis diagram and the frequency table waterfall diagram; the time axes of the first timing curve, the second timing curve and the third timing curve are consistent.

[0012] In a second aspect, the present invention further provides a device for processing broadband measurement data, the device comprising the following modules: An acquisition module, used for acquiring broadband measurement data of the power system; the broadband measurement data includes at least one of the following types: power frequency measurement, harmonic measurement and interharmonic measurement, and different types of broadband measurement data correspond to different standardized data structures; An analysis module, used to determine a spectrum analysis result and a cluster analysis result based on the broadband measurement data; A query module is used to call a general target query data interface to perform data query in a target table of a target database; the target table of the target database includes the broadband measurement data, the spectrum analysis results and the cluster analysis results; the table structure corresponding to the target table of the target database is predetermined based on different types of broadband measurement data using standard SQL syntax; the target database is a file database, and the file database is a database with a self-describing table structure; the target query data interface is predetermined based on different types of broadband measurement data.

[0013] In a third aspect, the present invention further provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the computer program, the method for processing broadband measurement data as described above is implemented.

[0014] In a fourth aspect, the present invention further provides a non-transitory computer-readable storage medium having a computer program stored thereon, wherein when the computer program is executed by a processor, the method for processing broadband measurement data as described in any one of the above is implemented.

[0015] In a fifth aspect, the present invention further provides a computer program product, comprising a computer program, wherein when the computer program is executed by a processor, the method for processing broadband measurement data as described above is implemented.

[0016] The broadband measurement data processing method, device, equipment and storage medium provided by the present invention obtain broadband measurement data of the power system; the type of broadband measurement data includes at least one of the following: power frequency measurement, harmonic measurement and interharmonic measurement, and different types of broadband measurement data correspond to different standardized data structures; then, based on the broadband measurement data, the spectrum analysis results and the cluster analysis results are determined; further, a general target query data interface is called to perform data query in a target table of a target database, the target table of the target database includes broadband measurement data, spectrum analysis results and cluster analysis results, the table structure corresponding to the target table of the target database is predetermined based on different types of broadband measurement data using standard SQL syntax, the target database is a file database, and the file database is a database with a self-describing table structure; the target query data interface is predetermined based on different types of broadband measurement data.

[0017] The types of broadband measurement data in the present invention include at least one of the following: power frequency measurement, harmonic measurement and interharmonic measurement. Different types of broadband measurement data correspond to different standardized data structures, that is, a unified data structure is designed. In addition, the target query data interface is predetermined based on different types of broadband measurement data. The present invention performs data query in the target table of the target database by calling a universal target query data interface. The present invention adopts standard SQL syntax to predetermine the table structure corresponding to the target table of the target database based on different types of broadband measurement data. The target database is a file database, which is a database with a self-describing table structure. The target database is independent and can be easily transferred and used between different operating systems and business systems, which simplifies the data exchange process and improves the flexibility of broadband measurement data application and data exchange. BRIEF DESCRIPTION OF THE DRAWINGS

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

[0019] Figure 1 This is one of the flow charts of the method for processing broadband measurement data provided by the present invention.

[0020] Figure 2 It is a data structure schematic diagram of the broadband measurement data provided by the present invention.

[0021] Figure 3 It is a schematic diagram of the effect of the multi-band joint display of broadband measurement data provided by the present invention.

[0022] Figure 4 It is a structural schematic diagram of a device for processing broadband measurement data provided by the present invention.

[0023] Figure 5 It is a structural schematic diagram of the electronic device provided by the present invention. DETAILED DESCRIPTION

[0024] In order to make the purpose, technical solution and advantages of the present invention clearer, the technical solution of the present invention will be clearly and completely described below in conjunction with the drawings of the present invention. Obviously, the described embodiments are 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.

[0025] The term "first", "second" etc. in the specification and claims of the present application is used to distinguish similar objects, and is not used to describe a specific order or sequential order. It should be understood that the terms used in this way can be interchangeable under appropriate circumstances, so that the embodiments of the present application can be implemented in an order other than those illustrated or described here, and the objects distinguished by "first" and "second" are generally a class, and the number of objects is not limited, such as the first node can be one or more. In addition, "and / or" in the specification and claims represents at least one of the connected objects, and the character " / " generally represents that the front and back associated objects are a kind of "or" relationship. For example, the process, method, system, product or equipment comprising a series of steps or units need not be limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or equipment.

[0026] In order to more clearly understand the various embodiments provided by the present invention, the technical content involved in the present invention is first introduced as follows.

[0027] Existing broadband measurement data storage and management methods mainly use relational databases, time series databases, and file storage, but they still have the following major defects in power system applications: 1. Strong platform dependence and complex integration Relational databases rely on fixed table structure designs and usually need to be deployed on specific database management platforms. This platform dependency limits the convenient exchange of data between different business systems. When sharing data across platforms or in a multi-system environment, it is often necessary to develop additional interfaces and perform data format conversion, which increases the complexity of system integration.

[0028] Although time series databases are optimized for time series data, they usually need to run on specific platforms or frameworks and cannot be independent of database management systems. This platform limitation also leads to obstacles in exchanging data between different business systems.

[0029] 2. Data exchange is inflexible and lacks self-descriptiveness The table structure of relational databases is fixed and lacks self-description function, which makes it impossible to intuitively express the specific content and structure of data, especially in multi-business scenarios. The traditional table structure design is difficult to meet the needs of fast exchange and reuse of data between different business systems in the power system.

[0030] Although time series databases have good performance in storing time series data, their data models are usually simplified and lack flexible metadata support, making them unsuitable for storing and transmitting data containing complex spectrum information. This will limit the sharing and application of data among multiple systems and increase the complexity of data analysis.

[0031] 3. Lack of efficient structured query and analysis support File storage methods (such as CSV and JSON formats) can perform simple data transmission between different systems, but they can only save raw data and cannot support complex structured query and analysis operations. In practical applications, a large amount of raw data needs to be reloaded and parsed each time analysis is performed, resulting in low computing efficiency and difficulty in meeting the real-time and high-efficiency requirements of the power system.

[0032] Although time series databases have good performance in time series data query, they do not adequately support advanced query requirements such as complex spectrum analysis and feature extraction, and cannot directly store analysis results. Users need to process the analyzed data themselves, which increases the burden on the system.

[0033] 4. Single visual display method In terms of data display, the existing system lacks a comprehensive display method for power frequency, interharmonics and harmonics data, and cannot intuitively reflect the dynamic changes of multi-band data. Especially in applications such as power quality monitoring and oscillation analysis, the existing display method cannot provide a complete and clear spectrum change trend chart, which limits the user's visual analysis effect and decision support.

[0034] In view of the shortcomings of existing broadband measurement data storage and management methods, the present invention proposes a structured storage and analysis method for broadband measurement data based on a file database, and designs a unified broadband measurement and analysis extension structure (Wide Measurement and Analysis eXtension, WMAX) data structure to solve the above problems.

[0035] 1. Eliminate platform dependence and realize cross-system data sharing A file database is used to store broadband measurement data. The file database is independent and can be easily transferred and used between different operating systems and business systems. It avoids the operating platform limitations of traditional relational databases and time series databases and simplifies the system integration and data exchange process.

[0036] 2. Improve the flexibility and portability of data exchange The present invention adopts a self-describing table structure of a file database, and the table structure definition and data are stored in the same file, which has self-explanatory capabilities. Different business systems can directly read and parse the file database without additional data conversion steps, thus realizing rapid exchange and reuse of data between multiple systems.

[0037] 3. Support efficient structured query and analysis A unified WMAX data structure is designed to store raw data and analysis results in a structured manner. The file database supports standard SQL queries, and can directly perform complex structured queries and spectrum analysis operations without reloading the raw data, significantly improving the query efficiency and analysis performance of the system.

[0038] 4. Provide comprehensive display and visual analysis of multiple frequency bands The present invention proposes a multi-band joint display method, which can comprehensively visualize the power frequency, interharmonic and harmonic data. It uses a variety of display methods such as time series curves, scatter plots, and heat maps to intuitively display the dynamic changes of data and improve the user's visualization analysis effect and decision support capabilities.

[0039] Through the above technical scheme, the present invention solves the deficiencies in existing broadband measurement data storage and management, realizes the high efficiency, flexibility and portability of data storage and analysis, and is suitable for various application scenarios such as power quality monitoring, harmonic analysis, and oscillation mode recognition.

[0040] Combine the following Figure 1-Figure 5 The invention describes a method, device, apparatus and storage medium for processing broadband measurement data.

[0041] Figure 1 FIG. 1 is a flow chart of a method for processing broadband measurement data provided by the present invention. Figure 1 As shown, the method includes the following: Step 101, obtaining broadband measurement data of the power system; the type of broadband measurement data includes at least one of the following: power frequency measurement, harmonic measurement and interharmonic measurement, and different types of broadband measurement data correspond to different standardized data structures; Specifically, it should be noted that the execution subject of this embodiment is implemented by an electronic device with data processing capabilities. The electronic device can be a server with data processing capabilities, or a terminal device with data processing capabilities. Among them, the server can be an independent server, or it can be a server cluster composed of multiple servers. The terminal device can be any user device with data processing capabilities, including but not limited to: existing, under development or future development of smart phones, tablet computers, laptop personal computers, desktop personal computers, small computers, medium-sized computers, mainframe computers, etc. The present invention is used to achieve the improvement of the flexibility of broadband measurement data application and data exchange.

[0042] The method for processing broadband measurement data provided in this embodiment is implemented by the following steps: First, broadband measurement data of the power system is obtained, for example, by using a broadband measurement device in a non-continuous frequency hopping transmission sequence format to collect broadband measurement data, which is rich spectrum data.

[0043] Among them, broadband measurement data, such as rich spectrum data including power frequency, interharmonics and harmonics. Power frequency usually refers to the fundamental frequency in the power system, usually 50Hz or 60Hz. Inter-harmonics: Interharmonics refers to waveform components with frequencies that are non-integer multiples of the fundamental frequency. Harmonics: Harmonics refer to waveform components with frequencies that are integer multiples of the fundamental frequency. Power frequency is mainly used for transmission and distribution of power systems and is the basic frequency of power systems. Interharmonics may cause voltage fluctuations and audio interference in power systems, affecting the normal operation of equipment. They are usually generated by nonlinear loads such as arc welding, variable frequency speed regulation devices, etc. Harmonic application: Harmonic analysis is used for power quality monitoring to identify and suppress nonlinear distortion in power systems. The generation of harmonics is usually related to nonlinear loads, such as UPS, switching power supplies, etc.

[0044] The present invention proposes a standardized WMAX data structure for uniformly representing various data types output by a broadband measurement device, including power frequency measurement, harmonic measurement, interharmonic measurement, second-level analysis data, and harmonic proportion statistics.

[0045] Step 102: Determine spectrum analysis results and cluster analysis results based on the broadband measurement data; Specifically, after the broadband measurement data is acquired, spectrum analysis is performed on the broadband measurement data to obtain spectrum analysis results, and cluster analysis is performed on the broadband measurement data to obtain cluster analysis results.

[0046] The spectrum analysis process is as follows: For example, the spectrum algorithm is used to analyze the active power, frequency and other data in the power frequency measurement data to obtain the spectrum analysis results.

[0047] The spectrum algorithms include but are not limited to the Porny algorithm, the Fast Fourier Transform (FFT) algorithm and the Empirical Mode Decomposition (EMD).

[0048] Among them, the Prony algorithm is a classic signal processing method, which is mainly used to extract signal parameters such as frequency, amplitude, phase and attenuation factor from a set of measurement data. It is particularly suitable for analyzing signals with multiple exponential decay or sinusoidal wave components.

[0049] The Fast Fourier Transform (FFT) algorithm is an algorithm for efficiently calculating the Discrete Fourier Transform (DFT) and its inverse transform. DFT is an important tool in signal processing, used to convert time domain signals into frequency domain signals. The FFT algorithm makes this process more efficient by reducing the computational complexity.

[0050] Empirical Mode Decomposition (EMD) is an adaptive signal decomposition method for processing nonlinear and non-stationary signals. The core idea is to decompose complex signals into a series of intrinsic mode functions (IMFs) and a residual term. Each IMF represents a vibration mode in the signal, has a single frequency, and can reflect the local characteristics of the signal.

[0051] The basic steps of the EMD algorithm include the following: 1. Find local extreme points: Find all local maximum and minimum points in the signal.

[0052] 2. Construct upper and lower envelopes: Connect the maximum and minimum points by interpolation (usually using cubic spline interpolation) to obtain the upper and lower envelopes respectively.

[0053] 3. Calculate the mean envelope: take the average value of the upper and lower envelopes as the mean envelope.

[0054] 4. Extract detail component: Subtract the mean envelope from the original signal to obtain a detail component.

[0055] 5. Screening process: Repeat the above steps for the detail component until the component meets the IMF conditions.

[0056] 6. Iterative decomposition: Remove the extracted IMF from the original signal and repeat the above steps for the remaining signal until the remaining signal cannot be decomposed any further.

[0057] Specifically, the spectrum analysis is performed with M seconds as the analysis window length and N seconds as the step length, and the oscillation mode results of each analysis window are calculated, including oscillation frequency, amplitude, damping ratio, initial phase, and energy proportion; Each analysis window may calculate multiple oscillation modes. The oscillation modes with an energy share greater than 40% are selected, and the spectrum analysis results are formed according to the device name, analysis window start time, analysis window end time, oscillation frequency, oscillation amplitude, damping ratio, initial phase, energy share and other values, and then written into the target database.

[0058] The cluster analysis process is as follows: For example, the frequency characteristics of the spectrum analysis results are input into clustering algorithms, including the K-means algorithm, the Density-Based Spatial Clustering ofApplications with Noise (DBSCAN) algorithm, etc., to automatically group them according to the similarity of oscillation frequencies to form clusters.

[0059] Among them, K-means algorithm is a classic partitioning clustering algorithm, which is widely used in data mining and machine learning fields to divide the data set into K clusters. The following is a detailed introduction to the K-means algorithm: The goal of the K-means algorithm is to divide the samples in the data set into K clusters so that the samples within each cluster are as similar as possible, while the samples between different clusters are as dissimilar as possible. Specifically, the algorithm achieves this goal by minimizing the mean squared error (SSE) of the samples within the cluster.

[0060] Among them, the DBSCAN algorithm is a classic density clustering algorithm that can identify clusters through dense areas of sample points and can handle noise points.

[0061] The core idea of ​​the DBSCAN algorithm is to define clusters based on density, through two main parameters: Neighborhood radius (eps): defines the neighborhood range of each point. Minimum number of points (minPts): defines the minimum number of points that must be included in the neighborhood to be considered a core point.

[0062] Based on these parameters, DBSCAN classifies the data points into three categories: Core point: A point that contains at least minPts points in its neighborhood.

[0063] Boundary point: a point that is not in the neighborhood of a core point but is connected to the neighborhood of a core point.

[0064] Noise point: a point that is neither a core point nor a boundary point.

[0065] The main advantages of DBSCAN include: no need to pre-specify the number of clusters. Can find clusters of arbitrary shapes. Strongly robust to noise.

[0066] Based on the above algorithm, operation and maintenance personnel can adjust clustering parameters (such as K value or radius threshold) to focus the results on high-energy and broadband oscillation events with similar frequencies, making it easier to define events for oscillation analysis.

[0067] For the obtained clusters, broadband oscillation events are named according to the central frequency and representative equipment, and the energy proportion is further calculated to form a list of involved equipment. Possible risk sources are marked and stored in the database.

[0068] It supports in-depth analysis of clusters with excessively high energy proportions or abnormal oscillation frequencies, including troubleshooting equipment failures, line problems, or external disturbances, and supports the formulation of corresponding scheduling and maintenance strategies.

[0069] Step 103: Call a general target query data interface to query data in a target table of a target database. The target table of the target database includes broadband measurement data, spectrum analysis results, and cluster analysis results. The table structure corresponding to the target table of the target database is predetermined based on different types of broadband measurement data using standard SQL syntax. The target database is a file database, and the file database is a database with a self-describing table structure. The target query data interface is predetermined based on different types of broadband measurement data.

[0070] Specifically, the target query data interface can be pre-designed, and data query is performed in the target table of the target database by calling a universal target query data interface. The target query data interface is pre-determined based on different types of broadband measurement data.

[0071] The table structure corresponding to the target table of the target database is predetermined based on different types of broadband measurement data using standard SQL syntax. The target database is a file database, which is a database with a self-describing table structure. The target database can be compatible with multiple databases to ensure that it can be used in file databases such as SQLite, DuckDB, and H2 Database. The target table of the target database includes the broadband measurement data, the spectrum analysis results, and the cluster analysis results.

[0072] It should be noted that the file database supports standard SQL queries and can directly execute complex structured queries and spectrum analysis operations without reloading the original data, significantly improving the query efficiency and analysis performance of the system.

[0073] The method provided in this embodiment obtains broadband measurement data of the power system; the type of broadband measurement data includes at least one of the following: power frequency measurement, harmonic measurement and interharmonic measurement, and different types of broadband measurement data correspond to different standardized data structures; then, based on the broadband measurement data, the spectrum analysis results and the cluster analysis results are determined; further, a general target query data interface is called to perform data query in a target table of a target database, the target table of the target database includes broadband measurement data, spectrum analysis results and cluster analysis results, the table structure corresponding to the target table of the target database is predetermined based on different types of broadband measurement data using standard SQL syntax, the target database is a file database, and the file database is a database with a self-describing table structure; the target query data interface is predetermined based on different types of broadband measurement data.

[0074] The types of broadband measurement data in the present invention include at least one of the following: power frequency measurement, harmonic measurement and interharmonic measurement. Different types of broadband measurement data correspond to different standardized data structures, that is, a unified data structure is designed. In addition, the target query data interface is predetermined based on different types of broadband measurement data. The present invention performs data query in the target table of the target database by calling a universal target query data interface. The present invention adopts standard SQL syntax to predetermine the table structure corresponding to the target table of the target database based on different types of broadband measurement data. The target database is a file database, which is a database with a self-describing table structure. The target database is independent and can be easily transferred and used between different operating systems and business systems, which simplifies the data exchange process and improves the flexibility of broadband measurement data application and data exchange.

[0075] According to a method for processing broadband measurement data provided by the present invention, before calling a general target query data interface and performing data query in a target table of a target database, the method further includes: Calling a general target insertion data interface to write the broadband measurement data, the spectrum analysis results and the cluster analysis results into a target table of a target database; The target insertion data interface is predetermined based on different types of broadband measurement data.

[0076] Specifically, after obtaining broadband measurement data, spectrum analysis results and cluster analysis results, the general target insertion data interface can be further called to write the broadband measurement data, spectrum analysis results and cluster analysis results into the target table of the target database to achieve efficient data storage.

[0077] Among them, the table structure corresponding to the target table of the target database is predetermined based on different types of broadband measurement data using standard SQL syntax. The target database is a file database, which is a database with a self-describing table structure. The target database can be compatible with multiple databases to ensure that it can be used in file databases such as SQLite, DuckDB, and H2 Database.

[0078] The target insertion data interface is predetermined based on different types of broadband measurement data. Different insertion data interfaces correspond to different types of broadband measurement data, thereby achieving efficient storage.

[0079] The method provided in this embodiment writes broadband measurement data, spectrum analysis results and cluster analysis results into the target table of the target database by calling the target insertion data interface, so as to facilitate data query in the target table of the target database by calling the general target query data interface. The present invention adopts standard SQL syntax to predetermine the table structure corresponding to the target table of the target database based on different types of broadband measurement data. The target database is a file database, which is a database with a self-describing table structure. The target database is independent and can be conveniently transferred and used between different operating systems and business systems, which simplifies the data exchange process and improves the flexibility of broadband measurement data application and data exchange.

[0080] According to a method for processing broadband measurement data provided by the present invention, any type of broadband measurement data is a broadband measurement and analysis extended structure WMAX structure, the main structure of the WMAX structure includes a device name field, a start time field, an end time field and a structure of the type of broadband measurement data; the target table includes a plant station table, an equipment table, a line table, a raw data measurement table, a broadband oscillation analysis record table, and a broadband oscillation statistics record table; the target insertion data interface includes a first insertion data interface, a second insertion data interface and a third insertion data interface.

[0081] Specifically, in some embodiments, any type of broadband measurement data is a broadband measurement and analysis extended structure WMAX structure, wherein the main structure of the WMAX structure includes a device name field deviceName, a start time field startTime, an end time field endTime, and a structure of the type of broadband measurement data.

[0082] For example, Figure 2 is a schematic diagram of the data structure of the broadband measurement data provided by the present invention, such as Figure 2 As shown, the main structure of WMAX is as follows: Device NamedeviceName Start time startTime End time endTime Power frequency measurement data fundamentalData Harmonic Measurement Data harmonicData Interharmonic Measurement DatainterharmonicData Second level K-line data list kLineData[ ] Energy Ratios Statistics List energyRatios[ ] For example, the structure FundamentalData of the power frequency measurement data structure is as follows: Active power list activePower[ ] Reactive power list reactivePower[ ] frequency list frequency[ ] Voltage list voltage[ ] For example, the structure of the harmonic measurement structure HarmonicMeasurement is as follows: Active harmonic list activePowerHarmonics[HarmonicData] Voltage Harmonics List voltageHarmonics[HarmonicData] Current harmonics list currentHarmonics[HarmonicData] For example, the structure of the interharmonic measurement structure InterharmonicMeasurement is as follows: Active interharmonics list activePowerInterharmonics[HarmonicData] Voltage interharmonics list voltageInterharmonics[HarmonicData] Current interharmonics list currentInterharmonics[HarmonicData].

[0083] Among them, the target tables in the file database include plant station table, equipment table, line table, raw data measurement table, broadband oscillation analysis record table, broadband oscillation statistics record table, and each table can be self-describing.

[0084] The pre-designed target insertion data interface in this embodiment includes a first insertion data interface, a second insertion data interface and a third insertion data interface, wherein the first insertion data interface is used to write broadband measurement data into a corresponding table, the second insertion data interface is used to write spectrum analysis results, and the third insertion data interface is used to write cluster analysis results. The universal insertion and query interface designed in the present invention can support the adaptation of different file databases and realize efficient storage and reading of data.

[0085] The method provided in this embodiment pre-designs a unified WMAX data structure, implements data storage and query by calling a common data query and data insertion interface, simplifies the data processing and data exchange process, and improves the efficiency of data processing.

[0086] According to a method for processing broadband measurement data provided by the present invention, a universal target insertion data interface is called to write broadband measurement data, spectrum analysis results and cluster analysis results into a target table of a target database, including: Calling the first data insertion interface to write the broadband measurement data into the corresponding raw data measurement table in the target database and the plant station table, equipment table and line table corresponding to the broadband measurement data; Calling the second data insertion interface to write the spectrum analysis result into the broadband oscillation analysis record table in the target database; The third data insertion interface is called to write the cluster analysis result into the broadband oscillation statistics record table in the target database.

[0087] Specifically, in some embodiments, the insert data interface is pre-designed by a SOL statement, and an example is as follows: insertStationData(database, stationID, stationName, stationType, voltageLevel, timestamp_bgn, timestamp_end, description). The corresponding interface can be called by executing a SQL statement.

[0088] The process of writing data in step 103 is implemented in the following manner: For example, the first data insertion interface is called to write the broadband measurement data into the corresponding raw data measurement table in the target database and the plant table, equipment table and line table corresponding to the broadband measurement data. Exemplarily, the following statement is executed to implement data writing: / / Insert plant station data Procedure insertStationData(database, stationID, stationName, stationType, voltageLevel, timestamp_bgn, timestamp_end, description): Execute the following SQL statement: INSERT INTO stationTable (stationID, stationName, stationType, voltageLevel, timestamp_bgn, timestamp_end, description) VALUES (stationID, stationName, stationType, voltageLevel, timestamp_bgn, timestamp_end, description) / / Insert device data Procedure insertDeviceData(database, stID, deviceID, deviceName,deviceType, voltageLevel, description): Execute the following SQL statement: INSERT INTO deviceTable (stID, deviceID, deviceName, deviceType, voltageLevel, description) VALUES (stID, deviceID, deviceName, deviceType, voltageLevel, description) / / Insert line data Procedure insertLineData(database, dev1ID, dev2ID, lineID, lineName,lineType, description): Execute the following SQL statement: INSERT INTO lineTable (dev1ID, dev2ID, lineID, lineName, lineType,description) VALUES (dev1ID, dev2ID, lineID, lineName, lineType, description) / / Insert raw measurement data Procedure insertSourceData(database, devID, measName, description, measType, measurement): Execute the following SQL statement: INSERT INTO sourceData (devID, measName, description, measType, measurement) VALUES (devID, measName, description, measType, measurement) Exemplarily, the predefined table structures of each table are as follows: Table 1: Station Table

[0089] Table 2: Equipment table stationTable

[0090] Table 3: Line Table lineTable

[0091] Table 4: SourceData of raw data measurement

[0092] Further, the second data insertion interface is called to write the spectrum analysis results into the broadband oscillation analysis record table in the target database. Exemplarily, the following statement is executed to write data into the broadband oscillation analysis record table: / / Insert broadband oscillation analysis record data Procedure insertWideFreqRecordData(database, devID, stID, type,harmonicType, frequency, max_amplitude, average_amplitude, timestamp_bgn,timestamp_end, freqData, ampData, phaseData) Execute the following SQL statement: INSERT INTO wideFreqRecordData (devID, stID, type, harmonicType,frequency, max_amplitude, average_amplitude, timestamp_bgn, timestamp_end,freqData, ampData, phaseData) VALUES (devID, stID, type, harmonicType, frequency, max_amplitude,average_amplitude, timestamp_bgn, timestamp_end, freqData, ampData,phaseData) Exemplarily, the broadband oscillation analysis record table is shown in Table 5 below: Table 5: Wide-band oscillation analysis record table wideFreqRecordData

[0093] The third insert data interface is called to write the cluster analysis results into the broadband oscillation statistics record table in the target database. Exemplarily, the following statement is executed to write data into the broadband oscillation statistics record table: / / Insert broadband oscillation statistics record data Procedure insertAnalyData(database,type,harmonicType,frequency,stationCount, deviceCount) Execute the following SQL statement: INSERT INTO analyzeData (type, harmonicType, frequency, stationCount, deviceCount) VALUES (type, harmonicType, frequency, stationCount, deviceCount) Exemplarily, the broadband oscillation statistics record table is shown in Table 6 below: Table 6: Broadband oscillation statistics record table analyData

[0094] The method provided in this embodiment designs a universal data insertion interface, supports adaptation to different file databases, and realizes efficient storage of broadband measurement data.

[0095] According to a method for processing broadband measurement data provided by the present invention, the target query data interface includes a first query data interface, a second query data interface and a third query data interface; calling the universal target query data interface to perform data query in a target table of a target database includes: Calling a first data insertion interface to query the broadband measurement data in a corresponding original measurement data table in a target database; Call the second insertion data interface to query the spectrum analysis result in the wide-band oscillation analysis record table; The third data insertion interface is called to query the cluster analysis result in the broadband oscillation statistical record table.

[0096] Specifically, in some embodiments, the query data interface is pre-designed by a SOL statement, as shown in the following example: queryStationData(database, stationID). The corresponding interface can be called by executing a SQL statement.

[0097] The process of querying data in step 104 is implemented in the following manner: Call the first data insertion interface to query the broadband measurement data in the corresponding original measurement data table in the target database. For example, execute the following statement to query the original measurement data: / / Query plant station data Function queryStationData(database, stationID): Execute the following SQL statement: SELECT FROM stationTable WHERE stationID = stationID Return query results / / Query device data Function queryDeviceData(database, stID): Execute the following SQL statement: SELECT FROM deviceTable WHERE stID = stID Return query results / / Query line data Function queryLineData(database, lineID): Execute the following SQL statement: SELECT FROM lineTable WHERE lineID = lineID Return query results / / Query the original measurement data Function querySourceData(database, devID, measType): Execute the following SQL statement: SELECT FROM sourceData WHERE devID = devID AND measType = measType Return query results Further, the second insertion data interface is called to query the spectrum analysis result in the broadband oscillation analysis record table. For example, the following statement is executed to query the spectrum analysis result: / / Query broadband oscillation analysis record data Function queryWideFreqRecordData(database, devID, type, timestamp_bgn, timestamp_end): Execute the following SQL statement: SELECT FROM wideFreqRecordData WHERE devID = devID AND type = type AND timestamp_bgn>= timestamp_bgnAND timestamp_end<= timestamp_end Return query results Further, the third insertion data interface is called to query the cluster analysis results in the broadband oscillation statistical record table. For example, the following statement is executed to query the cluster analysis results: / / Query the broadband oscillation statistics record data Function queryAnalyData(database, type, harmonicType): Execute the following SQL statement SELECT FROM analyzeData WHERE type = type AND harmonicType =harmonicType Return query results In the method provided in this embodiment, a universal data query interface is designed to support adaptation to different file databases and realize efficient reading of broadband measurement data.

[0098] According to a method for processing broadband measurement data provided by the present invention, the method further includes: Visualize the broadband measurement data within a preset time period; Perform trend analysis based on the results of the visual display.

[0099] Specifically, in some embodiments, the method further includes integrating power frequency measurement data, high-order harmonic measurement data, and interharmonic measurement data, and combining time axis linkage design to achieve intuitive and efficient spectrum analysis and visualization. The implementation process is as follows: First, the broadband measurement data within a preset time period is visualized, and different types of broadband measurement data share the same time axis.

[0100] Trend analysis is performed based on the results of the visualization. For example, the voltage and current fluctuations in the power system can be identified through the visualization of the power frequency measurement data, and then the transient disturbances and power quality anomalies in the detection system can be predicted. The frequency characteristics and change trends of the harmonic signal can be identified through the visualization of the harmonic measurement data (higher harmonics), so as to determine the impact of higher harmonics on the power quality of the system. The dynamic changes of interharmonics in time and frequency can be identified through the visualization of interharmonic measurement data.

[0101] The method provided in this embodiment realizes intuitive and efficient spectrum analysis and visualization by integrating power frequency measurement data, harmonic measurement data and interharmonic measurement data and combining it with time axis linkage design.

[0102] According to a method for processing broadband measurement data provided by the present invention, the broadband measurement data within a preset time period is visualized and displayed, including: Using the first timing curve to display the power frequency measurement data within a preset time period; Using the second timing curve and the first spectrum analysis diagram to display harmonic measurement data within a preset time period; The interharmonic measurement data within a preset time period is displayed using the third timing curve, the second spectrum analysis diagram and the frequency table waterfall diagram; the time axes of the first timing curve, the second timing curve and the third timing curve are consistent.

[0103] Specifically, in some embodiments, the specific implementation process of visually displaying the broadband measurement data within a preset time period includes the following steps: The first timing curve is used to display the power frequency measurement data within a preset time period. Specifically, in the display of power frequency measurement data, the timing curve is used to display the dynamic changes of indicators such as power frequency voltage (Ua, Ub, Uc) and power frequency current (Ia, Ib, Ic), helping users to identify voltage and current fluctuations in the power system in real time. The timing curve can intuitively reflect the changing trend of the power frequency signal over time, which is convenient for detecting transient disturbances and power quality abnormalities in the system.

[0104] The second timing curve and the first spectrum analysis diagram are used to display the harmonic measurement data within the preset time period. Specifically, for the display of high-order harmonic data, the system uses timing curves and spectrum diagrams to display the change trends of harmonic currents (IAJ, IBJ, ICJ) and harmonic voltages (UAJ, UBJ, UCJ). Combined with the spectrum analysis diagram, users can identify the frequency characteristics and change trends of harmonic signals, thereby determining the impact of high-order harmonics on the power quality of the system. The spectrum diagram displays the harmonic amplitude through changes in color intensity, helping users quickly locate abnormal spectrum components.

[0105] The third timing curve, the second spectrum analysis chart and the frequency table waterfall chart are used to display the interharmonic measurement data within the preset time period; the time axis of the first timing curve, the second timing curve and the third timing curve are consistent. Specifically, in the interharmonic data display, the tool uses a spectrum waterfall chart, with the horizontal axis being time, the vertical axis being frequency, and the color representing the amplitude. The chart shows the dynamic changes of interharmonics in time and frequency, and the brighter the color, the larger the amplitude. The spectrum analysis chart also provides the energy distribution of the interharmonics. Users can intuitively observe the changes in spectrum energy in different time periods through the diagram, which helps to identify the interharmonic characteristics of specific frequency bands. Figure 3 It is a schematic diagram of the effect of the multi-band joint display of broadband measurement data provided by the present invention.

[0106] The method provided in this embodiment realizes intuitive and efficient spectrum analysis and visualization by integrating power frequency measurement data, harmonic measurement data and interharmonic measurement data and combining it with time axis linkage design.

[0107] The following is a description of a processing device for broadband measurement data provided by the present invention. The processing device for broadband measurement data described below and the processing method for broadband measurement data described above can be referred to each other.

[0108] Figure 4 FIG. 1 is a schematic diagram of the structure of the broadband measurement data processing device provided by the present invention. Figure 4 As shown, the broadband measurement data processing device 400 includes the following modules: The acquisition module 410 is used to acquire broadband measurement data of the power system; the broadband measurement data includes at least one of the following types: power frequency measurement, harmonic measurement and interharmonic measurement, and different types of broadband measurement data correspond to different standardized data structures; An analysis module 420, configured to determine a spectrum analysis result and a cluster analysis result based on the broadband measurement data; The query module 430 is used to call a general target query data interface to perform data query in a target table of a target database; the target table of the target database includes the broadband measurement data, the spectrum analysis results and the cluster analysis results; the table structure corresponding to the target table of the target database is predetermined based on different types of broadband measurement data using standard SQL syntax; the target database is a file database, and the file database is a database with a self-describing table structure; the target query data interface is predetermined based on different types of broadband measurement data.

[0109] The device provided in this embodiment includes an acquisition module 410, an analysis module 420 and a query module 430, the acquisition module 410 acquires broadband measurement data of the power system; the type of broadband measurement data includes at least one of the following: power frequency measurement, harmonic measurement and interharmonic measurement, and different types of broadband measurement data correspond to different standardized data structures; the analysis module 420 determines the spectrum analysis results and the cluster analysis results based on the broadband measurement data; further, the query module 430 calls a general target query data interface to perform data query in a target table of a target database, the target table of the target database includes broadband measurement data, spectrum analysis results and cluster analysis results, the table structure corresponding to the target table of the target database is predetermined based on different types of broadband measurement data using standard SQL syntax, the target database is a file database, and the file database is a database with a self-describing table structure; the target query data interface is predetermined based on different types of broadband measurement data.

[0110] The types of broadband measurement data in the present invention include at least one of the following: power frequency measurement, harmonic measurement and interharmonic measurement. Different types of broadband measurement data correspond to different standardized data structures, that is, a unified data structure is designed. In addition, the target query data interface is predetermined based on different types of broadband measurement data. The present invention performs data query in the target table of the target database by calling a universal target query data interface. The present invention adopts standard SQL syntax to predetermine the table structure corresponding to the target table of the target database based on different types of broadband measurement data. The target database is a file database, which is a database with a self-describing table structure. The target database is independent and can be easily transferred and used between different operating systems and business systems, which simplifies the data exchange process and improves the flexibility of broadband measurement data application and data exchange.

[0111] According to a broadband measurement data processing device 400 provided by the present invention, the device further includes a writing module; the writing module is specifically used to: Calling a general target insertion data interface to write the broadband measurement data, the spectrum analysis result and the cluster analysis result into a target table of a target database; The target insertion data interface is predetermined based on different types of broadband measurement data.

[0112] According to a broadband measurement data processing device 400 provided by the present invention, any type of broadband measurement data is a broadband measurement and analysis extension structure WMAX structure, the main structure of the WMAX structure includes a device name field, a start time field, an end time field and a structure of the broadband measurement data of the type; the target table includes a plant station table, a device table, a line table, a raw data measurement table, a broadband oscillation analysis record table, and a broadband oscillation statistics record table; the target insertion data interface includes a first insertion data interface, a second insertion data interface and a third insertion data interface; According to the broadband measurement data processing device 400 provided by the present invention, the writing module is specifically used for: Calling the first data insertion interface to write the broadband measurement data into the corresponding raw data measurement table in the target database and the plant station table, equipment table and line table corresponding to the broadband measurement data; calling the second data insertion interface to write the spectrum analysis result into the broadband oscillation analysis record table in the target database; The third data insertion interface is called to write the cluster analysis result into the broadband oscillation statistical record table in the target database.

[0113] According to a broadband measurement data processing device 400 provided by the present invention, the target query data interface includes a first query data interface, a second query data interface and a third query data interface; the query module 430 is specifically used for: Calling the first data insertion interface to query the broadband measurement data in the corresponding original measurement data table in the target database; Calling the second data insertion interface to query the spectrum analysis result in the wide-band oscillation analysis record table; The third insertion data interface is called to query the cluster analysis result in the broadband oscillation statistical record table.

[0114] According to a broadband measurement data processing device 400 provided by the present invention, the device further comprises a display module, wherein the display module is used to: Visually displaying the broadband measurement data within a preset time period; Perform trend analysis based on the results of the visual display.

[0115] According to a broadband measurement data processing device 400 provided by the present invention, the display module is further used for: Using the first timing curve to display the power frequency measurement data within a preset time period; Using the second timing curve and the first spectrum analysis diagram to display the harmonic measurement data within the preset time period; The interharmonic measurement data within the preset time period is displayed using the third timing curve, the second spectrum analysis diagram and the frequency table waterfall diagram; the time axes of the first timing curve, the second timing curve and the third timing curve are consistent.

[0116] Figure 5 An example of a physical structure diagram of an electronic device is shown in FIG. Figure 5 As shown, the electronic device may include: a processor 510, a communications interface 520, a memory 530 and a communication bus 540, wherein the processor 510, the communications interface 520 and the memory 530 communicate with each other via the communication bus 540. The processor 510 may call the logic instructions in the memory 530 to execute the method for processing broadband measurement data, the method comprising: Acquire broadband measurement data of the power system; the broadband measurement data includes at least one of the following types: power frequency measurement, harmonic measurement and interharmonic measurement, and different types of broadband measurement data correspond to different standardized data structures; Determining spectrum analysis results and cluster analysis results based on the broadband measurement data; A general target query data interface is called to perform data query in a target table of a target database; the target table of the target database includes the broadband measurement data, the spectrum analysis results and the cluster analysis results; the table structure corresponding to the target table of the target database is predetermined based on different types of broadband measurement data using standard SQL syntax; the target database is a file database, and the file database is a database with a self-describing table structure; the target query data interface is predetermined based on different types of broadband measurement data.

[0117] In addition, the logic instructions in the above-mentioned memory 530 can be implemented in the form of a software functional unit and can be stored in a computer-readable storage medium when it is sold or used as an independent product. Based on such an understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art or the part of the technical solution, can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including a number of instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present invention. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), disk or optical disk, etc. Various media that can store program codes.

[0118] On the other hand, the present invention further provides a computer program product, the computer program product comprising a computer program, the computer program can be stored in a non-transitory computer-readable storage medium, when the computer program is executed by a processor, the computer can execute the method for processing broadband measurement data provided by the above methods, the method comprising: Acquire broadband measurement data of the power system; the broadband measurement data includes at least one of the following types: power frequency measurement, harmonic measurement and interharmonic measurement, and different types of broadband measurement data correspond to different standardized data structures; Determining spectrum analysis results and cluster analysis results based on the broadband measurement data; A general target query data interface is called to perform data query in a target table of a target database; the target table of the target database includes the broadband measurement data, the spectrum analysis results and the cluster analysis results; the table structure corresponding to the target table of the target database is predetermined based on different types of broadband measurement data using standard SQL syntax; the target database is a file database, and the file database is a database with a self-describing table structure; the target query data interface is predetermined based on different types of broadband measurement data.

[0119] In another aspect, the present invention further provides a non-transitory computer-readable storage medium having a computer program stored thereon, wherein when the computer program is executed by a processor, the method for processing broadband measurement data provided by the above methods is implemented, the method comprising: Acquire broadband measurement data of the power system; the broadband measurement data includes at least one of the following types: power frequency measurement, harmonic measurement and interharmonic measurement, and different types of broadband measurement data correspond to different standardized data structures; Determining spectrum analysis results and cluster analysis results based on the broadband measurement data; A general target query data interface is called to perform data query in a target table of a target database; the target table of the target database includes the broadband measurement data, the spectrum analysis results and the cluster analysis results; the table structure corresponding to the target table of the target database is predetermined based on different types of broadband measurement data using standard SQL syntax; the target database is a file database, and the file database is a database with a self-describing table structure; the target query data interface is predetermined based on different types of broadband measurement data.

[0120] The device embodiments described above are merely illustrative, wherein the units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the scheme of this embodiment. Ordinary technicians in this field can understand and implement it without paying creative labor.

[0121] Through the description of the above implementation methods, those skilled in the art can clearly understand that each implementation method can be implemented by means of software plus a necessary general hardware platform, and of course, can also be implemented by hardware. Based on this understanding, the above technical solution is essentially or the part that contributes to the prior art can be embodied in the form of a software product, and the computer software product can be stored in a computer-readable storage medium, such as ROM / RAM, a disk, an optical disk, etc., including a number of instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the methods described in each embodiment or some parts of the embodiments.

[0122] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A method for processing broadband measurement data, characterized in that: include: Acquire broadband measurement data of the power system; the broadband measurement data includes at least one of the following types: power frequency measurement, harmonic measurement and interharmonic measurement, and different types of broadband measurement data correspond to different standardized data structures; Determining spectrum analysis results and cluster analysis results based on the broadband measurement data; Call the general target query data interface to query data in the target table of the target database; The target table of the target database includes the broadband measurement data, the spectrum analysis result and the cluster analysis result. The table structure corresponding to the target table of the target database is predetermined based on different types of broadband measurement data using standard SQL syntax. The target database is a file database, and the file database is a database with a self-describing table structure. The target query data interface is predetermined based on different types of broadband measurement data.

2. The method for processing broadband measurement data according to claim 1, characterized in that: The calling of the general target query data interface, before performing data query in the target table of the target database, also includes: Calling a general target insertion data interface to write the broadband measurement data, the spectrum analysis result and the cluster analysis result into a target table of a target database; The target insertion data interface is predetermined based on different types of broadband measurement data.

3. The method for processing broadband measurement data according to claim 1, characterized in that: Any type of broadband measurement data is a broadband measurement and analysis extended structure WMAX structure, the main structure of the WMAX structure includes a device name field, a start time field, an end time field and a structure of the broadband measurement data of the type; the target table includes a plant table, an equipment table, a line table, a raw data measurement table, a broadband oscillation analysis record table, and a broadband oscillation statistics record table; the target insertion data interface includes a first insertion data interface, a second insertion data interface and a third insertion data interface.

4. The method for processing broadband measurement data according to claim 3, characterized in that: The calling of the universal target insertion data interface to write the broadband measurement data, the spectrum analysis result and the cluster analysis result into the target table of the target database includes: Calling the first data insertion interface to write the broadband measurement data into the corresponding raw data measurement table in the target database and the plant station table, equipment table and line table corresponding to the broadband measurement data; calling the second data insertion interface to write the spectrum analysis result into the broadband oscillation analysis record table in the target database; The third data insertion interface is called to write the cluster analysis result into the broadband oscillation statistical record table in the target database.

5. The method for processing broadband measurement data according to claim 3, characterized in that: The target query data interface includes a first query data interface, a second query data interface and a third query data interface; calling the universal target query data interface to query data in the target table of the target database includes: Calling the first data insertion interface to query the broadband measurement data in the corresponding original measurement data table in the target database; Calling the second data insertion interface to query the spectrum analysis result in the wide-band oscillation analysis record table; The third insertion data interface is called to query the cluster analysis result in the broadband oscillation statistical record table.

6. The method for processing broadband measurement data according to any one of claims 1 to 5, characterized in that: The method further comprises: Visually displaying the broadband measurement data within a preset time period; Perform trend analysis based on the results of the visual display.

7. The method for processing broadband measurement data according to claim 6, characterized in that: The visual display of the broadband measurement data within a preset time period includes: Using the first timing curve to display the power frequency measurement data within a preset time period; Using the second timing curve and the first spectrum analysis diagram to display the harmonic measurement data within the preset time period; The interharmonic measurement data within the preset time period is displayed using the third timing curve, the second spectrum analysis diagram and the frequency table waterfall diagram; the time axes of the first timing curve, the second timing curve and the third timing curve are consistent.

8. A device for processing broadband measurement data, characterized in that: include: An acquisition module, used for acquiring broadband measurement data of the power system; the broadband measurement data includes at least one of the following types: power frequency measurement, harmonic measurement and interharmonic measurement, and different types of broadband measurement data correspond to different standardized data structures; An analysis module, used for determining a spectrum analysis result and a cluster analysis result based on the broadband measurement data; A query module, used to call a universal target query data interface to perform data query in a target table of a target database; the target table of the target database includes the broadband measurement data, the spectrum analysis results and the cluster analysis results; the table structure corresponding to the target table of the target database is predetermined based on different types of broadband measurement data using standard SQL syntax; the target database is a file database, and the file database is a database of a self-describing table structure; The target query data interface is predetermined based on different types of broadband measurement data.

9. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein: When the processor executes the computer program, the method for processing broadband measurement data according to any one of claims 1 to 7 is implemented.

10. A non-transitory computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the method for processing broadband measurement data according to any one of claims 1 to 7 is implemented.

Images