A Digital Library to Archive Research Material from Jane Goodall's Gombe Chimpanzee Project www.goodall.msi.umn.edu

1
A Digital Library to Archive Research Material
from Jane Goodall's Gombe Chimpanzee
Projectwww.goodall.msi.umn.edu

• Student Sarmistha Rout (Dept. of Computer
  Science)

2
Research Materials

• Sample Raw Data for slides
• Category-Aggression
• Category-Portraits

3
Problem Statement

• Given
• Still photographs recorded at Gombe about
  chimpanzees.
• Metadata of Still photographs.
• Objective
• Digitize visual materials and create a database
  using metadata to index and access to these
  materials.
• Enhance the existing digital library view
  application to query and view the still images

4
Project Tasks

• Completed
• Raw Data analysis
• Logical Database design (ERD)
• Physical Database set up
• In Progress
• Data cleaning and loading data to database tables
• Enhance the existing web application to query and
  view the still images

5
Existing ER Diagram of the Database (Video Clip)
6
Revised ERD for both Video Clip and Still image
Database
7
Revised Physical DB for both Video Clip and Still
image
8
Open questions for discussion

• Two tables for Video_Clip and Slides
• vs
• One table (say Visual_Material)
• Do I have to define the relationship and enforce
  referential integrity between the tables to
  enforce data integrity.
• Need for Material_type and Category_type entity ?
• Category types Aggression, ASR, Character-F,
  Characters, Infant development, Locomotion, Play,
  Portraits, Rest, Sex, Siblings, Social Structure,
  Tools, Twins, Weaning, Calls, Faces, Feeding,
  Gestures, Grooming, Habitat, Health,Chimp-Baboons,
  Communication, Culture, Congobraz, Dominance,
  Orphans, Character-G, Human Interest, NonJGI,
  Other Primates, Anne Pusey, E.Vinson
• Can we automatically generate the record id by
  setting the datatype as autonumber.