1 / 25

BIDI: Bi ological D ata I ntegration Database Design Options

BIDI: Bi ological D ata I ntegration Database Design Options. Yassine LASSOUED y.lassoued@ucc.ie. Outline. Previous Work and Meetings Existent Data Database Design Options Future Work. Previous Work. Numerous options have been proposed Two options have been pre-selected

saddam
Download Presentation

BIDI: Bi ological D ata I ntegration Database Design Options

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. BIDI: Biological Data IntegrationDatabase Design Options Yassine LASSOUED y.lassoued@ucc.ie BIDI Meeting

  2. Outline • Previous Work and Meetings • Existent Data • Database Design Options • Future Work BIDI Meeting

  3. Previous Work • Numerous options have been proposed • Two options have been pre-selected • Data models have been implemented as Visio diagrams, using Arc Marine BIDI Meeting

  4. Existent Data • Acoustic Surveys • Nephrops Underwater TV Surveys • Larval Surveys • Deep Water Surveys • Groundfish Surveys • HABs BIDI Meeting

  5. Acoustic Surveys BIDI Meeting

  6. Nephrops Underwater TV Surveys BIDI Meeting

  7. Larval Surveys BIDI Meeting

  8. Deep Water Surveys BIDI Meeting

  9. Groundfish Surveys BIDI Meeting

  10. HABs BIDI Meeting

  11. FSS_Events FSS_LengthFreq FSS_AgedFish FSS_Hauls FSS_Scientists FSS_Samples FSS_Stratum_Bounds FSS_NASC FSS_SurveyTypes FSS_Surveys FSS_Vessels Original tables Information about events Information about surveys Information about samples Integrated Biological Data Schema • Current Version (Based on Acoustic Surveys) BIDI Meeting

  12. Catch Gear AgedFish Isobath BioassayChemistry Survey SurveyType Vessel Event Haul FishSample Scientist Species ICESDivision LengthFrequency SurveyStation Track Cruise Country SurveyGears HABStation Phytoplankton HABSample Original tables Fish samples Business Tables HABs Samples Information about events Integrated Biological Data Schema • Extended Version BIDI Meeting

  13. Catch SurveyStation HABs_Station Gear Species ICESDivision HABs_Sample BioassayChemistry LengthFrequency AgedFish FishSample Haul Cruise Event Phytoplankton Contact Isobath ContactRole PlatformType Country Track ActivityMetadata OrganisationRole ActivityOrganisationRoles Platform ActivityType ActivityContactRoles Organisation ActivityGears ActivityDevices Activity Original tables Fish samples Business Tables HABs Samples Information about events Integrated Biological Data Schema • Aligning Business tables with the MIDM BIDI Meeting

  14. Arc Marine Option B SurveyStation InstantaneousPoint ICESDivision Design Options • Fish Survey Stations BIDI Meeting

  15. Arc Marine Option E FeaturePoint HABs_Station Design Options • HABs Stations BIDI Meeting

  16. Option D.1 ActivityDevices Activity Gear Haul Species Sample Catch SurveyStation SubSample Individual IndividualMeasuredData Parameter Design Options • Fish Samples • Option 1: Generic Sample Analyses BIDI Meeting

  17. Option D.1 ActivityDevices Activity Gear Haul Species Sample Catch SurveyStation LengthFrequency Individual LengthClass Design Options • Fish Samples • Option 2: Current model BIDI Meeting

  18. Design Options • Fish Samples • Comparison BIDI Meeting

  19. Option F.1 HABSample Species HABStation Phytoplankton Bioassay WaterSample ShellfishSample Chemistry Organisation HABAnalysis Design Options • HABs Samples • Option 1: BIDI Meeting

  20. Option F.2 HABSample Species HABStation Phytoplankton BioassayChemistry Organisation HABAnalysis Design Options • HABs Samples • Option 2: BIDI Meeting

  21. Option G Species Genus Family Order Class PhylumOrDivision Phylum Division Kingdom Design Options • Species BIDI Meeting

  22. Future Work • Improve and validate models • Needed input from OSU • Load data • OSU (w/ Michael Blongewicz of DHI?) • Benchmarking • OSU (w/ Michael Blongewicz of DHI?) • Publications • CMRC & OSU: identify journals + write articles BIDI Meeting

  23. END BIDI Meeting

More Related