Transcript CChandler_data_update

VERTIGO data
OCB database status update
Cyndy Chandler
Ocean Carbon and Biogeochemistry
Data Management Office
3 October 2006
VERTIGO PI meeting
Woods Hole, MA, USA
Outline
•
•
•
•
Ocean Carbon and Biogeochemistry (OCB)
VERTIGO and OCB
JGOFS relational database engine
OCB - VERTIGO database status
3 October 2006
Chandler, WHOI OCB
2 of 18
Ocean 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
3 of 18
VERTIGO 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
4 of 18
BCO DMO
Biological and Chemical Oceanography
Data Management Office
• 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
3 October 2006
Chandler, WHOI OCB
5 of 18
OCB ~ the Web site
3 October 2006
http://ocb.whoi.edu
Chandler, WHOI OCB
6 of 18
OCB-VERTIGO project page
3 October 2006
Chandler, WHOI OCB
7 of 18
http://ocb.whoi.edu/jg/dir/OCB
OCB
Data
System
organized
by project
and cruise
3 October 2006
Chandler, WHOI OCB
8 of 18
JGOFS Database Engine
distributed, object-oriented, relational database management system
query
original data can be in any format
system uses methods to locate and translate the data objects
3 October 2006
Chandler, WHOI OCB
9 of 18
OCB-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
10 of 18
OCB-VERTIGO database status
for Kilo Moana and Revelle cruises:
• cruise data inventory
• cruise event logs
• CTD profile data
• Niskin bottle (base file)
3 October 2006
Chandler, WHOI OCB
11 of 18
2004 Kilo Moana cruise
3 October 2006
Chandler, WHOI OCB
12 of 18
2005 Revelle cruise
inventory object
3 October 2006
Chandler, WHOI OCB
13 of 18
event log – Data Display
3 October 2006
Chandler, WHOI OCB
14 of 18
event log - Documentation
3 October 2006
Chandler, WHOI OCB
15 of 18
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
16 of 18
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
17 of 18
Thank you !
visit the OCB site
http://ocb.whoi.edu
3 October 2006
Chandler, WHOI OCB
18 of 18