Data Loading Example 2

Data Loading example 2 (BHA with components)

If you use the above configuration, the data would look like the following tables if there is a need to store the actual composition of the BHA.

Drill_String

ID	NAME	BOREHOLE_ID
145123	Drill String #1	125087

BHA

The Bottom Hole Assembly is a logical facility used to hold the individual components that comprise it.

ID	NAME
145127	BHA #1

Drill_Bit

Drill_Bit_Type is a foreign key to the R_Drill_Bit class.

ID	DRILL_ BIT_TYPE	DRILL_HOLE_DIAMETER	MANUFACTURER	MODEL_NAME
145124	PDC	9.5	Baker	HCR-605

Generic_Tubular

ID	CATEGORY	LENGTH	MANUFACTURER	OUTSIDE_DIAMETER
145129	Bit Sub	0.5		8
145133	Drill Collar	18.63		8
145137	Crossover	1.09		8
145141	Drill Collar	56.99		6.5
145145	Crossover	0.52		6.5
145149	Heavyweight Drill Pipe	64.48		4
145153	Drill Pipe	597.51		4

Facility Connector

The facility_id is the foreign key attribute that links this connector to the facility to which it belongs. The attribute Facility_Tbl holds the table name where that facility can be found.

ID	FACILITY_ID	FACILITY_TBL	THREAD_TYPE	THREAD_OUTSIDE_DIAMETER	NAME
145125	145124	Drill_Bit	API REG	6.626	Top
145130	145129	Generic_Tubular	API REG	6.625	Top
145131	145129	Generic_Tubular	API REG	6.625	Bottom
145134	145133	Generic_Tubular	API REG	6.625	Top
145135	145133	Generic_Tubular	API REG	4.5	Bottom
145138	145137	Generic_Tubular	API REG	4.5	Top
145139	145137	Generic_Tubular	API REG	4.5	Bottom
145142	145141	Generic_Tubular	IF	4.5	Top
145143	145141	Generic_Tubular	API REG	4.5	Bottom
145146	145145	Generic_Tubular	FH	4.5	Top
145147	145145	Generic_Tubular	IF	4	Bottom
145150	145149	Generic_Tubular	FH	4	Top
145151	145149	Generic_Tubular	FH	4	Bottom
145154	145153	Generic_Tubular	FH	4	Top
145155	145153	Generic_Tubular	FH	4	Bottom

Facility_Composition

The whole_facility_id is the foreign key attribute to the whole facility, and the attribute whole_facility_tbl holds the name of the table in which this facility_id can be found.

The part_facility_id is the foreign key attribute to the part facility, and the attribute part_facility_tbl holds the name of the table in which this facility_id can be found.

The linear_sequence is the sequence in which the components are arranged within the assembly. The convention in drilling is that the first item placed in the hole is item #1, and so on. In this case, the Drill bit is the first thing in, then the BHA, and finally the drill pipe. In addition to this, you can also see that the BHA is composed of a bit sub, drill collar, crossover, drill collar, crossover, and heavyweight drill pipe.

ID	WHOLE_ FACILITY_TBL	WHOLE_ FACILITY_ID	PART_FACILITY_TBL	PART_ FACILITY_ID	PART_FACILITY_ ROLE	LINEAR_SEQUENCE
145126	Drill_String	145123	Drill_Bit	145124	Drill Bit	1
145132	BHA	145127	Generic_Tubular	145129	BHA Component	1
145136	BHA	145127	Generic_Tubular	145133	BHA Component	2
145140	BHA	145127	Generic_Tubular	145137	BHA Component	3
145144	BHA	145127	Generic_Tubular	145141	BHA Component	4
145148	BHA	145127	Generic_Tubular	145145	BHA Component	5
145152	BHA	145127	Generic_Tubular	145149	BHA Component	6
145156	Drill_String	145123	Generic_Tubular	145153	Drill Pipe	3
145128	Drill_String	145123	BHA	145127	BHA	2