A production data management system based on automated production

Abstract

The present invention discloses a production data management system based on automated production, and relates to the field of data integration; the production data management system based on automated production processes production data through a production system, receives production data sent by the production system through a data standardization module, and converts heterogeneous production data of production personnel into structured data based on unified terminology specifications, enables management personnel to log in to a data integration system through a management user login module, receives management personnel information logged in through the management user login module through a user authority query module, queries user authority based on the management personnel information, enables management personnel to input keywords of data to be queried through a matching condition input module, receives standard production data sent by a data standardization module through a data matching module, realizes data matching between the production system and the data integration system, and reliably and efficiently stores production data through a data evidence storage module.

Description

Technical Field

[0001] The present invention relates to data integration technology, and in particular to a production data management system based on automated production. Background Art

[0002] Production management is the management of asset acquisition (investment), capital financing (financing), cash flow (working capital) in operation, and profit distribution under certain overall goals. Production management is an integral part of enterprise management. It is an economic management work that organizes enterprise production activities and handles production relations based on financial laws and regulations and the principles of production management. Simply put, production management is an economic management work that organizes enterprise production activities and handles production relations.

[0003] When using existing production systems, since the habits of each user of the production system are different, it is necessary to modify the language habits of each user of the production system accordingly when integrating production data, which will increase the workload of production data integration. Summary of the invention

[0004] The purpose of the present invention is to provide a production data management system based on automated production to solve the problem in the prior art that due to the different expression habits of the users of each production system, the language of each production system user needs to be modified accordingly when integrating production data, which will increase the workload of production data integration.

[0005] In order to achieve the above object, the present invention provides the following technical solution: a production data management system based on automated production, comprising a plurality of production systems, wherein:

[0006] Multiple production systems are used to collect production data from different production personnel during the production process and send it to the data standardization module;

[0007] A data standardization module is used to receive production data sent by the production system and convert the heterogeneous production data of production personnel into structured data based on unified terminology specifications. The heterogeneous production data includes a balance sheet, an income statement, a cash flow statement, and business association relationships.

[0008] Management user login module, used for management personnel to log in to the data integration system;

[0009] A user authority query module is used to receive the management personnel information logged in through the management user login module, and query the user authority according to the management personnel information;

[0010] The matching condition input module is used by managers to input keywords for the data to be queried;

[0011] The data matching module is used to receive the standard production data sent by the data standardization module and realize the data matching between the production system and the data integration system;

[0012] The data storage module is used to store production data reliably and efficiently.

[0013] Furthermore, the specific working method of the data standardization module is:

[0014] A1: First, use the Oracle database's RMAN to back up the data files of the production data sent by the production system.

[0015] A2, extract, verify and clean the data from the backup database;

[0016] A3: For the unstructured data obtained, natural language processing is used to convert it into structured data;

[0017] A4, the processed data is mapped according to the OMOP data model rules and table structure, and converted into the OMOP general data model.

[0018] Furthermore, the specific working method of the user authority query module is:

[0019] B1: For operations when adding a new role, the administrator user submits the basic information of the role to the system. After the system reviews the current role rules, it enters the new role into the system and synchronizes it to the blockchain MSP;

[0020] B2: For the operation of binding roles and users, the administrator obtains all current role and user information from the system, binds the user to the role by the user's opt-in method, and then synchronizes the information to the blockchain MSP and records the result;

[0021] B3: For the operation of unbinding roles and users, the administrator obtains the binding information of the current role and user from the system, selects the relationship to be unbound and sends a request. The system records the unbinding relationship and synchronizes it to the blockchain MSP.

[0022] B4, for the operation of adding new permissions, the administrator user enters the basic information of the permissions to be added, and the system records the new permissions into the system after reviewing the current permission rules;

[0023] B5: For the operation of binding permissions and roles, the administrator obtains all current permissions and role information from the system, selects and confirms the permissions of the role, and then records the results;

[0024] B6: For the operation of unbinding permissions and roles, the administrator obtains the binding information of the current permissions and roles from the system, selects the relationship to be unbound and sends a request. The system unbinds the relationship and records it;

