The British Geological Survey has just released its geochemistry data model (GDM), a simplified version of BGS’ in-house geochemistry database. The database provides a central location for millions of borehole records and supports batch load of large volumes of boreholes data. Data can be viewed in a geographical information system.
The design of the database helps standardise information from a variety of sources. Controlled vocabularies and logical constraints make the information more re-usable and ‘discoverable.’ Data can be extracted and reformatted for a range of uses and clearly defined tables and columns remove the likelihood of ambiguity within the dataset ‘single version of the truth.’ Users can download either a logical data model or ready-to-run scripts for Microsoft Access or SQL Server, Oracle or PostgreSQL. The software is free for both commercial and non-commercial use but users are asked to acknowledge BGS’ copyright.
The geochemistry database is the second download available from the Open-Geoscience Knowledge Exchange project. The first was BGS’ Borehole Data Model released late in 2011. The borehole model provides a representation of boreholes linked to their geological interpretations and associated metadata. The design also makes use of corporate dictionaries or controlled vocabularies such as the BGS Lexicon. The borehole data model also derived from BGS’ in-house database that has been used to manage borehole records for over 15 years.
© Oil IT Journal - all rights reserved.