Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
database_structure [2008/09/17 18:39]
giesie
database_structure [2015/06/23 17:22] (current)
Line 1: Line 1:
  
 +======= Database structure =======
  
-**The EPD is set up as a [[http://​en.wikipedia.org/​wiki/​Relational_database |relational database]] consisting of a large number of tables to allow querying the data in complex ways and to minimise the storage space required. The aim of the database structure support group is to find and maintain a table structure and database management system that is adequate and up to date for the widest possible use of the EPD. The group is maintaining and fostering links to other palaeo-environmental databases like ALPADABA, [[Neotoma]],​ [[http://​medias.obs-mip.fr/​apd/​ |APD]], [[PANGAEA]] ​or [[http://​www.bugscep.com/​|BugsCEP]].+====== Aim ===== 
 +**The EPD is set up as a [[http://​en.wikipedia.org/​wiki/​Relational_database |relational database]] consisting of a large number of tables to allow querying the data in complex ways and to minimise the storage space required. The aim of the database structure support group is to find and maintain a table structure and database management system that is adequate and up to date for the widest possible use of the EPD. The group is maintaining and fostering links to other palaeo-environmental databases like the ALPine Pollen DAtaBAse (ALPADABA) housed in Bern (Switzerland), [[Neotoma]], ​the [[http://​medias.obs-mip.fr/​apd/​ |African Pollen Database (APD)]], [[PANGAEA]], and [[http://​www.bugscep.com/​|BugsCEP]].
 ** **
 +
 +----
  
  
 **The Publishing Network for Geoscientific & Environmental Data [[PANGAEA]] offers to support the EPD** **The Publishing Network for Geoscientific & Environmental Data [[PANGAEA]] offers to support the EPD**
 +
 +----
 +
  
 **We are keeping track of developments of pollen databases and had a closer look at the [[Neotoma]] database** **We are keeping track of developments of pollen databases and had a closer look at the [[Neotoma]] database**
  
  
-====== Review of the existing EPD table structure ======+ 
 + 
 +===== Review of the existing EPD table structure ===== 
    
 Walter Finsinger, Simon Brewer, Thomas Giesecke and Basil Davis met in Aix between Mai 29 and 31. We reviewed the EPD table structure, discussed working protocols with Michelle Leydet and helped John Keltner to correct mistakes in the database. We are grateful to John, Michelle and Valérie Andrieu for advice in discussions and support. ​ Walter Finsinger, Simon Brewer, Thomas Giesecke and Basil Davis met in Aix between Mai 29 and 31. We reviewed the EPD table structure, discussed working protocols with Michelle Leydet and helped John Keltner to correct mistakes in the database. We are grateful to John, Michelle and Valérie Andrieu for advice in discussions and support. ​
Line 22: Line 32:
 We first reviewed the **paradox table structure** (Fig. 1) that the EPD is currently held in and identified fields that have not been used, items that should be combined or items that should be added. We first reviewed the **paradox table structure** (Fig. 1) that the EPD is currently held in and identified fields that have not been used, items that should be combined or items that should be added.
  
-{{epd_tables.jpg|}}+{{epd_tables.jpg?900x600}}
  
  Fig. 1: //Table structure and relationships of the most important EPD paradox tables (here imported in Access).//  Fig. 1: //Table structure and relationships of the most important EPD paradox tables (here imported in Access).//
Line 192: Line 202:
   * Loss-on-ignition (% dry weight):   * Loss-on-ignition (% dry weight):
   * Description of the surrounding (regional and local) vegetation   * Description of the surrounding (regional and local) vegetation
 +
 +
 +
 +**You have to be logged for write access**
  
  
  
database_structure.1221669588.txt.gz · Last modified: 2015/06/25 16:07 (external edit)
Back to top
chimeric.de = chi`s home Creative Commons License Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0