160 likes | 301 Views
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
E N D
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 • 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
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
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
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)
Product Features Connection Manager
Product Features Expanded Tree View
Product Features Tabbed View of multiple WITSML Stores
Product Features XML view of a Standard Query
Product Features Grid View of a Standard Query
Advanced Features Database Mapping
Advanced Features Query Configuration
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);}
WITSML Product offerings • Query Assistant • Gateway Processor • Real-time Data Feed Simulator • Yield Point Hydraulics (Real time) • DBOS OnTime
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