Hash unique identification generation method based on contract and material attributes

Abstract

This invention discloses a hash-based unique identifier generation method based on contract and material attributes, belonging to the field of metallurgical data identification technology. This invention performs MD5 hash operations (collision probability less than 10⁻¹²) only on core essential material attributes such as material, thickness, width, zinc layer, and coating amount. The contract number is then appended as a prefix to the hash value, forming a globally unique identifier in the format "contract number_hash value". This fundamentally avoids the risk of hash collisions, enabling accurate differentiation and full-process traceability of different materials within the same contract and the same materials between different contracts. It boasts advantages such as strong uniqueness, high stability, cross-system applicability, and ease of implementation in industrial scenarios. This invention has been fully implemented in a real industrial ERP system and can operate stably in real production environments for a long time, demonstrating mature engineering value and industrial promotion capabilities.

Description

TECHNICAL FIELD

[0001] The application relates to the field of data identification technology of ERP and MES systems in the metallurgical industry, and in particular to a method for generating a globally unique identification by combining a contract number prefix and material core attribute MD5 hash. BACKGROUND

[0002] In the production process of metallurgical coiled materials, a same contract number usually contains multiple different specifications of materials, such as material quality, thickness, width, zinc layer, plating amount, surface grade, etc. The traditional contract number as the only association identifier cannot distinguish different materials under the same contract, which may cause problems such as material mixing, material error, and data correspondence confusion.

[0003] If the contract number and material attributes are hashed together in the prior art, there is a risk of hash collision, and it is not conducive to accurate matching between multiple systems and whole-process tracing, and cannot meet the requirements of uniqueness, stability and universality for industrial production. SUMMARY

[0004] OBJECTIVE To overcome the shortcomings of the prior art, a material unique identification generation method is provided, which is free of hash collision, globally unique, stable and universal, and can be used throughout the whole business process.

[0005] TECHNICAL SCHEME Extract the key attributes of the material (material quality, thickness, width, zinc layer, plating amount, surface grade, yield strength), which are the core and necessary attributes for distinguishing different specifications of materials and are indispensable to ensure the uniqueness of the hash value; According to a fixed order (material quality, thickness, width, zinc layer, plating amount, surface grade, yield strength), the above attributes are spliced into a unified format string; Only the material attribute string is subjected to MD5 hash operation to generate a 32-bit fixed-length pure hash value (with a collision probability lower than 10⁻¹², meeting the industrial-level uniqueness requirement); The contract number is used as a prefix and is spliced with the hash value using a separator to form the final unique identification, which is in the format of contract number_hash value; The unique identification is used as a unified identification code for the whole process of contracts, raw materials, production, quality, finished products, inventory and delivery.

[0006] CORE INNOVATION POINT The contract number is not involved in the hash operation and is only used as a prefix to distinguish different contracts, thereby avoiding the risk of hash collision from the root; The material core necessary attributes are spliced in a fixed order to ensure that the same attributes generate the same hash value and different attributes generate different hash values, thereby achieving accurate distinction of different materials under the same contract; MD5 hash algorithm generates a 32-bit fixed-length hash value, with a very low collision probability, meeting the uniqueness requirements of industrial scenarios; The unique identifier is universal across systems and can be used throughout the entire process of contracts, raw materials, production, inventory, and shipping to achieve data correlation and traceability.

[0007] Advantages Globally unique, stable, and non-repetitive, completely solving the problems of mixed materials, wrong materials, and difficult data reconciliation; Different materials under the same contract are automatically distinguished, and the same materials under different contracts are distinguished by the prefix of the contract number, with no risk of confusion; Strong cross-system compatibility, suitable for data interconnection between multiple systems such as ERP, MES, PLC, quality testing, and inventory management; Achieve accurate identification and traceability from order to finished product, with complete data link. DETAILED DESCRIPTION

[0008] In the sales contract input stage, the system collects all core attribute information of the material (material, thickness, width, zinc layer, plating amount, surface grade, yield strength), and if any core item is missing, the system will directly intercept and prompt "Incomplete attributes, cannot generate hash value"; Concatenate into a standard string in the preset fixed order (material → thickness → width → zinc layer → plating amount → surface grade → yield strength), and the string does not contain the contract number; Perform MD5 calculation on the concatenated string to get a 32-bit fixed-length pure hash value; Connect the contract number and the hash value with an underscore to generate a "contract number_hash value" format unique identifier; Write the identifier into the contract table, raw material table, production record table, finished product table, inventory table, and shipping table, etc. core business tables; Each business system realizes data correlation, query, traceability, and integration through the unique identifier, ensuring the consistency of the entire process data.

Claims

1. A method for generating hash-based unique identifiers based on contracts and material attributes, characterized in that, Includes the following steps: (1) Extract the material, thickness, width, zinc layer, coating amount, surface grade, and yield strength of the core essential attributes (all are indispensable); (2) Concatenate the above attributes into a string in a fixed order (material → thickness → width → zinc layer → coating amount → surface grade → yield strength); (3) Perform MD5 hash operation only on the string to obtain a 32-bit fixed-length pure hash value (collision probability is less than 10⁻¹²). (4) Prepend the contract number as a prefix to the hash value to form the final unique identifier: contract number_hash value; (5) Use this identifier as a unified identification code for the entire process of contracts, raw materials, production, quality, finished products, inventory, and delivery.

2. The method according to claim 1, characterized in that, The contract number is not involved in the MD5 hash calculation; it is only used to distinguish different contracts.

3. The method according to claim 1, characterized in that, This unique identifier is used for data exchange and unique association between ERP, MES, PLC, quality inspection, and inventory management systems.