摘要
针对缺陷产品进行召回管理的迫切性,指出了产品可追溯性研究的必要性,在总结和借鉴已有产品可追溯性研究的基础之上,给出了产品可追溯性的定义。基于以上讨论,提出并深入分析了批次清单的概念,以及通过构建批次清单实现产品可追溯性的方法;给出了基于关系型数据库的单层批次清单的数据库设计方法。
Due to the impendency of defective products recalls and management, it is necessary to study on the product traceability. Basing on the study of current researches on this topic, this paper gives the definition of product traceability. The concept of Bill of Lots (BOL)is analyzed and discussed in details. The method of tracking and tracing products through the BOL construction is also introduced. This paper presents a one-level BOL database design method based on the relationship database.
出处
《工业工程》
2006年第3期45-48,共4页
Industrial Engineering Journal
关键词
产品可追溯性
批次清单
追溯方法
数据库设计
product traceability
bill of lots (BOL)
method of tracking and tracing
design of database