Wind power plant time sequence database adaptive query display method and related device

Abstract

The invention belongs to the technical field of wind power generation, and provides a wind power plant time sequence database adaptive query display method and a related device. The method comprises the following steps: determining a segmentation time interval according to acquired information data displayed in a paging manner; according to the segmentation time interval, carrying out segmentation processing on a time period in the query starting time and the query ending time of the system time sequence database to obtain m segmentation intervals; selecting q segmentation intervals from the m segmentation intervals by taking the query starting time as a starting point to obtain a first segmentation set; performing adaptive expansion processing on the first segmentation set to obtain a second segmentation set; and displaying data corresponding to the second segmentation set in the display page. According to the method, the problem of slower system response caused by more fans and time sequence database calling and query in part of wind fields can be effectively solved, and the time sequence database query stability, query efficiency and user experience of the SCADA system can be improved.

Description

Technical Field

[0001] The present invention relates to the technical field of wind power generation, and in particular to a method for adaptively querying and displaying a time series database of a wind farm and a related device. Background Art

[0002] Calling and querying the wind farm operation data recorded in the SCADA system time series database can help improve the operating efficiency of the generator set, discover potential problems in advance, or take timely measures when problems occur in the unit, thereby improving the reliability and sustainable development of the entire wind power generation system. Data query is a core business function of SCADA. Therefore, it is very important to greatly improve the data query efficiency and optimize the user experience on the basis of existing technology and under the premise of ensuring system stability.

[0003] The time series database records a large amount of real-time data at the second level for each unit. Retrieving all the data at one time and returning it to the front end may cause the following problems:

[0004] (1) When the server memory is limited, reading a large amount of data into the memory at one time will cause memory overflow and application software crash;

[0005] (2) When the server has sufficient memory, even if we do not consider the memory limit, if the entire data set is returned to the front-end for processing, the user needs to wait for a long time to obtain the data of the required page, which greatly affects the user experience;

[0006] (3) In order to meet the centralized monitoring needs of wind power generation, the time series database needs to be queried by unit number or unit type. In the traditional technical solution of calling large-scale database queries, the model and unit classification are not considered. Therefore, it still cannot meet the query needs when the time span is large and the number of units is large. Summary of the invention

[0007] In view of the defects in the prior art, the present invention provides a wind farm time series database adaptive query and display method and related devices to solve the problem of slow system response caused by time series database call and query due to a large number of wind turbines in some wind farms, thereby improving the stability, query efficiency and user experience of the SCADA system time series database query.

[0008] A method for adaptively querying and displaying a wind farm time series database, comprising:

[0009] Determine the segmentation time interval according to the acquired information data displayed in pages;

[0010] According to the split time interval, the time period between the query start time and the query end time of the system time series database is split to obtain m split intervals;

[0011] From the m segmentation intervals, q segmentation intervals are selected with the query start time as the starting point to obtain a first segmentation set;

[0012] Adaptively expanding the first segmentation set to obtain a second segmentation set;

[0013] The data corresponding to the second segmentation set is displayed on the display page.

[0014] Furthermore, the time period in the query start time and the query end time of the system time series database is segmented according to the segmentation time interval to obtain m segmentation intervals, including:

[0015] The split time intervals are sequentially superimposed on the query start time using a linear superposition method to obtain the split intervals;

[0016] If the cumulative time of the query start time and m+1 split time intervals is greater than or equal to the query end time, m split intervals are obtained.

[0017] Furthermore, it also includes:

[0018] Determine q by the method shown in the following formula:

[0019]

[0020] Among them, X represents the output time containing m segmentation intervals, Q start Indicates the query start time, and l indicates the split time interval.

[0021] Further, the first segmentation set is adaptively expanded to obtain a second segmentation set, including:

[0022] Calculate the ratio of the data volume of the first segmentation set to the query time granularity to obtain a first value;

[0023] Obtaining the mean value of the amount of data in each segmentation interval of the first segmentation set to obtain a first mean value;

[0024] Determine a second value according to the first mean value, the query time granularity, and the first check value;

[0025] If the first value is greater than the second value, the first segmentation set is determined as the second segmentation set;

[0026] If the first value is less than or equal to the second value, extract the q+1th segmentation interval;

[0027] The union of the q+1th segmentation interval and the first segmentation set is determined as the second segmentation set.

[0028] Furthermore, the first check value is calculated using the following formula:

