SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

Advancements in Data Management for the West Coast Groundfish Trawl Catch Share Program

roanna-cox avatar
roanna-cox
32 diapositives · 586 Views · Nov 30, 2014

This presentation, led by Richard Kang from the National Marine Fisheries Service, explores the evolution and implementation of electronic reporting systems within the West Coast Groundfish Trawl Catch Share Program (IFQ). It highlights key data management practices, developmental milestones, and the significance of making data an agency resource alongside financial and human assets. Emphasis is placed on the challenges and solutions encountered throughout the project's lifecycle, showcasing lessons learned and the importance of collaboration, user feedback, and adaptive methodologies.

#advancements in data management for the west coast groundfish trawl catch share program #advancements in data management for the west coast groundfish trawl catch share program ppt #powerpoint #presentation
Advancements in Data Management for the West Coast Groundfish Trawl Catch Share Program - slide 1
01 / 32Advancements in Data Management for the West Coast Groundfish Trawl Catch Share Program
1 / 17

Télécharger la présentation

Advancements in Data Management for the West Coast Groundfish Trawl Catch Share Program
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  1. National Marine Fisheries Service FIS Electronic Reporting Special Interest Group: West Coast Groundfish Trawl Catch Share Program - Individual Fish Quota System (IFQ) Presented by: Richard Kang Scientific Data Management, NWFSC Seattle, WA Aug. 24, 2011

  2. Welcome to the Information Age and Electronic Reporting 11/29/2014

  3. What is Data Management? The development, execution and supervision of plans, policies, practices, and programs that control, protect, deliver, and enhance the value of data and information assets. Data Management Association International (DAMA) 11/29/2014

  4. 11/29/2014

  5. NMFS customers can confidently find, access, and use our data. “Deliver the right data, information, and services when and where they are needed.” "To effect a cultural change in which all NMFS data are recognized and managed as a core agency resource, on par with financial and human resources." 11/29/2014

  6. The Magnuson-Stevens Fishery Conservation and Management Act – Oct. 11, 1996 and 2007 • NMFS Catch Share Program • May 2010 - First meeting with NWR • June 2010 - Started Requirements gather process • Sept 2010 - No contractors on board til end of month • Sept – SER lockdown visit (Irene • Nov 2010 - first Prototype • Dec 17, 2010 – Requirements Completed • Dec - User reviews and changes to interface • Dec - working weekend and nights (web conference) • Jan 2011 - Testing,Testing,Testing • Jan 2011 - Multiple releases, collisions, and coordination • Jan 11, 2011 12:00 - West Coast Groundfish Catch Share Trawl Program or IFQ launched • Jan – Parties with SDM • Numerous releases and fixes • Mar - Presentation to Pacific Fisheries Council • June – Maintenance • Aug 2011 – Phase II Admin and Renewals development 11/29/2014

  7. Tools: • Oracle DB Ver. 10 • Oracle Designer 10 • Oracle ApEx 3.0 for reporting/Adhoc Query reports • Oracle SQL Developer/Toad • Subversion version control • Java (middle tier and web service) • PL/SQL • Adobe Flex 3.0 (Action Script) • Visio, Flex Designer (Visual Interface) • Oracle and Beehive Collaboration Suite • NWFSC Infrastructure – secured 11/29/2014

  8. 11/29/2014

  9. Deliver IFQ Application Database in 6 months by Jan. 1 2011 Actual Implementation Jan. 11, 2011 at 12:00 PM Functional Requirements (Use Cases) Legislation, Policy, and Business Rules Functions and Entity Analysis Review Existing Systems Discoverable Metadata In InPort 11/29/2014 IFQ Pilot Year Jan. 11, 2011 User Acceptance Review

  10. IFQ Development Portal 11/29/2014

  11. IFQ Collaboration, Document and Content Management

  12. 11/29/2014

  13. Data Flow Process 11/29/2014

  14. QA/QC Process 11/29/2014

  15. IFQ Entity Relationship Diagram 11/29/2014

  16. Data Dictionary 11/29/2014

  17. Function Hierarchy 11/29/2014

  18. IFQ Database Environment and more

  19. IFQ Release Process 11/29/2014

  20. IFQ Production 1.3.3 Training Videos IFQ Application User Help Guide Query & Search Tool

  21. 11/29/2014

  22. Next Steps • Phase II IFQ administrative requirements and enhancements – Summer/Fall 2011 • Account renewals for 2011 • Economic Data Survey database system linkage • Year 2 rollover on Jan. 1, 2012 • Complete detailed system documentation • Implement scalable redundant array cluster (RAC) • Apply lessons learned to on-going projects for further integration • Observer Program development Oracle DB Observer in Database and Apex Website Observer Client in Apex and Oracle XE DB – Dec. 31, 2011 Observer Program Logistics Database – Oct. 1 Observer with AdHoc Query in Apex/GIS - 12/2012 • Celebrate team successes 11/29/2014

  23. Economic Data Survey Collection built in 6 weeks 11/29/2014

  24. 11/29/2014

  25. Metadata Card Catalog https://inport.nmfs.noaa.gov/inport/item/11090 11/29/2014

  26. Lessons Learned • Borrow, learn, and adopt what others have done, • ASK FOR HELP!!! • Alaska Region and Center, Pacific States, Southeast Region*, NWR, OLE, NWC and potential users • Capture extensive business requirements and rules from all participants, extensive review process and the Regs • The right people, tools, methods, and budgets • User feedback, bugs, and timely responses until resolved, • Try new tools (Adobe Flex) and processes (Subversion) leverage past successful efforts (Oracle ApEx, PL/SQL/Java) and enterprise infrastructure supported by IT, • Web services/ODBC to integrate disparate DB over the web • Top Down, Agile, and Spiral (don’t get stuck on methodology). • Data QA/QC resolution issues will take significant time and resources as part of maintenance 11/29/2014

  27. Conclusions Data management and Electronic Reporting is successful when your project: • supports agency’s high priority mission, • will result in positive management support, • sufficient budgets, • the right people, tools, and methods, • meets tight timeframes • appreciative customers, • lead by successful examples, • celebrate successes, • Just Do It and Deliver and hope you survive! 11/29/2014

  28. 11/29/2014

  29. Q & A Crew for hire. Will share code and knowledge. Contact SDM Helpdesk 11/29/2014

  30. Websites NWR and NWC Websites: https://webapps.nwfsc.noaa.gov https://webapps.nwfsc.noaa.gov/ifq http://www.nwr.noaa.gov/ 11/29/2014