VERTIGO dataOCB database status update

VERTIGO dataOCB database status update

Cyndy Chandler

Ocean Carbon and Biogeochemistry

Data Management Office

Cyndy Chandler

Ocean Carbon and Biogeochemistry

Data Management Office

3 October 2006 VERTIGO PI meeting Woods Hole, MA, USA

3 October 2006

Chandler, WHOI OCB 2 of 18

OutlineOutline

• Ocean Carbon and Biogeochemistry (OCB)

• VERTIGO and OCB

• JGOFS relational database engine

• OCB - VERTIGO database status

3 October 2006

Chandler, WHOI OCB 3 of 18

Ocean Carbon and BiogeochemistryOcean Carbon and Biogeochemistry

• OCB collaboratory one year proposal funded by NSF in May 2005

• PIs: Dave Glover, Ken Buesseler, Scott Doney• original proposal was entitled “Coordination and Data

Management for Ocean Carbon Cycle Research» data management support for targeted programs to improve

accessibility to ocean biogeochemistry data » scientific workshop on recent advances and future

opportunities (held at WHOI, August, 2005)» name changed from OCCC/OCCR to OC&B in June 2005

and to OCB in January 2006, then back to OC&B Oct 2006

3 October 2006

Chandler, WHOI OCB 4 of 18

VERTIGO and OCBVERTIGO and OCB

• VERTIGO is one of five participating programs in the OCB collaboratory

• CARIACO time-series, EDDIES, MedFlux, and SOFeX

• each independent project was collecting biogeochemistry data and each had an aspect we found ‘intriguing’ » OCB is itself a research project» how difficult would it be to take data from several different

projects at various stages in their life cycle and create a relational database

3 October 2006

Chandler, WHOI OCB 5 of 18

BCO DMOBCO DMO

• NSF funded project PIs: Peter Wiebe and David Glover

• 3 year project (start: 1 Oct 2006)• data management for biological and

chemical oceanography• continued data management support for

original OCB projects

Biological and Chemical Oceanography Data Management Office

Biological and Chemical Oceanography Data Management Office

3 October 2006

Chandler, WHOI OCB 6 of 18

OCB ~ the Web siteOCB ~ the Web site http://ocb.whoi.eduhttp://ocb.whoi.edu

3 October 2006

Chandler, WHOI OCB 7 of 18

OCB-VERTIGO project pageOCB-VERTIGO project page

3 October 2006

Chandler, WHOI OCB 8 of 18

OCB Data

System

organizedby project and cruise

OCB Data

System

organizedby project and cruise

http://ocb.whoi.edu/jg/dir/OCB

3 October 2006

Chandler, WHOI OCB 9 of 18

JGOFS Database EngineJGOFS Database Enginedistributed, object-oriented, relational database management system

original data can be in any formatsystem uses methods to locate and translate the data objects

query

3 October 2006

Chandler, WHOI OCB 10 of 18

OCB-VERTIGO database statusOCB-VERTIGO database status

• cruise event logs and basic hydrographic data done first

• working on bottle summary files now

• questions referred to VERTIGO project office

3 October 2006

Chandler, WHOI OCB 11 of 18

for Kilo Moana and Revelle cruises:

• cruise data inventory

• cruise event logs

• CTD profile data

• Niskin bottle (base file)

OCB-VERTIGO database statusOCB-VERTIGO database status

3 October 2006

Chandler, WHOI OCB 12 of 18

2004 Kilo Moana cruise2004 Kilo Moana cruise

3 October 2006

Chandler, WHOI OCB 13 of 18

2005 Revelle cruise2005 Revelle cruise

inventory object

3 October 2006

Chandler, WHOI OCB 14 of 18

event log – Data Displayevent log – Data Display

3 October 2006

Chandler, WHOI OCB 15 of 18

event log - Documentationevent log - Documentation

3 October 2006

Chandler, WHOI OCB 16 of 18

What can you do ?What can you do ?

• contribute data to VERTIGO project office

• metadata metadata metadata» spatial and temporal» methodology (acquisition and processing)» quality control procedures» any publications associated with the data

• use the database, provide feedback

3 October 2006

Chandler, WHOI OCB 17 of 18

What next ?What next ?• continued ingestion of VERTIGO data

into online OCB database

• synthesis of data from Niskin bottle samples Niskin bottle summary data product (e.g. full cruise merged Niskin bottle data)

• BCO DMO funding will support development of an enhanced data system interface(data discovery: map and improved search)

3 October 2006

Chandler, WHOI OCB 18 of 18

Thank you !Thank you ! visit the OCB site

http://ocb.whoi.edu