Management and instant query of distributed oil and gas production dynamic data

WANG Hongliang,MU Longxin,SHI Fugeng,LIU Kaiming,QIAN Yurong

Table 3 Fact table of production well.

Subject Fact table Data category Indicators Data analysis of production well Well information Spud date, coordinate, and target formation, etc. Production data Production time, liquid production, oil production, water production, gas production, gas volume vented, verified liquid production, verified oil production, verified water production, verified gas production, water cut, and gas oil ratio, etc. Status data Oil nozzle, electric pump current A, electric pump current B, electric pump current C, electric pump voltage, tubing pressure, casing pressure, back pressure, shutdown tubing pressure, and shutdown casing pressure, etc. Mechanical data Pump efficiency, pump diameter, discharge capacity, stroke length, stroke frequency, revolutions, dynamic liquid level, static liquid level, theoretical discharge capacity, static pressure, and flowing pressure, etc. Stimulation data Stimulation type, starting date, completion date, primary stimulation, secondary stimulation, oil production, oil production increment, etc. Shutdown data Starting time, end time, shutdown type, gas production before shutdown, etc.