database interoperability
Download
Skip this Video
Download Presentation
Database interoperability

Loading in 2 Seconds...

play fullscreen
1 / 10

Database interoperability - PowerPoint PPT Presentation


  • 69 Views
  • Uploaded on

Database interoperability. Aspen Lodge, September 26, 2007. The problem. Most collections use different data formats and search functions and everybody likes their own system Given value of cruise samples, need to report their acquisition and characteristics early

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Database interoperability' - mardi


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
database interoperability
Database interoperability

Aspen Lodge, September 26, 2007

the problem
The problem
  • Most collections use different data formats and search functions
    • and everybody likes their own system
  • Given value of cruise samples, need to report their acquisition and characteristics early
    • Also need a way to let NSF track data and publications derived from samples
  • Need complete registration of standard sample IDs and data formats (IGSNs)
a proposal step 1
A proposal: Step 1
  • Establish system of Sea-going curators to accompany coring cost centers
    • Provides uniformity of sample description
    • Filled by sea-going core technicians and dredge handling staff or people trained by curatorial staff.
  • Use standard template with required fields to write preliminary metadata during sampling
    • There are relatively few sea-going curators so they can be trained in proper data entry and sample description
    • Write script to harvest cruise metadata into this template (lat/longs, cruise ids…)
step 2 sample registration
Step 2Sample registration
  • Automate sample IGSN registration
    • Use a pre-assigned block of numbers or “Trusted Author” set up
    • If each repository has its own code, then the repositories should assign their own numbers and send the registered metadata to SESAR
    • If ship samples are taken, they get their own “daughter number”
step 3 once an internet link is available
Step 3: Once an internet link is available…
  • Automatically register basic sample information (location, sample type, cruise ID, IGSN) with NGDC from ship or shortly after cruise.
    • The community immediately can see each sampling event although an embargo may exist on other data for ~1 year (or agreed period)
    • If additional data are not forthcoming from the repository after the embargo, NGDC could sent the repository and PI a query asking for these data
step 3 at the repository
Step 3At the repository…
  • Collections staff produce complete sample description
  • Associate data objects like photographs and physical property data sets with a sample object
  • Publish metadata and data objects to local repository in local format
  • Ideally use a web form that can write consolidated PDF or other format for easy downloads by users
slide7

Example of a metadata

template for cores (left)

and dredges (right_

step 4 publish final metadata to ngdc
Step 4Publish final metadata to NGDC
  • Develop translation tools for each US repository to write information on metadata and data objects to NGDC format
    • When data are published locally, NGDC is notified so they can harvest local data
  • NGDC also notified when there are new updates (say for sample history or new geochemical data) with new sample description information for samples that already have IGSN numbers
ad