Effective relational database approach to represent bills-of-materials
| Autor: | Askiner Gungor, Ali Aydın |
|---|---|
| Jazyk: | angličtina |
| Rok vydání: | 2005 |
| Předmět: |
Engineering
Material requirements planning Bill-of-materials (BOM) Operations research Relational database Strategy and Management Mass customization Bill of quantities Management Science and Operations Research computer.software_genre Industrial and Manufacturing Engineering Personalization Production (economics) bill-of-materials (BOM) material requirements planning (MRP) mass Materials handling Database business.industry Product design Product (business) Planning Product development Production systems Database systems Materials requirement planning (MRP) Manufacturing resource planning business computer Material requirements planning (MRP) Algorithms customization |
| Popis: | Today's production systems are under the pressure of mass customization where customer orders may result in an explosive number of product variations. Handling information related to materials and components becomes a complex issue with the increasing variability. This paper presents an effective approach to handle product information in a relational database environment for multi-product and multi-process production systems. The approach presented in this paper aims to reduce the efforts when de. ning products to the production systems for the purpose of generating bills-of-materials (BOMs) and executing material requirements planning (MRP). Two algorithms are presented in this paper. The first algorithm is to retrieve information from the relational database environment to generate the BOMs. The second algorithm calculates the material requirements for all products in a customer order list. Examples are chosen from textiles since complications related to the MRP issues are at a greater extent in this branch of the industry. C1 Pamukkale Univ, Coll Engn, Dept Ind Engn, TR-09020 Denizli, Turkey. Egekom Ltd, TR-09020 Denizli, Turkey. |
| Databáze: | OpenAIRE |
| Externí odkaz: |
|