A method and device for accessing equipment operating condition data

Abstract

The present invention provides a method and device for accessing equipment operating condition data, wherein the method includes: obtaining equipment operating condition data of at least one operating condition of at least one equipment at a target collection time; recording the equipment operating condition data in one of the list items of a time series database; each list item corresponds to equipment operating condition data of a collection time, the list item includes multiple record fields, and different types of data in the equipment operating condition data are respectively recorded in corresponding types of record fields in the list item; obtaining equipment operating condition data of all operating conditions of the equipment at each time point that can divide a first preset time; when the equipment operating condition data meets the preset conditions, adding the equipment operating condition data to the cache library of the materialized view. In this embodiment, the list item fields are few, the records are simple, the number of operating condition tables does not need to be increased according to the increase in the number of equipment, and the table fields do not need to be reserved, so as to avoid the problem of too sparse operating condition tables and waste of resources.

Description

Technical Field

[0001] The present invention relates to the technical field of data processing, and in particular to a method and device for accessing equipment operating condition data. Background Art

[0002] The biggest challenge facing the IoT platform is how to continuously collect, store and use massive amounts of equipment operating data. These data come from different types of equipment and are completely heterogeneous. How to efficiently store and use these heterogeneous data is one of the main obstacles that the IoT platform needs to overcome. There are currently two main solutions for storing massive amounts of heterogeneous operating data (time series data): one table for one category and one table for multiple categories. With the increase in the number of equipment types, the number of operating tables in the time series database increases linearly, which consumes a lot of system resources when operating at full capacity. It is difficult to find a perfect number of reserved fields with one table for multiple categories, which can easily cause the operating table to be too sparse and waste a lot of storage space. When querying, two select statements are needed to implement the query, which increases complexity and performance issues. Summary of the invention

[0003] The purpose of the present invention is to provide a method and device for accessing equipment operating condition data, which is used to solve the problem in the prior art that the number of operating condition tables increases linearly with the increase of equipment, and the operating condition tables are easily too sparse, resulting in resource waste.

[0004] In order to solve the above technical problems, an embodiment of the present invention provides a method for accessing equipment operating condition data, wherein the method comprises:

[0005] Acquire equipment operating condition data of at least one operating condition of at least one equipment at a target collection time;

[0006] Record the equipment operating condition data in one of the list items in the time series database; wherein each of the list items corresponds to equipment operating condition data at a collection time, the list item includes a plurality of record fields, and different types of data in the equipment operating condition data are respectively recorded in corresponding types of record fields in the list item;

[0007] Acquire the equipment operating condition data of all operating conditions of the equipment at each time point that can divide the first preset time period;

[0008] When the equipment operating condition data meets a preset condition, the equipment operating condition data is added to a cache library of the materialized view.

[0009] Optionally, in the access method, the time series database includes a plurality of data partitions corresponding to different time intervals, and recording the equipment operating condition data in one of the list items in the time series database includes:

[0010] The equipment operating condition data is recorded in a first target data partition among multiple data partitions; wherein the time interval corresponding to the first target data partition includes the target collection time.

[0011] Optionally, in the access method, the record field includes at least one of the following:

[0012] Type of device;

[0013] Device ID;

[0014] Timestamp;

[0015] Working condition name;

[0016] Operating value.

[0017] Optionally, in the access method, the preset condition includes two record fields: the operating condition name and the operating condition value.

[0018] Optionally, in the access method, the data in the operating condition value is stored in the form of a character string.

[0019] Optionally, the access method further comprises:

[0020] Obtaining a first query request; wherein the first query request includes a preset condition to be queried;

[0021] Outputting the query result in the cache library of the materialized view; wherein the query result is a collection of the equipment operating condition data that meets the preset condition to be queried.

[0022] Optionally, the access method further comprises:

[0023] Obtaining a second query request, where the second query request includes a query request time;

