Umeå University
Back to the SEAD index The SEAD relational database will contain data essential to our understanding of past environmental and climatic changes, and the human relationship with these changes.
Introduction

The data in SEAD will take the form of biological and chemical/physical proxy data, i.e. fossil frequencies and measured variables derived from soil samples taken from archaeological and natural deposits. See the Concepts page for details of the methods involved in their collection.

 

Geographical scope

The initial geographical scope will primarily be Sweden and Europe, reflecting the contents of the two main data sources: The Environmental Archaeology Lab at Umeå University, and the BugsCEP dataset. Partnerships are being established in order to incorporate or collaborate with other datasets in the future.

Geographical scope of the MAL dataset (1996-2004).

BugsCEP geographical scope
The geographical scope of the BugsCEP dataset, displayed in the QSEAD prototype.

 

Database system and structure

SEAD is a relational database, where data are stored in a complex but efficient web of database tables. The structure allows for efficient data retrieval and querying, in other words, it allow complex questions to be asked of the data, and easier integration with other data sources.

The SEAD database id being designed using MicroOlap Database Designer for PostgreSQL.

SEAD structure in MicroOlap Database Designer

 

Online delivery and software tools

SEAD provide online access to the raw data, and a number of simple analysis tools to help interpretation. A number of these tools will be derived from those in the BugsCEP system, including those for climate and environmental reconstruction from fossil beetle data. See the tools pages for more information.

SEAD Research Data Model
Click for the full diagram

 

The SEAD team is currently prioritising the following data areas:

Master site data and metadata from MAL. Jan-Erik Wallin is using the new Tilia to ingest legacy data.

Porting the BugsCEP database into the SEAD structure. The latest BugsCEP dataset will soon be transfered to SEAD for testing on the online interface.

Import and quality control of digital soil property data from MAL. Currently quality control processing legacy data.

Manual entry of key plant macrofossil site data from MAL. Currently data collation.

 

Last updated: 2011-05-02 Webmaster: Phil Buckland