Internet of Things monitoring analysis method and system of cold chain system based on BI

Abstract

The invention provides an Internet of Things monitoring analysis method and system of a BI-based cold chain system, and the method comprises the steps: transmitting user side data to a cloud server through a trusted authentication device, and storing the user side data as different meta-databases as the basic data of data analysis after the user side data is processed by the cloud server; and the cloud server creates a report template and fills the report template with corresponding metadata according to the analysis request of the user or the subscription of the user so as to generate a report and display the report to the user. According to the invention, the security of user side data can be ensured; a corresponding report can be quickly generated according to an analysis request of a user side; meanwhile, when the existing report template cannot meet the analysis request of the user side or the user has a customized analysis request, a new report template can be quickly created, the analysis request of the user is comprehensively displayed, and interaction with the user side is enhanced.

Description

Technical Field

[0001] The present invention relates to the field of industrial control, and in particular to an Internet of Things monitoring and analysis method and system for a cold chain system based on BI. Background Art

[0002] Cold chain logistics refers to a systematic project that keeps refrigerated and frozen foods in a specified low-temperature environment during production, storage, transportation, sales, and before consumption, in order to ensure food quality and reduce food loss. It was established with the advancement of science and technology and the development of refrigeration technology. It is a low-temperature logistics process based on freezing technology and using refrigeration technology as a means.

[0003] The new BI-based cloud platform IoT monitoring system is a data deep mining system for the cloud center of the monitoring system. The data is captured from the cloud center system to the data warehouse, and after data cleaning and other work, it presents the reports required by customers. These reports help to make reference content for food safety, energy-saving control and other aspects, and users can adjust the cold chain equipment according to the report results.

[0004] Currently, there is no cold chain data analysis cloud platform in the market that specializes in specific areas, and customers’ data is not allowed to be put on public platforms for data analysis. In addition, the existing data analysis cloud platforms not only require the technical staff to have professional debugging skills, but also require users to have certain data analysis capabilities, and the interactive functions are poor. Summary of the invention

[0005] To solve the above problems, the present invention proposes an Internet of Things monitoring and analysis method and system for a cold chain system based on BI.

[0006] The main contents of the present invention include:

[0007] The IoT monitoring and analysis method of the cold chain system based on BI includes the following steps:

[0008] The user-side data is transmitted to a trusted authentication device, which sets access rights for the user-side data according to its type, and encapsulates it into encrypted data and transmits it to a cloud server; the cloud server processes the received data according to different data types and stores it in different metadata libraries;

[0009] The cloud server receives and analyzes the user's analysis request through the authentication device, or the cloud server obtains the corresponding report template according to the user's subscription; the analysis request at least includes the analysis subject name and / or customized information;

[0010] The cloud server obtains corresponding metadata from the associated metadata database according to the corresponding report template and fills it into the report template, generates the corresponding report and transmits it to the user;

[0011] Preferably, the user-side data includes data collected by local monitoring equipment and data read via an API.

[0012] Preferably, the cloud server receives and analyzes the user's analysis request through the authentication device, and obtains the corresponding report template, including:

[0013] The authentication device authenticates the user who issued the analysis request. If the authentication is successful, the analysis request is transmitted to the cloud server; if the authentication is unsuccessful, the analysis request is rejected.

[0014] The cloud server parses the received analysis request and creates a corresponding report template.

[0015] Preferably, the cloud server parses the received analysis request and creates a corresponding report template, including:

[0016] The cloud server parses the received analysis request to obtain a corresponding topic name, and obtains a data item category to be included in the analysis request through a large language model according to the topic name;

[0017] The cloud server searches for a report template that matches the data item category to be included and has the largest number of matches in a preset report module library, and uses the template as the current report template.

[0018] Preferably, the cloud server finds out the data item categories required to be included in the analysis request but not included in the table items included in the current report template, and sends a prompt to the user to start a new template;

[0019] Based on the user's feedback, the cloud server fills the corresponding metadata into the current report template to generate the report;

[0020] Or the cloud server creates a new report template based on user feedback, fills the corresponding metadata into the new report template, generates the report and transmits it to the user.

[0021] Preferably, the server creates a new report template based on the user's feedback, and fills the corresponding metadata into the new report template, including:

[0022] After the user confirms the prompt to start the new template, the cloud server sets an item name for the newly added item and / or prompts the user to create an item name for the newly added item;

[0023] The cloud server associates the newly added table item name with the corresponding metadata, and combines the newly added table item name with the current report template to obtain a new report template.

[0024] Preferably, after obtaining the corresponding report template, the cloud server selects corresponding metadata from the corresponding metadata database and fills it into the report template according to the customized information in the analysis request;

[0025] The customized information includes device-specific and / or time-specific data.

