Data Modeling of Traceability Information for Manufacturing Control System

Abstract

This paper focuses on data modeling for traceability in information layer of manufacturing control system. The model is able to trace all associated data throughout the product manufacturing from order to final product. Applicability of designed data-model is enhanced with traceability of associated quality data for the system dynamically. The modeling consisted of four steps, mapped successfully and integrated in one final framework. Techniques and procedures of the modeling are explained along with business relationships. Data model expression based on Entity-Relationships modeling is proposed. The developed model promises to handle fundamental issues of a traceability system effectively. It supports for customization and real-time control of material in flow in all quality and production operation processes. Recording deviations and assessing their impact become easier. Through enhanced visibility and dynamic store/retrieval of data, all traceability usages and applications is responded. Designed solution is initially applicable in identical lot-base traceability of material in flow cases as a reference data model.