1 / 16

Presented by: Yash Gidh & David Moran

Presented by: Yash Gidh & David Moran. Drilling WITSML Public Seminar and Exhibition. May 16, 2007. History. In 2002 Smith developed two “helper” utilities to graphically map information between a database and a WITSML document Xtrude TM - XML export tool Xhume TM - XML import tool

ojal
Download Presentation

Presented by: Yash Gidh & David Moran

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. Presented by:Yash Gidh & David Moran Drilling WITSML Public Seminar and Exhibition May 16, 2007

  2. History • In 2002 Smith developed two “helper” utilities to graphically map information between a database and a WITSML document • XtrudeTM - XML export tool • XhumeTM - XML import tool • Using these tools a developer can add XML capability to an existing program with as little as 3 lines of code, without extensive XML or WITSML knowledge

  3. Objective • The two tools were limited to generating XML files which would be then consumed by application • There was a need for a tool to query the data in different WITSML stores, apply transformations to the data and view the results before it is actually stored

  4. Features • Verification of Use Case Scenarios and Work Process Functions • Maintenance tool • Performance monitoring of different WITSML servers using multiple queries to benchmark • Provides persisted connections • Supports both v 1.2 and v 1.3.1 WITSML Server queries • Fully configurable

  5. WITSML Stores Tested Compatibility • Sense Intellifield (Version 1.2.0 and 1.3.1) • Pason (Version 1.2.0) • Petrolink (Version 1.2.0) • Visean (Version 1.1.0) • Baker Hughes (Version 1.2.0) • Halliburton (Version 1.2.0) • Schlumberger (Version 1.2.0) • Aspen Tech (Version 1.2.0) • Datalog (Version 1.2.0)

  6. Product Features Connection Manager

  7. Product Features Expanded Tree View

  8. Product Features Tabbed View of multiple WITSML Stores

  9. Product Features XML view of a Standard Query

  10. Product Features Grid View of a Standard Query

  11. Advanced Features Database Mapping

  12. Advanced Features Query Configuration

  13. Advanced Features Stored Procedures and User Defined Functions Example Consider the following translation expression:  @Func1(%value%) %else% @Func2(%value%) %else% @Func3() if %value% is not available, the expression value will be the return value of Func3, as the first two functions cannot be called. If %value% has a value, but for some reason Func1 has an unhandled exception, then Func2's value will be used. If the stored procedure Func1 always catches and handles all errors, then Func2 can never be called.//-------------------------------------------------------------------------------------------------------------//These are test functions to test the user defined function calls. These call functions//in the UserFunctions.dll installed with this product. function integer test1(integer a,integer b){   return @AddInts(a,b)*3;}function number test2(number a,number b){   return @AddNumbers(a,b);}

  14. WITSML Product offerings • Query Assistant • Gateway Processor • Real-time Data Feed Simulator • Yield Point Hydraulics (Real time) • DBOS OnTime

  15. Contact Information David Moran Director, Engineering Applications, Smith Technologies 16740 E Hardy Street, Houston TX 77032, USA Tel: (281)233-5387, email: dmoran@smith.com Yash Gidh, Ph.D. Sr. Project Engineer, Real-time Apps, Smith Technologies 16740 E Hardy Street, Houston TX 77032, USA Tel: (281)233-5235, email: ygidh@smith.com Mark Frenzel Mgr i-Drill/DBOS-OnTime, Smith Technologies 16740 E Hardy Street, Houston, TX 77032, USA Tel: (281)233-5791, email: mfenzel@smith.com

  16. Questions?

More Related