Item Traceability Code Storage with Blockchain and Relational Database

The patent segments item information into distinct components: source tracing code (identifying production origin), flow information (tracking movement through supply chain), and form data items (structured attributes). This segmentation enables targeted verification of authenticity while organizing complex data into manageable, queryable units that can be stored and retrieved efficiently.

The patent introduces a dual-storage architecture where a relational database serves as an intermediary for structured flow information and a blockchain serves as an intermediary for immutable source tracing codes. This intermediary layering allows the system to maintain both the flexibility of traditional databases and the security of blockchain technology without requiring a complete system overhaul.

The patent extracts only the essential elements needed for authenticity verification: source tracing codes and key flow information milestones. Rather than storing all possible item data, the system selectively extracts and stores only the critical information required to prevent counterfeit goods, reducing storage requirements while maintaining verification effectiveness.

The patent performs preliminary hashing of flow information before storage, converting comprehensive data into compact hash values that serve as unique identifiers. This preliminary processing reduces storage volume significantly while preserving the ability to verify information integrity, as the hash functions allow for efficient comparison and validation without storing the original large datasets.

The patent generates source tracing codes at the earliest stage in the supply chain, during the production or initial distribution phase. This preliminary generation ensures that the authenticating identifier is already in place before the item enters circulation, eliminating the need for time-consuming code generation during verification processes and enabling rapid authentication at later stages.

The patent uses hashing algorithms to create compact digital copies (hash values) of the source tracing codes and flow information. These hash copies serve as efficient verification tokens that can be quickly compared and validated without requiring processing of the original, more complex data structures, thereby reducing verification time while maintaining security.