Dbk: Protected "OR/14/061 Appendix" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite)) [cascading]

2016-02-19T10:45:39Z

Protected "OR/14/061 Appendix" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite)) [cascading]

← Older revision	Revision as of 11:45, 19 February 2016
(No difference)

Dbk: 1 revision imported

2016-02-19T10:35:43Z

1 revision imported

← Older revision	Revision as of 11:35, 19 February 2016
(No difference)

Ajhil: /* Selected data model diagrams */

2016-02-19T09:32:41Z

Selected data model diagrams

New page

__NOTOC__
{{OR/14/061}}
This appendix contains a series of screenshots and diagrams that relate to the work carried out and outputs generated throughout the project.

==Website screenshots==

<center>
<div><ul>
<li style="display: inline-block;"> [[File:OR14061appendfig1.jpg|thumb|center|400px|The original website, part of the BGS OpenGeoscience resource: http://www.bgs.ac.uk/opengeoscience/home.html<br>http://www.bgs.ac.uk/services/dataModels/home.html]] </li>
<li style="display: inline-block;"> [[File:OR14061appendfig2.jpg|thumb|center|348px|The Borehole Data Model webpage.]] </li>
</ul></div>
</center>

<center>
<div><ul>
<li style="display: inline-block;"> [[File:OR14061appendfig3.jpg|thumb|center|450px|The original website as it was in July 2012: http://www.bgs.ac.uk/services/dataModels/home.html]] </li>
<li style="display: inline-block;"> [[File:OR14061appendfig4.jpg|thumb|center|451px|The homepage for the community branded (rather than BGS) website: http://www.earthdatamodels.org]] </li>
</ul></div>
</center>

==Selected data model diagrams==

[[Image:OR14061appendfig5.jpg|thumb|center|500px| High level entity relationship diagram for the borehole data model.]]

[[Image:OR14061appendfig6.jpg|thumb|center|750px| Full entity relationship model diagram for the Borehole data model.]]

[[Image:OR14061appendfig7.jpg|thumb|center|500px| High level entity relationship model diagram for the Geochemistry data model.]]

[[Image:OR14061appendfig8.jpg|thumb|center|500px| High level entity relationship model diagram for the Lexicon of Named Rocks data model.]]

[[Image:OR14061appendfig9.jpg|thumb|center|500px| High level diagram for the spatial metadata data model.<br>
Each of the child tables (light green) in the high level diagram were further explained by additional figures showing the logical structure of the data model, as shown over the next two pages.]]

<center>
<div><ul>
<li style="display: inline-block;"> [[File:OR14061appendfig10a.jpg|frameless|center|420px|]] </li>
<li style="display: inline-block;"> [[File:OR14061appendfig10b.jpg|frameless|center|372px|]] </li>
</ul></div>
</center>

==Example of scripts==
[[Image:OR14061appendfig11.jpg|thumb|center|500px|Sample of the SQL scripts for the creation of Borehole data model in an Oracle implementation.]]

[[Image:OR14061appendfig12.jpg|thumb|center|500px|Sample of the SQL scripts for the population of an Oracle implementation of the borehole data model, the data includes example dummy values as well as content for the dictionaries of controlled terms used in the design.]]

[[Image:OR14061appendfig13.jpg|thumb|center|500px|Example of the results from the questionnaire handed out at the 24th meeting of the Colloquium of African Geology (CAG24).]]

[[Image:OR14061appendfig14.jpg|thumb|center|500px|Diagram to show the components which make up a downloadable database design package.]]
[[category:OR/14/061 Open geoscience data models: end of project report| 10]]

OR/14/061 Appendix - Revision history

Dbk: Protected "OR/14/061 Appendix" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite)) [cascading]

Dbk: 1 revision imported

Ajhil: /* Selected data model diagrams */