Transcript PPT - Energistics

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
Compatibility
WITSML Stores Tested
• 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: [email protected]
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: [email protected]
Mark Frenzel
Mgr i-Drill/DBOS-OnTime, Smith Technologies
16740 E Hardy Street, Houston, TX 77032, USA
Tel: (281)233-5791,
email: [email protected]
Questions?