[0024] Output the equipment operating condition data in the second target data partition among the multiple data partitions; wherein the time interval corresponding to the second target data partition includes the query request time; the query request time is the target collection time corresponding to the equipment operating condition data.

[0025] Optionally, the access method further comprises:

[0026] Obtaining a third query request; wherein the third query request includes a target device;

[0027] Output the first time closest to the current time that is divisible by the first preset time length;

[0028] The device operating condition data corresponding to all the operating conditions of the target device from the first moment to the current moment is obtained.

[0029] Optionally, in the access method, after acquiring the device operating condition data corresponding to all the operating conditions of the target device from the first moment to the current moment, the method further comprises:

[0030] The equipment operating condition data at a second moment that is the shortest distance from the current moment and belongs to the same operating condition among the equipment operating condition data is obtained.

[0031] Optionally, in the access method, after acquiring the device operating condition data corresponding to all the operating conditions of the target device from the first moment to the current moment, the method further comprises:

[0032] Obtain the device operating condition data corresponding to all the operating conditions of the target device at each time point that can be divided by a second preset time length from the first moment to the current moment; wherein the second preset time length is less than the first preset time length.

[0033] Optionally, the access method further comprises:

[0034] Obtaining a fourth query request; wherein the fourth query request includes a target device and a target operating condition;

[0035] The device operating condition data of the target operating condition of the target device from the first moment to the current moment is obtained.

[0036] In order to achieve the above-mentioned object, the present invention further provides a device for accessing equipment operating condition data, wherein the device comprises:

[0037] A first acquisition module is used to acquire equipment operating condition data of at least one operating condition of at least one equipment at a target collection time;

[0038] A first processing module is used to record the equipment operating condition data in one of the list items in the time series database; wherein each of the list items corresponds to equipment operating condition data at a collection time, the list item includes a plurality of record fields, and different types of data in the equipment operating condition data are respectively recorded in corresponding types of record fields in the list item;

[0039] A second acquisition module, used for acquiring the equipment operating condition data of all operating conditions of the equipment at each time point that can divide the first preset time period;

[0040] The second processing module is used to add the equipment operating condition data to the cache library of the materialized view when the equipment operating condition data meets the preset conditions.

[0041] Optionally, in the access device, the time series database includes a plurality of data partitions corresponding to different time intervals, and the first processing module includes:

[0042] The first processing unit is used to record the equipment operating condition data into a first target data partition among multiple data partitions; wherein the time interval corresponding to the first target data partition includes the target collection time.

[0043] Optionally, in the access device, the record field includes at least one of the following:

[0044] Type of device;

[0045] Device ID;

[0046] Timestamp;

[0047] Working condition name;

[0048] Operating value.

[0049] The beneficial effects of the above technical solution of the present invention are as follows:

[0050] In the above scheme, the equipment operating condition data obtained at the target collection time is recorded in a list item including multiple record fields in the time series database. One list item corresponds to the equipment operating condition data at one collection time. The list item has few fields, simple records, and extremely high data insertion speed. There is no need to increase the number of operating condition tables according to the increase in the number of equipment, and there is no need to reserve table fields to avoid the problem of too sparse operating condition tables and waste of resources. All operating conditions are recorded at each time point that can divide the first preset time length, so that the operating conditions within a certain period of time are complete, avoiding missing working conditions and causing incomplete data. BRIEF DESCRIPTION OF THE DRAWINGS

[0051] Figure 1 A schematic diagram of a method for accessing equipment operating condition data according to an embodiment of the present invention;

[0052] Figure 2 One of the schematic diagrams of an example of a method for accessing equipment operating condition data according to an embodiment of the present invention;

[0053] Figure 3 The second schematic diagram is an example of a method for accessing equipment operating condition data according to an embodiment of the present invention;

[0054] Figure 4 The third schematic diagram is an example of a method for accessing equipment operating condition data according to an embodiment of the present invention;

