Industrial Internet of Things data storage optimization method, system and equipment
By establishing a total sensing database and sub-database in the sensor network platform, the storage and retrieval of control parameters are optimized, the problem of insufficient memory of edge devices is solved, and the storage and communication efficiency of the system is improved.
Patent Information
- Application Number
- CN202411174873.4
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-26
- Publication Date
- 2024-11-19
- Estimated Expiration
- 2044-08-26
AI Technical Summary
In the cloud-edge collaboration system, edge devices have small memory and cannot store too many control parameters, resulting in the need to store control parameters in cloud computing devices, increasing communication pressure.
By establishing a total sensing database and a sub-database in the sensor network platform, the target tasks are obtained and parsed, and the target control parameters are retrieved and stored. If not, they are obtained and stored from the management platform, and the storage and allocation of control parameters are optimized. .
It effectively solves the problem of insufficient memory at edge devices, reduces dependence on cloud computing devices, and improves the system's storage efficiency and communication efficiency.
Smart Images

Figure CN118689880B_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the technical field of Internet of Things, and in particular to an industrial Internet of Things data storage optimization method, system and device. Background Art
[0002] Industrial Internet of Things is the Internet of Things applied in the industrial field, and its core task is Intelligent Manufacturing (IM). The Industrial Internet of Things integrates new industrialization, informatization, and digitalization, aiming to comprehensively strengthen manufacturing and management capabilities and improve the level of industrial modernization. It includes edge computing and cloud computing. Edge computing is a distributed computing architecture. Unlike cloud computing, it decomposes the tasks previously handled by the central server and distributes these decomposed task fragments to the edge of the network, which is responsible for computing. Edge computing reduces the transmission time of relevant information and reduces latency. Although cloud computing can put large computing tasks on the cloud, for applications that require low latency, it will encounter problems such as network bandwidth bottlenecks. Edge computing can put tasks on the edge, so edge computing is limited by the computing power of local edge terminals. In order to solve the above shortcomings of cloud computing and edge computing, cloud-edge collaboration came into being. Cloud-edge collaboration closely combines cloud computing with edge computing, and by reasonably allocating the tasks of cloud computing and edge computing, it realizes the sinking of cloud computing and extends cloud computing and cloud analysis to the edge. With the development of technology, cloud-edge collaboration will definitely have a place in the future Internet industry.
[0003] At present, in the cloud-edge collaborative system, in order to complete different tasks, each task requires corresponding control parameters. In order to improve efficiency, the control parameters are often pre-configured and stored in the cloud computing device or the edge device. Since the control parameters are stored in the cloud computing device, the cloud computing device needs to send the control parameters to the edge device each time the edge device is controlled. When multiple edge devices need to be controlled, the communication pressure is relatively large. Therefore, the existing solutions generally choose to store the control parameters in the edge device. However, the edge device generally has a small memory and cannot store too many control parameters. There are still many control parameters that need to be stored in the cloud computing device. Summary of the invention
[0004] The present invention provides an industrial Internet of Things data storage optimization method, system and device, which at least solves the problem that in the prior art, control parameters are generally stored in edge devices, but edge devices generally have small memory and cannot store too many control parameters, and there are still many control parameters that need to be stored in cloud computing devices.
[0005] The present invention provides an industrial Internet of Things data storage optimization method for an industrial Internet of Things system, wherein the industrial Internet of Things system comprises a management platform, a sensor network platform and an object platform that establish communication in sequence, wherein the sensor network platform comprises a sensor master database that communicates with the management platform and at least one sensor sub-database that communicates with the object platform, wherein the sensor sub-database is matched one-to-one with a working object in the object platform, and the method is executed by the sensor network platform, and comprises:
[0006] Obtain and analyze the target task, and obtain the target work object and target requirements according to the target task;
[0007] According to the target work object and the target requirement, searching the sensor master database and / or the at least one sensor sub-database to determine whether there is a target control parameter corresponding to the target requirement, the target control parameter being used to control the target work object to complete the target requirement;
[0008] When there is a corresponding target control parameter, storing the target control parameter in the target sensor sub-database;
[0009] When there is no corresponding target control parameter, feedback information is sent to the management platform, the target control parameter sent by the management platform in response to the feedback information is received, and the target control parameter is stored in the target sensor sub-database.
[0010] Optionally, the step of searching the sensor master database and / or the at least one sensor sub-database according to the target work object and the target requirement to determine whether there is a target control parameter corresponding to the target requirement includes:
[0011] According to the target requirement, a target control parameter requirement corresponding to the target requirement is obtained, where the target control parameter requirement is configured as a requirement for a control parameter used to control a target work object to achieve the target requirement;
[0012] According to the target work object, obtaining an identifier of the target work object, wherein the identifier includes at least one of a unique identifier and a device identifier;
[0013] According to the identifier and the target control parameter requirement, a search is performed in the sensor master database and / or the at least one sensor sub-database to determine whether there is a target control parameter corresponding to the target requirement.
[0014] Optionally, the step of searching the sensor general database and / or the at least one sensor sub-database according to the identifier and the target control parameter requirement to determine whether there is a target control parameter corresponding to the target requirement includes:
[0015] According to the unique identifier and the target control parameter requirement, searching the sensor master database and / or the at least one sensor sub-database to determine whether there is a target control parameter corresponding to the target requirement;
[0016] When there is no target control parameter corresponding to the target requirement, the sensor general database and / or the at least one sensor sub-database are searched according to the device identifier and the target control parameter requirement to determine whether there is a target control parameter corresponding to the target requirement.
[0017] Optionally, the sensor database includes a first data table, which includes at least a unique identifier field for a work object, a device identifier field, a product field, and a control parameter address field.
[0018] The step of searching the sensor database according to the target working object and the target requirement to determine whether there is a target control parameter corresponding to the target requirement includes:
[0019] Acquire a target device identifier of the target work object according to the unique identifier of the target work object;
[0020] Determine, according to the target device identifier, a product corresponding to the target device identifier;
[0021] According to the product corresponding to the target device identifier, determining whether the product corresponding to the target device identifier meets the target requirement;
[0022] When a corresponding target control parameter exists, storing the target control parameter in the target sensor sub-database includes:
[0023] When the target requirement is met, obtaining a target control parameter address corresponding to the target requirement;
[0024] Obtaining a corresponding target control parameter according to the target control parameter address, and storing the target control parameter in the target sensor sub-database;
[0025] When there is no corresponding target control parameter, sending feedback information to the management platform, receiving the target control parameter sent by the management platform in response to the feedback information, and storing the target control parameter in the target sensor sub-database, comprises:
[0026] When the target requirement is not met, sending feedback information to the management platform, receiving the target control parameter sent by the management platform in response to the feedback information, and storing the target control parameter in the target sensor sub-database;
[0027] The products corresponding to the target demand are written into the first data table.
[0028] Optionally, also include:
[0029] The data volume of the control parameters stored in the target sensor sub-database is obtained, and when the data volume of the control parameters stored in the target sensor sub-database is greater than the average data volume of the control parameters stored in at least one sensor sub-database, at least one control parameter stored in the target sensor sub-database is transferred to other sensor sub-databases with the same device identifier.
[0030] Optionally, the target control parameters also include target verification parameters for verifying whether the target working object is working normally;
[0031] After storing the target control parameters in the target sensor sub-database, the method further includes:
[0032] Receive and store the target operation log of the target work object;
[0033] Obtaining a target operation state of the target work object according to the target operation log and the target verification parameter;
[0034] According to the target operating state, when the target operating state is inconsistent with the expected operating state, a communication link between the target work object and the management platform is established.
[0035] Optionally, the first data table further includes an access mode field, in which a target access mode allowed by the target work object is stored;
[0036] The step of establishing a communication link between the target work object and the management platform includes:
[0037] Sending a communication request to the management platform, and receiving an access mode sequence fed back by the management platform in response to the communication request;
[0038] According to the access method sequence and the target access method, a communication link between the target work object and the management platform is established.
[0039] In another aspect, an industrial Internet of Things data storage optimization system includes a management platform, a sensor network platform, and an object platform that establish communication in sequence, the sensor network platform includes a sensor master database that communicates with the management platform and at least one sensor sub-database that communicates with the object platform, the sensor sub-databases are matched one-to-one with work objects in the object platform;
[0040] The sensor network platform is configured as follows:
[0041] Obtain and analyze the target task, and obtain the target work object and target requirements according to the target task;
[0042] According to the target work object and the target requirement, searching the sensor master database and / or the at least one sensor sub-database to determine whether there is a target control parameter corresponding to the target requirement, the target control parameter being used to control the target work object to complete the target requirement;
[0043] When there is a corresponding target control parameter, storing the target control parameter in the target sensor sub-database;
[0044] When there is no corresponding target control parameter, sending feedback information to the management platform, receiving the target control parameter sent by the management platform in response to the feedback information, and storing the target control parameter in the target sensor sub-database;
[0045] The management platform is configured as follows:
[0046] Feedback information sent by the sensor network platform is received, target control parameters are acquired according to the feedback information, and the target control parameters are sent to the sensor network platform.
[0047] Optionally, the sensor database includes a first data table, which includes at least a unique identifier field of the work object, a device identifier field, a product field and a control parameter address field; the sensor sub-database includes a second data table, which includes a product field and a control parameter field.
[0048] On the other hand, an industrial Internet of Things data storage optimization device includes a memory and a processor, wherein the memory stores a computer program, and the processor executes the computer program to implement any of the above methods.
[0049] On the other hand, a computer-readable storage medium is provided. The device includes a memory and a processor. The memory stores a computer program. The processor executes the computer program to implement any of the above methods.
[0050] Compared with the prior art, the present invention has the following advantages and beneficial effects:
[0051] The present invention discloses an industrial Internet of Things data storage optimization method, which is used in an industrial Internet of Things system. The industrial Internet of Things system comprises a management platform, a sensor network platform and an object platform which establish communication in sequence. The sensor network platform comprises a sensor master database which communicates with the management platform and at least one sensor sub-database which communicates with the object platform. The sensor sub-database is matched one by one with a work object in the object platform. The method is executed by the sensor network platform, and comprises: acquiring and parsing a target task, and obtaining a target work object and a target requirement according to the target task; searching the sensor master database and / or the at least one sensor sub-database according to the target work object and the target requirement, and judging whether there is a target control parameter corresponding to the target requirement, wherein the target control parameter is used to control the target work object to complete the target requirement; when there is a corresponding target control parameter, storing the target control parameter in the target sensor sub-database; when there is no corresponding target control parameter, sending feedback information to the management platform, receiving the target control parameter sent by the management platform in response to the feedback information, and storing the target control parameter in the target sensor sub-database. At least it solves the problem that in the prior art, the control parameters are generally stored in the edge device, but the edge device generally has a small memory and cannot store too many control parameters, and there are still many control parameters that need to be stored in the cloud computing device. BRIEF DESCRIPTION OF THE DRAWINGS
[0052] In order to more clearly illustrate the specific implementation of the present application or the technical solution in the prior art, the following is a brief introduction to the drawings required for the specific implementation or the prior art description. In all drawings, similar elements or parts are generally identified by similar reference numerals. In the drawings, each element or part is not necessarily drawn according to the actual scale.
[0053] Figure 1 A schematic diagram of the process of the industrial Internet of Things data storage optimization method in this application;
[0054] Figure 2 A schematic diagram of the framework of the sensor network platform system involved in this application;
[0055] Figure 3 This is a schematic diagram of the framework of the Internet of Things system involved in this application;
[0056] Figure 4 This is a schematic diagram of the framework of the service platform involved in this application;
[0057] Figure 5 This is a schematic diagram of the equipment for the industrial Internet of Things data storage optimization method in this application.
[0058] Markings in the figure: 101 - processor, 102 - communication bus, 103 - network interface, 104 - user interface, 105 - memory.
[0059] The realization of the purpose, functional features and advantages of this application will be further explained in conjunction with embodiments and with reference to the accompanying drawings. DETAILED DESCRIPTION
[0060] In order to enable those skilled in the art to better understand the scheme of the present disclosure, the technical scheme in the embodiments of the present disclosure will be clearly and completely described below in conjunction with the drawings in the embodiments of the present disclosure. Obviously, the described embodiments are only part of the embodiments of the present disclosure, not all of the embodiments. Based on the embodiments in the present disclosure, all other embodiments obtained by ordinary technicians in the field without creative work should fall within the scope of protection of the present disclosure.
[0061] It should be noted that the terms "first", "second", etc. in the specification and claims of the present disclosure and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchangeable where appropriate, so that the embodiments of the present disclosure described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, system, product, or device that includes a series of steps or units is not necessarily limited to those steps or units that are clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products, or devices.
[0062] Example 1
[0063] like Figure 1 As shown, an industrial Internet of Things data storage optimization method is used in an industrial Internet of Things system. The industrial Internet of Things system includes a management platform, a sensor network platform and an object platform that establish communication in sequence. The sensor network platform includes a sensor general database that communicates with the management platform and at least one sensor sub-database that communicates with the object platform. The sensor sub-database is matched one-to-one with the working object in the object platform. Specifically, the working object can be a generating device, a monitoring device and other equipment;
[0064] The method is executed by a sensor network platform and includes:
[0065] S1. Obtain and analyze the target task, and obtain the target work object and target requirements according to the target task;
[0066] Specifically, the target work object belongs to the work object in the object platform;
[0067] Optionally, when the target task is a production task, the target demand includes the demand type and the demand quantity;
[0068] Optionally, the target task can be obtained through the management platform or directly input by the user;
[0069] Optionally, the target task can be structured data, such as:
[0070] |Object ID|Requirement Type|Requirement Quantity|
[0071] |--------|--------|----------|
[0072] |10010001|M5 nut|1000|;
[0073] According to the target task, the target work object is the equipment with ID 10010001, and the target demand is 1000 M5 nuts;
[0074] Optionally, the target task can also be unstructured data, such as: let the device with ID 10010001 produce 1000 M5 nuts; through NLP technology, the target task can also obtain the target work object as the device with ID 10010001, and the target demand is 1000 M5 nuts;
[0075] By adopting the above method, when a task is received, the task is parsed to obtain the work object and work content pointed to by the task.
[0076] S2. According to the target working object and the target demand, searching in the sensor general database and / or at least one sensor sub-database to determine whether there is a target control parameter corresponding to the target demand;
[0077] Specifically, the SQL language may be used to search in the sensor database and / or at least one sensor sub-database using the unique feature code of the target work object and the target requirement as search conditions;
[0078] Optionally, the unique feature code of the target work object may be an object ID or other feature code;
[0079] Through the above method, it is determined whether the system stores target control parameters for controlling the target work object to complete the target requirements;
[0080] Specifically, the target control parameters are used to control the target work object to complete the target requirements;
[0081] Optionally, searching in at least one sensor sub-database includes: searching in at least one sensor sub-database corresponding to other devices of the same model as the target device.
[0082] When there are corresponding target control parameters;
[0083] S3, storing the target control parameters in the target sensor sub-database;
[0084] Specifically, when there is a corresponding target control parameter, the target control parameter can be stored in the target sensor sub-database, the sensor master database or other sensor sub-databases. Since the sensor sub-databases and the working objects are matched one by one, if the target control parameter is stored in the target sensor sub-database, the target control parameter can be directly used, otherwise the target control parameter needs to be stored in the target sensor sub-database for use. The method of storing the target control parameter in the target sensor sub-database can be that other sensor sub-databases transfer the target control parameter through the sensor master database, or other sensor sub-databases directly send the target control parameter to the target sensor sub-database for transfer;
[0085] Optionally, when the target control parameter is obtained from other sensor sub-databases, after the target task is completed, the target control parameter stored in the target sub-database is deleted.
[0086] When there is no corresponding target control parameter;
[0087] S4. Send feedback information to the management platform, receive the target control parameters sent by the management platform in response to the feedback information, and store the target control parameters in the target sensor sub-database.
[0088] By adopting the above method, the sensor sub-database can be set up on the same device as the work object or on a device or device close to the position. When a target task is received, the sensor main database and the sensor sub-database are retrieved to obtain whether there are pre-configured target control parameters. If so, they are used directly, otherwise the target control parameters are obtained and stored. After storage, if other work objects need to use them, the target control parameters are sent to the sensor sub-databases corresponding to the other work objects.
[0089] Example 2
[0090] This embodiment is based on the first embodiment. An industrial Internet of Things data storage optimization method is used in an industrial Internet of Things system. The industrial Internet of Things system includes a management platform, a sensor network platform and an object platform that establish communication in sequence. The sensor network platform includes a sensor general database that communicates with the management platform and at least one sensor sub-database that communicates with the object platform. The sensor sub-database is matched one-to-one with the working object in the object platform. Specifically, the working object can be a generating device, a monitoring device and other equipment;
[0091] The method is executed by a sensor network platform and includes:
[0092] S1. Obtain and analyze the target task, and obtain the target work object and target requirements according to the target task;
[0093] S2. According to the target working object and the target demand, searching in the sensor general database and / or at least one sensor sub-database to determine whether there is a target control parameter corresponding to the target demand;
[0094] Optionally, according to the target work object and the target requirement, searching in the sensor general database and / or at least one sensor sub-database to determine whether there is a target control parameter corresponding to the target requirement includes:
[0095] According to the target demand, a target control parameter demand corresponding to the target demand is obtained;
[0096] According to the target work object, obtaining an identifier of the target work object, the identifier including at least one of a unique identifier and a device identifier;
[0097] According to the identifier and the target control parameter requirement, a search is performed in the sensor general database and / or at least one sensor sub-database to determine whether there is a target control parameter corresponding to the target requirement.
[0098] Specifically, the unique identifier of the target work object may be a device ID, and the device identifier may be a device name;
[0099] By adopting the above method, it is possible to search the sensor general database and / or at least one sensor sub-database through the device ID or device name to determine whether the target control parameter exists.
[0100] Optionally, the step of searching the sensor general database and / or at least one sensor sub-database according to the identifier and the target control parameter requirement to determine whether there is a target control parameter corresponding to the target requirement includes:
[0101] According to the unique identifier and the target control parameter requirement, searching in the sensor general database and / or at least one sensor sub-database to determine whether there is a target control parameter corresponding to the target requirement;
[0102] When there is no target control parameter corresponding to the target requirement, a search is performed in the sensor general database and / or at least one sensor sub-database based on the device identifier and the target control parameter requirement to determine whether there is a target control parameter corresponding to the target requirement.
[0103] By adopting the above method, the device ID or device name can be used to search in the sensor database and / or at least one sensor sub-database to determine whether the target control parameter exists, and the device ID can be used for matching first, which has better accuracy.
[0104] Specifically, the target control parameters are used to control the target work object to complete the target requirements;
[0105] When there are corresponding target control parameters;
[0106] S3, storing the target control parameters in the target sensor sub-database;
[0107] When there is no corresponding target control parameter;
[0108] S4. Send feedback information to the management platform, receive the target control parameters sent by the management platform in response to the feedback information, and store the target control parameters in the target sensor sub-database.
[0109] Optionally, the sensor database includes a first data table, which includes at least a unique identifier field for the work object, a device identifier field, a product field, and a control parameter address field.
[0110] According to the target work object and target demand, search in the sensor database to determine whether there are target control parameters corresponding to the target demand, including:
[0111] Obtaining a target device identifier of the target work object according to a unique identifier of the target work object;
[0112] According to the target device identifier, determine the product corresponding to the target device identifier;
[0113] According to the product corresponding to the target device identifier, determining whether the product corresponding to the target device identifier meets the target requirement;
[0114] When there are corresponding target control parameters, the target control parameters are stored in the target sensor sub-database, including:
[0115] When the target requirement is met, the target control parameter address corresponding to the target requirement is obtained;
[0116] Obtain the corresponding target control parameter according to the target control parameter address, and store the target control parameter in the target sensor sub-database;
[0117] When there is no corresponding target control parameter, sending feedback information to the management platform, receiving the target control parameter sent by the management platform in response to the feedback information, and storing the target control parameter in the target sensor sub-database, including:
[0118] When the target requirements are not met, feedback information is sent to the management platform, target control parameters sent by the management platform in response to the feedback information are received, and the target control parameters are stored in the target sensor sub-database;
[0119] The products corresponding to the target demand are written into the first data table.
[0120] Specifically, in this solution, the sensor master database only stores the first data table but not the specific control parameters. The specific control parameters are stored in each sensor sub-database. Specifically, an example of a first data table is shown in Table 1:
[0121] Table 1:
[0122]
[0123] Among them, sensor sub-database A is the sensor sub-database corresponding to the work object with ID 10010001, sensor sub-database B is the sensor sub-database corresponding to the work object with ID 10010002, sensor sub-database C is the sensor sub-database corresponding to the work object with ID 10020001, and sensor sub-database D is the sensor sub-database corresponding to the work object with ID 10020002; it should be noted that, although the sensor sub-databases correspond to the work objects one-to-one, the control instructions for controlling device A to produce product C may be the same as the control instructions for controlling device B to produce product C, so the control instructions for controlling device A to produce product C may also be stored in the sensor sub-database B, and transferred through the sensor master database for use when needed;
[0124] When the target task is: the work object with ID 10010001 produces 1000 pieces of product C, according to the target work object and target demand, search in the sensor database to determine whether there is a target control parameter corresponding to the target demand;
[0125] When there are corresponding target control parameters, the target control parameters are stored in the target sensor sub-database;
[0126] When there is no corresponding target control parameter, the steps of sending feedback information to the management platform, receiving the target control parameter sent by the management platform in response to the feedback information, and storing the target control parameter in the target sensor sub-database include:
[0127] According to the unique identifier 10010001 of the target working object, the target device identifier of the target working object is obtained as device A;
[0128] According to the target device identifier, it is determined that the products corresponding to the target device identifier include product A, product B, and product C;
[0129] According to the product corresponding to the target device identifier, determine whether the product corresponding to the target device identifier meets the target demand. The target demand is 1,000 pieces of product C. The target demand includes the demand type and the demand quantity. Since the demand quantity does not affect the control parameters, the demand type is product C.
[0130] When the target demand is met, the target control parameter address corresponding to the product C corresponding to the target demand is obtained as the sensor sub-database B;
[0131] Obtain the corresponding target control parameter according to the target control parameter address, and store the target control parameter in the target sensor sub-database, i.e., the sensor sub-database A;
[0132] Optionally, when the target control parameter is obtained from other sensor sub-databases, after the target task is completed, the target control parameter stored in the target sub-database is deleted.
[0133] If the target task is: when the work object with ID 10010001 produces 1000 pieces of product D, when the target demand is not met, feedback information is sent to the management platform, the target control parameters sent by the management platform in response to the feedback information are received, and the target control parameters are stored in the target sensor sub-database and the sensor sub-data A;
[0134] The products corresponding to the target demand are written into the first data table, and Table 2 is obtained as the updated first data table:
[0135] Table 2:
[0136]
[0137] Optionally, the first data table may also be split into two interrelated tables, a third data table and a fourth data table, wherein the third data table is used to indicate the correspondence between the unique identifier and the device identifier, and the fourth data table is used to indicate the relationship between the device identifier and the demand and control parameter address.
[0138] Optionally, the sensor sub-database includes a second data table, and the second data table includes a product field and a control parameter field;
[0139] Since a sensor sub-database may store multiple control parameters, such as the control parameters of product A and product B corresponding to device A are stored in sensor sub-database A, it is necessary to use a second data table to record the product field and control parameter field.
[0140] By adopting the above method, different control parameters are stored in each sensor sub-database in a distributed storage manner, without the need to store too many control parameters in one sensor sub-database, which effectively alleviates the storage pressure of the system.
[0141] Optionally, also include:
[0142] The data volume of the control parameters stored in the target sensor sub-database is obtained, and when the data volume of the control parameters stored in the target sensor sub-database is greater than the average data volume of the control parameters stored in at least one sensor sub-database, at least one control parameter stored in the target sensor sub-database is transferred to other sensor sub-databases with the same device identifier.
[0143] The above scheme can effectively balance the amount of data in each sensor sub-database;
[0144] Optionally, the step of obtaining the data volume of the control parameters stored in the target sensor sub-database, and when the data volume of the control parameters stored in the target sensor sub-database is greater than the average data volume of the control parameters stored in at least one sensor sub-database, transferring at least one control parameter stored in the target sensor sub-database to another sensor sub-database with the same device identifier comprises:
[0145] The data volume of the control parameters stored in the target sensor sub-database is obtained. When the data volume of the control parameters stored in the target sensor sub-database is greater than the average data volume of the control parameters stored in at least one sensor sub-database, the sequence of the control parameters with the lowest frequency of use in the target sensor sub-database is obtained, and at least one control parameter is transferred to other sensor sub-databases with the same device identifier according to the sequence. The above scheme can ensure that the control parameters commonly used by the corresponding working objects are stored in the sensor sub-databases, and the control parameters with the frequency of use of the corresponding working objects will be preferentially transferred to other sensor sub-databases.
[0146] Optionally, the target control parameters also include target verification parameters for verifying whether the target working object is working normally;
[0147] After storing the target control parameters in the target sensor database, it also includes:
[0148] Receive and store the target operation log of the target work object;
[0149] According to the target operation log and the target verification parameters, the target operation status of the target work object is obtained;
[0150] According to the target operating state, when the target operating state is inconsistent with the expected operating state, a communication link between the target work object and the management platform is established.
[0151] By adopting the above solution, it is possible to quickly monitor whether the work object is working normally during the production process.
[0152] Optionally, the first data table further includes an access method field, in which a target access method allowed by the target work object is stored;
[0153] The steps of establishing a communication link between the target work object and the management platform include:
[0154] Sending a communication request to the management platform, and receiving an access mode sequence fed back by the management platform in response to the communication request;
[0155] According to the access method sequence and the target access method, a communication link is established between the target work object and the management platform.
[0156] Optionally, when a corresponding target control parameter exists, a step of storing the target control parameter in a target sensor sub-database; when the target control parameter is stored in other sensor sub-databases instead of the target sensor sub-database, obtaining access methods allowed by the target sensor sub-database and the other sensor sub-databases, establishing a connection between the target sensor sub-database and the other sensor sub-databases according to the access methods allowed by the target sensor sub-database and the other sensor sub-databases, and sending the target control parameter to the target sensor sub-database through the connection.
[0157] The steps of establishing a connection between the target sensor sub-database and other sensor sub-databases according to the access modes allowed by the target sensor sub-database and other sensor sub-databases include:
[0158] Obtaining the allowed access modes of the target sensor sub-database and other sensor sub-databases, and determining the bandwidth margin, network delay and signal quality of different access modes according to the target sensor sub-database and other sensor sub-databases;
[0159] The connection between the target sensor sub-database and other sensor sub-databases is established according to the communication requirements, bandwidth margin, network delay and signal quality.
[0160] Example 3
[0161] An industrial Internet of Things data storage optimization system includes a management platform, a sensor network platform and an object platform that establish communication in sequence, the sensor network platform includes a sensor master database that communicates with the management platform and at least one sensor sub-database that communicates with the object platform, and the sensor sub-database is matched one by one with a working object in the object platform;
[0162] The sensor network platform is configured as follows:
[0163] Obtain and parse the target tasks, and obtain the target work objects and target requirements based on the target tasks;
[0164] According to the target work object and the target demand, searching in the sensor general database and / or at least one sensor sub-database to determine whether there is a target control parameter corresponding to the target demand, the target control parameter is used to control the target work object to complete the target demand;
[0165] When there are corresponding target control parameters, the target control parameters are stored in the target sensor sub-database;
[0166] When there is no corresponding target control parameter, sending feedback information to the management platform, receiving the target control parameter sent by the management platform in response to the feedback information, and storing the target control parameter in the target sensor sub-database;
[0167] The management platform is configured as:
[0168] Receive feedback information sent by the sensor network platform, obtain target control parameters corresponding to the feedback information, and send the target control parameters to the sensor network platform.
[0169] Optionally, the sensor database includes a first data table, which includes at least a unique identifier field of the work object, a device identifier field, a product field and a control parameter address field, and the sensor sub-database includes a second data table, which includes a product field and a control parameter field.
[0170] Specifically, Figure 2 As shown, an industrial Internet of Things data storage optimization system includes: a sensor network platform and a management platform and an object platform connected to the sensor network platform, the sensor network platform includes a sensor main database, n sensor sub-databases communicating with the sensor main database, and a sensor network sub-platform matched one-to-one with the sensor sub-databases, the sensor network sub-platform is configured to perform operations related to the corresponding sensor sub-databases, the object platform includes work objects matched one-to-one with the n sensor sub-databases, the target sensor sub-database belongs to one of the n sensor sub-databases, and the target work object belongs to one of the n work objects in the object platform.
[0171] Example 4
[0172] like Figure 3 As shown, this embodiment is based on Embodiment 2, an industrial Internet of Things data storage optimization system, including a user platform, a service platform, a management platform, a sensor network platform and an object platform that establish communication in sequence;
[0173] The user platform is configured to provide front-end service functions to users; users obtain the required perceived service information through the user platform, process the perceived service information, and convert it into user perceived information; users analyze the user perceived information and make corresponding decisions based on their own wishes, and convert the user perceived information into user control information through the corresponding information system and send it to the service platform, thereby expressing the user's corresponding service demand intention.
[0174] The physical entities of the user platform include various user terminals, such as mobile phones, computers, special terminals, etc., which realize user-side services through integration with user information system software.
[0175] The service platform is configured as an API server or other server used to establish communication between the management platform and the user platform to implement corresponding functions; the physical entity of the service platform includes various servers.
[0176] The management platform is configured to perform at least one of equipment operation status monitoring management, data monitoring management, equipment parameter management, and life cycle management; the management platform is an operational coordination platform for the Internet of Things, which may include various management sub-platforms, and different management sub-platforms perform different management services; the physical entities of the management platform include various servers.
[0177] The sensor network platform is configured to perform at least one of network management, command management, device status management, data protocol management, data analysis, data classification, data transmission monitoring, and data transmission security management. The sensor network platform provides data communication, analysis, identification, classification, and other functions, avoiding the direct aggregation of data from various object platforms on the management platform, resulting in redundant data on the management platform and low data processing efficiency; the physical entities of the object platform include various gateways, edge computing devices, etc.
[0178] The object platform is configured to carry out specific production work such as production control, detection, and measurement; the physical entities of the work objects include various production equipment, sensors, etc.
[0179] Optionally, the service platform includes a service master database communicating with the management platform, and at least one service sub-platform communicating with the service platform master database and the user platform, and the service sub-platform includes a service sub-database;
[0180] Optionally, each service sub-platform corresponds to an API function or API server;
[0181] Specifically, Figure 4 As shown, the service platform includes a service master database communicating with the user platform, n service sub-databases communicating with the service master database and the management platform, and service sub-platforms matching one-to-one with the service sub-databases.
[0182] Example 5
[0183] This embodiment provides an industrial Internet of Things data storage optimization device, which includes a memory and a processor. The memory stores a computer program, and the processor executes the computer program to implement any of the above methods.
[0184] Specifically, Figure 5 As shown, Figure 5This is a schematic diagram of the device structure of the hardware operating environment involved in the embodiment of the present application. The device is an electronic device and may include: a processor 101, such as a central processing unit (CPU), a communication bus 102, a user interface 104, a network interface 103, and a memory 105. Among them, the communication bus 102 is used to realize the connection and communication between these components. The user interface 104 may include a display screen (Display), an input unit such as a keyboard (Keyboard), and the user interface 104 may also include a standard wired interface and a wireless interface. The network interface 103 may optionally include a standard wired interface and a wireless interface (such as a wireless fidelity (WIreless-FIdelity, WI-FI) interface). The memory 105 may optionally be a storage device independent of the aforementioned processor 101. The memory 105 may be a high-speed random access memory (RAM) memory, or it may be a stable non-volatile memory (NVM), such as at least one disk storage. The processor 101 may be a general-purpose processor, including a central processing unit, a network processor, etc., or it may be a digital signal processor, an application-specific integrated circuit, a field programmable gate array or other programmable logic device, a discrete gate or transistor logic device, or a discrete hardware component.
[0185] Those skilled in the art will appreciate that Figure 5 The structure shown in the figure does not constitute a limitation on the electronic device, and may include more or less components than shown in the figure, or combine certain components, or arrange the components differently.
[0186] like Figure 5 As shown, the memory 105 as a storage medium may include an operating system, a network communication module, a user interface module, and an application program for implementing an industrial Internet of Things data storage optimization method.
[0187] exist Figure 5 In the electronic device shown, the network interface 103 is mainly used for data communication with a network server; the user interface 104 is mainly used for data interaction with a user; the processor 101 and the memory 105 in the present application can be set in the electronic device, and the electronic device calls the application program stored in the memory 105 for implementing an industrial Internet of Things data storage optimization method through the processor 101 to implement the above method.
[0188] Example 6
[0189] This embodiment provides a computer-readable storage medium, on which a computer program is stored, and a processor executes the computer program to implement any of the above methods.
[0190] In some embodiments, the computer readable storage medium may be a memory such as FRAM, ROM, PROM, EPROM, EEPROM, flash memory, magnetic surface memory, optical disk, or CD-ROM; or various devices including one or any combination of the above memories. The computer may be various computing devices including intelligent terminals and servers.
[0191] In the above embodiments of the present disclosure, the description of each embodiment has its own emphasis. For parts that are not described in detail in a certain embodiment, reference can be made to the relevant descriptions of other embodiments.
[0192] In the several embodiments provided in this application, it should be understood that the disclosed technical content can be implemented in other ways. Among them, the device embodiments described above are only schematic. For example, the division of units can be a logical function division. There may be other division methods in actual implementation. For example, multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of units or modules, which can be electrical or other forms.
[0193] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed over multiple units. Some or all of the units may be selected according to actual needs to achieve the purpose of the present embodiment.
[0194] In addition, each functional unit in each embodiment of the present disclosure may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of software functional units.
[0195] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable non-volatile storage medium. Based on this understanding, the technical solution of the present disclosure is essentially or the part that contributes to the prior art or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a non-volatile storage medium, including a number of instructions to enable a device (which can be a personal computer, server or network device, etc.) to perform all or part of the steps of the various embodiments of the present disclosure. The aforementioned non-volatile storage medium includes: U disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), mobile hard disk, disk or optical disk and other media that can store program codes.
[0196] The above are only preferred embodiments of the present disclosure. It should be pointed out that, for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the principles of the present disclosure. These improvements and modifications should also be regarded as the protection scope of the present disclosure.
Claims
1. An industrial Internet of Things data storage optimization method, characterized in that: For an industrial Internet of Things system, the industrial Internet of Things system includes a management platform, a sensor network platform and an object platform that establish communication in sequence, the sensor network platform includes a sensor master database that communicates with the management platform and at least one sensor sub-database that communicates with the object platform, the sensor sub-database is matched one-to-one with a working object in the object platform, and the method is executed by the sensor network platform, including: Obtain and analyze the target task, and obtain the target work object and target requirements according to the target task; According to the target work object and the target requirement, searching the sensor master database and / or the at least one sensor sub-database to determine whether there is a target control parameter corresponding to the target requirement, the target control parameter being used to control the target work object to complete the target requirement; When there is a corresponding target control parameter, storing the target control parameter in the target sensor sub-database; When there is no corresponding target control parameter, sending feedback information to the management platform, receiving the target control parameter sent by the management platform in response to the feedback information, and storing the target control parameter in the target sensor sub-database; The sensor database includes a first data table, which includes at least a unique identifier field for a work object, a device identifier field, a product field, and a control parameter address field. The step of searching the sensor database according to the target working object and the target requirement to determine whether there is a target control parameter corresponding to the target requirement includes: Acquire a target device identifier of the target work object according to the unique identifier of the target work object; Determine, according to the target device identifier, a product corresponding to the target device identifier; According to the product corresponding to the target device identifier, determining whether the product corresponding to the target device identifier meets the target requirement; When a corresponding target control parameter exists, storing the target control parameter in the target sensor sub-database includes: When the target requirement is met, obtaining a target control parameter address corresponding to the target requirement; Obtaining a corresponding target control parameter according to the target control parameter address, and storing the target control parameter in the target sensor sub-database; When there is no corresponding target control parameter, sending feedback information to the management platform, receiving the target control parameter sent by the management platform in response to the feedback information, and storing the target control parameter in the target sensor sub-database, comprises: When the target requirement is not met, sending feedback information to the management platform, receiving the target control parameter sent by the management platform in response to the feedback information, and storing the target control parameter in the target sensor sub-database; Writing the products corresponding to the target demand into the first data table; Also includes: acquiring a data volume of the control parameters stored in the target sensor sub-database, and when the data volume of the control parameters stored in the target sensor sub-database is greater than an average data volume of the control parameters stored in at least one sensor sub-database, transferring at least one control parameter stored in the target sensor sub-database to another sensor sub-database with the same device identifier; The sensor database includes a first data table, which includes at least a unique identifier field for the work object, a device identifier field, a product field and a control parameter address field. The sensor sub-database includes a second data table, which includes a product field and a control parameter field.
2. The method for optimizing data storage in industrial Internet of Things according to claim 1, characterized in that: The step of searching the sensor master database and / or the at least one sensor sub-database according to the target working object and the target requirement to determine whether there is a target control parameter corresponding to the target requirement includes: According to the target requirement, a target control parameter requirement corresponding to the target requirement is obtained, where the target control parameter requirement is configured as a requirement for a control parameter used to control a target work object to achieve the target requirement; According to the target work object, obtaining an identifier of the target work object, wherein the identifier includes at least one of a unique identifier and a device identifier; According to the identifier and the target control parameter requirement, a search is performed in the sensor master database and / or the at least one sensor sub-database to determine whether there is a target control parameter corresponding to the target requirement.
3. The method for optimizing data storage in industrial Internet of Things according to claim 2, characterized in that: The step of searching the sensor master database and / or the at least one sensor sub-database according to the identifier and the target control parameter requirement to determine whether there is a target control parameter corresponding to the target requirement includes: According to the unique identifier and the target control parameter requirement, searching the sensor master database and / or the at least one sensor sub-database to determine whether there is a target control parameter corresponding to the target requirement; When there is no target control parameter corresponding to the target requirement, the sensor master database and / or the at least one sensor sub-database are searched according to the device identifier and the target control parameter requirement to determine whether there is a target control parameter corresponding to the target requirement.
4. The method for optimizing data storage in industrial Internet of Things according to claim 1, characterized in that: The target control parameters also include target verification parameters for verifying whether the target working object is working normally; After storing the target control parameters in the target sensor sub-database, the method further includes: Receive and store the target operation log of the target work object; Obtaining a target operation state of the target work object according to the target operation log and the target verification parameter; According to the target operating state, when the target operating state is inconsistent with the expected operating state, a communication link between the target work object and the management platform is established.
5. The method for optimizing data storage in industrial Internet of Things according to claim 4, characterized in that: The first data table further includes an access mode field, in which the target access mode allowed by the target work object is stored; The step of establishing a communication link between the target work object and the management platform includes: Sending a communication request to the management platform, and receiving an access mode sequence fed back by the management platform in response to the communication request; According to the access method sequence and the target access method, a communication link between the target work object and the management platform is established.
6. An industrial Internet of Things data storage optimization system, characterized in that: The method comprises establishing a management platform, a sensor network platform and an object platform in sequence, wherein the sensor network platform comprises a sensor master database communicating with the management platform and at least one sensor sub-database communicating with the object platform, wherein the sensor sub-databases are matched one by one with the working objects in the object platform; The sensor network platform is configured as follows: Obtain and analyze the target task, and obtain the target work object and target requirements according to the target task; According to the target work object and the target requirement, searching the sensor master database and / or the at least one sensor sub-database to determine whether there is a target control parameter corresponding to the target requirement, the target control parameter being used to control the target work object to complete the target requirement; When there is a corresponding target control parameter, storing the target control parameter in the target sensor sub-database; When there is no corresponding target control parameter, sending feedback information to the management platform, receiving the target control parameter sent by the management platform in response to the feedback information, and storing the target control parameter in the target sensor sub-database; The sensor database includes a first data table, which includes at least a unique identifier field for a work object, a device identifier field, a product field, and a control parameter address field. The step of searching the sensor database according to the target working object and the target requirement to determine whether there is a target control parameter corresponding to the target requirement includes: Acquire a target device identifier of the target work object according to the unique identifier of the target work object; Determine, according to the target device identifier, a product corresponding to the target device identifier; According to the product corresponding to the target device identifier, determining whether the product corresponding to the target device identifier meets the target requirement; When a corresponding target control parameter exists, storing the target control parameter in the target sensor sub-database includes: When the target requirement is met, obtaining a target control parameter address corresponding to the target requirement; Obtaining a corresponding target control parameter according to the target control parameter address, and storing the target control parameter in the target sensor sub-database; When there is no corresponding target control parameter, sending feedback information to the management platform, receiving the target control parameter sent by the management platform in response to the feedback information, and storing the target control parameter in the target sensor sub-database, comprises: When the target requirement is not met, sending feedback information to the management platform, receiving the target control parameter sent by the management platform in response to the feedback information, and storing the target control parameter in the target sensor sub-database; Writing the products corresponding to the target demand into the first data table; Also includes: Acquiring the data volume of the control parameters stored in the target sensor sub-database, and when the data volume of the control parameters stored in the target sensor sub-database is greater than the average data volume of the control parameters stored in at least one sensor sub-database, transferring at least one control parameter stored in the target sensor sub-database to other sensor sub-databases with the same device identifier; The sensor database includes a first data table, the first data table includes at least a unique identifier field of the work object, a device identifier field, a product field and a control parameter address field, and the sensor sub-database includes a second data table, the second data table includes a product field and a control parameter field; The management platform is configured as follows: Feedback information sent by the sensor network platform is received, target control parameters are acquired according to the feedback information, and the target control parameters are sent to the sensor network platform.
7. An industrial Internet of Things data storage optimization device, characterized in that: The device comprises a memory and a processor, wherein a computer program is stored in the memory, and the processor executes the computer program to implement the method according to any one of claims 1 to 5.
