presented by: yash gidh & david moran may 16, 2007 drilling witsml public seminar and exhibition
TRANSCRIPT
![Page 1: Presented by: Yash Gidh & David Moran May 16, 2007 Drilling WITSML Public Seminar and Exhibition](https://reader036.vdocuments.us/reader036/viewer/2022081511/56649e8a5503460f94b9013d/html5/thumbnails/1.jpg)
Presented by: Yash Gidh & David Moran
May 16, 2007
Drilling WITSML Public Seminar and Exhibition
![Page 2: Presented by: Yash Gidh & David Moran May 16, 2007 Drilling WITSML Public Seminar and Exhibition](https://reader036.vdocuments.us/reader036/viewer/2022081511/56649e8a5503460f94b9013d/html5/thumbnails/2.jpg)
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
![Page 3: Presented by: Yash Gidh & David Moran May 16, 2007 Drilling WITSML Public Seminar and Exhibition](https://reader036.vdocuments.us/reader036/viewer/2022081511/56649e8a5503460f94b9013d/html5/thumbnails/3.jpg)
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
![Page 4: Presented by: Yash Gidh & David Moran May 16, 2007 Drilling WITSML Public Seminar and Exhibition](https://reader036.vdocuments.us/reader036/viewer/2022081511/56649e8a5503460f94b9013d/html5/thumbnails/4.jpg)
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
![Page 5: Presented by: Yash Gidh & David Moran May 16, 2007 Drilling WITSML Public Seminar and Exhibition](https://reader036.vdocuments.us/reader036/viewer/2022081511/56649e8a5503460f94b9013d/html5/thumbnails/5.jpg)
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)
Compatibility
![Page 6: Presented by: Yash Gidh & David Moran May 16, 2007 Drilling WITSML Public Seminar and Exhibition](https://reader036.vdocuments.us/reader036/viewer/2022081511/56649e8a5503460f94b9013d/html5/thumbnails/6.jpg)
Connection Manager
Product Features
![Page 7: Presented by: Yash Gidh & David Moran May 16, 2007 Drilling WITSML Public Seminar and Exhibition](https://reader036.vdocuments.us/reader036/viewer/2022081511/56649e8a5503460f94b9013d/html5/thumbnails/7.jpg)
Product Features
Expanded Tree View
![Page 8: Presented by: Yash Gidh & David Moran May 16, 2007 Drilling WITSML Public Seminar and Exhibition](https://reader036.vdocuments.us/reader036/viewer/2022081511/56649e8a5503460f94b9013d/html5/thumbnails/8.jpg)
Product Features
Tabbed View of multiple WITSML Stores
![Page 9: Presented by: Yash Gidh & David Moran May 16, 2007 Drilling WITSML Public Seminar and Exhibition](https://reader036.vdocuments.us/reader036/viewer/2022081511/56649e8a5503460f94b9013d/html5/thumbnails/9.jpg)
Product Features
XML view of a Standard Query
![Page 10: Presented by: Yash Gidh & David Moran May 16, 2007 Drilling WITSML Public Seminar and Exhibition](https://reader036.vdocuments.us/reader036/viewer/2022081511/56649e8a5503460f94b9013d/html5/thumbnails/10.jpg)
Product Features
Grid View of a Standard Query
![Page 11: Presented by: Yash Gidh & David Moran May 16, 2007 Drilling WITSML Public Seminar and Exhibition](https://reader036.vdocuments.us/reader036/viewer/2022081511/56649e8a5503460f94b9013d/html5/thumbnails/11.jpg)
Advanced Features
Database Mapping
![Page 12: Presented by: Yash Gidh & David Moran May 16, 2007 Drilling WITSML Public Seminar and Exhibition](https://reader036.vdocuments.us/reader036/viewer/2022081511/56649e8a5503460f94b9013d/html5/thumbnails/12.jpg)
Advanced Features
Query Configuration
![Page 13: Presented by: Yash Gidh & David Moran May 16, 2007 Drilling WITSML Public Seminar and Exhibition](https://reader036.vdocuments.us/reader036/viewer/2022081511/56649e8a5503460f94b9013d/html5/thumbnails/13.jpg)
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);}
![Page 14: Presented by: Yash Gidh & David Moran May 16, 2007 Drilling WITSML Public Seminar and Exhibition](https://reader036.vdocuments.us/reader036/viewer/2022081511/56649e8a5503460f94b9013d/html5/thumbnails/14.jpg)
WITSML Product offerings
• Query Assistant• Gateway Processor• Real-time Data Feed
Simulator • Yield Point Hydraulics (Real
time)• DBOS OnTime
![Page 15: Presented by: Yash Gidh & David Moran May 16, 2007 Drilling WITSML Public Seminar and Exhibition](https://reader036.vdocuments.us/reader036/viewer/2022081511/56649e8a5503460f94b9013d/html5/thumbnails/15.jpg)
Contact Information
David MoranDirector, Engineering Applications, Smith Technologies16740 E Hardy Street, Houston TX 77032, USATel: (281)233-5387, email: [email protected]
Yash Gidh, Ph.D.Sr. Project Engineer, Real-time Apps, Smith Technologies16740 E Hardy Street, Houston TX 77032, USATel: (281)233-5235, email: [email protected]
Mark FrenzelMgr i-Drill/DBOS-OnTime, Smith Technologies16740 E Hardy Street, Houston, TX 77032, USATel: (281)233-5791, email: [email protected]
![Page 16: Presented by: Yash Gidh & David Moran May 16, 2007 Drilling WITSML Public Seminar and Exhibition](https://reader036.vdocuments.us/reader036/viewer/2022081511/56649e8a5503460f94b9013d/html5/thumbnails/16.jpg)
Questions?