[0029]

[0030] Among them, σ represents the first check value, c i represents the amount of data in the i-th partition interval in the first partition set, represents the mean data volume of the i-th segmentation interval in the first segmentation set, and T represents the query time granularity.

[0031] A wind farm time series database adaptive query and display device, the device comprising:

[0032] A determination unit, used for determining a segmentation time interval according to the acquired information data displayed in pages;

[0033] A segmentation unit, used to segment the time period in the query start time and the query end time of the system time series database according to the segmentation time interval to obtain m segmentation intervals;

[0034] A selection unit, configured to select q segmentation intervals from the m segmentation intervals with the query start time as a starting point, to obtain a first segmentation set;

[0035] An adaptive processing unit, configured to perform adaptive expansion processing on the first segmentation set to obtain a second segmentation set;

[0036] The display unit is used to display the data corresponding to the second segmentation set on the display page.

[0037] Furthermore, the segmentation unit is specifically used for:

[0038] The split time intervals are sequentially superimposed on the query start time using a linear superposition method to obtain the split intervals;

[0039] If the cumulative time of the query start time and m+1 split time intervals is greater than or equal to the query end time, m split intervals are obtained.

[0040] Furthermore, the device is also used to determine q:

[0041]

[0042] Among them, X represents the output time containing m segmentation intervals, Q start Indicates the query start time, and l indicates the split time interval.

[0043] A station-side network topology includes networking equipment, security equipment, and terminals, wherein the networking equipment includes a networking switch for aggregating data information at a data access layer; the security equipment includes a vertical encryption and intranet firewall for providing encryption and authentication protection for upper and lower level businesses; the terminal equipment includes a server for running a wind farm time series database adaptive query business program. BRIEF DESCRIPTION OF THE DRAWINGS

[0044] In order to more clearly illustrate the specific embodiments of the present invention, the following will briefly introduce the drawings required for the specific embodiments or the prior art description. In all the drawings, each element or part is not necessarily drawn according to the actual scale.

[0045] Figure 1 A flow chart of a method for adaptively querying and displaying a wind farm time series database provided by an embodiment of the present invention;

[0046] Figure 2 A schematic structural diagram of a wind farm time series database adaptive query and display device provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0047] The following embodiments of the technical solution of the present invention are described in detail in conjunction with the accompanying drawings. The following embodiments are only used to more clearly illustrate the technical solution of the present invention, and are therefore only used as examples, and cannot be used to limit the protection scope of the present invention.

[0048] It should be noted that, unless otherwise specified, the technical terms or scientific terms used in this application should have the common meanings understood by those skilled in the art to which the present invention belongs.

[0049] In one embodiment, if Figure 1 As shown, a method for adaptively querying a wind farm time series database is provided, comprising:

[0050] 1. Determine the segmentation time interval based on the information data obtained for paging display;

[0051] In one of the embodiments, the information data displayed in pages includes the number of units, the query time granularity, and the single-page entry number threshold.

[0052] According to the known information data, the segmentation time interval l is calculated as follows:

[0053]

[0054] Among them, l represents the split time interval, T represents the query time granularity, n represents the number of units, and p max It indicates the threshold of the number of entries per page.

[0055] 2. Split the time periods in the query start time and query end time of the system time series database according to the split time interval to obtain m split intervals;

[0056] (1) Use linear superposition to superimpose the split time interval on the query start time to obtain the split interval;

[0057] (2) If the cumulative time of the query start time and m+1 split time intervals is greater than or equal to the query end time, then m split intervals are obtained. That is, if the cumulative time of the query start time and m split time intervals is less than the query end time, then the split time intervals are continued to be accumulated. When the cumulative time of the query start time and m+1 split time intervals is greater than or equal to the query end time, the split time intervals are stopped to obtain m split intervals. m is an integer.

[0058] Specifically, the following formula is used to perform linear superposition and segmentation of time intervals based on the query start time:

[0059]

[0060] Among them, C end Indicates the end time of the split, Q start Indicates the query start time, Q end Indicates the query end time, and m indicates the number of split intervals.

[0061] 3. From the m segmentation intervals, take the query start time as the starting point and select q segmentation intervals to obtain the first segmentation set;

[0062] In one embodiment, the specific value of q is obtained by the following calculation formula:

[0063]

[0064] Where X represents the output time of m segmented intervals X = (x1, x2, ..., x m ), X is less than or equal to Q end , Q start Indicates the query start time, and l indicates the split time interval.

