Title :
Structured Bill of Material Design and Consistency Maintenance in Drilling Industry
Author :
Li Runzhou ; Fang Ming ; Zhang Liumei
Author_Institution :
Sch. of Comput. Sci., Xi´an Shiyou Univ., Xi´an, China
Abstract :
In this paper, a ODBOM structure for oil-well construction process is designed by analyzing model and features of the ODBOM, and combining multi-layered and level-sorted BOM structure. Such design enables the construction of ODBOM tree, moreover simplifies both basic data preparation and data maintenance algorithm. In application, according to ODBOM consistency requirement, a consistency maintenance scheme is implemented to avoid recursive retrieval by using batch query via SQL statements.
Keywords :
bills of materials; maintenance engineering; oil drilling; trees (mathematics); ODBOM structure; ODBOM tree; SQL statements; consistency maintenance; level-sorted BOM structure; oil drilling; oil well construction process; structured bill of material design; Algorithm design and analysis; Bills of materials; Encoding; Maintenance engineering; Materials; Oil drilling; Periodic structures; Bill of Material; Consistency; Petroleum; Well Drilling;
Conference_Titel :
Intelligent Systems Design and Engineering Applications (ISDEA), 2014 Fifth International Conference on
Conference_Location :
Hunan
Print_ISBN :
978-1-4799-4262-6
DOI :
10.1109/ISDEA.2014.204
