Automatic college data filling method based on Internet of Things equipment

Collect and preprocess university data through IoT devices, and use blockchain and Apriori algorithm to realize automatic data filling, solving the problem of time-consuming and labor-intensive traditional data filling methods and insufficient data correlation analysis, and improving the efficiency of data collection and filling accuracy.

CN119005146APending Publication Date: 2024-11-22NUOSTAR (GUANGZHOU) INFORMATION TECH CO LTD
View PDF 6 Cites 0 Cited by

Patent Information

Application Number
CN202411066554.1
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-08-05
Publication Date
2024-11-22

AI Technical Summary

Technical Problem

The traditional method of filling out data in colleges and universities requires manual input of large amounts of data, which is time-consuming and labor-intensive, prone to errors, and fails to effectively correlate and analyze, wasting valuable information.

Method used

Collect and preprocess internal data of colleges and universities through IoT devices, use blockchain technology to perform storage management, and use Apriori algorithm to obtain data association rules, build target tables, and realize automatic filling and auditing of data.

Benefits of technology

It improves data acquisition efficiency and accuracy, ensures data quality and consistency, improves the degree of automation and efficiency of data processing, and ensures the accuracy of data filling.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119005146A_ABST
    Figure CN119005146A_ABST
Patent Text Reader

Abstract

The invention discloses an automatic college data filling method based on Internet of Things equipment, and belongs to the technical field of table filling. The method comprises the following steps: collecting various data in a college through Internet of Things equipment, preprocessing the various data to obtain a source data set, and uploading the source data set to a business database; carrying out storage management on the source data set by utilizing a block chain technology; constructing a target table by obtaining a filling demand; data filling of the target table is completed through a preset data filling mode and an inspection rule, and a task filling table is obtained; the filled task filling table is comprehensively checked, the integrity coefficient of automatic filling of the data is calculated, and whether the data passes the auditing or not is judged according to a set standard threshold value.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field of form filling, and in particular to a method for automatically filling university data based on an Internet of Things device. Background Art

[0002] With the development of information technology, the internal management of colleges and universities increasingly relies on electronic means, including student information management, academic management, financial management, etc. The traditional data reporting method often requires manual input of a large amount of data, which is not only time-consuming and labor-intensive, but also prone to errors. The accuracy and reliability of the data are difficult to guarantee; there is no correlation analysis of the collected data, which wastes a lot of valuable information.

[0003] Therefore, the present invention provides a method for automatically filling in university data based on Internet of Things devices, which integrates all business data resources in the school through Internet of Things devices, and uses blockchain technology to complete the storage and management of data; constructs a target table according to the filling requirements, and applies the Apriori algorithm to obtain the association rules between data, realizes automatic filling of data, and further evaluates the task filling table to improve the accuracy of automatic data filling. Summary of the invention

[0004] The purpose of the present invention is to provide a method for automatically filling university data based on Internet of Things devices to solve the deficiencies in the background technology.

[0005] The purpose of the present invention can be achieved by the following technical solution: A method for automatically filling university data based on an Internet of Things device, comprising the following steps:

[0006] Step 1: Collect various data within the university through IoT devices, pre-process the data, obtain the source data set and upload it to the business database;

[0007] Step 2: Use blockchain technology to store and manage source data sets;

[0008] Step 3: Obtain reporting requirements and build the target form;

[0009] Step 4: Complete the data filling of the target table according to the preset data filling mode and verification rules to obtain the task filling table;

[0010] Step 5: Perform a comprehensive check on the filled task filling table, calculate the completeness coefficient of the automatic data filling, and determine whether the data has passed the review based on the set standard threshold.

[0011] Furthermore, the method for preprocessing the collected data in step 1 is as follows:

[0012] The collected data is preliminarily cleaned to remove outliers and duplicate information, and the data from different IoT devices are formatted and integrated to form a unified source data set; among them, various data include but are not limited to student information, teacher information, course information, grade information, and equipment usage.

[0013] Furthermore, the implementation method of storing and managing the source data set in step 2 is as follows:

[0014] The source data set is stored, and the source data set is calculated using a hash algorithm, the source data set is used as an independent variable, and the calculated hash value is the storage address of the source data set;

[0015] The calculation formula is:

[0016] M = Hash (x);

