Data model

The PANGAEA data model is running on a relational database (SYBASE). The fields of its tables are connected by ‚relations‘ to one each other. The model is strictly normalized. The hierarchy of the four main tables in the data model follows the steps in science for gathering analytical data:



Within a PROJECT different CAMPAIGNs are executed to get samples for further investigations or to make measurements at distinct locations (SITE/EVENT). The result of the investigations are analytical data, organized in Data Series, grouped in Data Sets. The four main level of the model are supported by tables with supplemental information, like persons with address (Staff/Institution), methods and devices and the list of parameters. Any describing fields around the data are called metadata.

- http://wiki.pangaea.de/wiki/Project - http://wiki.pangaea.de/wiki/Campaign - http://wiki.pangaea.de/wiki/Event - http://wiki.pangaea.de/wiki/Data_Sets - http://wiki.pangaea.de/wiki/Data_Series