| 基于存储过程的物料单层次码算法 |
| |
| 引用本文： | 焦文彬,宫俊,汪定伟. 基于存储过程的物料单层次码算法[J]. 控制工程, 2003, 10(1): 53-55 |
| |
| 作者姓名： | 焦文彬 宫俊 汪定伟 |
| |
| 作者单位： | 东北大学,信息科学与工程学院,系统工程研究所,辽宁,沈阳,110004 |
| |
| 基金项目： | 国家自然科学基金资助项目 (70 1710 5 6) |
| |
| 摘 要： | 作为制造业的EPR软件，物料需求计划（MRP）模块是必不可少的，模块的基础数据之一的物料单层次码的计算，对于该类ERP软件的成功编制是一个很重要的环节，介绍了层次码算法，采用了递归的设计思想，充分利用现代关系数据库所提供的强大查询，计算功能，将其设计为一个存储过程，设计符合现代软件工程思想，即将用户界面，商务逻辑，数据相分离的原则，以便于维护、移植，由于存储过程是在服务器端运行，也使得算法具有较高的执行效率。
|
| 关 键 词： | 存储过程 物料单层次码算法 软件设计 制造业 ERP |
| 文章编号： | 1671-7848(2003)01-0053-03 |
| 修稿时间： | 2002-05-13 |
Algorithm of BOM Level Code Based on Store Procedure |
| |
| JIAO Wen bin,GONG Jun,WANG Ding wei. Algorithm of BOM Level Code Based on Store Procedure[J]. Control Engineering of China, 2003, 10(1): 53-55 |
| |
| Authors: | JIAO Wen bin GONG Jun WANG Ding wei |
| |
| Abstract: | As a ERP software of manufacturing industry, generally speaking, Material Requirement Planning (MRP) module is necessary. So as a basic data module, the computing of BOM level code is an important part to make the ERP software successfully. Here, the algorithm adopts recursion ideology and makes full use of the powerful querying and computing functions of modern relation database system. The algorithm performs as a store procedure, so it meets modern software engineering, that is, separating the GUI, business logic and data in order to maintain and transplant. Since store procedure runs at server side, it also makes the algorithm has a high executing efficiency. |
| |
| Keywords: | level code store procedure ERP MRP BOM |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
