关键词: 物料清单, 存储模型, 可扩展标记语言, 缓存

Abstract: To exactly represent the graph data structure of manufacturing BOM in actual production, BOM structure was defined as an independent entity in the storage model and the relationships of Father_Part-Structure and Structure-Son_Part were separated and corresponding mathematical models were presented respectively. A novel storage model combining XML data model with relation data model was constructed, and the tree structured XML model was designed as the cache of BOM query results to avoid the inefficiency of transforming BOM data from relational model to tree structured object model. The entity relationship diagram of the novel model and the XML architecture of the cache were presented, and the methods of creating and querying the cache in XML type were introduced in detail. Running in an actual production system, the novel model could greatly improve efficiency of BOM data querying when compared with traditional models.

Key words: bill of material, storage model, extensible markup language, cache