摘要
目的为了有效地组织和管理好机械产品数据和信息,并且提高已有资源的利用率,研究产品配置系统的数据库设计无疑是一项重要的工作。方法提出一种从树状结构过渡到部分网状的产品配置数据结构,并引入到数据库设计中,在PDM的关系数据库管理系统中,实现对产品数据的面向对象表示。结果基于SmarTeam-PDM创建符合于产品配置系统的数据结构,构造一个适合用户需要的数据库。结论采用基于关系数据库的面向对象技术,实现产品配置系统数据库设计,提高了基于PDM的产品配置系统开放性和适应能力,为设计类似系统数据库提供了参考。
Aim The aim of this research was to effectively organize and manage mechanical products data information,and improve the utilization of existing resources.Methods presents a data structure changed from tree structure to part reticular structure,which was introduced into the database design,so as to realize Object-Oriented technology in relational database of the product configuration management system.Results Based on the PDM SmarTeam,data structure was created corresponds to the product configuration system,and then a database be nicely able to the mark of user requirements was constructed.Conclusion The results suggest that realizing the product configuration system database design based on object-oriented technology of relational database,improve the product configuration openness and adaptability,and provides reference for database design of similar system.
出处
《机械设计与制造》
北大核心
2012年第5期264-266,共3页
Machinery Design & Manufacture
基金
宝鸡文理学院重点项目(ZK11048)
关键词
数据库设计
数据结构
关系数据库
面向对象
产品配置
Database design
Data structure
Relational database
Object-oriented database
Product configuration