Design and Effectiveness Analysis of Relational Logical BOM (Bill Of Material) Database using Repeated Join

반복 조인(Join)을 이용한 관계형 논리 부품구성표(BOM) 데이타 베이스 설계와 그 효용성 분석

Material Requirement Planning(MRP) has been the most widely implemented large scale production management system in the manufacturing industry. Computerization of MRP systems involves, in general, Bill Of Material(BOM) explosion algolithms which usually takes heavy computation time. In order to improve the effectiveness of the MRP systems, we propose to build a logical BOM database in advance, which reflects the Join operations for the BOM explosion. It reduces the response time for the BOM indented explosion. It reduces the MRP processing time. It also increased main memory utilization.