[0026] The present invention also proposes an Internet of Things monitoring and analysis system for a cold chain system based on BI, including a cloud server, an authentication device and a terminal; the authentication device transmits the analysis request transmitted by the terminal to the cloud server after identity identification, authority setting and encryption, and the cloud server parses the analysis request, creates a corresponding report template, fills in the corresponding metadata in the report template, generates a corresponding report and transmits it to the terminal.

[0027] Preferably, the cloud server includes a report template library, a report development module and a report generation module, and the report development module includes a developer design unit and a user customization unit;

[0028] The user customization unit customizes the report template through natural language or graphical customization pages; the developer design unit is used for developers to develop general or user-customized report templates, and the developed report templates are stored in the report template library;

[0029] The report generation module is used to associate the table items newly added by the user with the corresponding metadata, and to generate a new report template by combining the report template in the report template library with the single table item customized by the user.

[0030] Preferably, the terminal includes monitoring equipment and data acquisition software.

[0031] Compared with the prior art, the present invention proposes an Internet of Things monitoring and analysis method and system for a cold chain system based on BI, which realizes identity authentication between a cloud server and a user side through a trusted authentication device, thereby ensuring the security of user side data; by storing user side data as different metadata, corresponding reports can be quickly generated according to the analysis requests of the user side; at the same time, when the existing report template cannot meet the analysis requests of the user side or the user has a customized analysis request, a new report template can be quickly created to fully display the user's analysis request, thereby enhancing the interaction with the user side. BRIEF DESCRIPTION OF THE DRAWINGS

[0032] Figure 1 It is a functional block diagram of the present invention. DETAILED DESCRIPTION

[0033] The technical solution protected by the present invention is described in detail below with reference to the accompanying drawings.

[0034] The present invention proposes an Internet of Things monitoring and analysis system for a cold chain system based on BI, including a cloud server, an authentication device and a terminal; the terminal includes monitoring equipment and data acquisition software for generating basic data to be analyzed, the authentication device can be a trusted server, and the cloud server obtains the user-side data generated by the terminal through two modes: database reading and API reading; the server processes the received user-side data according to the data type and stores it as different metadata databases to facilitate subsequent data analysis.

[0035] Specifically, for the basic data generated on the user side, the authentication device sets corresponding access permissions for these data, and transmits them to the cloud server after encryption to ensure the security of data transmission; for analysis requests on the user side, the authentication device only forwards analysis requests of users who have passed identity identification, thereby ensuring the security of data storage on the user side.

[0036] The cloud server can transmit the corresponding report to the user side according to the analysis request of the terminal, and can also send the customized report regularly according to the subscription of the user side. In the present invention, the cloud server includes a report template library, a report development module and a report generation module, and the report development module includes a developer design unit and a user customization unit; wherein the user customization unit customizes the report template through natural language or graphical customization page; the developer design unit is used for developers to develop general or user-customized report templates, and the developed report templates are stored in the report template library; the report generation module is used to associate the table items newly added by the user with the corresponding metadata, and combine the report template in the report template library with the single table item customized by the user to generate a new report template.

[0037] See also Figure 1 The BI-based IoT monitoring and analysis method for cold chain systems proposed in the present invention includes two major steps: the collection and processing of basic data for analysis and the generation of data analysis results. The collection step of basic data for analysis includes: the user-side data is transmitted to a trusted authentication device, and the authentication device sets access rights for the user-side data according to the type of the user-side data, and encapsulates the data into encrypted data and transmits it to a cloud server; the cloud server processes the received data and stores it as different metadata databases according to different data types.

[0038] The steps for generating data analysis results are as follows:

[0039] The cloud server receives and parses the user's analysis request through the authentication device, and obtains the corresponding report template; the analysis request includes at least the analysis subject name and / or customized information; the user can use natural language or specific query statements to issue an analysis request, and the cloud server uses a large language model to obtain the subject name in the analysis request, and returns the corresponding report template based on the subject name. The report template may be fully adapted to the analysis request, that is, the table items of the report template can meet the requirements of the analysis request, that is, the categories of data items that the analysis request wants to present can be included in the table items of the report template or correspond one-to-one with the table items of the report template. At this time, the cloud server can obtain specific metadata set by the user from the metadata database associated with the table items in the report template, such as user-side data generated by a specific time period or specific equipment / software, and fill it into the selected report template to obtain the corresponding report.

[0040] In other embodiments, after parsing the analysis request, the cloud server searches for a report template that matches the most data item categories required by the analysis request, but there are still some data items that have no corresponding table entries in the selected report template. At this time, the cloud server can prompt the user to start a new template; that is, confirm with the user whether to use the selected report template. If the user confirms, the corresponding metadata is directly filled in the currently selected report template to generate a report.

[0041] In other embodiments, the user may also modify the current report template or add new items to create a new report template. Specifically, after the user confirms the prompt to start a new template, the cloud server sets an item name for the newly added item and / or prompts the user to create an item name for the newly added item; the cloud server associates the newly added item name with the corresponding metadata, and combines the newly added item name with the current report template to obtain a new report template.

