Food information tracing method based on relational database

Abstract

The invention relates to a food information tracing method based on a relational database. The method comprises the following steps of: collecting information of food in the production, storage, transportation and selling processes; associating the information with the food, and then storing the information into relevant nodes; storing enterprises through which the food sequentially passes in the circulation process into a tracing path table so as to form a food tracing tree diagram with the path tracing function; and then, tracking or tracing the relevant information of certain food according to the food tracing tree diagram. The food information tracing method has the advantages that the tree diagram in the food tracing process is built; if the information of the food is increased, information increased in the links can be supplemented into relevant nodes, so that the information storage becomes reasonable; great convenience is brought for the information query and retrieval of relevant food in the whole production and circulation processes through the building of the tree diagram in the food tracing process; the links with problems can be found in time through tracing; and the food safety is further guaranteed.

Description

technical field [0001] The invention relates to the field of food safety, in particular to a method for tracing food information based on a relational database. Background technique [0002] The frequent occurrence of food safety incidents has attracted people's attention, especially since the 21st century, people have put forward higher requirements for food safety. In order to bring consumers more security, it is urgent to build a food safety traceability system. The food safety traceability system emphasizes the unique identification and process tracking of products, and implements ISO9001 and other quality standards in all aspects of product production, transportation, storage, and sales. The control method is tracked and traced. Once a food safety problem occurs, the whereabouts of the food can be effectively tracked, and unqualified products can be recalled in time to minimize losses. [0003] At present, in the systems used by most enterprises, relational databases o...

AI Technical Summary

Problems solved by technology

[0005] In order to solve the problem of lack of regularity in storage and low traceability in the food safety traceability system in the prior art due to the large amount of food information / fast growth rate, the present invention provides a food information traceability method based on a relational database. In the present invention, the food traceability path is regarded as a tree structure, the root node represents the food production enterprise, the branch nodes represent the food transportation and sales enterprises, and the leaf nodes represent the food sellers. The circulation path visits the nodes in the tree sequentially, which not only enables fast storage of food information, but also improves traceability efficiency

Images