[0017] In the formula, M is the hash value of the source data set, Hash is the hash function, and x is the input source data set;

[0018] Get the source data set and its corresponding hash value, store the source data set under the blockchain, and store the hash value of the source data set on the blockchain.

[0019] Furthermore, the method for constructing the target table in step 3 is as follows:

[0020] Select a pre-designed template or custom style based on the obtained reporting requirements, and determine the data position and data field that need to be filled in each target cell in the target table; among them, the custom style includes setting form controls, control properties and data properties.

[0021] Furthermore, the data filling mode and verification rules preset in step 4 specifically include:

[0022] Traverse the business database to obtain the source data set, match the source data set with the required data fields in the target table according to the association rules between the data, and identify the associated fields;

[0023] Create a mapping table based on the matched associated fields, and traverse each cell of the target table in turn; if the cell needs to be filled with data, find the corresponding data field according to the mapping table for recommendation, and automatically fill it into the corresponding data position; if not, move to the next cell;

[0024] Perform data verification on the filled target table. Based on the filled data field, use the same hash function to recalculate the hash value of the obtained data field and compare it with the stored hash value. If the two hash values ​​are the same, the verification is successful, indicating that the data field has not been tampered with; otherwise, the verification fails, indicating that the data field has been tampered with and cannot be filled, and an error prompt pops up.

[0025] Furthermore, the method of obtaining the association rules between data is as follows:

[0026] Traverse the business database to obtain the source data set, where each business in the source data set is an item set and contains a group of data items;

[0027] For data items A and B, count the number of item sets that contain both A and B, and calculate the support of rule AB:

[0028]

[0029] In the formula, S is the support of association rule AB, n is the number of item sets containing both A and B, and N is the total number of item sets contained in the source data set;

[0030] Count the number of item sets containing data item A and calculate the confidence of association rule AB;

[0031]

[0032] In the formula, C is the confidence of rule AB, and m is the number of item sets containing data item A;

[0033] Set the minimum support threshold and the minimum confidence threshold. If and only if the support and confidence of rule AB are greater than or equal to the minimum support threshold and the minimum confidence threshold respectively, the rule is established and recorded as an association rule.

[0034] Furthermore, the evaluation and review of the task filling table in step 5 specifically includes:

[0035] By setting SQL query statements, the task filling table is fully checked to confirm whether there are omissions or errors in the data fields, and the errors found are counted to calculate the completeness coefficient of automatic data filling;

[0036] The calculation formula is:

[0037]

[0038] Where P is the completeness coefficient, u is the number of missing data fields in the task filling table, v is the number of errors in the data fields in the task filling table, and H is the total number of data fields that need to be filled in the task filling table;

[0039] Set the standard threshold to Q, and compare the obtained completeness coefficient with the standard threshold. If P<Q, the task filling table passes the review and is slightly improved; if P≥Q, the task filling and collection are carried out again.

[0040] In order to solve the problem, the present invention also discloses a university data automatic filling system based on Internet of Things devices, comprising:

[0041] The data collection and processing module collects various data within the university through IoT devices, pre-processes the data, obtains the source data set and uploads it to the business database;

[0042] Data storage management module, which uses blockchain technology to store and manage source data sets;

[0043] Form construction module, obtains reporting requirements and builds target forms;

[0044] The data filling module completes the data filling of the target table according to the preset data filling mode and verification rules to obtain the task filling table;

[0045] The audit and evaluation module conducts a comprehensive check on the filled task filling table, calculates the completeness coefficient of the automatic data filling, and determines whether the data has passed the audit based on the set standard threshold.

[0046] Compared with the existing solutions, the present invention achieves the following beneficial effects:

[0047] The present invention collects various data within the university through the Internet of Things devices, thereby improving the efficiency and accuracy of data collection; and pre-processes various data to ensure the quality of data used in subsequent steps.

[0048] The present invention uses blockchain technology to store and manage source data sets and perform hash calculations on source data sets, which is beneficial to data management and subsequent verification of source data sets;

[0049] The present invention obtains reporting requirements, constructs a target form, and completes data filling in the target form through preset data filling modes and verification rules, thereby ensuring the consistency and compliance of data filling and improving the automation and efficiency of data processing.

