Database

From Scientist and Sensor to Synthesis: The GCE Data Toolbox for Matlab and Metabase Management System. Nov. 28-30, 2012

LTER sites use a wide range of software to acquire, process, quality control and archive data. A separate set of tools is then typically used to produce and manage metadata content and generate EML-described data packages for the LTER NIS. This separation of data and metadata processing is inefficient, risks loss of information, and often delays data release. Software developed at the GCE LTER site - the GCE Data Toolbox for MATLAB - streamlines this process by coupling metadata creation to data processing and quality control.

SiteDB

Participants:
• In-person: James Brunt, Yang Xia, Jason Downing, Margaret O’Brien, Don Henshaw
• Videoteleconference: Jamie Hollingsworth, Aaron Stephenson

Day 1: Thursday, April 5, 2012

0830: Introduction
• Agenda review (Don)
• Discuss goals / products for this meeting

a. Consider advantages of use and need for redesign of SiteDB
i. Common use and sharing of SiteDB
ii. Accommodation of discipline-specific metadata within the design

b. Consider use of SiteDB within the PASTA architecture
i. EML best practices for discipline-specific metadata

Digital Data Organization

Introduction Once data are acquired in the field or laboratory, they frequently will have to be hand entered or if acquired digitally organized in a way that they can be analyzed. Consideration for QA/QC are important at this step. Both, Excel and databases offer approaches to speed data entry and provide some control over data quality. Presentations

ClimDB/HydroDB

The Climate and Hydrologic Database Project is a component of the LTER Network Information System (NIS), the suite of LTER intersite database modules being created to promote synthetic ecological research. The ClimDB and associated HydroDB were developed in response to research scientist need for current and comparable climate and hydrologic data summaries for LTER sites and U.S. Forest Service Experimental Watersheds widely used in intersite comparisons, modeling studies, and land management-related studies (Henshaw et al. 1998).

Documentation: Metadata Database

We released a SQL script, a mysql workbench schema and a PDF of the corresponding database schema diagram.

Here is a bit of explanation. After several years of working with many LTER sites, we found a common metadata content pattern. The database designed here is intended to provide a platform to contain these common content pattern across LTER sites, and some other ecological data providers.

Syndicate content