Proceedings of the 2nd International Conference on Computer Science and Electronics Engineering (ICCSEE 2013)

A New Type of BOM Model and Its Application

Authors
Yao Wang, Weiguo Wang, Song Mao
Corresponding Author
Yao Wang
Available Online March 2013.
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)

Volume Title
Proceedings of the 2nd International Conference on Computer Science and Electronics Engineering (ICCSEE 2013)
Series
Advances in Intelligent Systems Research
Publication Date
March 2013
ISBN
978-90-78677-61-1
ISSN
1951-6851
DOI
10.2991/iccsee.2013.486How to use a DOI?
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/).

Cite this article

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  -