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

2016-02-19T10:44:16Z

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

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

Dbk: 1 revision imported

2016-02-19T10:35:32Z

1 revision imported

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

Ajhil at 14:17, 15 February 2016

2016-02-15T14:17:18Z

New page

__NOTOC__
{{OR/14/061}}
==Online, downloadable data model packages==
As briefly described in the objectives section the project produced a number of downloadable database design packages. Initially these were referred to as data model downloads packages but it became apparent that the vast majority of potential users were non-database experts and therefore did not necessarily understand the specialised field of data modelling, but they did understand that databases required an underlying design.

The downloads were made up of relational data models in the form of entity relations (ER) diagrams, plain English documents (available in MS Word and PDF to maximise access), implementation scripts, example data and links to associated dictionary data sources.

The BGS staff on the project produced four full database design packages and a further three are in progress, which, will be released regardless of the knowledge exchange project formally coming to an end.

The BGS produced downloads were complemented by a number of designs made available by project partners and associated organisations, these were hosted on the information providers website and links provided on EarthDataModels.org model library.

===Database Design Package===
[[Image:OR14061fig9database.jpg|thumb|center|500px| Diagram to show the components which make up a downloadable database design package. ]]

<center>
{| class="wikitable"
|+ Table showing data model downloads created specifically for the project
| style="background-color: #dcdcdc;" | '''Topic'''
| style="background-color: #dcdcdc;" | '''Download items'''
| style="background-color: #dcdcdc;" | '''Status'''
|- style="vertical-align:top;"
| Borehole
|
* Logical data model documents 
* Microsoft Access implementation and technical documentation 
* MySQL scripts and technical documentation 
* Oracle scripts and technical documentation 
* PostgreSQL scripts and technical documentation 
* SQLServer scripts and technical documentation 
| Live
|- style="vertical-align:top;"
| Geochemistry
|
* Logical data model documents
* Microsoft Access implementation and technical documentation

MySQL scripts were created and distributed directly to some users
| Live
|- style="vertical-align:top;"
| Lexicon
|
* Logical data model documents
* Microsoft Access implementation and technical documentation
| Live
|- style="vertical-align:top;"
| Metadata
|
* Logical data model documents
* Microsoft Access implementation and technical documentation
| Live
|- style="vertical-align:top;"
| ! scope="col" style="width: 150px;" | Landslides
| ! scope="col" style="width: 450px;" | Draft data model documentation and Entity Relationship model created
| ! scope="col" style="width: 50px;" | Unfinished
|- style="vertical-align:top;"
| 3D geological model objects
| Entity Relationship model created
| ! scope="col" style="width: 300px;" | Commitment made by the BGS to release design post peer review paper publication
|- style="vertical-align:top;"
| Coal Analysis
| Draft data model documentation and Entity Relationship model created
| ! scope="col" style="width: 300px;" | Commitment made by BGS Wales to release by the end of 2014/2015 financial year
|}
</center>

<center>
{| class="wikitable"
|+ Table showing data models made available by community members and associates
| style="background-color: #dcdcdc;"| '''Topic'''
| style="background-color: #dcdcdc;"| '''Provider'''
|- style="vertical-align:top;"
| ! scope="col" style="width: 150px;" | Borehole
| ! scope="col" style="width: 500px;" | Geological Survey of Denmark and Greenland (GEUS)
|- style="vertical-align:top;"
| Geochemistry
| U.S. Geological Survey (USGS)
|- style="vertical-align:top;"
| Geological Mapping
| The North American Geological Data Model (NADM)
|- style="vertical-align:top;"
| Geological Mapping
| GeoSciML
|- style="vertical-align:top;"
| Geological Mapping
| New Mexico Bureau of Geology and Mineral Resources
|- style="vertical-align:top;"
| Geophysics
| Geological Survey of Denmark and Greenland (GEUS)
|- style="vertical-align:top;"
| Geophysics
| XODB by Xstract mining consultants, Australia
|- style="vertical-align:top;"
| Oceanographic
| British Oceanographic Data Centre
|- style="vertical-align:top;"
| Water Quality
| U.S. Geological Survey (USGS)
|}
</center>

==Download stats for online data model packages==
<center>
{| class="wikitable"
| style="background-color: #dcdcdc;" | '''Year'''
| style="background-color: #dcdcdc;" | '''Total Hits (downloads)'''
| style="background-color: #dcdcdc;" | '''Unique Visitors'''
| style="background-color: #dcdcdc;" | '''Most poplar download'''
|-
| ! scope="col" style="width: 75px;" | 2011
| ! scope="col" style="width: 200px;" | 655
| ! scope="col" style="width: 175px;" | 188
| ! scope="col" style="width: 200px;" | Boreholes
|-
| 2012
| 2,531
| 620
| Boreholes
|-
| 2013
| 3,618
| 578
| Geochemistry
|}
''* Note: these do not include the direct delivery of data models via email and in person and the most popular data model to be delivered directly to contacts described spatial metadata.''
</center>

==Conferences==
<center>
{| class="wikitable"
| style="background-color: #dcdcdc;"| '''Conference'''
| style="background-color: #dcdcdc;"| '''Presentation title'''
|-
| IGC Brisbane 2012
| The need for an Open Exchange of Geoscience Data Models
|-
| CAG Addis Ababa 2013
| ! scope="col" style="width: 400px;" | Sharing the most valuable database designs in African geology
|-
| ! scope="col" style="width: 250px;" | IMAG Madrid September 2013
| Control the system, free the data, feed the science
|}
</center>

==Technical visits, workshops and meetings==
<center>
{| class="wikitable"
|- style="vertical-align:top;"
| style="background-color: #dcdcdc;"| '''Location'''
| style="background-color: #dcdcdc;"| '''Objective'''
| style="background-color: #dcdcdc;"| '''Outcomes'''
|- style="vertical-align:top;"
| ! scope="col" style="width: 150px;" | Malawi – June 2013
| ! scope="col" style="width: 250px;" | Assess data modelling capability and requirements
| ! scope="col" style="width: 250px;" | Plan of action for return visit(s) and new contacts made
|- style="vertical-align:top;"
| Malawi – January 2014
| Detailed requirements gathering with the Department of Surveys
| Spatial metadata model handed over, plan of action agreed with DoS and World Bank to implement a new spatial metadata system for Malawi
|- style="vertical-align:top;"
| Denmark – February 2014
| Share understanding of data models amongst GSOs, City planners and water companies
| Follow up meeting between Data Architects set up between BGS and GEUS. Invite to join pan European knowledge exchange project Sub-Urban, specialising in Data Management
|- style="vertical-align:top;"
| Denmark – April 2014
| Knowledge Exchange on data models, systems architecture and related information management issues
| Agreement to collaborate in the future on various data models including geotechnical data and 3D model storage
|- style="vertical-align:top;"
| UK, IGS 
Face to face meetings held: 
12/04/2012 
21/12/2012 
17/01/2013 
25/10/2013 
 
Email support: 
02/04/2014
 15/04/2014
| Identify data models which could support the commercial aspirations of the newly formed IGS company
| IGS have incorporated lessons learnt from BGS development of databases and use of international standards to develop the new commercial produce IGS Geodata
|}
</center>
[[category:OR/14/061 Open geoscience data models: end of project report| 07]]

OR/14/061 Results and highlights - Revision history

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

Dbk: 1 revision imported

Ajhil at 14:17, 15 February 2016