Modeling of traceability information system for material flow control data

Abstract

This paper focuses on data modeling for traceability of material/work flow in informationlayer of manufacturing control system. The model is able to trace all associated data throughout theproduct manufacturing from order to final product. Dynamic data processing of Quality and Purchaseactivities are considered in data modeling as well as Order and Operation base on lots particulars. Themodeling consisted of four steps and integrated as one final model. Entity-Relationships Modeling asdata modeling methodology is proposed. The model is reengineered with Toad Data Modeler softwarein physical modeling step. The developed model promises to handle fundamental issues of atraceability system effectively. It supports for customization and real-time control of material in flowin all levels of manufacturing processes. Through enhanced visibility and dynamic store/retrieval ofdata, all traceability usages and applications is responded. Designed solution is initially applicable asreference data model in identical lot-base traceability system.