Design of object-relational spatial databases for mineral deposit research and targeting

Abstract

An object-relational database is the entry point for geoinformatic exploration tools applied for mineral targeting. A data model is proposed to establish standards for database contents that enable information sharing across multidisciplinary fields, modeling geological processes a database, and to provid data for advanced modeling tasks. An application-specific database model for mineral targeting was based largely on the generic North American Data Model Conceptual Design 1.0 and the ESRI Geology Data Model 812. These data models were modified and extended to datasets typically involved within research and exploration of mineral deposits. The development of a conceptual model into physical database was achieved through the integration of a relational database and a geographic information system. The result is a highly visual relational database in which database query, analysis, and visualization of subsurface geologic data can be performed visually on computer screen via a feature interface. The case study shows that navigation and access to the contents of database can be done effectively through relational query protocols. Results of queries become input data for advanced modeling tasks such as geostatistical analysis, solid 3D modeling, and hydrothermal system modeling.