[0065] 4. Adaptively expand the first segmentation set to obtain a second segmentation set;

[0066] (1) Calculate the ratio of the amount of data in the first segmentation set to the query time granularity T from the SCADA system time series database through SQL statements to obtain the first value

[0067] The first partition set p q The amount of data in C pis equal to the sum of the data in the q partition intervals, C p =C1+C2+...+C i ...+C q , where C1 represents the amount of data in the first segmentation interval in the first segmentation set, C2 represents the amount of data in the second segmentation interval in the first segmentation set, and C i represents the amount of data in the i-th segmentation interval in the first segmentation set, C q Indicates the amount of data in the qth partition interval in the first partition set.

[0068] C i The following formula is used to calculate:

[0069]

[0070] b represents the bth unit, n represents the nth unit, S table Indicates the amount of data corresponding to each unit.

[0071] C1, C2, and Cq can be obtained by the same logic as above.

[0072] Since one collection point in the second-level database (TDengine time series database) is regarded as one table, each item in the first segmentation set contains multiple sub-tables, such as d10001, d10002, d10003, etc., which is related to the number of units n.

[0073] (2) Obtain the mean value of the amount of data in each segmentation interval of the first segmentation set, and obtain the first mean value

[0074] First mean in, It represents the mean value of the data volume in the first segmentation interval in the first segmentation set. represents the mean value of the data volume in the second segmentation interval in the first segmentation set. Represents the mean value of the data volume in the qth segmentation interval in the first segmentation set.

[0075] (3) Determine the second value based on the first mean value, the query time granularity and the first check value

[0076] In one embodiment, the first check value is calculated using the following formula:

[0077]

[0078] Wherein, σ represents the first check value, ci represents the amount of data in the i-th segmentation interval in the first segmentation set, represents the mean data volume of the i-th segmentation interval in the first segmentation set, and T represents the query time granularity.

[0079] (4) If the first value Greater than the second value Then the first segmentation set is determined as the second segmentation set p new ;

[0080] (5) If the first value Less than or equal to the second value Then extract the q+1th segmentation interval;

[0081] (6) The union of the q+1th segmentation interval and the first segmentation set is determined as the second segmentation set p new .

[0082] The following is the calculation formula for determining the second segmentation set:

[0083]

[0084] Among them, p new is the second partition set, p q is the first partition set, p q+1 is the union of the q+1th partition interval and the first partition set, represents the first value, Indicates the second value.

[0085] In line with the above, see Figure 2 , Figure 2 The present invention provides a schematic diagram of a wind farm time series database adaptive query and display device. Figure 2 As shown, the device comprises:

[0086] A determination unit, used for determining a segmentation time interval according to the acquired information data displayed in pages;

[0087] A segmentation unit, used to segment the time period in the query start time and the query end time of the system time series database according to the segmentation time interval to obtain m segmentation intervals;

[0088] A selection unit, configured to select q segmentation intervals from the m segmentation intervals with the query start time as a starting point, to obtain a first segmentation set;

[0089] An adaptive processing unit, configured to perform adaptive expansion processing on the first segmentation set to obtain a second segmentation set;

[0090] The display unit is used to display the data corresponding to the second segmentation set on the display page.

[0091] Preferably, the segmentation unit is specifically used for:

[0092] The split time intervals are sequentially superimposed on the query start time using a linear superposition method to obtain the split intervals;

[0093] If the cumulative time of the query start time and m+1 split time intervals is greater than or equal to the query end time, m split intervals are obtained.

[0094] Preferably, a wind farm time series database adaptive query display device is also used to determine q:

[0095]

[0096] Among them, X represents the output time containing m segmentation intervals, Q start Indicates the query start time, and l indicates the split time interval.

[0097] An embodiment of the present application also provides a site-side network topology, including networking equipment, security equipment, and terminals, wherein the networking equipment includes a networking switch for aggregating data access layer data information; the security equipment includes vertical encryption and intranet firewalls for providing encryption and authentication protection for upstream and downstream businesses; the terminal equipment includes a server for running a wind farm time series database adaptive query business program.

[0098] The present invention can effectively solve the problem of slow system response caused by time series database call and query due to the large number of wind turbines in some wind farms, and can improve the stability, query efficiency and user experience of time series database query in the SCADA system.