[0050] The present invention performs a comprehensive check on the filled task filling table, calculates the integrity coefficient of the automatic data filling, and determines whether the data passes the review according to a set standard threshold, thereby ensuring the quality standard of the data and improving the accuracy of data filling. BRIEF DESCRIPTION OF THE DRAWINGS

[0051] The present invention will be further described below in conjunction with the accompanying drawings.

[0052] Figure 1 The present invention is a flowchart of a method for automatically filling university data based on Internet of Things devices.

[0053] Figure 2 This is a module block diagram of a university data automatic filling system based on Internet of Things devices of the present invention. DETAILED DESCRIPTION

[0054] The technical solutions in the embodiments of the present invention will be described clearly and completely below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, rather than all the embodiments.

[0055] Embodiment 1, as Figure 1 As shown, a method for automatically filling university data based on an Internet of Things device includes the following steps:

[0056] Step 1: Collect various data within the university through IoT devices, pre-process the data, obtain the source data set and upload it to the business database;

[0057] Step 2: Use blockchain technology to store and manage the source data set to achieve encrypted storage of the source data set;

[0058] Step 3: Obtain reporting requirements and build the target form;

[0059] Step 4: Complete the data filling of the target table according to the preset data filling mode and verification rules to obtain the task filling table;

[0060] Step 5: Perform a comprehensive check on the filled task filling table, calculate the completeness coefficient of the automatic data filling, and determine whether the data has passed the review based on the set standard threshold.

[0061] In step 1, the method for preprocessing the collected data is as follows:

[0062] Perform preliminary cleaning of the collected data, remove outliers and duplicate information, format and integrate data from different IoT devices to form a unified source data set; the various data include but are not limited to student information, teacher information, course information, grade information, and device usage;

[0063] In step 2, the implementation method for storage management of the source data set is as follows:

[0064] The source data set is stored, and the source data set is calculated using a hash algorithm, the source data set is used as an independent variable, and the calculated hash value is the storage address of the source data set;

[0065] The calculation formula is:

[0066] M = Hash (x);

[0067] In the formula, M is the hash value of the source data set, Hash is the hash function, and x is the input source data set;

[0068] Obtain the source data set and its corresponding hash value, store the source data set under the blockchain, and store the hash value of the source data set on the blockchain;

[0069] It should be noted that the hash value of the source data set on the blockchain is publicly accessible and almost impossible to change. The source data set stored on the blockchain can be protected from unauthorized access through various encryption methods, which not only ensures the secure storage of data, but also ensures the immutability of the hash value.

[0070] In step 3, the method of constructing the target table is as follows:

[0071] Select a pre-designed template or custom style based on the reporting requirements obtained, and determine the data location and data fields that need to be filled in each target cell in the target table;

[0072] Custom styles include setting form controls, control properties, and data properties; form controls include but are not limited to text boxes, combo boxes, list boxes, and check boxes; each control can set specific properties, such as default values ​​and allowed value lists; data properties include data types and range restrictions;

[0073] In step 4, the preset data filling mode and verification rules specifically include:

[0074] Traverse the business database to obtain the source data set, match the source data set with the required data fields in the target table according to the association rules between the data, and identify the associated fields;

[0075] Create a mapping table based on the matched associated fields, and traverse each cell of the target table in turn; if the cell needs to be filled with data, find the corresponding data field according to the mapping table for recommendation, and automatically fill it into the corresponding data position; if not, move to the next cell; the mapping table is used to establish a direct connection between the source data set and the target table, and find the corresponding information in the source data set, so as to quickly complete the data filling of the target table;

[0076] Perform data verification on the filled target table. Based on the filled data field, use the same hash function to recalculate the hash value of the acquired data field and compare it with the stored hash value. If the two hash values ​​are the same, the verification is successful, indicating that the data field has not been tampered with. Otherwise, the verification fails, indicating that the data field has been tampered with and cannot be filled. At the same time, an error prompt pops up.

[0077] Specifically, the method for obtaining the association rules between data is as follows:

[0078] Traverse the business database to obtain the source data set, where each business in the source data set is an item set and contains a group of data items; the businesses in the source data set include but are not limited to student information, faculty information, course information, financial information, scientific research information, and asset information;

[0079] For data items A and B, count the number of item sets that contain both A and B, and calculate the support of rule AB:

[0080]

[0081] In the formula, S is the support of association rule AB, n is the number of item sets containing both A and B, and N is the total number of item sets contained in the source data set;

