Production data management system based on automatic production
By introducing data standardization, permission query and evidence storage modules into the production data management system, the problem of increasing data integration workload caused by different users' habits is solved, unified data standardization and efficient evidence storage are achieved, and production data management is improved. Efficiency and reliability.
Patent Information
- Application Number
- CN202411412179.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-10-11
- Publication Date
- 2024-11-08
- Estimated Expiration
- 2044-10-11
AI Technical Summary
Due to the different expression habits of each user, the existing production systems need to modify the language of each system when integrating production data, which increases the workload.
A production data management system based on automated production was designed, including data standardization module, user permission query module, data matching module and data proof storage module, through Oracle database, natural language processing, OMOP data model, blockchain MSP and private Key decryption mixed processing scheme to realize unified data specification, authority management and evidence storage.
It reduces the workload of production data integration, improves the efficiency and reliability of data processing, ensures unified data specifications and permission management, and provides reliable evidence storage through blockchain.
Smart Images

Figure CN118917949A_ABST
Abstract
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), operating cash flow (working capital), and profit distribution within a specific overall objective. Production management is an integral part of enterprise management. It is an economic management task that organizes an enterprise's production activities and handles production relations in accordance with financial laws and regulations and the principles of production management. Simply put, production management is an economic management task that organizes an enterprise's production activities and handles production relations.
[0003] When using existing production systems, since the habits of users of each production system are different, it is necessary to modify the language habits of each production system user accordingly when integrating production data, which increases 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 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-mentioned 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: 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 from 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 balance sheets, income statements, cash flow statements, and business 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 administrator logged in through the management user login module and query the user authority based on the administrator information; Matching condition input module, used for 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 data matching between the production system and the data integration system; The data notarization module is used to reliably and efficiently store production data.
[0006] Furthermore, the specific working method of the data standardization module is: A1: First, use Oracle database RMAN to back up the data files of 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.
[0007] Furthermore, 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 verifies the current role rules, it enters the new role into the system and synchronizes it to the blockchain MSP; B2: For the role-user binding operation, the administrator obtains all current role and user information from the system, binds the user to the role through the user's opt-in method, and then synchronizes the information to the blockchain MSP and records the results; B3: To unbind a role from a user, 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 then records the unbinding relationship and synchronizes it to the blockchain MSP. B4: When adding a new permission, the administrator enters the basic information of the permission to be added. The system records the new permission after reviewing the current permission rules. B5: For operations that bind permissions to roles, the administrator obtains all current permissions and role information from the system, selects and confirms the permissions for the role, and then records the results. B6: For the unbinding of permissions and roles, the administrator obtains the current binding information of permissions and roles from the system, selects the relationship to be unbound, and sends a request. The system then unbinds the relationship and records it. B7: For role or permission modification operations, 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.
[0008] Furthermore, the specific working method of the data matching module is: C1, decrypts the hashing solution and data using the locally stored private key; C2, restore the hash value group of the original data according to the private key decryption and hashing processing scheme in step C1; C3, will synchronize the production data hash value group [P i , P j ,…,P i ] and the hash value of the locally stored production data [C i , C j ,…,C i ] and calculate the similarity (P i , C i ): i. For information that can fully identify production data processed using SHA256, the hash values are directly compared, and the similarity is assigned a value of 1 or 0 depending on whether they are the same or not; ii. Calculate the similarity of the information processed using SimHash and sort it. Sorting by the calculation results, and weighting the database production data with the top two rankings; C4, weight calculation based on the matched data composition: For the data results filtered out by similarity calculation, the total weight is calculated according to the pre-defined weight ratio scheme. , the specific weight w distribution scheme is as follows: i, gives the highest weight, 0.8-1, to identity authentication information and work number information that uniquely identifies the identity; ii. For name, address, and phone number, assign a weight of 0.1-0.5 based on their importance; C5, sum the weights and compare with the threshold to determine whether they are the same production data.
[0009] Furthermore, the data evidence module includes.
[0010] 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; Production data viewing module, used to provide different viewing modes for different roles; The production data authentication module is used to verify the authenticity of the production data text information and authentication materials of the designated query end, authenticate it in the system, and store the production data on the blockchain; The production data modification module is used by the queried end to modify the production data if errors are found between the time the production data is entered and the time the authentication is successful. It is also used to modify the production data after authentication fails and a production data query is raised. 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; The production data query processing module is used by the querying end to process the production data query operation proposed by the queried end.
[0011] Furthermore, the specific working method of the data evidence storage module is as follows: D1, the first stage 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 the information; D2: After receiving the production data, the production data authentication module performs field verification and format verification. After completion, it searches the system for duplicate production data information. If not, it stores the production data in the database and returns a successful production data entry prompt to the queried end, ending the production data entry phase. D3, the second stage of production data authentication, is when the query end submits a production data viewing request to the data storage module. After receiving the request, the data storage module uses the query end's department information and the provided multi-dimensional search criteria to find the production data under the corresponding department and cache it to facilitate repeated use 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. It also calls the shared model on the chain to process the production data, obtain the production data label, and store it as a certificate. D6 is the production data query stage again. 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 final production data query processing stage. The querying end submits a query processing request to the production data query processing module. The production data query processing module searches the database for the current query request based on the querying end's department and uses the query information to find the corresponding production data list. As in the production data query stage, the authentication status of the production data must be determined before reading. D9, the query end selects the query information to be processed, reviews and processes it, and writes the processing information. After completion, it submits the query processing completion request to the production data query module.
[0012] Compared with the existing technology, 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. The manager logs in to the data integration system through the management user login module, receives the manager information logged in through the management user login module through the user authority query module, and queries user authority based on the manager information. The manager inputs keywords of the 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, and 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
[0013] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the following briefly introduces the drawings required for use in the embodiments. Obviously, the drawings described below are only some embodiments described in the present invention. For ordinary technicians in this field, other drawings can also be obtained based on these drawings.
[0014] Figure 1 A schematic diagram of the overall structure provided by an embodiment of the present invention. DETAILED DESCRIPTION
[0015] 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.
[0016] See also Figure 1 , a production data management system based on automated production, including multiple production systems, wherein: 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 from 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 balance sheets, income statements, cash flow statements, and business 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 administrator logged in through the management user login module and query the user authority based on the administrator information; Matching condition input module, used for 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 data matching between the production system and the data integration system; The data notarization module is used to reliably and efficiently store production data.
[0017] In this way, different production personnel are arranged to process production data through the production system, receive production data sent 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 manager logs in to the data integration system through the management user login module, receives the manager information logged in through the management user login module through the user authority query module, and queries the user authority according to the manager information. The manager inputs the keyword of the data to be queried through the matching condition input module, receives the standard production data sent 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.
[0018] Furthermore, the specific working method of the data standardization module is: A1: First, use Oracle database RMAN to back up the data files of 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.
[0019] Furthermore, 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 verifies the current role rules, it enters the new role into the system and synchronizes it to the blockchain MSP; B2: For the role-user binding operation, the administrator obtains all current role and user information from the system, binds the user to the role through the user's opt-in method, and then synchronizes the information to the blockchain MSP and records the results; B3: To unbind a role from a user, 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 then records the unbinding relationship and synchronizes it to the blockchain MSP. B4: When adding a new permission, the administrator enters the basic information of the permission to be added. The system records the new permission after reviewing the current permission rules. B5: For operations that bind permissions to roles, the administrator obtains all current permissions and role information from the system, selects and confirms the permissions for the role, and then records the results. B6: For the unbinding of permissions and roles, the administrator obtains the current binding information of permissions and roles from the system, selects the relationship to be unbound, and sends a request. The system then unbinds the relationship and records it. B7: For role or permission modification operations, 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.
[0020] Furthermore, the specific working method of the data matching module is: C1, a locally stored private key decryption hashing processing scheme and data, wherein the specific private key decryption hashing processing scheme represents the private key decryption hybrid processing method and is cited as a prior art and is therefore not explained; C2, restore the hash value group of the original data according to the private key decryption and hashing processing scheme in step C1; C3, will synchronize the production data hash value group [P i , P j ,…,P i ] and the hash value of the locally stored production data [C i , C j ,…,C i ] and calculate the similarity (P i , C i ): i. For information that can fully identify production data processed using SHA256, the hash values are directly compared, and the similarity is assigned a value of 1 or 0 depending on whether they are the same or not; ii. Calculate the similarity of the information processed using SimHash and sort it. Sorting by the calculation results, and weighting the database production data with the top two rankings; C4, weight calculation based on the matched data composition: For the data results filtered out by similarity calculation, the total weight is calculated according to the pre-defined weight ratio scheme. , the specific weight w distribution scheme is as follows: i, gives the highest weight, 0.8-1, to identity authentication information and work number information that uniquely identifies the identity; ii. For name, address, and phone number, assign a weight of 0.1-0.5 based on their importance; C5, sum the weights and compare with the threshold to determine whether they are the same production data.
[0021] Furthermore, the data evidence module includes.
[0022] 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; Production data viewing module, used to provide different viewing modes for different roles; The production data authentication module is used to verify the authenticity of the production data text information and authentication materials of the designated query end, authenticate it in the system, and store the production data on the blockchain; The production data modification module is used by the queried end to modify the production data if errors are found between the time the production data is entered and the time the authentication is successful. It is also used to modify the production data after authentication fails and a production data query is raised. 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; The production data query processing module is used by the querying end to process the production data query operation proposed by the queried end.
[0023] Furthermore, the specific working method of the data evidence storage module is as follows: D1, the first stage 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 the information; D2: After receiving the production data, the production data authentication module performs field verification and format verification. After completion, it searches the system for duplicate production data information. If not, it stores the production data in the database and returns a successful production data entry prompt to the queried end, ending the production data entry phase. D3, followed by the production data authentication phase, involves the query client submitting a production data viewing request to the data storage module. Upon receiving the request, the data storage module uses the query client's department information and the provided multi-dimensional search criteria to locate the production data for the corresponding department and cache it for easy reuse by the query client. The production data for the corresponding department is then returned to the query client. 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. It also calls the shared model on the chain to process the production data, obtain the production data label, and store it as an authentication certificate. Upon completion, a successful authentication notification is returned to the query end, ending the production data authentication phase. D6 is the production data query phase. The queried end submits a production data query request to the production data query module. After receiving the request, the production data query module submits a query request for the corresponding production data to the data evidence module based on the system information. The data evidence module determines the authentication status of the production data and reads the production data from the database if authentication fails or from the blockchain if authentication succeeds, and returns the production data. After receiving the request, the production data query module returns the query submission window with the production data information to the queried end. D7: The queried party modifies the production data and writes a corresponding query request before submitting the query information to the production data query module. The production data query module queries the database to see if there is any unprocessed query information in the current system to prevent duplicate queries. The query information is then stored in the database, and the modified production data information is stored in the database through the data evidence module. After completion, a successful query submission information is returned to the queried party, ending the production data query phase. D8: Finally, the production data query processing stage. The querying end submits a query processing request to the production data query module. The production data query processing module searches the database for the current query request based on the querying end's department. It then uses the query information to find the corresponding production data list. As in the production data query stage, the authentication status of the production data must be determined before reading. Upon completion, the query information is cached and stored, and the query list containing the production data is returned to the querying end. D9: The query side selects the query information to be processed, reviews it, and writes the processing information. Upon completion, it submits a query completion request to the production data query module. The production data query module updates the query information and query status in the database. Simultaneously, the data evidence module performs different operations based on the existence of the corresponding production data on the blockchain: if the production data does not exist, it will be authenticated; if it already exists, it will be updated. Upon completion, a query completion notification is returned to the query side, ending the production data query processing phase.
[0024] Working principle: When in use, production data is processed through the production system, production data sent 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 sent 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 recorded through the data notarization module.
[0025] The above description is merely illustrative of certain exemplary embodiments of the present invention. It goes without saying that those skilled in the art will be able to modify the described embodiments in various ways without departing from the spirit and scope of the present invention. Therefore, the above drawings and description are illustrative in nature and should not be construed as limiting the scope of protection of the claims.
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 management personnel information 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 for 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 [P i , P j ,…,P i ] and the hash value of the locally stored production data [C i , C j , …, C i ] and calculate the similarity (P i , C i ): 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 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 authenticate the production data text information and certification materials of the designated queried end in the system after the authenticity is confirmed, and then perform the operation of blockchain evidence storage of the production data. The production data modification module is used by 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 by the queried end to modify the resume when it wants to re-authenticate after the production data authentication fails. The production data query processing module is used by 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.
Citation Information
Patent Citations
Intellectual property management system based on block chain
CN112801827A
Enterprise management data interaction system and method based on big data regulation and control
CN114969066A
Product data intelligent management system
CN117371923A
S2B2C online and offline combined innovative business mode saas service system
CN117829759A
Managing production pipelines
EP3961523A1
