摘要
研究当前主要的两种BOM表结构——单层BOM结构和多层BOM结构,分析它们各自的优缺点.提出一种基于存储过程的单层BOM结构到多层BOM结构转化的方法,并给出部分实现代码.该算法是基于存储过程的,因此,相对于一般的算法具有更好的计算性能.
Two main bill of material （BOM） structures which are single BOM and multiple BOM are studied. The advantages and disadvantages of these two structures are analyzed. An algorithm which is based on store procedure and transforms single BOM to multiple BOM is presented. At the same time, part codes of the algorithm is given. The algorithm based on store procedure has higher computational performace that of the general algorithnm.
出处
《华侨大学学报（自然科学版）》
CAS
北大核心
2009年第3期354-356,共3页
Journal of Huaqiao University(Natural Science)
基金
福建省青年科技人才创新项目(2006F3085)
关键词
物料清单
企业资源计划
数据库
存储过程
bill of material
enterprise resource planning
database
store procedure
