1 / 13

ONGC’s Feedback for POSC

ONGC’s Feedback for POSC. P.K. Mittal GM-Head EPINET Project Oil & Natural Gas Corporation Ltd India. EPINET. Exploration and Production Information Networking project Distributed databases involving 18 servers A 3-Tier database approach for data flow:

quilla
Download Presentation

ONGC’s Feedback for POSC

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ONGC’s Feedback for POSC P.K. Mittal GM-Head EPINET Project Oil & Natural Gas Corporation Ltd India

  2. EPINET • Exploration and Production Information Networking project • Distributed databases involving 18 servers • A 3-Tier database approach for data flow: • Field level : Asset/Forward Base Database • Regional level : Basin Database • Corporate level : Corporate Database • Covers Well, Production, Drilling, Seismic, Logging & Physical Asset data utilizing • Online Master Database • Log Archival Database • Seismic Archival Database

  3. Softwares • FINDER • LOGDB • SEISDB • DRILLDB • ASSETDB • GEOFRAME GEOLOGY • GEOFRAME PETROPHYSICS • DECISION POINT DATA ACCESS

  4. Databases & Their Integration 1. Corporate Server Dehradun • KDMIPE, IDT, GEOPIC, E&D Dte & Frontier Basin 2. Regional Server Panvel 3. Regional Server Baroda 4. Regional Server Jorhat 5. Regional Server Chennai 7. Regional Server Kolkata • Western Offshore Basin • IOGPT • A&AA Basin • Cauvery Basin • CBM-BPM Basin • Western Onshore Basin 9. Ahmedabad Site Server • IRS • A’Bad Asset 6. Rajahmundry Site Server 14. Nazira Site Server 10.Mehsana Site Server • Assam Asset • KG Basin • Rajahmundry Asset • Mehsana Asset 17 Karaikal Site Server 8. Vasudhara Site Server 15. Agartala Site Server 11.Ankleshwar Site Server • Mumbai High Asset • Neelam Asset • Bassein Asset • Uran plant • Hazira plant • Tripura Asset • Karaikal Asset • Ankleshwar Asset 12. Cambay Site Server 16. Silchar Site Server • Cambay FB 13. Jodhpur Site Server • Cachar FB • Jodhpur FB

  5. ONGC’s UWI Policy • Maximum Character size is 20. • 2 characters are reserved for the Region Code • 5 characters are reserved for the Field/Structure Code • 13 characters are reserved for the Well_No and the Well_Type_Code. • Some of the examples of the UWI generated are: • W-AMBD-20 (Western Region, Ahmedabad , Well no 20) • M-B-126-5 (Field code=’M-B-126’, Well no=’5’)

  6. UWI- Well Type Codes • Well Type Code codes are • Horizontal………………..(H) • Drain Hole……………….(DH) • Sub sea Completion …...(SS) • 1st SideTrack……….…. (Z) • 2nd Side Track……….….(Y) • 3rd Side track ……….…..(X) • Multilateral ………. (ML) • First Multilateral……... (ML1) • Second Multilateral….…..(ML2) • Examples: M-B173A-A6-H (Horizontalwell A6 of B173A Structure)

  7. Seismic Data Management Issues • Location data & trace data stored separately • Viewing data is through different S/W applications • Near line storage • Aggregation/Merging • Reloading (?) • Need for a separate SIG (?)

  8. On land Seismic Survey Name • Survey name will be of max 20 characters as shown below :- • Basin Code –Four Characters as followed in Finder • For Onshore-Two Characters i.e. ON • Separator-One Character • Block Code-Three characters • 2D or 3D-Two characters • Separator-One Character • State Code-Max two Characters (As mentioned in Annexure-II) • Investigation No-Max five characters • Example-CMBYON-MEH2D-G401 • CMBYON-ANK3D-G423 • CMBYON-ANK3D-MERGE1 • MERGE1 should indicate the seismic investigation numbers considered for the merging, the details of which should be given in C19 of Annexure IV.

  9. 2D Seismic EBCDIC Header • C 1 CLIENT: OIL AND NATURAL GAS CORPORATION LIMITED. 2D SEISMIC DATA • C 2 LINE: M125-02 SURVEY: xxxxxxxxxxxxxxxx AREA:xxxxxxxxxxxxxxxxxx • C 3 SPHEROID: EVEREST75 PROJECTION:UTM-44 CM : 81 CP2: XX • C 4 FSP: 74 IS AT LAT: 11 12 18.12 N LON: 79 30 29.01 E • C 5 LSP: 1088 IS AT LAT: 11 01 26.84 N LON: 79 20 42.52 E • C 6 FCDP: 1 SP ON FCDP: 1 LCDP: 1088 SP ON LCDP: 1088 • C 7 ADDITIONAL SP CDP RELATION PAIRS FOR CROOKED PROFILE (OTHERWISE BLANK) • C 8 ADDITIONAL SP CDP RELATION PAIRS FOR CROOKED PROFILE (OTHERWISE BLANK) • C 9 BLANK • C10 ACQUISITION PARAMETERS • C11 RECORDING YEAR: 2004 AGENCY:ONGC VESSEL/PARTY:GP-29 • C12 SYSTEM:DFS-IV REC FORMAT:SEG-B LOW/HIGHCUT: 8/128 HZ • C13 NO OF CHANNELS: 96 FOLD: 48 SOURCE: VIBROSEIS • C14 SAMPLE INTERVAL: 2MS REC LENGTH: 5000 MS REC START TIME: 0MS • C15 SHOT INTERVAL: 100 M GROUP INTERVAL: 100 M NEAR OFFSET: 200 M • C16 LAYOUT:SPLITSPREAD BACK CHANNELS: 72 FORWARD CHANNELS: 24 • C17- C18 ENTER ADDITIONAL INFORMATION HERE • C19 BLANK • C20 PROCESSING PARAMETERS AGENCY: RCC, CHENNAI, ONGC BASIC/REPROCESSING • C21 to C35 PROCESSING STEPS • C36 PROCESSED OUTPUT STORED IN THIS TAPE:DMOSTK/MISTK/PSTM/PSDM • C37 DOMAIN:TIME/DEPTH REC LENGTH: 4000 MS SAMPLE INTERVAL: 4 MS • C38 ADDITIONAL INFORMATION • C39 BLANK • C40 END EBCDIC • REMARKS: • 1.All text fields are left justified and numeric values are right justified as shown • 2.C1 TO C6,( also C7 & C8 for Crooked Lines ) & C36 AND 37 ARE MANDATORY FOR LOADING OLD DATA

  10. Issues for DBAs • Multiple accounts for single user • Unix Accounts • Application wise Accounts • Finder & DPDA • LogDB, Geoframe • SeisDB • AssetDB • Remote Login accounts • Assigning privileges • Over 300 tables • Role based or Oracle based • Dynamic assignment • Remote Users

  11. Data Flow Issues • Online replication/Synchronization yet to be achieved • Insert, Update, Delete Transactions Management • Time series data (Nlist Files) merging/Reloading (?)

  12. Challenges • Data aggregation • Merging of Seismic Trace Data from Basin servers to Corporate server • Interface between SAP and EPINET for transfer of Drilling and Production data

  13. Thank You

More Related