[0025] B7, for the operation of modifying roles or permissions, the administrator submits the modified permission or role information. After the system verifies the repeatability of the modification, it modifies the database and synchronizes it to the blockchain MSP.

[0026] Furthermore, the specific working method of the data matching module is:

[0027] C1, decrypts the promiscuous processing scheme and data using the locally stored private key;

[0028] C2, restoring the hash value group of the original data according to the private key decryption and promiscuous processing scheme in step C1;

[0029] C3, will synchronize the production data hash value group Combined with the hash value of the locally stored production data Calculate the similarity of each item separately , where [P i ] represents the hash value of the production data of the ith production system, [C i ] represents the theoretical standard production data hash value of the i-th production system:

[0030] i. For information that can fully identify production data processed using SHA256, the hash values ​​are directly compared, and the similarity is 1 or 0 depending on whether they are the same or not;

[0031] ii. Calculate the similarity of the information processed by SimHash and sort it. Sorting is done according to the calculation results, and the weight calculation is done on the database production data with the top two rankings in the comparison results;

[0032] C4, weight calculation is performed according to the matched data composition:

[0033] For the data results filtered out by the similarity calculation, the total weight is calculated according to the pre-determined weight ratio scheme. , the specific weight w allocation scheme is as follows:

[0034] i, identity authentication information and work number information that uniquely identifies the identity are given the highest weight, 0.8-1;

[0035] ii. For name, address, and phone number, a weight of 0.1-0.5 is assigned based on their importance;

[0036] C5, sum the weights and compare them with the threshold to determine whether they are the same production data.

[0037] Furthermore, the data storage module includes.

[0038] The production data entry module is used to complete the operation of entering the production data and production data certification materials provided by the query end into the system;

[0039] Production data viewing module, used to provide different viewing modes for different roles;

[0040] The production data authentication module is used to confirm the authenticity of the production data text information and authentication materials of the designated queried end, authenticate them in the system and store the production data on the blockchain;

[0041] The production data modification module is used for the queried end to modify the production data information if the production data information is found to be incorrect during the period between the time when the production data is entered and the time when the authentication is successful, and to modify the production data after the authentication fails and a production data query is raised;

[0042] The production data query module is used by the queried end to modify the resume when the production data authentication fails and wants to re-authenticate;

[0043] The production data query processing module is used for the query end to process the production data query operation proposed by the queried end.

[0044] Furthermore, the specific working method of the data evidence storage module is:

[0045] D1, first is the production data entry stage, the queried end submits a production data entry request, fills in the corresponding production data information according to the requirements of the production data entry window returned by the production data authentication module, and submits the production data information after filling in;

[0046] D2, after receiving the production data information, the production data authentication module performs field verification and format verification operations. After completion, the system searches the production data to see if there is duplicate production data information. If not, the production data is stored in the database and then returned to the queried end to indicate that the production data entry is successful, thus ending the production data entry phase;

[0047] D3, the second is the production data authentication stage, where the query end submits a production data viewing request to the data storage module. After receiving the request, the data storage module finds the production data under the corresponding department through the department information of the query end and the provided multi-dimensional search criteria, and performs a cache operation to facilitate multiple uses by the query end;

[0048] D4, the query end selects the production data information to be authenticated, checks it, verifies its authenticity, fills in the authentication evaluation, and submits the authentication result to the production data authentication module;

[0049] D5, the production data authentication module updates the evaluation information and authentication status to the corresponding production data and then stores the production data on the blockchain. At the same time, the shared model on the chain is called to process the production data to obtain the production data label and store it;

[0050] D6, the next stage is the production data query phase, where the queried end submits a production data query request to the production data query module;

[0051] D7, the queried end modifies the production data information, writes a corresponding query request, and submits the query information to the production data query module;

[0052] D8, the last is the production data query processing stage. The query end submits a query processing request to the production data query module. The production data query processing module queries the current query request from the database according to the department where the query end is located, and queries the corresponding production data list through the list in the query information. Similar to the production data query stage, it is necessary to judge the production data authentication status before reading;

[0053] D9, the query end selects the query information to be processed, writes the processing information after review, and submits the query processing completion request to the production data query module after completion.

