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 On:||19 Apr 2011 09:01|
|Last Modified:||04 Jul 2014 06:45|
Repository Staff Only: Edit item detail
Document Download Statistics
This item has been downloaded for since 19 Apr 2011 09:01.