期刊文献+

关系型数据库BOM表的遍历算法的改进及实现 被引量:15

Modeling and Algorithms Implement of Traversing of BOM Production Based on Relational Database
下载PDF
导出
摘要 定义了单层BOM和多层BOM树的结构,并总结了实际运用中的多级型BOM遍历的两种基本算法:递归查找法、分层查找法.在介绍这两种算法的原理和对其速度、资源占用、实用性进行评价的基础上,提出了一种综合以上两种算法的优点,且适合普遍使用的关系型数据库存储的改进的多级型BOM遍历算法,使该改进算法包含速度快、资源占用低、实用性高的优点.同时详细介绍了此算法的软件实现,并且在实际的运用中取得了明显的效果. The mono-layer BOM and multi-layer BOM trees are defined, and two of the basic algorithms of traversal of multilevel BOM are summarized as well,which are Recursive Search and Level Search. Based on the analysis of algorithms principles, and evaluating the calculating rate, percentage of using CPU and practicability of them, a kind of improved Traversal of multi-level BOM algorithms is proposed. It is applied in relational database with high calculating rate, lower percentage of using CPU and high applicability. The software implement of these algori-thms is also introduced in detail, and the results of its application show that these algorithms are feasible and effective.
出处 《重庆大学学报(自然科学版)》 EI CAS CSCD 北大核心 2005年第7期82-85,共4页 Journal of Chongqing University
基金 重庆市制造业信息化重大专项子项目"重庆青山工业有限责任公司CAD/CIMS一期工程"(2001-03)
关键词 BOM 递归查找法 分层查找法 BOM recursive search level search
  • 相关文献

参考文献6

  • 1罗鸿,王忠民编著..ERP原理·设计·实施 第2版[M].北京:电子工业出版社,2003:366.
  • 2严蔚敏,吴伟民编著..数据结构 C语言版[M].北京:清华大学出版社,1997:334.
  • 3温咏堂.制造资源计划系统[R].北京:机电部北京机械工业总的呼研究所,1990.. 被引量:2
  • 4张列平主编..制造资源计划 MRPⅡ原理与实践[M].上海:上海交通大学出版社,1992:277.
  • 5冯玉才,刘玉葆,王元珍.关联规则开采的集合算法[J].小型微型计算机系统,2003,24(3):563-566. 被引量:3
  • 6张小剑,陈伟,窦延平.关于BOM的数据库设计及算法的研究[J].计算机应用与软件,2004,21(5):33-34. 被引量:3

二级参考文献9

  • 1张毅.企业资源计划(ERP)[M].北京:电子工业出版社,2002.. 被引量:4
  • 2[1]Agrawal R,Imielinski T and Swai A.Mining association rules between sets of items in large databases[C].Proc.ACM SIGMOD Conf.Management of Data,Washington,D.C .,May 1993,207~216 被引量:1
  • 3[2]Agrawal R and Srikant R.Fast algorithms for mining association rules[C].Proc. 20th Int'l Conf.Very Large Databases,Santiago,Chile,Sept 1994,487~499 被引量:1
  • 4[3]Houtsma M and A.Swai.Set-oriented mining of association rules in relational databases[C].Proc.Int'l Conf.Data Engineering,Taipei,March 1995,25~33 被引量:1
  • 5[4]Lavington S, Dewhurst N, Wilkins E and Freitas A.Interfacing knowledge discovery algorithms to large database management systems[J]. Informati on and Software Technology,1999,605~617 被引量:1
  • 6[5]Sunita Sarawagi, Shiby Thomas, Rakesh Agrawal. Integrating associati on rule mining with relational database systems:alternatives and implications[R].Resea rch Report of IBM Research Division Almaden Research Center,1998; 被引量:1
  • 7[6]Han J,Fu Y, Koperski K, Wang W and Zaiane O. DMQL:a data mining query lang uage for relational database[C]. In Proc. of the 1996 SIGMOD workshop o n res earch issues on data mining and knowledge discovery, Montreal, Canada, May 1996 被引量:1
  • 8[7]Imielinski T,Virmani A and Abdulghani A. Discovery board application programming interface and query language for database mining[C]. In Proc. of the 2nd Int'l Conference on Knowledge Dicovery and Data Mining, Portland, Oregon, August 1996 被引量:1
  • 9程控 革扬.MRPⅡ/ERP原理与应用[M].电子工业出版社,(2002).. 被引量:1

共引文献5

同被引文献80

引证文献15

二级引证文献38

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

内容加载中请稍等...
;
使用帮助 返回顶部