[0099] In the description of this specification, the description with reference to the terms "one embodiment", "some embodiments", "example", "specific example", or "some examples" etc. means that the specific features, structures, materials or characteristics described in conjunction with the embodiment or example are included in at least one embodiment or example of the present invention. In this specification, the schematic representations of the above terms do not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials or characteristics described may be combined in any one or more embodiments or examples in a suitable manner. In addition, those skilled in the art may combine and combine the different embodiments or examples described in this specification and the features of the different embodiments or examples, without contradiction.

[0100] 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 replace some or all of the technical features therein by equivalents. These modifications or replacements do not make the essence of the corresponding technical solutions deviate from the scope of the technical solutions of the embodiments of the present invention, and they should all be included in the scope of the claims and specification of the present invention.

Claims

1. A method for adaptive query and display of a wind farm time series database, characterized in that: include: Determine the segmentation time interval according to the acquired information data displayed in pages; According to the split time interval, the time period in the query start time and the query end time of the system time series database is split to obtain m split intervals; From the m segmentation intervals, taking the query start time as the starting point, select q segmentation intervals to obtain a first segmentation set; Adaptively expanding the first segmentation set to obtain a second segmentation set; The data corresponding to the second segmentation set is displayed on the display page.

2. The method for adaptively querying a wind farm time series database according to claim 1, characterized in that: The time period in the query start time and the query end time of the system time series database is segmented according to the segmentation time interval to obtain m segmentation intervals, including: The split time intervals are sequentially superimposed on the query start time using a linear superposition method to obtain the split intervals; If the cumulative time of the query start time and m+1 split time intervals is greater than or equal to the query end time, m split intervals are obtained.

3. The method for adaptively querying a wind farm time series database according to claim 1, characterized in that: The method further comprises: Determine q by the method shown in the following formula: Among them, X represents the output time containing m segmentation intervals, Q start Indicates the query start time, and l indicates the split time interval.

4. The method for adaptively querying and displaying a wind farm time series database according to claim 3, characterized in that: The step of adaptively expanding the first segmentation set to obtain the second segmentation set includes: Calculating a ratio of the data volume of the first segmentation set to the query time granularity to obtain a first value; Obtaining the mean value of the amount of data in each segmentation interval of the first segmentation set to obtain a first mean value; Determine a second value according to the first mean value, the query time granularity and the first check value; If the first value is greater than the second value, determining the first segmentation set as the second segmentation set; If the first value is less than or equal to the second value, extract the q+1th segmentation interval; The union of the (q+1)th segmentation interval and the first segmentation set is determined as the second segmentation set.

5. The method for adaptively querying and displaying a wind farm time series database according to claim 4, characterized in that: The first check value is calculated using the following formula: Among them, σ represents the first check value, c i represents the amount of data in the i-th partition interval in the first partition set, represents the mean data volume of the i-th segmentation interval in the first segmentation set, and T represents the query time granularity.

6. A wind farm time series database adaptive query display device, characterized in that: The device comprises: A determination unit, used for determining a segmentation time interval according to the acquired information data displayed in pages; A segmentation unit, configured to segment the time period in the query start time and the query end time of the system time series database according to the segmentation time interval to obtain m segmentation intervals; A selection unit, configured to select q segmentation intervals from the m segmentation intervals with the query start time as a starting point, to obtain a first segmentation set; An adaptive processing unit, configured to perform adaptive expansion processing on the first segmentation set to obtain a second segmentation set; A display unit is used to display the data corresponding to the second segmentation set in a display page.

7. The wind farm time series database adaptive query device according to claim 6, characterized in that: The segmentation unit is specifically used for: The split time intervals are sequentially superimposed on the query start time using a linear superposition method to obtain the split intervals; If the cumulative time of the query start time and m+1 split time intervals is greater than or equal to the query end time, m split intervals are obtained.

8. The wind farm time series database adaptive query device according to claim 6, characterized in that: The device is also used to determine q: Among them, X represents the output time containing m segmentation intervals, Q start Indicates the query start time, and l indicates the split time interval.

9. A station-side network topology, including networking equipment, security equipment, and terminals, wherein: The networking equipment includes a networking switch, which is used to aggregate data information at the data access layer; the security equipment includes vertical encryption and intranet firewalls, which are used to provide encryption and authentication protection for upstream and downstream businesses; the terminal equipment includes a server, which is used to run the wind farm time series database adaptive query business program.

Images