[0082] Count the number of item sets containing data item A and calculate the confidence of association rule AB;

[0083]

[0084] In the formula, C is the confidence of rule AB, and m is the number of item sets containing data item A;

[0085] Set the minimum support threshold and the minimum confidence threshold. If and only if the support and confidence of rule AB are greater than or equal to the minimum support threshold and the minimum confidence threshold respectively, the rule is established and recorded as an association rule. Among them, the setting of the minimum support threshold and the minimum confidence threshold needs to be adjusted according to the specific application scenario and data characteristics.

[0086] For example, by applying the Apriori algorithm to analyze students' course selection records and performance data, it is found that students who have chosen "Advanced Mathematics" and "Data Structure" usually also choose the "Machine Learning" course; based on such association rules, in the course selection form, "Machine Learning" is recommended and automatically filled in for students who have chosen "Advanced Mathematics" and "Data Structure".

[0087] In step 5, the evaluation and review of the task filling table specifically includes:

[0088] By setting SQL query statements, the task filling table is fully checked to confirm whether there are omissions or errors in the data fields, and the errors found are counted to calculate the completeness coefficient of automatic data filling;

[0089] The calculation formula is:

[0090]

[0091] Where P is the completeness coefficient, u is the number of missing data fields in the task filling table, v is the number of errors in the data fields in the task filling table, and H is the total number of data fields that need to be filled in the task filling table;

[0092] Set the standard threshold to Q, and compare the obtained completeness coefficient with the standard threshold. If P<Q, the task filling table passes the review and is slightly improved; if P≥Q, the task filling and collection are re-performed; among them, the standard threshold is set specifically according to the actual review standards.

[0093] Embodiment 2, as Figure 2 As shown, a university data automatic filling system based on Internet of Things devices includes:

[0094] The data collection and processing module collects various data within the university through IoT devices, pre-processes the data, obtains the source data set and uploads it to the business database;

[0095] Data storage management module, which uses blockchain technology to store and manage source data sets;

[0096] Form construction module, obtains reporting requirements and builds target forms;

[0097] The data filling module completes the data filling of the target table according to the preset data filling mode and verification rules to obtain the task filling table;

[0098] The audit and evaluation module conducts a comprehensive check on the filled task filling table, calculates the completeness coefficient of the automatic data filling, and determines whether the data has passed the audit based on the set standard threshold.

[0099] In the several embodiments provided by the present invention, it should be understood that the disclosed system can be implemented in other ways. For example, the above-described embodiments of the invention are only illustrative, for example, the division of modules is only a logical function division, and there may be other division methods in actual implementation.

[0100] The modules described as separate accessories may or may not be physically separated, and the accessories shown as modules may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0101] In addition, each functional module in each embodiment of the present invention may be integrated into one processing unit, 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 hardware plus software functional modules.

[0102] It is obvious to those skilled in the art that the present invention is not limited to the details of the above exemplary embodiments, and that the present invention can be implemented in other specific forms without departing from the spirit or essential characteristics of the present invention.

[0103] Finally, it should be noted that the above embodiments are only used to illustrate the technical solution of the present invention rather than to limit it. Although the present invention has been described in detail with reference to the preferred embodiments, those skilled in the art should understand that the technical solution of the present invention can be modified or replaced by equivalents without departing from the spirit and scope of the technical solution of the present invention.

Claims

1. A method for automatically filling university data based on Internet of Things devices, characterized in that: The following steps are involved: Step 1: Collect various data within the university through IoT devices, pre-process the data, obtain the source data set and upload it to the business database; Step 2: Use blockchain technology to store and manage source data sets; Step 3: Obtain reporting requirements and build the target form; Step 4: Complete the data filling of the target table according to the preset data filling mode and verification rules to obtain the task filling table; Step 5: Perform a comprehensive check on the filled task filling table, calculate the completeness coefficient of the automatic data filling, and determine whether the data has passed the review based on the set standard threshold.

2. According to the method of automatic filling of university data based on Internet of Things devices according to claim 1, it is characterized in that: The method for preprocessing the collected data in step 1 is as follows: The collected data is preliminarily cleaned to remove outliers and duplicate information, and the data from different IoT devices are formatted and integrated to form a unified source data set; among them, various data include but are not limited to student information, teacher information, course information, grade information, and equipment usage.

