Structured Bill of Material Design and Consistency Maintenance in Drilling Industry

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.