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

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

Table 2 Descriptions of dimension table of production well.

Dimension Description of dimension levels Date Year, quarter, month, ten days, day Well purpose Oil well, gas well Drive type Primary recovery, water flooding, chemical flooding, thermal recovery of heavy oil, etc. Production method Flowing, pumping unit, electric pump, screw pump, jet pump, and air lift, etc. Oil and gas type Thin oil, heavy oil, conventional natural gas, coal bed methane, shale gas Well type Vertical, horizontal Reservoir type Medium and high permeability sandstone, low permeability sandstone, conglomerate, and heavy oil, etc. Production unit Oilfield, reservoir, block, layer Organization Company, plant, mine and team