摘要
为准确表达实际生产中制造物料清单的图形数据结构,在物料清单存储模型中将装配结构定义为独立实体,使父件-结构和结构-子件两层关系分离,并分别给出了数学描述。针对物料清单数据由关系模型转换为树形结构的对象模型时所导致的效率下降,建立了关系模型与可扩展标记语言模型相结合的新型存储模型,将具有树形结构的可扩展标记语言模型设计为物料清单查询结果在数据库中的缓存。给出了新型存储模型的实体关系图和缓存部分的可扩展标记语言架构,并详细介绍了可扩展标记语言模型缓存的构建及查询方法。在实际系统运行中与传统模型相比,该模型可大幅提高物料清单的查询效率。
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.
出处
《计算机集成制造系统》
EI
CSCD
北大核心
2010年第3期558-562,共5页
Computer Integrated Manufacturing Systems
关键词
物料清单
存储模型
可扩展标记语言
缓存
bill of material
storage model
extensible markup language
cache