[0055] Figure 5 A schematic diagram of a device for accessing equipment operating condition data according to an embodiment of the present invention. DETAILED DESCRIPTION

[0056] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0057] The present invention aims to provide a method and device for accessing equipment condition data in order to solve the problem that the number of condition tables in the prior art increases linearly with the increase of equipment, and the condition tables are easily too sparse, resulting in a waste of resources.

[0058] like Figure 1 As shown, an embodiment of the present invention provides a method for accessing equipment operating condition data, wherein the method includes:

[0059] Step S10, obtaining equipment operating condition data of at least one operating condition of at least one equipment at a target collection time;

[0060] Step S20, recording the equipment operating condition data in one of the list items of the time series database; wherein each of the list items corresponds to equipment operating condition data at a collection time, the list item includes a plurality of record fields, and different types of data in the equipment operating condition data are respectively recorded in corresponding types of record fields in the list item;

[0061] It should be noted that Figure 2 This is an example of the present invention, wherein each piece of the equipment operating condition data is the operating condition of a certain collection position of a certain equipment collected at the target collection time, and each piece occupies one line. It is not necessary to record the complete operating condition every time, and it is not necessary to complete the operating condition record, thereby improving the access efficiency of the equipment operating condition data; the positions corresponding to the record fields in the list items are all necessary recorded data, and there is no need to reserve too many table fields, thereby avoiding the situation where sparse tables occupy more memory, and of course, it also avoids the problem of insufficient reserved table fields, resulting in the inability to store in the database.

[0062] Step S30, acquiring the equipment operating condition data of all operating conditions of the equipment at each time point that can divide the first preset time period;

[0063] It should be noted that, when the first preset time length is ten minutes, the action of obtaining the equipment operating condition data of all operating conditions of the equipment is performed every ten minutes.

[0064] Step S40, when the equipment operating condition data meets the preset conditions, adding the equipment operating condition data to the cache library of the materialized view;

[0065] It should be noted that a materialized view is a physical table that can be updated regularly through the internal mechanism of the database. Using materialized views to connect some large and time-consuming tables can improve query efficiency. The cache library of the materialized view is used to pre-save the equipment operating data that meets the preset conditions, thereby reducing the time-consuming operations when querying according to the preset conditions and quickly obtaining results.

[0066] In this embodiment, the equipment operating condition data obtained at the target collection time is recorded in a list item including multiple record fields in a time series database. One list item corresponds to the equipment operating condition data at one collection time. The list item has few fields, simple records, and extremely high data insertion speed. There is no need to increase the number of operating condition tables according to the increase in the number of equipment, which would cause a waste of resources. In addition, all operating conditions are recorded at each time point that can divide the first preset time period, so that the operating conditions within a certain period of time are complete, avoiding missing operating conditions and causing incomplete data.

[0067] Optionally, in the access method, the time series database includes a plurality of data partitions corresponding to different time intervals, and step S20 includes:

[0068] A10, recording the equipment operating condition data into a first target data partition among multiple data partitions; wherein the time interval corresponding to the first target data partition includes the target collection time.

[0069] In this embodiment, Figure 2 The example shown shows that the time series database includes three data partitions, which are divided according to June 2023, July 2023 and August 2023. When the target collection time of the equipment operating condition data is June 25, 2023, it is recorded in the data partition Partition1 June 2023. In actual application, the equipment operating condition data can be partitioned by time according to the number of equipment and the number of operating conditions. According to the amount of data, annual partitioning, quarterly partitioning, monthly partitioning, weekly partitioning, daily partitioning or hourly partitioning can be selected to ensure that the data scale in a partition is controllable.

[0070] Optionally, in the access method, the record field includes at least one of the following:

[0071] Type of device;

[0072] Device ID;

[0073] Timestamp;

[0074] Working condition name;

[0075] Operating value.

