GCE Taxonomic Database:A researcher-managed web
database application
Wade SheldonWade Sheldon
GCE Information ManagerGCE Information Manager
Primary Design Goals
Create database structure to store general Create database structure to store general taxonomic information (plants, animals, taxonomic information (plants, animals, fungi)fungi)
Create web application to generate dynamic Create web application to generate dynamic species lists from databasespecies lists from database
Include links to ancillary information Include links to ancillary information (habitats, voucher specimen, site (habitats, voucher specimen, site occurrences, photos, data sets, pubs)occurrences, photos, data sets, pubs)
Hidden IM Agenda
Develop framework to allow investigators Develop framework to allow investigators to maintain database & web pages to maintain database & web pages themselvesthemselves
Goals:Goals: Engage researchers in interactive IM project (inreach)Engage researchers in interactive IM project (inreach) Relieve IM of additional web maintenance tasksRelieve IM of additional web maintenance tasks
Components
Relational database (SQL Server)Relational database (SQL Server) 3 dynamic web pages3 dynamic web pages
List catalog page (with custom list selector form)List catalog page (with custom list selector form) Species list pageSpecies list page Taxonomic details page with links to ancillary infoTaxonomic details page with links to ancillary info
Web management tables in databaseWeb management tables in database Forms-based UI for entering/editing taxonomic Forms-based UI for entering/editing taxonomic
info and managing web lists and page captions info and managing web lists and page captions (Access Data Project)(Access Data Project)
Database Schema
(on WWW)
Catalog Page
Species List Page
Species Detail Page