摘要
在分析产品动态 B O M 数据结构特点的基础上,通过比较,提出了一种在关系型数据库中表达 B O M 数据信息的合理的数据库设计方案。并针对 B O M 的使用情况和关系型数据库后台管理系统的特点。
In this paper,we discuss three main kinds of BOM representation methods,which have different advantages and disadvantages. By comparison,we conclude that the single child-single father method is the most suitable solution, which has the most stable structure and needs the least mount of storage space.In relational database,an appropriate index can be adopted to greatly improve the speed of data query.In the light of the use condition of BOM and the feature of the relational database management system, we prove a kind of composite index is optimal.
出处
《组合机床与自动化加工技术》
北大核心
1999年第5期6-9,共4页
Modular Machine Tool & Automatic Manufacturing Technique