Database Services
- Database Design - SADM have developed a series of commodity optimised data models to manage most aspects of resource industry data. The SADM models have been designed to manage multiple instances of commonly occurring attributes such as collar coordinates, downhole surveys and geological interpretations. SADM 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.
SADM works closely with the GBIS development team to develop and enhance the standard GBIS data model to manage a variety of data types in all major relational database management systems (RDBMS), Access, SQL Server or Oracle.
- Database Administration - SADM 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 don't know the answers to these questions then call SADM and let us help you.
Download Database Administration Brochure