[0042] In one of the embodiments, the cloud server can also send corresponding analysis results to users on a regular basis according to the user's subscription. The user can choose to subscribe to the report template developed by the developer, or customize the personalized report template through the user customization unit and the report generation module. The cloud server saves the customized report template for the corresponding user and provides reports on a regular basis, thereby increasing the interactivity with the user.

[0043] The above descriptions are merely embodiments of the present invention and are not intended to limit the patent scope of the present invention. Any equivalent structure or equivalent process transformation made using the contents of the specification and drawings of the present invention, or directly or indirectly applied in other related technical fields, are also included in the patent protection scope of the present invention.

Claims

1. The IoT monitoring and analysis method of cold chain system based on BI is characterized by: The steps include: The user-side data is transmitted to a trusted authentication device, which sets access rights for the user-side data according to its type, and encapsulates it into encrypted data and transmits it to a cloud server; the cloud server processes the received data according to different data types and stores it in different metadata libraries; The cloud server receives and analyzes the user's analysis request through the authentication device, or the cloud server obtains the corresponding report template according to the user's subscription; the analysis request at least includes the analysis subject name and / or customized information; The cloud server obtains corresponding metadata from the associated metadata database according to the corresponding report template and fills it into the report template, generates the corresponding report and transmits it to the user.

2. The Internet of Things monitoring and analysis method for a cold chain system based on BI according to claim 1 is characterized in that: User-side data includes data collected by local monitoring devices and data read through API.

3. The Internet of Things monitoring and analysis method for cold chain system based on BI according to claim 1 is characterized in that: The cloud server receives and analyzes the user's analysis request through the authentication device and obtains the corresponding report template, including: The authentication device authenticates the user who issued the analysis request. If the authentication is successful, the analysis request is transmitted to the cloud server; if the authentication is unsuccessful, the analysis request is rejected. The cloud server parses the received analysis request and creates a corresponding report template.

4. The Internet of Things monitoring and analysis method for a cold chain system based on BI according to claim 3 is characterized in that: The cloud server parses the received analysis request and creates the corresponding report template. include, The cloud server parses the received analysis request to obtain a corresponding topic name, and obtains a data item category to be included in the analysis request through a large language model according to the topic name; The cloud server searches for a report template that matches the data item category to be included and has the largest number of matches in a preset report module library, and uses the template as the current report template.

5. The Internet of Things monitoring and analysis method for a cold chain system based on BI according to claim 4 is characterized in that: The cloud server finds out the data item categories required by the analysis request but not included in the table items included in the current report template, and sends a prompt to the user to start a new template; Based on the user's feedback, the cloud server fills the corresponding metadata into the current report template to generate the report; Or the cloud server creates a new report template based on user feedback, fills the corresponding metadata into the new report template, generates the report and transmits it to the user.

6. The Internet of Things monitoring and analysis method for cold chain system based on BI according to claim 5 is characterized in that: The server creates a new report template based on user feedback and fills the corresponding metadata into the new report template, including: After the user confirms the prompt to start the new template, the cloud server sets an item name for the newly added item and / or prompts the user to create an item name for the newly added item; The cloud server associates the newly added table item name with the corresponding metadata, and combines the newly added table item name with the current report template to obtain a new report template.

7. The Internet of Things monitoring and analysis method for cold chain system based on BI according to claim 4 is characterized in that: After the cloud server obtains the corresponding report template, it selects corresponding metadata from the corresponding metadata database and fills it into the report template according to the customized information in the analysis request; The customized information includes device-specific and / or time-specific data.

8. The IoT monitoring and analysis system of the cold chain system based on BI is characterized by: It includes a cloud server, an authentication device and a terminal; the authentication device transmits the analysis request transmitted by the terminal and the user-side data generated by the terminal to the cloud server after identity recognition, permission setting and encryption; The cloud server stores the user-side data as different metadata databases, parses the analysis request, creates a corresponding report template, fills the corresponding metadata in the report template, generates a corresponding report and transmits it to the terminal.

9. The Internet of Things monitoring and analysis system for cold chain systems based on BI according to claim 8 is characterized in that: The cloud server includes a report template library, a report development module and a report generation module, wherein the report development module includes a developer design unit and a user customization unit; The user customization unit customizes the report template through natural language or graphical customization pages; The developer design unit is used for developers to develop general or user-customized report templates, and the developed report templates are stored in the report template library; The report generation module is used to associate the table items newly added by the user with the corresponding metadata, and to generate a new report template by combining the report template in the report template library with the single table item customized by the user.

10. The Internet of Things monitoring and analysis system for cold chain system based on BI according to claim 8, characterized in that: The terminal includes monitoring equipment and data acquisition software.

Images