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 EntityRelationships 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.

Performance Prediction of a MongoDB-Based Traceability System in Smart Factory Supply Chains

“…Khabbazi et al [24] proposed a data modeling method for lot-based traceability systems in make-to-order production environments. They suggested an integrated traceability model including quality lot, quality lot relation, operation lot relation, and order lot by performing conceptual modeling and physical modeling.…”

“…Figure 1 describes all four dimensions that must be included in a single traceability event based on EPCIS version 1.1 (GS1 EPCglobal) [22]. As proposed in [24], traceability data can include ordering, purchasing, and quality data. However, in this research, the traceability data range is restricted to data that can be collected from IoT, such as RFID, barcodes, sensors, and GPS.…”

Developing a Framework for Traceability Implementation in the Textile Supply Chain

“…[54]. These requirements are managed by the proper identification and classification of information, and the classification helps with easier identification of entities and relationships of various ingredients to form the traceable entity [25,54]. The traceable entity can be a batch of products, lot, or a single product.…”

Un DSL para trazabilidad alimentaria

“…Para esto propone un modelo de datos donde toda la información técnica del producto se encuentra inmersa en el producto mismo. Khabbazi et al (2009), plantean los inconvenientes más comunes de la trazabilidad en la industria de la manufactura en general, tomando como ejemplo la fabricación de automóviles y sus partes, y cómo la información de trazabilidad se almacena en diferentes sistemas y en fuentes de datos heterogéneas; y luego presenta un diagrama Entidad-Relación para modelizar los datos de un sistema de trazabilidad centrado en el producto, que pretende resolver esos problemas e incorpora características de calidad de los productos. Se comprueba que el modelo presentado hace que el pasaje desde el análisis del sistema hacia la implementación sea más rápido y menos complicado.…”

“…Para que la trazabilidad al nivel de las TRU sea efectiva se debe implementar un sistema que administre eficientemente los recursos, debido a que la información está almacenada en fuentes muy heterogéneas en las diferentes compañías. Por esto, el modelo de datos de trazabilidad debe proveer una representación integral de los contenidos de estas diversas fuentes y suministrar un punto de acceso único a la información de los productos a través de su ciclo de vida, mediante el mapeo de las estructuras de las fuentes de los datos y de su contenido (Khabbazi et al, (2009)) (Tursi et al, (2007)).…”