CN108564381B - Mother and infant product production traceability management system and method thereof - Google Patents
Mother and infant product production traceability management system and method thereof Download PDFInfo
- Publication number
- CN108564381B CN108564381B CN201810323430.5A CN201810323430A CN108564381B CN 108564381 B CN108564381 B CN 108564381B CN 201810323430 A CN201810323430 A CN 201810323430A CN 108564381 B CN108564381 B CN 108564381B
- Authority
- CN
- China
- Prior art keywords
- information
- tracing
- storage area
- identity information
- database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Expired - Fee Related
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/018—Certifying business or products
Landscapes
- Business, Economics & Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Accounting & Taxation (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Finance (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a maternal and infant product production traceability management system, which comprises an identity information input module, a traceability management module and a traceability management module, wherein the identity information input module is used for endowing a maternal and infant product with unique identity information and inputting the identity information into a database; the system comprises a traceability information input module, a database and a database, wherein the traceability information input module is used for acquiring traceability information of maternal and infant articles and inputting the traceability information into the database; the database comprises an identity information storage area, a tracing information storage area and an information temporary storage area; the information matching module is used for matching the identity information and the tracing information in the database; and the information output module is used for outputting the tracing information of the maternal and infant products by reading the information stored in the information matching module. The invention can improve the defects of the prior art and improve the operation efficiency of the system.
Description
Technical Field
The invention relates to the technical field of information, in particular to a maternal and infant product production traceability management system and a maternal and infant product production traceability management method.
Background
The safety of the maternal and infant products directly affects the physical health of both the maternal and infant, so that the mass consumers pay more attention to the quality of the maternal and infant products. In order to strictly monitor the quality of maternal and infant products, a set of production traceability management system needs to be established. However, the existing production traceability management system has the problem of serious data redundancy, and the normal operation of the whole system is affected due to the fact that the processing speed of the system is reduced due to overlarge data amount after the system is used for a long time.
Disclosure of Invention
The technical problem to be solved by the invention is to provide a maternal and infant product production traceability management system and a method thereof, which can overcome the defects of the prior art and improve the system operation efficiency.
In order to solve the technical problems, the technical scheme adopted by the invention is as follows.
A maternal and infant product production traceability management system, which comprises,
the identity information input module is used for endowing the mother and infant products with unique identity information and inputting the identity information into a database;
the system comprises a traceability information input module, a database and a database, wherein the traceability information input module is used for acquiring traceability information of maternal and infant articles and inputting the traceability information into the database;
the database comprises an identity information storage area, a tracing information storage area and an information temporary storage area;
the information matching module is used for matching the identity information and the tracing information in the database;
and the information output module is used for outputting the tracing information of the maternal and infant products by reading the information stored in the information matching module.
A management method of the maternal and infant product production traceability management system comprises the following steps:
A. the identity information input module gives unique identity information to each piece of mother and infant article and inputs the identity information into a database;
B. in the production and circulation links of each piece of mother and infant supplies, the tracing information input module inputs corresponding tracing information into a database, and establishes the corresponding relation between the tracing information and the identity information;
C. the identity information and the tracing information are respectively stored in an identity information storage area and a tracing information storage area in a database;
D. the information matching module stores the identity information and the tracing information corresponding to the identity information into an information temporary storage area for information matching;
E. and the information output module outputs the matched maternal and infant article tracing information.
Preferably, in step B, the traceability information of the maternal and infant products includes material information, manufacturer information, manufacturing time information, warehouse information and distributor information.
Preferably, in the step B, the establishing of the corresponding relationship between the tracing information and the identity information includes the following steps,
b1, establishing a hash value of each identity information, and establishing a mapping relation of the tracing information corresponding to each hash value;
b2, merging the tracing information with the same content, and establishing a pointer link in a mapping relation corresponding to the merged tracing information for pointing to different identity information hash values;
b3, establishing an index directory linked by pointers, wherein the index directory is stored in the information temporary storage area.
Preferably, priority access rights are given to the information buffer.
Preferably, in the step D, the matching of the information includes the steps of,
the information matching module searches in an index directory in the information temporary storage area according to the hash value of the identity information, and if a corresponding pointer link is searched, the tracing information is read through the pointer link; and if the corresponding pointer link is not searched, searching the tracing information in the tracing information storage area directly through the mapping relation of the tracing information corresponding to the hash value.
Adopt the beneficial effect that above-mentioned technical scheme brought to lie in: according to the invention, by optimizing the storage and reading modes of the mother and infant product tracing information, the data storage capacity is simplified, and the data information reading speed is increased.
Drawings
FIG. 1 is a schematic diagram of one embodiment of the present invention.
In the figure: 1. an identity information input module; 2. a database; 3. a tracing information input module; 4. an information matching module; 5. an information output module; 21. an identity information storage area; 22. tracing an information storage area; 23. an information temporary storage area.
Detailed Description
Referring to fig. 1, one embodiment of the present invention includes,
the identity information input module 1 is used for endowing the mother and infant products with unique identity information and inputting the identity information into the database 2;
the tracing information input module 3 is used for acquiring tracing information of the maternal and infant products and inputting the tracing information into the database 2;
the database 2 comprises an identity information storage area 21, a tracing information storage area 22 and an information temporary storage area 23;
the information matching module 4 is used for matching the identity information and the tracing information in the database 2;
and the information output module 5 is used for outputting the traceability information of the maternal and infant products by reading the information stored in the information matching module 4.
A management method of the maternal and infant product production traceability management system comprises the following steps:
A. the identity information input module 1 gives unique identity information to each piece of mother and infant article and inputs the identity information into the database 2;
B. in the production and circulation links of each piece of mother and infant supplies, the tracing information input module 3 inputs corresponding tracing information into the database 2, and establishes the corresponding relationship between the tracing information and the identity information;
C. the identity information and the tracing information are respectively stored in an identity information storage area 21 and a tracing information storage area 22 in the database 2;
D. the information matching module 4 stores the identity information and the tracing information corresponding to the identity information into the information temporary storage area 23 for information matching;
E. the information output module 5 outputs the matched maternal and infant article tracing information.
In the step B, the tracing information of the maternal and infant products comprises raw material information, manufacturer information, manufacturing time information, warehousing information and distributor information.
In the step B, the establishment of the corresponding relationship between the tracing information and the identity information comprises the following steps,
b1, establishing a hash value of each identity information, and establishing a mapping relation of the tracing information corresponding to each hash value;
b2, merging the tracing information with the same content, and establishing a pointer link in a mapping relation corresponding to the merged tracing information for pointing to different identity information hash values;
b3, creating an index directory of pointer links, wherein the index directory is stored in the information temporary storage area 23.
Giving priority access to the information buffer 23.
In step D, the information matching includes the following steps,
the information matching module 4 searches in the index directory in the information temporary storage area 23 according to the hash value of the identity information, and if the corresponding pointer link is searched, the trace back information is read through the pointer link; if the corresponding pointer link is not retrieved, the trace back information is searched in the trace back information storage area 22 directly through the mapping relation of the trace back information corresponding to the hash value.
And setting a marking field in the pointer link, wherein the pointer link related to the tracing information with the same content has the same marking field, when the index directory is established, the marking field is used for establishing a first-stage index entry, the pointing path of the pointer link is used for establishing a second-season index entry, when the index directory is searched, the first-stage index entry is searched first, and then the second-season index entry is searched. According to the invention, the index directories are classified according to the characteristics of pointer links, so that the retrieval efficiency can be effectively improved.
In the description of the present invention, it is to be understood that the terms "longitudinal", "lateral", "upper", "lower", "front", "rear", "left", "right", "vertical", "horizontal", "top", "bottom", "inner", "outer", and the like, indicate orientations or positional relationships based on those shown in the drawings, are merely for convenience of description of the present invention, and do not indicate or imply that the referenced devices or elements must have a particular orientation, be constructed and operated in a particular orientation, and thus, are not to be construed as limiting the present invention.
The foregoing shows and describes the general principles and broad features of the present invention and advantages thereof. It will be understood by those skilled in the art that the present invention is not limited to the embodiments described above, which are described in the specification and illustrated only to illustrate the principle of the present invention, but that various changes and modifications may be made therein without departing from the spirit and scope of the present invention, which fall within the scope of the invention as claimed. The scope of the invention is defined by the appended claims and equivalents thereof.
Claims (2)
1. A management method of a maternal and infant product production traceability management system comprises,
the identity information input module (1) is used for endowing the mother and infant products with unique identity information and inputting the identity information into the database (2);
the tracing information input module (3) is used for acquiring tracing information of maternal and infant supplies and inputting the tracing information into the database (2);
the database (2) comprises an identity information storage area (21), a tracing information storage area (22) and an information temporary storage area (23);
the information matching module (4) is used for matching the identity information and the tracing information in the database (2);
the information output module (5) is used for outputting the maternal and infant article tracing information by reading the information stored in the information matching module (4);
the method is characterized by comprising the following steps:
A. the identity information input module (1) gives unique identity information to each piece of mother and infant article and inputs the identity information into the database (2);
B. in the production and circulation links of each piece of mother and infant supplies, the tracing information input module (3) inputs corresponding tracing information into the database (2), and establishes the corresponding relationship between the tracing information and the identity information;
the establishment of the corresponding relationship between the traceability information and the identity information comprises the following steps,
b1, establishing a hash value of each identity information, and establishing a mapping relation of the tracing information corresponding to each hash value;
b2, merging the tracing information with the same content, and establishing a pointer link in a mapping relation corresponding to the merged tracing information for pointing to different identity information hash values;
b3, establishing an index directory linked by pointers, wherein the index directory is stored in the information temporary storage area (23);
giving priority access rights to an information buffer (23)
C. The identity information and the tracing information are respectively stored in an identity information storage area (21) and a tracing information storage area (22) in a database (2);
D. the information matching module (4) stores the identity information and the tracing information corresponding to the identity information into an information temporary storage area (23) for information matching;
performing the matching of the information includes the steps of,
the information matching module (4) searches in an index directory in the information temporary storage area (23) according to the hash value of the identity information, and if a corresponding pointer link is searched, the trace back information is read through the pointer link; if the corresponding pointer link is not searched, searching the tracing information in the tracing information storage area (22) directly through the mapping relation of the tracing information corresponding to the hash value;
E. the information output module (5) outputs the matched maternal and infant article tracing information.
2. The management method of the maternal and infant product production traceability management system according to claim 1, wherein: in the step B, the tracing information of the maternal and infant products comprises raw material information, manufacturer information, manufacturing time information, warehousing information and distributor information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810323430.5A CN108564381B (en) | 2018-04-12 | 2018-04-12 | Mother and infant product production traceability management system and method thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810323430.5A CN108564381B (en) | 2018-04-12 | 2018-04-12 | Mother and infant product production traceability management system and method thereof |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108564381A CN108564381A (en) | 2018-09-21 |
| CN108564381B true CN108564381B (en) | 2021-09-24 |
Family
ID=63534679
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810323430.5A Expired - Fee Related CN108564381B (en) | 2018-04-12 | 2018-04-12 | Mother and infant product production traceability management system and method thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108564381B (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106296228A (en) * | 2016-08-16 | 2017-01-04 | 杭州维甄科技有限公司 | A kind of product product control source tracing method |
| CN107067266A (en) * | 2017-03-24 | 2017-08-18 | 广东省食品药品监督管理局政务服务中心 | A kind of dispensed food for baby electronics traceability system |
Family Cites Families (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060212243A1 (en) * | 2005-03-17 | 2006-09-21 | Levine Frank E | Event tracing using hash tables with support for dynamic address to name resolution |
| US8122501B2 (en) * | 2008-06-20 | 2012-02-21 | International Business Machines Corporation | Traitor detection for multilevel assignment |
| CN102309059B (en) * | 2010-06-30 | 2013-08-14 | 北京航天万源科技公司 | Box-type formula technology of tobacco threshing and redrying production line |
| CN102572958B (en) * | 2011-12-20 | 2014-12-10 | 中国船舶重工集团公司第七0九研究所 | Resource organization system and resource query method applicable to wireless mobile grid |
| US8788471B2 (en) * | 2012-05-30 | 2014-07-22 | International Business Machines Corporation | Matching transactions in multi-level records |
| CN103325041B (en) * | 2013-04-11 | 2016-09-21 | 青岛欧帝欧环保科技发展有限公司 | The false proof managing and control system of agricultural product security supply chain |
| CN103577856B (en) * | 2013-11-25 | 2017-03-08 | 王伟 | Product back-tracing system and method |
| CN106447362B (en) * | 2016-12-14 | 2020-01-07 | 大连中盈科技股份有限公司 | Method and device for preventing counterfeit and shoddy commodities from entering circulation field |
-
2018
- 2018-04-12 CN CN201810323430.5A patent/CN108564381B/en not_active Expired - Fee Related
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106296228A (en) * | 2016-08-16 | 2017-01-04 | 杭州维甄科技有限公司 | A kind of product product control source tracing method |
| CN107067266A (en) * | 2017-03-24 | 2017-08-18 | 广东省食品药品监督管理局政务服务中心 | A kind of dispensed food for baby electronics traceability system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108564381A (en) | 2018-09-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10664888B2 (en) | Method and system for attribute extraction from product titles using sequence labeling algorithms | |
| CN111666296A (en) | SQL data real-time processing method and device based on Flink, computer equipment and medium | |
| CN113220945B (en) | Method and system for field retrieval and path display of data blood edges | |
| CN112163160A (en) | Knowledge graph-based sensitive identification method | |
| CN105373541A (en) | Processing method and system for data operation request of database | |
| CN115130008B (en) | Search ordering method based on machine learning model algorithm | |
| CN105956666A (en) | Machine learning method and system | |
| CN112199363A (en) | Fusion storage method and system for agricultural multi-source heterogeneous data | |
| US20140317113A1 (en) | Tabular data parsing in document(s) | |
| CN108564381B (en) | Mother and infant product production traceability management system and method thereof | |
| CN113722302A (en) | Data management method and device | |
| CN107451623A (en) | A kind of multi-Sensor Information Fusion Approach and device | |
| CN115904238A (en) | Storage method and device based on data integration, computer equipment and storage medium | |
| Nishikawa et al. | Physical database design for manufacturing business analytics | |
| CN116662327B (en) | Data fusion cleaning method for database | |
| CN118625709A (en) | A fast two-way transmission processing method for IO signals of an automation control system | |
| CN118297448A (en) | Method, device, terminal and medium for tracing quality data of any point-to-point in whole process | |
| CN105574124A (en) | Data storage system based on product information | |
| CN106476423A (en) | A kind of printing quality monitoring system that can determine whether to put product type in storage | |
| US20210110344A1 (en) | Electronic device and data docking method | |
| CN115422293A (en) | Distributed database and data retrieval method thereof | |
| CN106919683B (en) | Method and system for quickly querying data | |
| CN115328961B (en) | A method for managing and retrieving product traceability information, an electronic device, and a storage medium. | |
| CN113284573A (en) | Method and device for searching document database | |
| CN106485383A (en) | A kind of printing quality monitoring system for carrying out putting judgement in storage |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20210924 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |