Introduction to Geological Databases
A geological database is one of the most valuable assets of a mining company. It contains the evidence required to make many strategic decisions and includes the primary data used to estimate resources and reserves. The creation and maintenance of a successful geological database requires careful planning and consideration. Geologists, exploration managers or database administrators are responsible for collecting large volumes of data that will help to increase productivity and effectiveness. We will demonstrate how to design, develop, maintain, and verify geological databases to ensure their physical and logical integrity.
Upon completion of this course, you will be able to:
- Understand the fundamentals of relational “geological” databases.
- Recognise different types of database systems and their differences.
- Understand SQL language database definition, modification, and querying.
- Obtain skills designing error-free geological databases.
- Acquire skills implementing geological databases in Microsoft Access.
Our facilitator is an experienced practitioner with a robust mix of academic and practical expertise.
DR ADRIAN MARTINEZ VARGAS
P.GEO, PH.D. in Geological Sciences, ISMM Moa. Specialist in Geostatistics (CFSG), Paris Mining School. B.Eng. Geology, ISMM Moa
Adrian is both a geologist and a geostatistician. He produces open source software for geostatistics and mineral resources in Python, Fortran, Cython, C and SQL. He has worked as a consultant since 2002 covering many commodities including gold, copper, nickel, chromium, and raw materials for the cement industry. Adrian has experience using multiple indicator kriging for resource estimation of gold deposits with high nugget and domaining issues; with non-linear geostatistics and with conditional simulations for resource estimation and model validation.
Who is this course for?
This one-day course is designed for geologists, metallurgists, and engineers interested in working with geological and drill hole databases. You will learn the minimal essentials and gain practical insights to SQL, Access, and SQLite.