产品配置管理系统中数据库关键技术的研究  

Key technology of database in product configuration management system

作　　者：郑雁翎[1] 

机构地区：[1]宝鸡文理学院电子电气工程系,宝鸡721007

出　　处：《机械设计与制造》2012年第5期264-266,共3页Machinery Design & Manufacture

基　　金：宝鸡文理学院重点项目(ZK11048)

摘　　要：目的为了有效地组织和管理好机械产品数据和信息,并且提高已有资源的利用率,研究产品配置系统的数据库设计无疑是一项重要的工作。方法提出一种从树状结构过渡到部分网状的产品配置数据结构,并引入到数据库设计中,在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.

关 键 词：数据库设计 数据结构 关系数据库 面向对象 产品配置 

分 类 号：TH16[机械工程—机械制造及自动化]