Introduction

This documentation is the user guide for the Data Mining Solutions’ Exploration Database Management System (dmsEDBMS). It is intended to act as a reference for daily usage, it also intends to give a comprehensive understanding of the whole management system, such that the broader context of the system can be understood.

Design rationale

The database management system is primarily designed for use as a comprehensive exploration drilling / surface sample and geochemistry data, however it also incorporates additional tables for general exploration management tasks.

It has been designed to only be as complex as it needs to be, and as intuitive and as easy reason and rationalize about as possible.

The database schema is not obfuscated, rather it is encouraged that the users are able to clearly understand it.

The frontend interface components of the system are designed to be usable without any prior backend database experience. An open minded geologist who is prepared to learn a few new concepts will be able to manage the whole database easily.

Architecture

The database server itself uses a spatially enabled Postgresql database which allows for integration with GIS and additional spatial capabilities out of the box.

Reference `Connect to QGIS`_

Frontend desktop applications interface with the database via a backend server, adding security and a feature rich user experience.