A New Type of BOM Model and Its Application

DOI

10.2991/iccsee.2013.486How to use a DOI?

Keywords

Bill of Material, Storage model, XML, Cache

Abstract

To exactly represent the graph data structure of BOM in actual design and production, BOM structure was defined as an independent entity in the storage model and the relations of Father_Part-Structure and Structure-Son_Part were separated and described mathematically respectively. A novel storage model combining XML data model and relational data model was built, 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 schema of the cache were present, and the methods of creating and querying the cache in XML type was introduced in detail. Running in a real system, the novel model can greatly improve efficiency of BOM data querying comparing to traditional models.

Copyright

© 2013, the Authors. Published by Atlantis Press.

Open Access

This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).

Download article (PDF)

TY  - CONF
AU  - Yao Wang
AU  - Weiguo Wang
AU  - Song Mao
PY  - 2013/03
DA  - 2013/03
TI  - A New Type of BOM Model and Its Application
BT  - Proceedings of the 2nd International Conference on Computer Science and Electronics Engineering (ICCSEE 2013)
PB  - Atlantis Press
SP  - 1937
EP  - 1940
SN  - 1951-6851
UR  - https://doi.org/10.2991/iccsee.2013.486
DO  - 10.2991/iccsee.2013.486
ID  - Wang2013/03
ER  -