[0076] In this embodiment, Figure 2 The record fields in include the device type, the device ID, the timestamp, the condition name, and the condition value, wherein the timestamp can be a string of numbers obtained according to the target collection time of the device condition data, or a combination of other numbers and letters, as long as it can distinguish different target collection times. And each piece of the device condition data corresponds to a timestamp, which avoids the need to complete other condition parameters when updating part of the condition information in the prior art, but the other condition information was updated before, so that the completed parameters and the updated parameters share the timestamp, resulting in inaccurate records.

[0077] Optionally, in the access method, the preset condition includes two record fields: the operating condition name and the operating condition value.

[0078] In this embodiment, when using the cache library of the materialized view to store the equipment operating condition data, it is necessary to set the preset condition in advance, which includes two record fields of the operating condition name and the operating condition value, for example, the engine speed is greater than 3000.

[0079] Optionally, in the access method, the data in the operating condition value is stored in the form of a character string.

[0080] In this embodiment, since the fields of the device type, the device ID, the timestamp and the working condition name have a certain degree of homogeneity, longitudinal compression can be well implemented. Only the working condition value field has a large value fluctuation and belongs to heterogeneous data. In the embodiment of the present invention, the working condition value field is designed as a string type, and the string field itself has good compressibility, so a higher compression ratio can be achieved.

[0081] Optionally, the access method further comprises:

[0082] B10, obtaining a first query request; wherein the first query request includes a preset condition to be queried;

[0083] B20, outputting the query result in the cache library of the materialized view; wherein the query result is a collection of the equipment operating condition data that meets the preset condition to be queried.

[0084] In this embodiment, using the cache library of the materialized view to cache the set of equipment operating condition data that meets the preset conditions can solve the problem that high-frequency complex queries require two-step queries, which increases memory consumption and query time. The two-step query is as follows:

[0085] SELECT column_name(s)

[0086] FROM table_name

[0087] WHERE column_name IN(SELECT STATEMENT)

[0088] The two-step query first uses a select statement to extract the working condition name and working condition value and puts them into the in clause, and then splices them with the select statement of the previous layer. For example, in general, to directly query the equipment working condition data of "engine speed greater than 3000", you need to query the working condition name "engine speed" and then query the equipment working condition data with working condition values ​​greater than 3000 in the query results.

[0089] If the first query request including the preset condition is directly used for query, the query result outputted can be directly obtained. According to the user's usage habits, the equipment condition data that meets the preset condition will be updated to the cache of the materialized view while being recorded in the time series database, and the first query request is directly connected to the cache of the materialized view, and no two-step query is required, but a select statement can quickly obtain the required results. For example, before recording the equipment condition data, the preset condition is set to "engine speed is greater than 3000", and the updated data in the time series database is queried at fixed intervals to see whether there is the equipment condition data that meets the preset condition "engine speed is greater than 3000", and when the equipment condition data that meets the condition is queried, the equipment condition data is added to the cache of the materialized view. Therefore, when the first query request is directly connected to the cache of the materialized view, the set of the equipment condition data in the cache of the materialized view can be directly output, which improves the query efficiency.

[0090] Optionally, the access method further comprises:

[0091] B30, obtaining a second query request, where the second query request includes a query request time;

[0092] B40, outputting the equipment operating condition data in the second target data partition among the multiple data partitions; wherein the time interval corresponding to the second target data partition includes the query request time; the query request time is the target collection time corresponding to the equipment operating condition data.

[0093] In this embodiment, when the second query request is obtained, the second query request is automatically directed to the second target data partition according to the query request time, thereby improving the query speed.

[0094] Optionally, the access method further comprises:

[0095] Obtaining a third query request; wherein the third query request includes a target device;

[0096] Output the first time closest to the current time that is divisible by the first preset time length;

[0097] The device operating condition data corresponding to all the operating conditions of the target device from the first moment to the current moment is obtained.

