Geological exploration management system

DBExplor Geo is a relational database management system for automation of geoscience research and economic projects. This package provides users to collect, store, analyze and export scientific data with a user-friendly interface.

It can be implemented on a local MySQL Server or on a webhosting with direct access to MySQL databases.

DBExplor database

 

Access to the application and the database is controlled by role, login and password. Each user gets personal credentials and rights.

Login form

DBExplor allows user to manage information such as:

Drillhole Data

Collar Location

• Drillhole details: date, company, geologist, …
• X,Y,Z Coordinates

Downhole Survey

• DH Survey details: date, company, type
• DH Survey parameters

Geology

• Geology logging intervals
• Lithology fields, codes, colors, patterns
• Alteration, Mineralization, Structure
• Hydrology

Assay

• Elements
• Assay types
• Sample assay results
• Lab methods, suite definitions, shipment
• QA/QC: standards, duplicates, blanks

 

Basic application functionality:

Review   Edit   Seacrh   Filter   Sort   Export

Drillhole form (Well)

 

DH Samples & Surface Samples

Samples

• Soil & Rock
• Geochemistry               
• Environmental
• Rock Properties
• Sample Details, Location, Photos

Check Samples

• Check Sample Intervals
• Parent Sample
• CheckType
• Standard Reference Material
• •Lab QA/QC

Basic application functionality:

Review   Edit   Seacrh   Filter   Sort   Export

Samples form

 

Importing Data

 

Assay Import

• Sample Assay Results
• Check Samples & Standard Reference Material Results
• Laboratory Certificates

Well Log Import

• Well Lithology
• Well Survey

Sample Import

• Sample Details
• Core Data and Photos
• Surface Samples
• Sample Shipment tracking

Well Survey Import

• Collar Survey Information
• Downhole Survey Information

Drilling Data Import

• Well Site Reports
• Daily Driller’s Logs
• Consumable Reports
• Expenses Reports

Basic application functionality:

Data Clean-up    Extract    Transfer   Load

Extract Transfer Load process in DBExplor

Using additional tool DBRaptor speeds-up ETL process up to 5-10 times

Helps to overcome challenges in a very complicated incoming data structures Processes multiple (up to severeal thousands) files per session Handles following formats of incoming files: TXT, CSV, XLS, TAB, Space delimited, LAS Normalizes flat tables

 

Drill Rig Tracking *

* is not part of DBExplor Geo  but can be purchased and included as additional module

Drilling Crew

• Timesheets
• Human Resources
• Shift Management

Operations

• Time Tracking
• Labour Tracking

Equipment

• Drill Bit Management
• Performance Tracking

Materials

• Drilling Consumables
• Drilling Expenses

Basic application functionality:

Review   Edit   Seacrh   Filter   Sort   Export

• DBExplor installs on web hosted, MySQL platform
• Low cost, low overhead
• Rapid migration of historical data
• Implementation of DBExplor is simple
• Experienced support and training in relational databases