Anti-revolving door multi-table data reproduction method based on time alignment
Through the anti-revolving door multi-table data reproduction method based on time alignment, the problems of data acquisition inconsistency and data loss after compression of equipment at all levels of wind farms are solved, and the data is aligned and reproduced at the same time are realized, providing subsequent analysis and evaluation. Strong support.
Patent Information
- Application Number
- CN202411282628.5
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-09-13
- Publication Date
- 2025-02-11
AI Technical Summary
Most of the data collected by equipment at all levels of wind farms are independently collected and lost compression, making it difficult to directly obtain the data values of equipment at all levels that are aligned at all levels, which affects the post-processing analysis of data and the evaluation of energy consumption.
Using the anti-revolving door multi-table data reproduction method based on time alignment, the initial data set and the revolving door compression results of each level of equipment are obtained, the minimum difference and alignment start time are determined, and the two-way time alignment is performed to obtain the complete data set at the time. And use the reverse turntable method to backfill the missing time value of data.
It realizes the time alignment and data reproduction of equipment at all levels, solves the problems of data acquisition inconsistency and data loss after compression, and provides an important foundation for post-processing analysis of data and power loss assessment.
Smart Images

Figure CN119415842A_ABST
Abstract
Description
Technical Field
[0001] The invention relates to a method for reproducing multi-table data of an anti-rotation door based on time alignment, which is applicable to the field of offshore wind power digitalization. Background Art
[0002] Wind farms will experience a large amount of power loss during operation, which restricts power generation efficiency. Currently, wind farms mostly use theoretical power generation and actual power generation to conduct overall energy consumption analysis, and lack specific analysis of equipment data at each level.
[0003] The main problem in analyzing the data of each level of equipment is that the data collected by each level of wind power equipment is mostly collected independently and lossy compressed, making it difficult to directly obtain the data values of each level of equipment that are aligned at the same time. Therefore, it is necessary to align the time of the data of each level of equipment and reproduce the data of each device at the same time to facilitate post-processing analysis of the data and evaluation of energy consumption. Summary of the invention
[0004] The technical problem to be solved by the present invention is: in view of the above-mentioned existing problems, a method for reproducing multi-table data of an anti-rotation gate based on time alignment is provided.
[0005] The technical solution adopted by the present invention is: a method for reproducing multi-table data of an anti-rotation gate based on time alignment, characterized in that it includes:
[0006] Obtaining initial data sets of devices at all levels, and compression results of each initial data set based on a revolving door compression algorithm;
[0007] Based on the time values corresponding to the initial data sets of any two devices, determine the minimum time difference between the two initial data sets, and based on the time value corresponding to the minimum time difference, determine the alignment start time;
[0008] Perform bidirectional time alignment on the two data sets based on the alignment start time to obtain a data set with complete time.
[0009] Based on the complete dataset, according to the mutual relationship of time alignment, the time alignment of the initial datasets of the remaining equipment at all levels is completed to obtain the time-aligned datasets of the equipment at all levels;
[0010] Traverse the time-aligned data sets of each level of equipment, filter the time values with missing data, and use the reverse rotation gate method to backfill the data corresponding to the missing time values based on the compression results of each initial data set.
[0011] The obtaining of initial data sets of devices at all levels and compression results of each initial data set based on a revolving door compression algorithm includes:
[0012] Obtain selected devices at all levels, and obtain initial data sets of the devices at all levels from a storage system;
[0013] The initial data set of each level of equipment is divided by the fuzzy C-means clustering algorithm and outliers are removed by screening.
[0014] The step of determining the minimum time difference between the two initial data sets based on the time values corresponding to the initial data sets of any two devices, and determining the alignment start time based on the time value corresponding to the minimum time difference, includes:
[0015] The time value in one initial data set is traversed and subtracted from the time value in another initial data set to obtain the time difference;
[0016] Traverse all time differences and use the single bubble method to filter out the minimum time difference between the two initial data sets;
[0017] Determine the middle time of the two time values corresponding to the minimum time difference, and use the middle time as the alignment start time.
[0018] The step of performing bidirectional time alignment on the two data sets based on the alignment start time to obtain a data set with complete time includes:
[0019] The alignment start time is used as the start time of the time alignment, and the two data sets are bidirectionally time aligned at preset time intervals to obtain a data set with complete time.
[0020] The traversing of the time-aligned data sets of each level of equipment, screening the time values of missing data, and backfilling the data corresponding to the missing time values of data using the reverse rotation gate method based on the compression results of each initial data set, includes:
[0021] The slope of the data segment is determined based on the data values before and after the missing data moment and the compression deviation of the revolving door compression algorithm, and the data at the missing moment is reproduced using linear interpolation.
[0022] A time-aligned anti-rotation gate multi-table data reproduction device, characterized by comprising:
[0023] A data acquisition module, used to acquire initial data sets of devices at all levels, and compression results of each initial data set based on a revolving door compression algorithm;
[0024] A difference determination module is used to determine the minimum time difference between two initial data sets based on the time values corresponding to the initial data sets of any two devices, and determine the alignment start time based on the time value corresponding to the minimum time difference;
[0025] The time alignment module I is used to perform bidirectional time alignment on two data sets based on the alignment start time to obtain a data set with complete time;
[0026] The time alignment module II is used to complete the time alignment of the initial data sets of the remaining equipment at all levels based on the complete time data set and the mutual relationship of the time alignment, and obtain the time-aligned data sets of the equipment at all levels;
[0027] The data reproduction module is used to traverse the time-aligned data sets of each level of equipment, filter the time values with missing data, and backfill the data corresponding to the missing time values using the reverse rotation gate method based on the compression results of each initial data set.
[0028] A storage medium stores a computer program executable by a processor, wherein the computer program implements the steps of the method for reproducing multi-table data based on time alignment by using an anti-rotation gate when the computer program is executed.
[0029] A device for reproducing multi-table data based on time alignment by reverse rotation gate has a memory and a processor, wherein the memory stores a computer program that can be executed by the processor, and is characterized in that when the computer program is executed, the steps of the method for reproducing multi-table data based on time alignment by reverse rotation gate are implemented.
[0030] The beneficial effects of the present invention are as follows: the present invention determines the alignment start time by subtracting the time values of two data sets, and then performs bidirectional alignment processing on the time-unaligned data sets based on the determined alignment start time, thereby obtaining time-aligned data sets for each level of equipment, and on this basis, uses the reverse rotation gate method for the time of missing data and utilizes data interpolation to achieve data reproduction. The present invention effectively solves the problem that the data collection time of each device in a wind farm is uneven and there are large missing data after compression, and provides an important basis for data post-processing analysis and power loss evaluation at the same time through data time alignment and data reproduction. BRIEF DESCRIPTION OF THE DRAWINGS
[0031] Figure 1 This is a flow chart of Example 1. DETAILED DESCRIPTION
[0032] Embodiment 1: This embodiment is a method for reproducing multi-table data of an anti-rotation gate based on time alignment, which specifically includes the following steps:
[0033] S1. Obtaining initial data sets of devices at all levels, and compression results of each initial data set based on a revolving door compression algorithm.
[0034] S1-1, obtaining the devices at each level selected by the user, and obtaining the initial data sets of the devices at each level from the storage system, wherein the initial data sets have set compression deviations and are compressed and stored by a revolving door compression algorithm (SDT), and have corresponding compression results.
[0035] S1-2, the initial data set of each level of equipment is divided by fuzzy C-means clustering algorithm and outliers are removed by screening. Using fuzzy C-means clustering algorithm to cluster the data in the data set and then screen out outliers can effectively reduce data fluctuations and improve data quality.
[0036] S2. Based on the time values corresponding to the initial data sets of any two devices, determine the minimum time difference between the two initial data sets, and based on the time value corresponding to the minimum time difference, determine the alignment start time.
[0037] S2-1. Subtract the time value in one initial data set from the time value in another initial data set to obtain a time difference.
[0038] Assume that the two initial data sets are data set 1 and data set 2, where the values of data set 1 at any given moment are: a[1], a[2], a[3], …, a[m-1], a[m], and the values of data set 2 at any given moment are: b[1], b[2], b[3], …, b[n-1], b[n].
[0039] A. Subtract the initial time a[1] in data set 1 from the time values b[1]~b[n] in data set 2 in sequence, using the formula:
[0040]
[0041] Get n time differences Δt between two data sets.
[0042] B. Subtract each time point a[i] (i = 2, 3, ..., m) from b[j] (j = 1, 2, ..., n) of data set 1 in sequence, using the formula:
[0043]
[0044] Combined with the calculation results corresponding to the above initial time a[1], a total of m×n Δt values can be obtained, that is, all the time differences Δt between the two data sets.
[0045] In this embodiment, when the initial moment a[i] is subtracted from the moment value b[j] of data set 2, the moment in b[j] that is closer to the moment a[i] can be preferentially selected for subtraction. When the initial moment a[1] of data set 1 is subtracted from the moment values b[1] to b[n] of data set 2, the moment in b[j] that is closer to the moment a[1] can be preferentially selected for subtraction. For example, if the moment value of a[1] is 2021-05-01-07:00:00, the moment values in the range of 2021-05-01-05:00:00 to 2021-05-01-09:00:00 can be selected in data set 2 for subtraction.
[0046] S2-2, traverse all the time difference values Δt, and use the single bubble method to select the minimum value min(Δt) of Δt from all the time difference values Δt;
[0047] S2-3. Determine the middle time of the two time values corresponding to the minimum time difference, and use the middle time as the alignment start time.
[0048] According to min(Δt), get the time value t corresponding to the time difference min1 and t min2 , if t min1 =t min2 , then t=t min1 =t min2 If t min1 ≠t min2 , then take t as t min1 and t min2 The middle moment of the time alignment. Where t is the reference moment of the time alignment, that is, the alignment start moment.
[0049] S3. Perform bidirectional time alignment on the two data sets based on the alignment start time to obtain a data set with complete time.
[0050] The extracted t is used as the starting time of the time alignment, and the two data sets are bidirectionally time aligned at preset time intervals to obtain a data set with complete time.
[0051] S4. Based on the complete data set, according to the mutual relationship of time alignment, complete the time alignment of the initial data sets of the remaining devices at all levels, and obtain the time-aligned data sets of the devices at all levels.
[0052] S5. Traverse the time-aligned data sets of each level of equipment, filter the time values with missing data, and use the reverse rotation gate method to backfill the data corresponding to the missing time values based on the compression results of each initial data set.
[0053] In this embodiment, the slope of the data segment is determined based on the data values before and after the missing data moment and the compression deviation of the revolving door compression algorithm, and the data at the missing moment is reproduced using linear interpolation.
[0054] Embodiment 2: This embodiment is a time-aligned anti-rotation gate multi-table data reproduction device, including a data acquisition module, a difference determination module, a time alignment module I, a time alignment module II and a data reproduction module, etc.
[0055] In this example, the data acquisition module is used to obtain the initial data sets of the devices at each level, and the compression results of each initial data set based on the revolving door compression algorithm.
[0056] In this embodiment, the difference determination module is used to determine the minimum time difference between the two initial data sets based on the time values corresponding to the initial data sets of any two devices, and determine the alignment start time based on the time value corresponding to the minimum time difference; the time alignment module I is used to perform bidirectional time alignment on the two data sets based on the alignment start time to obtain a data set with complete time; the time alignment module II is used to complete the time alignment of the initial data sets of the remaining devices at all levels based on the data set with complete time and according to the mutual relationship of the time alignment, so as to obtain the time-aligned data sets of the devices at all levels.
[0057] In this embodiment, the data reproduction module is used to traverse the time-aligned equipment data sets at all levels, filter the time values with missing data, and backfill the data corresponding to the missing time values using the reverse rotation gate method based on the compression results of each initial data set.
[0058] Embodiment 3: This embodiment is a storage medium on which a computer program that can be executed by a processor is stored. When the computer program is executed, the steps of the method for reproducing multi-table data based on time alignment of the anti-rotation gate in Embodiment 1 are implemented.
[0059] Embodiment 4: This embodiment is a time-aligned reverse rotation gate multi-table data reproduction device, which has a memory and a processor. The memory stores a computer program that can be executed by the processor. When the computer program is executed, the steps of the time-aligned reverse rotation gate multi-table data reproduction method in Embodiment 1 are implemented.
Claims
1. A method for reproducing multi-table data of an anti-rotation gate based on time alignment, characterized in that: include: Obtaining initial data sets of devices at all levels, and compression results of each initial data set based on a revolving door compression algorithm; Based on the time values corresponding to the initial data sets of any two devices, determine the minimum time difference between the two initial data sets, and based on the time value corresponding to the minimum time difference, determine the alignment start time; Perform bidirectional time alignment on the two data sets based on the alignment start time to obtain a data set with complete time. Based on the complete dataset, according to the mutual relationship of time alignment, the time alignment of the initial datasets of the remaining equipment at all levels is completed to obtain the time-aligned datasets of the equipment at all levels; Traverse the time-aligned data sets of each level of equipment, filter the time values with missing data, and use the reverse rotation gate method to backfill the data corresponding to the missing time values based on the compression results of each initial data set.
2. The method for reproducing multi-table data based on time alignment of the anti-rotation gate according to claim 1 is characterized in that: The obtaining of initial data sets of devices at all levels and compression results of each initial data set based on a revolving door compression algorithm includes: Obtain selected devices at all levels, and obtain initial data sets of the devices at all levels from a storage system; The initial data set of each level of equipment is divided by the fuzzy C-means clustering algorithm and outliers are removed by screening.
3. The method for reproducing multi-table data based on time alignment of the anti-rotation gate according to claim 1, characterized in that: The step of determining the minimum time difference between the two initial data sets based on the time values corresponding to the initial data sets of any two devices, and determining the alignment start time based on the time value corresponding to the minimum time difference, includes: The time value in one initial data set is traversed and subtracted from the time value in another initial data set to obtain the time difference; Traverse all time differences and use the single bubble method to filter out the minimum time difference between the two initial data sets; Determine the middle time of the two time values corresponding to the minimum time difference, and use the middle time as the alignment start time.
4. The method for reproducing multi-table data based on time alignment of the anti-rotation gate according to claim 1, characterized in that: The step of performing bidirectional time alignment on the two data sets based on the alignment start time to obtain a data set with complete time includes: The alignment start time is used as the start time of the time alignment, and the two data sets are bidirectionally time aligned at preset time intervals to obtain a data set with complete time.
5. The method for reproducing multi-table data based on time alignment of the anti-rotation gate according to claim 1, characterized in that: The traversing of the time-aligned data sets of each level of equipment, screening the time values of missing data, and backfilling the data corresponding to the missing time values of data using the reverse rotation gate method based on the compression results of each initial data set, includes: The slope of the data segment is determined based on the data values before and after the missing data moment and the compression deviation of the revolving door compression algorithm, and the data at the missing moment is reproduced using linear interpolation.
6. A device for reproducing multi-table data based on time alignment and anti-rotation gate, characterized in that: include: A data acquisition module, used to acquire initial data sets of devices at all levels, and compression results of each initial data set based on a revolving door compression algorithm; A difference determination module is used to determine the minimum time difference between two initial data sets based on the time values corresponding to the initial data sets of any two devices, and determine the alignment start time based on the time value corresponding to the minimum time difference; The time alignment module I is used to perform bidirectional time alignment on two data sets based on the alignment start time to obtain a data set with complete time; The time alignment module II is used to complete the time alignment of the initial data sets of the remaining equipment at all levels based on the complete time data set and the mutual relationship of the time alignment, and obtain the time-aligned data sets of the equipment at all levels; The data reproduction module is used to traverse the time-aligned data sets of each level of equipment, filter the time values with missing data, and backfill the data corresponding to the missing time values using the reverse rotation gate method based on the compression results of each initial data set.
7. A storage medium having stored thereon a computer program executable by a processor, characterized in that: When the computer program is executed, the steps of the method for reproducing multi-table data by using an anti-rotation gate based on time alignment as claimed in any one of claims 1 to 5 are implemented.
8. A time-aligned anti-rotation gate multi-table data reproduction device, comprising a memory and a processor, wherein the memory stores a computer program executable by the processor, characterized in that: When the computer program is executed, the steps of the method for reproducing multi-table data by using an anti-rotation gate based on time alignment as claimed in any one of claims 1 to 5 are implemented.