gce taxonomic database: a researcher-managed web database application wade sheldon gce information...

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