[0098] In this embodiment, when the first preset time is ten minutes, the function to Start Of Ten Minutes is used to calculate the last time point that is divisible by ten minutes. For example, the current time now is 2023-10-15 09:12:31, to Start Of Ten Minutes(now()) returns 2023-10-15 09:10:00, and the device operating condition data corresponding to all the operating conditions of the target device from the first moment is obtained through the third query request. Since the first moment is close to the current moment, the amount of the device operating condition data returned by the query is appropriate.

[0099] Optionally, in the access method, after acquiring the device operating condition data corresponding to all the operating conditions of the target device from the first moment to the current moment, the method further comprises:

[0100] The equipment operating condition data at a second moment that is the shortest distance from the current moment and belongs to the same operating condition among the equipment operating condition data is obtained.

[0101] In this embodiment, if Figure 3As shown, the equipment operating condition data of all the latest versions obtained through the third query request are output, that is, the equipment operating condition data of the second moment with the smallest distance from the current moment belonging to the same operating condition in the equipment operating condition data is obtained. For example, the equipment operating condition data of the target device includes the following arranged in chronological order: A1, A2, A3, A4, B1, B2, B3, C1, C2, wherein A, B, C represent the target operating condition, and the numbers after A, B, C represent the version of the target operating condition. The larger the number, the newer the version. As time goes by, the new version will replace the old version, and finally A4, B3, C2 are obtained. Use "select * from operating condition table where timestamp>=to Start Of Ten Minutes(now())and device ID='BJ-X5-00001'" for query.

[0102] Optionally, in the access method, after acquiring the device operating condition data corresponding to all the operating conditions of the target device from the first moment to the current moment, the method further comprises:

[0103] Obtain the device operating condition data corresponding to all the operating conditions of the target device at each time point that can be divided by a second preset time length from the first moment to the current moment; wherein the second preset time length is less than the first preset time length.

[0104] It should be noted that if Figure 4 As shown, after obtaining the third query request, when the first preset time is ten minutes and the second preset time is one second, the query result is the equipment condition data corresponding to all the conditions of the target equipment from the first moment that is divisible by ten minutes to the current moment, and the final query result is calculated by the condition completion algorithm to obtain the equipment condition data corresponding to all the conditions of the target equipment recorded every one second. Use "select * from condition table where timestamp>=to Start OfTen Minutes(start)and timestamp<=end device ID='BJ-X5-00001'" to query.

[0105] Optionally, the access method further comprises:

[0106] Obtaining a fourth query request; wherein the fourth query request includes a target device and a target operating condition;

[0107] The device operating condition data of the target operating condition of the target device from the first moment to the current moment is obtained.

[0108] In this embodiment, "select * from operating condition table where timestamp>=to Start Of en Minutes (start)and timestamp<=enddevice ID='BJ-X5-00001'and operating condition name='engine speed'" is used to query the device operating condition data of the target operating condition of the target device from the first moment to the current moment.

[0109] like Figure 5 As shown, in order to achieve the above-mentioned purpose, the present invention also provides a device for accessing equipment operating condition data, wherein the device comprises:

[0110] A first acquisition module 51 is used to acquire equipment operating condition data of at least one operating condition of at least one equipment at a target collection time;

[0111] The first processing module 52 is used to record the equipment operating condition data in one of the list items in the time series database; wherein each of the list items corresponds to equipment operating condition data at a collection time, the list item includes a plurality of record fields, and different types of data in the equipment operating condition data are respectively recorded in corresponding types of record fields in the list item;

[0112] A second acquisition module 53 is used to acquire the equipment operating condition data of all operating conditions of the equipment at each time point that can divide the first preset time period;

[0113] The second processing module 54 is configured to add the equipment operating condition data to a cache library of the materialized view if the equipment operating condition data meets a preset condition.

[0114] Optionally, in the access device, the time series database includes a plurality of data partitions corresponding to different time intervals, and the first processing module 52 includes:

[0115] The first processing unit is used to record the equipment operating condition data into a first target data partition among multiple data partitions; wherein the time interval corresponding to the first target data partition includes the target collection time.