3. The method for automatically filling university data based on Internet of Things devices according to claim 2 is characterized in that: The implementation method for storage management of the source data set in step 2 is as follows: The source data set is stored, and the source data set is calculated using a hash algorithm, the source data set is used as an independent variable, and the calculated hash value is the storage address of the source data set; The calculation formula is: M = Hash (x); In the formula, M is the hash value of the source data set, Hash is the hash function, and x is the input source data set; Get the source data set and its corresponding hash value, store the source data set under the blockchain, and store the hash value of the source data set on the blockchain.

4. The method for automatically filling university data based on Internet of Things devices according to claim 1 is characterized in that: The method for constructing the target table in step 3 is as follows: Select a pre-designed template or custom style based on the obtained reporting requirements, and determine the data position and data field that need to be filled in each target cell in the target table; among them, the custom style includes setting form controls, control properties and data properties.

5. The method for automatically filling university data based on Internet of Things devices according to claim 1 is characterized in that: The data filling mode and verification rules preset in step 4 specifically include: Traverse the business database to obtain the source data set, match the source data set with the required data fields in the target table according to the association rules between the data, and identify the associated fields; Create a mapping table based on the matched associated fields, and traverse each cell of the target table in turn; if the cell needs to be filled with data, find the corresponding data field according to the mapping table for recommendation, and automatically fill it into the corresponding data position; if not, move to the next cell; Perform data verification on the filled target table. Based on the filled data field, use the same hash function to recalculate the hash value of the obtained data field and compare it with the stored hash value. If the two hash values ​​are the same, the verification is successful, indicating that the data field has not been tampered with; otherwise, the verification fails, indicating that the data field has been tampered with and cannot be filled, and an error prompt pops up.

6. The method for automatically filling university data based on Internet of Things devices according to claim 5 is characterized in that: The method of obtaining association rules between data is as follows: Traverse the business database to obtain the source data set, where each business in the source data set is an item set and contains a group of data items; For data items A and B, count the number of item sets that contain both A and B, and calculate the support of rule AB: In the formula, S is the support of association rule AB, n is the number of item sets containing both A and B, and N is the total number of item sets contained in the source data set; Count the number of item sets containing data item A and calculate the confidence of association rule AB; In the formula, C is the confidence of rule AB, and m is the number of item sets containing data item A; Set the minimum support threshold and the minimum confidence threshold. If and only if the support and confidence of rule AB are greater than or equal to the minimum support threshold and the minimum confidence threshold respectively, the rule is established and recorded as an association rule.

7. The method for automatically filling university data based on Internet of Things devices according to claim 6 is characterized in that: The evaluation and review of the task filling table in step 5 specifically includes: By setting SQL query statements, the task filling table is fully checked to confirm whether there are omissions or errors in the data fields, and the errors found are counted to calculate the completeness coefficient of automatic data filling; The calculation formula is: Where P is the completeness coefficient, u is the number of missing data fields in the task filling table, v is the number of errors in the data fields in the task filling table, and H is the total number of data fields that need to be filled in the task filling table; Set the standard threshold to Q, and compare the obtained completeness coefficient with the standard threshold. If P<Q, the task filling table passes the review and is slightly improved; if P≥Q, the task filling and collection are carried out again.

8. A university data automatic filling system based on Internet of Things devices, characterized in that: include: The data collection and processing module collects various data within the university through IoT devices, pre-processes the data, obtains the source data set and uploads it to the business database; Data storage management module, which uses blockchain technology to store and manage source data sets; Form construction module, obtains reporting requirements and builds target forms; The data filling module completes the data filling of the target table according to the preset data filling mode and verification rules to obtain the task filling table; The audit and evaluation module conducts a comprehensive check on the filled task filling table, calculates the completeness coefficient of the automatic data filling, and determines whether the data has passed the audit based on the set standard threshold.

Citation Information

Patent Citations

  • Association rule-based MBD (Model Based Definition) data set completeness checking method

    CN104598569A

  • A method, apparatus, computer device and storage medium for matching large amount of data

    CN109408535A

  • Table icon filling method and device, equipment and storage medium

    CN114492342A

  • Data storage method and device, computer equipment and storage medium

    CN115809241A

  • Electronic recording method and system for ship

    CN116011418A