ERIMS Full Service Data Management
ERIMS (Expedio Resource Information Management Solution) is our full-service offering, designed to address all aspects of data management typically required by clients in the resources industry. From data model right through to reporting, including data audit and replication capability, ERIMS is the end-to-end answer for all your needs.
ERIMS is a comprehensive product offering, but briefly it covers the following areas:
SQL Server Data Model
A database ready to store and manage your data, including any legacy data from existing systems you may have. This data model works in conjunction with the features listed below to provide you with a comprehensive data management solution. In addition to tables you may be familiar with Expedio have included the ability to record additional data to ensure a complete understanding of the status of your exploration work. You can record information such as downhole obstructions, downhole horizon data, daily drilling record, links to photographs or documents and additional metadata pertaining to individual sampling sites.
Auto calculation of coordinates relative to UTM and Local grids plus auto rotation of any Downhole Survey and structural data.
Ability to auto populate fields such as Original Lease, Current Lease, Prospect, Project etc. in the Header table. Our system can be used to spatially validate any data sent from the field and ensures that all data is correctly flagged against Leases which typically forms a very important component in Data Reporting.
The ability to accurately report drilling progress and associated costs - plus extra summary statistics reporting directly from the database. Validation of any downhole tables against recorded drilling depths to ensure no data extends beyond the bottom of hole.
Clean data! The validation routines will ensure that no matter how data is entered into the database it will be as clean as possible. The post-import integrity checking will also provide an opportunity to check and fix any 3D issues, sort multiple collar surveys, sort multiple downhole surveys, check status of sample despatches and receipts etc.
Session-Based Data Import
Full validation and session reporting statistics that records the total number of rows loaded and the number and type of errors in the data (if any). You also get an interface to run imports and then check for and fix any rows with errors trapped in the buffers. Using this import system allows data to be streamed into the database from one or more sources. The session statistics allow for checking whether the field personnel are providing valid data and if there are improvements in data quality over time.
A very efficient way to manage Sample Despatching and Assay Receipting that has built-in checks and balances to ensure you are getting the correct data from the Labs. We have streamlined the despatching process in line with how we manage our samples. You can check both field and lab sourced QA/QC data on receipt of an assay job and choose to stop the import process if the results indicate that the job is not up to specification. If you want to perform more comprehensive studies of the QA/QC samples load the assay jobs in and run the charts over a longer period of time - should the results prove to be unfavourable simply delete the offending jobs from the database. Our pivot functions mean you can view and use data in real-time - as soon as a job is loaded it is available for interrogation.
Data Integration and Configuration
A fully functioning interface with all objects required to query, browse, export and report from the underlying database. Support if you require assistance or want modifications and additions to our supplied system. The system handles many ‘real world’ situations such as one sample being split into size or magnetic recovery fractions with Iron Ore analysis.
Accurate and timely intercepts calculated directly from the database soon after assay jobs have been loaded. Reports can either be Excel spreadsheets or Graphical Reports side by side with lithology, mineralisation and other relevant geology. These reports can be on a manager’s desk minutes after an assay job has been loaded.
A full history of changes made to the database which allows you to demonstrate your confidence in the data contained therein. It is an ever increasing requirement that people are accountable for data and without this system it is impossible to demonstrate this.
Up to date data contained in a replica of the head office data model. The remote database could be updated in real time but perhaps more realistically your workers could be accessing current data within 12 hours of it hitting the master database. Having a database on-site means that workers have access to all the reporting and extraction tools available to the database administrator and can therefore generate these reports themselves
If you would like to learn more about ERIMS, please Contact Expedio