Database Services

• Database Design - Expedio have developed a series of commodity optimised data models to manage most aspects of resource industry data. The Expedio models have been designed to manage multiple instances of commonly occurring attributes such as collar coordinates, downhole surveys and geological interpretations. Expedio have models to manage metalliferous and diamond related data.

• Database Performance Audits - performance tuning SQL Server databases. Enhancements include optimising field types and tuning indices and are best performed after all data has been migrated into the database and validated.
• Database Migration - services to migrate existing databases (many formats) into SQL Server.
• Advanced Query Development - advanced SQL query development to optimise database functionality and query performance.
• Value Added GBIS Support & Configuration - advanced GBIS system configuration including:
  • high performance pivot queries
  • interface creation and enhancement
  • graphic reporter drawing creation
  • on import grid transformation
  • on import Dip/Dip Direction calculation
  • lease boundary assignment on import and more.
  Expedio also works closely with the GBIS development team to enhance the standard GBIS data model to manage a variety of data types in all major relational database management systems (RDBMS) such as SQL Server, Oracle or Access.
• Database Administration - Expedio offer a service to review aspects of your in-house managed RDBMS:
  • Can you be sure that your most valuable asset is being housed in the most appropriate way?
  • Do you have security concerns?
  • Are changes to your database being recorded?

  If you would like to learn more about our database services, please Contact Expedio