The Borehole Data Model is our first database design package to be released.
This data model is designed to represent an index of boreholes linked to their geological interpretations and associated metadata.
The design also makes use of corporate dictionaries/controlled vocabularies such as the BGS Lexicon.
The BGS have been using databases to manage our borehole records for over 15 years, the data models behind those systems have continually evolved over that time to provide greater efficiencies and functionality.
Here are a few of the benefits the current database provides:
Select the database platform you are most interested in or simply select the Logical Data Model only option from the following list:
The implementation scripts are available for the following relational database platforms:
If you have any suggestions you would like to share please contact Carl Watson
Please let us know what you think about this data model and whether you have an alternative design, we would be particularly interested in designs for 'deviated boreholes'.
Please acknowledge the material as:
Copyright/database right, reproduced with the permission of the British Geological Survey
© NERC 2012. All rights reserved.