[0116] Optionally, in the access device, the record field includes at least one of the following:

[0117] Type of device;

[0118] Device ID;

[0119] Timestamp;

[0120] Working condition name;

[0121] Operating value.

[0122] Optionally, in the access device, the preset condition includes two record fields: the operating condition name and the operating condition value.

[0123] Optionally, in the access device, the data in the operating condition value is stored in the form of a character string.

[0124] Optionally, the access device further includes:

[0125] A second acquisition module is used to acquire a first query request; wherein the first query request includes a preset condition to be queried;

[0126] The first output module is used to output the query result in the cache library of the materialized view; wherein the query result is a collection of the equipment operating condition data that meets the preset condition to be queried.

[0127] Optionally, the access device further includes:

[0128] A third acquisition module is used to acquire a second query request, where the second query request includes a query request time;

[0129] The second output module is used to output the equipment operating condition data in the second target data partition among multiple data partitions; wherein the time interval corresponding to the second target data partition includes the query request time; the query request time is the target collection time corresponding to the equipment operating condition data.

[0130] Optionally, the access device further includes:

[0131] A fourth acquisition module, configured to acquire a third query request; wherein the third query request includes a target device;

[0132] A third output module, used to output a first time that is closest to the current time and is divisible by the first preset time length;

[0133] The fifth acquisition module is used to acquire the equipment operating condition data corresponding to all the operating conditions of the target equipment from the first moment to the current moment.

[0134] Optionally, the access device further includes:

[0135] The sixth acquisition module is used to obtain the equipment operating condition data at a second moment that is the shortest distance from the current moment and belongs to the same operating condition among the equipment operating condition data.

[0136] Optionally, the access device further includes:

[0137] The seventh acquisition module is used to obtain the equipment operating condition data corresponding to all the operating conditions of the target equipment at each time point that can be divided by a second preset time length from the first moment to the current moment; wherein the second preset time length is less than the first preset time length.

[0138] Optionally, the access device further includes:

[0139] An eighth acquisition module, configured to acquire a fourth query request; wherein the fourth query request includes a target device and a target operating condition;

[0140] A ninth acquisition module is used to acquire the equipment operating condition data of the target operating condition of the target equipment from the first moment to the current moment.

[0141] It should be noted here that the above-mentioned device provided in the embodiment of the present invention can implement all the method steps implemented in the above-mentioned method embodiment, and can achieve the same technical effect. The parts and beneficial effects that are the same as the method embodiment in this embodiment will not be described in detail here.

[0142] Obviously, those skilled in the art can make various changes and modifications to the present invention without departing from the spirit and scope of the present invention. Thus, if these modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalents, the present invention is also intended to include these modifications and variations.

Claims

1. A method for accessing equipment operating condition data, characterized in that: The method comprises: Acquire equipment operating condition data of at least one operating condition of at least one equipment at a target collection time; The equipment operating condition data is recorded in one of the list items in the first target data partition of the multiple data partitions corresponding to different time intervals in the time series database; wherein each of the list items corresponds to the equipment operating condition data of a collection time, the list item includes multiple record fields, and different types of data in the equipment operating condition data are respectively recorded in the corresponding types of record fields in the list item; the time interval corresponding to the first target data partition includes the target collection time; the multiple data partitions are time partitions for the equipment operating condition data according to the number of equipment and the number of operating conditions, and the partitioning methods include one or more of the following: yearly partitions, quarterly partitions, monthly partitions, weekly partitions, daily partitions, and hourly partitions; Acquire the equipment operating condition data of all operating conditions of the equipment at each time point that can divide the first preset time period; When the equipment operating condition data meets the preset conditions, the equipment operating condition data is added to the cache library of the materialized view; Obtaining a first query request; wherein the first query request includes a preset condition to be queried; Outputting the query result in the cache library of the materialized view; wherein the query result is a collection of the equipment operating condition data that meets the preset condition to be queried; Obtaining a second query request, where the second query request includes a query request time; Outputting the equipment operating condition data in a second target data partition among the multiple data partitions; wherein the time interval corresponding to the second target data partition includes the query request time; the query request time is the target collection time corresponding to the equipment operating condition data; Obtaining a third query request; wherein the third query request includes a target device; Output the first time closest to the current time that is divisible by the first preset time length; Acquire the device operating condition data corresponding to all the operating conditions of the target device from the first moment to the current moment; Obtaining a fourth query request; wherein the fourth query request includes a target device and a target operating condition; Acquire the equipment operating condition data of the target operating condition of the target equipment from the first moment to the current moment; Wherein, after acquiring the equipment operating condition data corresponding to all the operating conditions of the target equipment from the first moment to the current moment, the method further includes: Acquire the equipment operating condition data at a second moment that is the shortest distance from the current moment and belongs to the same operating condition among the equipment operating condition data; Obtain the device operating condition data corresponding to all the operating conditions of the target device at each time point that can be divided by a second preset time length from the first moment to the current moment; wherein the second preset time length is less than the first preset time length.