[0054] Compared with the prior art, the present invention provides a production data management system based on automated production, which processes production data through the production system, receives production data issued by the production system through the data standardization module, and converts the heterogeneous production data of production personnel into structured data based on unified terminology specifications, allows managers to log in to the data integration system through the management user login module, receives the management information logged in through the management user login module through the user authority query module, and queries user authorities based on the management information, allows managers to input keywords of data to be queried through the matching condition input module, receives standard production data issued by the data standardization module through the data matching module, realizes data matching between the production system and the data integration system, and reliably and efficiently stores the production data through the data storage module. BRIEF DESCRIPTION OF THE DRAWINGS

[0055] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings required for use in the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments recorded in the present invention. For ordinary technicians in this field, other drawings can also be obtained based on these drawings.

[0056] Figure 1 A schematic diagram of the overall structure provided for an embodiment of the present invention. DETAILED DESCRIPTION

[0057] In order to enable those skilled in the art to better understand the technical solution of the present invention, the present invention will be further described in detail below with reference to the accompanying drawings.

[0058] See also Figure 1 , a production data management system based on automated production, comprising a plurality of production systems, wherein:

[0059] Multiple production systems are used to collect production data from different production personnel during the production process and send it to the data standardization module;

[0060] A data standardization module is used to receive production data sent by the production system and convert the heterogeneous production data of production personnel into structured data based on unified terminology specifications. The heterogeneous production data includes a balance sheet, an income statement, a cash flow statement, and business association relationships.

[0061] Management user login module, used for management personnel to log in to the data integration system;

[0062] A user authority query module is used to receive the information of the management personnel logged in through the management user login module, and query the user authority according to the management personnel information;

[0063] The matching condition input module is used by managers to input keywords for the data to be queried;

[0064] The data matching module is used to receive the standard production data sent by the data standardization module and realize the data matching between the production system and the data integration system;

[0065] The data storage module is used to store production data reliably and efficiently.

[0066] In this way, different production personnel are arranged to process production data through the production system, receive production data issued by the production system through the data standardization module, and convert the heterogeneous production data of the production personnel into structured data based on the unified terminology specification. The management personnel log in to the data integration system through the management user login module, receive the management personnel information logged in through the management user login module through the user authority query module, and query the user authority according to the management personnel information. The management personnel input the keywords of the data to be queried through the matching condition input module, receive the standard production data issued by the data standardization module through the data matching module, and realize the data matching between the production system and the data integration system, and reliably and efficiently store the production data through the data storage module.

[0067] Furthermore, the specific working method of the data standardization module is:

[0068] A1: First, use the Oracle database's RMAN to back up the data files of the production data sent by the production system.

[0069] A2, extract, verify and clean the data from the backup database;

[0070] A3: For the unstructured data obtained, natural language processing is used to convert the data into structured data;

[0071] A4, the processed data is mapped according to the OMOP data model rules and table structure, and converted into the OMOP general data model.

[0072] Furthermore, the specific working method of the user authority query module is:

[0073] B1: For operations when adding a new role, the administrator user submits the basic information of the role to the system. After the system reviews the current role rules, it enters the new role into the system and synchronizes it to the blockchain MSP;

[0074] B2: For the operation of binding roles and users, the administrator obtains all current role and user information from the system, binds the user to the role by the user's opt-in method, and then synchronizes the information to the blockchain MSP and records the result;

[0075] B3: For the operation of unbinding roles and users, the administrator obtains the binding information of the current role and user from the system, selects the relationship to be unbound and sends a request. The system records the unbinding relationship and synchronizes it to the blockchain MSP.

[0076] B4, for the operation of adding new permissions, the administrator user enters the basic information of the permissions to be added, and the system records the new permissions into the system after reviewing the current permission rules;

[0077] B5: For the operation of binding permissions and roles, the administrator obtains all current permissions and role information from the system, selects and confirms the permissions of the role, and then records the results;

[0078] B6: For the operation of unbinding permissions and roles, the administrator obtains the binding information of the current permissions and roles from the system, selects the relationship to be unbound and sends a request. The system unbinds the relationship and records it;

[0079] B7, for the operation of modifying roles or permissions, the administrator submits the modified permission or role information. After the system verifies the repeatability of the modification, it modifies the database and synchronizes it to the blockchain MSP.

