[1]陈志烽,陈永红.一种单层BOM到多层BOM转化算法的实现[J].华侨大学学报(自然科学版),2009,30(3):354-356.[doi:10.11830/ISSN.1000-5013.2009.03.0354]
　CHEN Zhi-feng,CHEN Yong-hong.An Algorithm Implemention of Transformation from Single BOM to Multiple BOM[J].Journal of Huaqiao University(Natural Science),2009,30(3):354-356.[doi:10.11830/ISSN.1000-5013.2009.03.0354]
点击复制

一种单层BOM到多层BOM转化算法的实现()
分享到：

《华侨大学学报（自然科学版）》[ISSN:1000-5013/CN:35-1079/N]

卷:
第30卷
期数:
2009年第3期
页码:
354-356
栏目:
出版日期:
2009-05-20

文章信息/Info

Title:
An Algorithm Implemention of Transformation from Single BOM to Multiple BOM
文章编号:
1000-5013(2009)03-0354-03
作者:
陈志烽; 陈永红
华侨大学计算机科学与技术学院
Author(s):
CHEN Zhi-feng;  CHEN Yong-hong
College of Computer Science and Technology, Huaqiao University, Quanzhou 362021, China
关键词:
物料清单;  企业资源计划;  数据库;  存储过程
Keywords:
bill of material;  enterprise resource planning;  database;  store procedure
分类号:
TP301.6
DOI:
10.11830/ISSN.1000-5013.2009.03.0354
文献标志码:
A
摘要:
研究当前主要的两种BOM表结构——单层BOM结构和多层BOM结构,分析它们各自的优缺点.提出一种基于存储过程的单层BOM结构到多层BOM结构转化的方法,并给出部分实现代码.该算法是基于存储过程的,因此,相对于一般的算法具有更好的计算性能.
Abstract:
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 algorithm.

参考文献/References:

[1] 陈 庄, 毛华扬. ERP原理与应用教程 [M]. 北京:电子工业出版社, 2006.33-34.
[2] GOU Ling-yi, WEI Sheng-min. Database designing and optimizing for dynamic product BOM based on rehtional database [J]. Modular Machine Tool & Automatic Manufacturing Technique, 1999(5):6-9.
[3] 严蔚敏, 吴伟民. 数据结构 [M]. 北京:清华大学出版社, 1997.118-120.
[4] JI Guo-li, GONG Da-xin, TSUI F. Analysis and implementation of the BOM of a tree-type structure in MRP II [J]. Journal of Materials Processing Technology, 2003, (1/3):535-538.doi:10.1016/S0924-0136(03)00520-X.
[5] WU Muh-cherng, HSU Yang-kang. Design of BOM configuration for reducing spare parts logistic costs [J]. Expert Systems With Applications, 2008(4):2417-2423.doi:10.1016/j.eswa.2007.04.001.
[6] 陈维斌, 喻小光. 一种XML数据到结构化数据的转换方法 [J]. 华侨大学学报(自然科学版), 2003(2):201-207.doi:10.3969/j.issn.1000-5013.2003.02.017.

备注/Memo

备注/Memo:
福建省青年科技人才创新项目(2006F3085)
更新日期/Last Update: 2014-03-23