A New Type of BOM Model and its Application

Yao Wang; Wei Guo Wang; Song Mao

doi:10.4028/www.scientific.net/AMM.347-350.1234

Paper Titles

Structure-Based Pharmacophore Models Generation and Combinatorial Screening of ICE Inhibitors
p.1216

The Research on the Rice Bran Extruder's Body Structural Design
p.1221

The Design of Demountable Modular Milling Attachment Based on Engine Lathes
p.1224

Machining Precision Research for Two WEDM Processes
p.1229

A New Type of BOM Model and its Application
p.1234

XPS Analysis of Carbon and Oxygen in Coking Coal with Different Density Intervals
p.1239

Discussion on Optimizing Internal Supply Chain of Chinese Enterprise
p.1244

Fiber Grating Based 64-Channel Interleavers with 25GHz Channel Spacing and Flat-Top Passbands
p.1251

Potential Transformer in High-Frequency and mV Voltage
p.1256

HomeApplied Mechanics and MaterialsApplied Mechanics and Materials Vols. 347-350A New Type of BOM Model and its Application

A New Type of BOM Model and its Application

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.

You might also be interested in these eBooks

View Preview

Info:

Periodical:

Applied Mechanics and Materials (Volumes 347-350)

Pages:

1234-1238

DOI:

https://doi.org/10.4028/www.scientific.net/AMM.347-350.1234

Citation:

Cite this paper

Online since:

August 2013

Authors:

Yao Wang, Wei Guo Wang, Song Mao

Keywords:

Bill of Material, Cache, Storage Model, XML

Export:

RIS, BibTeX

Price:

Permissions CCC:

Request Permissions

Permissions PLS:

Request Permissions

Сopyright:

Citation:

References

[1] Benbo LI. Research on Process Capability and Control Chart for Mass Varieties and Small Batches Production[D]. Chongqing: Chongqing University, 2007. (In Chinese).

Google Scholar

[2] Zhiqiang Wei, Xiankui Wang, Dan Wu, et al. BOM multi-view mapping of product based on a single data source[J]. Journal of Tsinghua University(Science and Technology). 2002, 42(6): 802-805. (In Chinese).

Google Scholar

[3] Guiliang Xie, Junqiang Wang, Shudong Sun. BOM information system based on component and new data structure[J]. Chinese Journal of Mechanical Engineering. 2004, 40(5): 118-120. (In Chinese).

DOI: 10.3901/jme.2004.05.118

Google Scholar

[4] Zheng DONG, Xiao-fei XU, De-chen ZHAN. Research on New Product Structure Model Based on Semi-structured Data[J]. Computer Integrated Manufacturing Systems. 2003, 9(1): 15-19. (In Chinese).

Google Scholar

[5] Xuewen HUANG, Yushun Fan. RESEARCH ON BOM VIEWS AND BOM VIEW MAPPING MODEL[J]. Chinese Journal of Mechanical Engineering. 2005, 41(04): 97-102. (In Chinese).

DOI: 10.3901/jme.2005.04.097

Google Scholar

[6] Xiaopan Zhang, Yi Lei, Hongfeng Liu, etal. Customization Approach for CAXA-BOM Generation[J]. Journal of Computer Aided Design & Computer Graphics. 2002, 14(5): 483-485. (In Chinese).

Google Scholar