[0080] Furthermore, the specific working method of the data matching module is:

[0081] C1, a locally stored private key decryption promiscuous processing scheme and data, wherein the specific private key decryption promiscuous processing scheme represents a private key decryption hybrid processing method which is cited as a prior art and is therefore not explained;

[0082] C2, restoring the hash value group of the original data according to the private key decryption and promiscuous processing scheme in step C1;

[0083] C3, will synchronize the production data hash value group Combined with the hash value of the locally stored production data Calculate the similarity of each item separately , where [P i ] represents the hash value of the production data of the ith production system, [C i ] represents the theoretical standard production data hash value of the i-th production system:

[0084] i. For information that can fully identify production data processed using SHA256, the hash values ​​are directly compared, and the similarity is 1 or 0 depending on whether they are the same or not;

[0085] ii. Calculate the similarity of the information processed by SimHash and sort it. Sorting is done according to the calculation results, and the weight calculation is done on the database production data with the top two rankings in the comparison results;

[0086] C4, weight calculation is performed according to the matched data composition:

[0087] For the data results filtered out by the similarity calculation, the total weight is calculated according to the pre-determined weight ratio scheme. , the specific weight w allocation scheme is as follows:

[0088] i, identity authentication information and work number information that uniquely identifies the identity are given the highest weight, 0.8-1;

[0089] ii. For name, address, and phone number, a weight of 0.1-0.5 is assigned based on their importance;

[0090] C5, sum the weights and compare them with the threshold to determine whether they are the same production data.

[0091] Furthermore, the data storage module includes.

[0092] The production data entry module is used to complete the operation of entering the production data and production data certification materials provided by the query end into the system;

[0093] Production data viewing module, used to provide different viewing modes for different roles;

[0094] The production data authentication module is used to confirm the authenticity of the production data text information and authentication materials of the designated queried end, authenticate them in the system and store the production data on the blockchain;

[0095] The production data modification module is used for the queried end to modify the production data information if the production data information is found to be incorrect during the period between the time when the production data is entered and the time when the authentication is successful, and to modify the production data after the authentication fails and a production data query is raised;

[0096] The production data query module is used by the queried end to modify the resume when the production data authentication fails and wants to re-authenticate;

[0097] The production data query processing module is used for the query end to process the production data query operation proposed by the queried end.

[0098] Furthermore, the specific working method of the data evidence storage module is:

[0099] D1, first is the production data entry stage, the queried end submits a production data entry request, fills in the corresponding production data information according to the requirements of the production data entry window returned by the production data authentication module, and submits the production data information after filling in;

[0100] D2, after receiving the production data information, the production data authentication module performs field verification and format verification operations. After completion, the system searches the production data to see if there is duplicate production data information. If not, the production data is stored in the database and then returned to the queried end to indicate that the production data entry is successful, thus ending the production data entry phase;

[0101] D3, the second is the production data authentication stage, where the query end submits a production data viewing request to the data storage module. After receiving the request, the data storage module finds the production data under the corresponding department through the department information of the query end and the provided multi-dimensional search criteria, and performs cache operations to facilitate multiple uses by the query end. Then the production data information under the corresponding department is returned to the query end;

[0102] D4, the query end selects the production data information to be authenticated, checks it, verifies its authenticity, fills in the authentication evaluation, and submits the authentication result to the production data authentication module;

[0103] D5, the production data authentication module updates the evaluation information and authentication status to the corresponding production data, and then stores the production data on the blockchain. At the same time, the shared model on the chain is called to process the production data to obtain the production data label and store it. After completion, the authentication success prompt is returned to the query end, and the production data authentication stage ends;

[0104] D6, again, is the production data query stage, the queried end submits a production data query request to the production data query module. After receiving the corresponding request, the production data query module submits a request to query the corresponding production data to the data storage module according to the system information. The data storage module determines the authentication status of the production data, reads the production data from the database when the authentication fails, or reads the production data from the blockchain when the authentication succeeds, and returns the production data. After receiving it, the production data query module returns the query submission window with the production data information to the queried end;

