Presented by: Yash Gidh

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  _at_Func1(value) else
_at_Func2(value) else _at_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
_at_AddInts(a,b)3function number test2(number
a,number b)   return _at_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 [phone],
• email dmoran_at_smith.com
• Yash Gidh, Ph.D.
• Sr. Project Engineer, Real-time Apps, Smith
  Technologies
• 16740 E Hardy Street, Houston TX 77032, USA
• Tel [phone],
• email ygidh_at_smith.com
• Mark Frenzel
• Mgr i-Drill/DBOS-OnTime, Smith Technologies
• 16740 E Hardy Street, Houston, TX 77032, USA
• Tel [phone],
• email mfenzel_at_smith.com

16
Questions?