2. The access method according to claim 1, characterized in that: The record field includes at least one of the following: Type of device; Device ID; Timestamp; Working condition name; Operating value.

3. The access method according to claim 2, characterized in that: The preset condition includes two record fields: the working condition name and the working condition value.

4. The access method according to claim 2, characterized in that: The data in the operating condition value is stored in the form of a character string.

5. A device for storing and accessing equipment operating condition data, characterized in that: The device comprises: A first acquisition module is used to acquire equipment operating condition data of at least one operating condition of at least one equipment at a target collection time; A first processing module, for recording the equipment operating condition data in one of the list items of a time series database, comprising: recording the equipment operating condition data in a first target data partition among a plurality of data partitions; wherein each of the list items corresponds to equipment operating condition data of a collection time, the list item comprises a plurality of record fields, and different types of data in the equipment operating condition data are respectively recorded in corresponding types of record fields in the list item; the time series database comprises a plurality of data partitions respectively corresponding to different time intervals; the time interval corresponding to the first target data partition comprises the target collection time; A second acquisition module, used for acquiring the equipment operating condition data of all operating conditions of the equipment at each time point that can divide the first preset time period; A second processing module, configured to add the equipment operating condition data to a cache library of the materialized view when the equipment operating condition data meets a preset condition; A second acquisition module is used to acquire a first query request; wherein the first query request includes a preset condition to be queried; A first output module, configured to output the query result in the cache library of the materialized view; wherein the query result is a collection of the equipment operating condition data that meets the preset condition to be queried; A third acquisition module is used to acquire a second query request, where the second query request includes a query request time; A second output module is used to output the equipment operating condition data in a second target data partition among the multiple data partitions; wherein the time interval corresponding to the second target data partition includes the query request time; and the query request time is the target collection time corresponding to the equipment operating condition data; A fourth acquisition module, configured to acquire a third query request; wherein the third query request includes a target device; A third output module, used to output a first time that is closest to the current time and is divisible by the first preset time length; A fifth acquisition module, used to acquire the device operating condition data corresponding to all the operating conditions of the target device from the first moment to the current moment; An eighth acquisition module, configured to acquire a fourth query request; wherein the fourth query request includes a target device and a target operating condition; A ninth acquisition module, configured to acquire the device operating condition data of the target operating condition of the target device from the first moment to the current moment; Wherein, the access device further includes: A sixth acquisition module, used to acquire the equipment operating condition data at a second moment that is the shortest distance from the current moment and belongs to the same operating condition among the equipment operating condition data; The seventh acquisition module is used to obtain the equipment operating condition data corresponding to all the operating conditions of the target equipment at each time point that can be divided by a second preset time length from the first moment to the current moment; wherein the second preset time length is less than the first preset time length.

Images