[0105] D7, the queried end modifies the production data information, writes the corresponding query request and submits the query information to the production data query module. The production data query module queries the database based on the information to see if there is any unprocessed query information in the current system to prevent repeated queries. The query information is then stored in the database, and the modified production data information is stored in the database through the data storage module. After completion, the query is returned to the queried end to indicate that the query has been successfully submitted, ending the production data query stage;

[0106] D8, the last is the production data query processing stage. The query end submits a query processing request to the production data query module. The production data query processing module queries the current query request from the database according to the department where the query end is located, and queries the corresponding production data list through the list in the query information. As in the production data query stage, it is necessary to judge the production data authentication status for reading. After completion, the query information is cached and stored, and the query list containing production data is returned to the query end;

[0107] D9, the query end selects the query information to be processed, writes the processing information after review, and submits the query processing completion request to the production data query module after completion. The production data query module updates the query information and query status in the database, and at the same time, the data storage module performs different operations according to the existence of the corresponding production data on the blockchain: when the production data does not exist, the production data is stored, and when it already exists, the update operation is performed. After completion, the query processing completion prompt is returned to the query end, and the production data query processing stage ends.

[0108] Working principle: When in use, production data is processed through the production system, production data issued by the production system is received through the data standardization module, and based on the unified terminology specification, the heterogeneous production data of production personnel are converted into structured data, and the management personnel log in to the data integration system through the management user login module, and the management personnel information logged in through the management user login module is received through the user authority query module, and the user authority is queried according to the management personnel information, and the management personnel input the keywords of the data to be queried through the matching condition input module, and the standard production data issued by the data standardization module is received through the data matching module, and the data matching between the production system and the data integration system is realized, and the production data is reliably and efficiently stored through the data storage module.

[0109] The above description is only by way of illustration of certain exemplary embodiments of the present invention. It is undoubted that those skilled in the art can modify the described embodiments in various ways without departing from the spirit and scope of the present invention. Therefore, the above drawings and descriptions are illustrative in nature and should not be construed as limiting the scope of protection of the claims of the present invention.

Claims

1. A production data management system based on automated production, characterized in that: It comprises a plurality of production systems, characterized in that: Multiple production systems are used to collect production data from different production personnel during the production process and send it to the data standardization module; A data standardization module is used to receive production data sent by the production system and convert the heterogeneous production data of production personnel into structured data based on unified terminology specifications. The heterogeneous production data includes a balance sheet, an income statement, a cash flow statement, and business association relationships. Management user login module, used for management personnel to log in to the data integration system; A user authority query module is used to receive the information of the management personnel logged in through the management user login module, and query the user authority according to the management personnel information; The matching condition input module is used by managers to input keywords for the data to be queried; The data matching module is used to receive the standard production data sent by the data standardization module and realize the data matching between the production system and the data integration system. The specific working method of the data matching module is as follows: C1, decrypts the promiscuous processing scheme and data using the locally stored private key; C2, restoring the hash value group of the original data according to the private key decryption and promiscuous processing scheme in step C1; C3, will synchronize the production data hash value group Combined with the hash value of the locally stored production data Calculate the similarity of each item separately , where [P i ] represents the actual production data hash value of the i-th production system, [C i ] represents the theoretical standard production data hash value of the i-th production system: i. For information that can fully identify production data processed using SHA256, the hash values ​​are directly compared, and the similarity is 1 or 0 depending on whether they are the same or not; ii. Calculate the similarity of the information processed by SimHash and sort it. Sorting is done according to the calculation results, and the weight calculation is done on the database production data with the top two rankings in the comparison results; C4, weight calculation is performed according to the matched data composition: For the data results filtered out by the similarity calculation, the total weight is calculated according to the pre-determined weight ratio scheme. , the specific weight w allocation scheme is as follows: i, identity authentication information and work number information that uniquely identifies the identity are given the highest weight, 0.8-1; ii. For name, address, and phone number, a weight of 0.1-0.5 is assigned based on their importance; C5, weight sum and compare with the threshold to determine whether it is the same production data; The data evidence storage module is used to store production data reliably and efficiently. The data evidence storage module includes a production data entry module, a production data viewing module, a production data authentication module, a production data modification module, a production data query module and a production data query processing module. The production data entry module is used to complete the operation of entering the production data and production data certification materials provided by the queried end into the system. The production data viewing module is used to provide different viewing methods for different roles. The production data authentication module is used to confirm the authenticity of the production data text information and certification materials of the designated queried end, authenticate in the system and perform blockchain evidence storage on the production data. The production data modification module is used for the queried end to modify the production data information if the production data information is found to be incorrect during the period between the production data entry and the successful authentication, and to modify the production data after the authentication fails and the production data query is raised. The production data query module is used for the queried end to determine whether the modified production data can be used for production data authentication after the production data is modified when the production data authentication fails and the queried end wants to re-authenticate. The production data query processing module is used for the query end to process the production data query operation raised by the queried end.

