Transcript Slide 1
BIDI: Biological Data Integration Database Design Options Yassine LASSOUED [email protected] 21 July 2007 BIDI Meeting 1 Outline • Previous Work and Meetings • Existent Data • Database Design Options • Future Work 21 July 2007 BIDI Meeting 2 Previous Work • Numerous options have been proposed • Two options have been pre-selected • Data models have been implemented as Visio diagrams, using Arc Marine 21 July 2007 BIDI Meeting 3 Existent Data • Acoustic Surveys • Nephrops Underwater TV Surveys • Larval Surveys • Deep Water Surveys • Groundfish Surveys • HABs 21 July 2007 BIDI Meeting 4 Acoustic Surveys 21 July 2007 BIDI Meeting 5 Nephrops Underwater TV Surveys 21 July 2007 BIDI Meeting 6 Larval Surveys 21 July 2007 BIDI Meeting 7 Deep Water Surveys 21 July 2007 BIDI Meeting 8 Groundfish Surveys 21 July 2007 BIDI Meeting 10 HABs 21 July 2007 BIDI Meeting 12 Integrated Biological Data Schema • Current Version (Based on Acoustic Surveys) FSS_Surveys FSS_SurveyTypes FSS_Events FSS_Vessels FSS_Hauls FSS_AgedFish FSS_NASC FSS_Scientists FSS_Stratum_Bounds 21 July 2007 FSS_Samples FSS_LengthFreq Original tables Information about events Information about surveys Information about samples BIDI Meeting 13 Integrated Biological Data Schema • Extended Version Survey Track Event Cruise Country Vessel Haul SurveyType SurveyGears HABStation SurveyStation ICESDivision Scientist Gear HABSample Catch FishSample AgedFish LengthFrequency Phytoplankton Species BioassayChemistry Isobath Original tables Fish samples Business Tables HABs Samples Information about events 21 July 2007 BIDI Meeting 14 Integrated Biological Data Schema • Aligning Business tables with the MIDM Contact Organisation Country Platform PlatformType ActivityOrganisationRoles OrganisationRole ActivityType ActivityContactRoles ActivityMetadata ContactRole ActivityDevices Activity Track Event Cruise ActivityGears ICESDivision Haul HABs_Station HABs_Sample SurveyStation Gear Catch AgedFish BioassayChemistry Phytoplankton FishSample LengthFrequency Isobath Species Original tables Fish samples Business Tables HABs Samples Information about events 21 July 2007 BIDI Meeting 15 Design Options • Fish Survey Stations Criteria Arc Marine InstantaneousPoint SurveyStation Option B 21 July 2007 ICESDivision Option B Ease of Understanding ▲▲▲ Ease of Query Formulation ▲▲▲ Normalization ▲▲▲ BCNF Storage Efficiency ▲▲▲ Access Efficiency ▲▲▲ Scalability ▲▲▲ Genericity ▲▲ Data Processing ▲▲ Harmony with the MIDM ▲ Compatibility with Arc Marine ▲▲▲ BIDI Meeting 16 Design Options • HABs Stations Criteria Arc Marine FeaturePoint HABs_Station Option E Ease of Understanding ▲▲▲ Ease of Query Formulation ▲▲▲ Normalization ▲▲▲ BCNF Storage Efficiency ▲▲▲ Access Efficiency ▲▲▲ Scalability ▲▲▲ Genericity ▲▲ Data Processing ▲▲ Harmony with the MIDM ▲▲ Compatibility with Arc Marine ▲▲▲ Option E 21 July 2007 BIDI Meeting 17 Design Options • Fish Samples • Option 1: Generic Sample Analyses Activity ActivityDevices Gear SubSample Haul SurveyStation Sample Catch Individual Species Parameter IndividualMeasuredData Option D.1 21 July 2007 BIDI Meeting 18 Design Options • Fish Samples • Option 2: Current model Activity ActivityDevices Gear LengthFrequency Haul SurveyStation Sample Catch Individual Species LengthClass Option D.1 21 July 2007 BIDI Meeting 19 Design Options • Fish Samples • Comparison Criteria 21 July 2007 Option D.1 Option D.2 Ease of Understanding ▲▲ ▲▲▲ Ease of Query Formulation ▲▲ ▲▲▲ Normalization ▲▲▲ ▲▲▲ Storage Efficiency ▲▲▲ ▲▲▲ Access Efficiency ▲▲ ▲▲▲ Scalability ▲▲ ▲▲▲ Genericity ▲▲▲ ▲ Data Processing ▲▲ ▲▲▲ Harmony with the MIDM ▲▲ ▲ Compatibility with Arc M. ▲▲▲ ▲▲ BIDI Meeting 20 Design Options • HABs Samples • Option 1: HABStation HABSample HABAnalysis WaterSample Organisation Phytoplankton Species ShellfishSample Bioassay Chemistry Option F.1 21 July 2007 BIDI Meeting 21 Design Options • HABs Samples • Option 2: HABStation HABSample HABAnalysis Organisation Species Phytoplankton BioassayChemistry Option F.2 21 July 2007 BIDI Meeting 22 Design Options • Species Species Genus Family Order Class PhylumOrDivision Phylum Kingdom Division Option G 21 July 2007 BIDI Meeting 23 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 21 July 2007 BIDI Meeting 24 END 21 July 2007 BIDI Meeting 25