Khabbazi, Mahmood Reza and Ismail, Md.Yusof and Ismail, Napsiah and Mousavi, Sayed Alireza (2010) Modeling of Traceability Information System for Material Flow Control Data. Australian Journal of Basic and Applied Sciences, 4 (2). pp. 208-216. ISSN 1991-8178
This paper focuses on data modeling for traceability of material/work flow 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. Dynamic data processing of Quality and Purchase activities are considered in data modeling as well as Order and Operation base on lots particulars. The modeling consisted of four steps and integrated as one final model. Entity-Relationships Modeling as data modeling methodology is proposed. The model is reengineered with Toad Data Modeler software in physical modeling step. 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 levels of manufacturing processes. Through enhanced visibility and dynamic store/retrieval of data, all traceability usages and applications is responded. Designed solution is initially applicable as reference data model in identical lot-base traceability system.
|Keyword:||Computer-aided systems, Manufacturing information system, Data modeling, Traceability, Entity-relationship modeling, Lot-based material flow control|
|Faculty or Institute:||Faculty of Engineering|
|Deposited By:||Anas Yahaya|
|Deposited On:||19 Apr 2011 17:01|
|Last Modified:||19 Apr 2011 17:05|
Repository Staff Only: item control page