2. A production data management system based on automated production according to claim 1, characterized in that: The specific working method of the data standardization module is: A1: First, use the Oracle database's RMAN to back up the data files of the production data sent by the production system. A2, extract, verify and clean the data from the backup database; A3: For the unstructured data obtained, natural language processing is used to convert it into structured data; A4, the processed data is mapped according to the OMOP data model rules and table structure, and converted into the OMOP general data model.

3. A production data management system based on automated production according to claim 2, characterized in that: The specific working method of the user authority query module is: B1: For operations when adding a new role, the administrator user submits the basic information of the role to the system. After the system reviews the current role rules, it enters the new role into the system and synchronizes it to the blockchain MSP; B2: For the operation of binding roles and users, the administrator obtains all current role and user information from the system, binds the user to the role by the user's opt-in method, and then synchronizes the information to the blockchain MSP and records the result; B3: For the operation of unbinding roles and users, the administrator obtains the binding information of the current role and user from the system, selects the relationship to be unbound and sends a request. The system records the unbinding relationship and synchronizes it to the blockchain MSP. B4, for the operation of adding new permissions, the administrator user enters the basic information of the permissions to be added, and the system records the new permissions into the system after reviewing the current permission rules; B5: For the operation of binding permissions and roles, the administrator obtains all current permissions and role information from the system, selects and confirms the permissions of the role, and then records the results; B6: For the operation of unbinding permissions and roles, the administrator obtains the binding information of the current permissions and roles from the system, selects the relationship to be unbound and sends a request. The system unbinds the relationship and records it; B7, for the operation of modifying roles or permissions, the administrator submits the modified permission or role information. After the system verifies the repeatability of the modification, it modifies the database and synchronizes it to the blockchain MSP.

4. A production data management system based on automated production according to claim 3, characterized in that: The specific working method of the data evidence storage module is as follows: D1, first is the production data entry stage, the queried end submits a production data entry request, fills in the corresponding production data information according to the requirements of the production data entry window returned by the production data authentication module, and submits the production data information after filling in; D2, after receiving the production data information, the production data authentication module performs field verification and format verification operations. After completion, the system searches the production data to see if there is duplicate production data information. If not, the production data is stored in the database and then returned to the queried end to indicate that the production data entry is successful, thus ending the production data entry phase; D3, the second is the production data authentication stage, where the query end submits a production data viewing request to the data storage module. After receiving the request, the data storage module finds the production data under the corresponding department through the department information of the query end and the provided multi-dimensional search criteria, and performs a cache operation to facilitate multiple uses by the query end; D4, the query end selects the production data information to be authenticated, checks it, verifies its authenticity, fills in the authentication evaluation, and submits the authentication result to the production data authentication module; D5, the production data authentication module updates the evaluation information and authentication status to the corresponding production data and then stores the production data on the blockchain. At the same time, the shared model on the chain is called to process the production data to obtain the production data label and store it; D6, the next stage is the production data query phase, where the queried end submits a production data query request to the production data query module; D7, the queried end modifies the production data information, writes a corresponding query request, and submits the query information to the production data query module; D8, the last is the production data query processing stage. The query end submits a query processing request to the production data query module. The production data query processing module queries the current query request from the database according to the department where the query end is located, and queries the corresponding production data list through the list in the query information. Similar to the production data query stage, it is necessary to judge the production data authentication status before reading; D9, the query end selects the query information to be processed, writes the processing information after review, and submits the query processing completion request to the production data query module after completion.

Images