再制造产品数据库中对象唯一性标识方法

Object Identification in Remanufacturing Database

提出了一种运用关系型数据库的外键约束和编码系统的混合方式实现再制造数据库对象唯一性标识的方法,即从项目到零件,采用编码的形式;零件层以下,采用主键结合外键参考的外键约束方法。再制造产品由于其毛坯是废旧的机电产品,其产品信息具有不确定性的特点,为此表述再制造产品信息的信息模型是不完全的树型结构。在创建再制造产品数据库对象唯一标识的主键时,文中首先试图采用现有的外键约束方法和编码系统方法,结果表明这两种中方法都有其欠缺和不足。实践证明,该混合方式的数据库对象标识方法能较好地解决具有不完全的树型结构的数据库对象的唯一标识问题。

This paper proposes a hybrid object identification in remanufacturing database combining constraint-foreign keys of relational database with coding system.That is,object identification based on coding system is used from the item level to parts level and the method of constraint-foreign keys combining main keys with foreign keys is used below the pat level.To illustrate the remanufacturing product information in detail,its model is described in an incomplete tree structure because the remanufacturing blanks come from discarded electromechanical products and their product information are usually uncertain.After analysis,either constraint-foreign keys of relational database or coding system both are defective,but the hybrid object identification meutioned in this paper is very effective.