Creating an Alternative Video and DVD Catalog

1
Creating an Alternative Video and DVD Catalog

• Nora Dimmock
• Media Librarian, Multimedia Center
• ndimmock_at_library.rochester.edu
• Jeff Suszczynski
• Senior Web Developer
• jeffs_at_library.rochester.edu

2
The Multimedia Center
3
MMC Collections
4
Responding to our Users

• Student Senate representatives ask for help in
  establishing a DVD collection for recreational
  viewing
• The Senate contributes 10,000 towards the
  collection
• The library agrees to purchase, process and
  circulate the collection through the Multimedia
  Center

5
Student DVD collection
6
The Back Room
7
DVDs and Videos

• Finding DVDs in Voyager (URs Library Catalog)
  just didnt cut it.
• Not browse-able
• Cumbersome limits page to work through
• Demo

8
DVDs and Videos

• Created a separate interface
• Search by keyword
• Browse by title, genre, language, and director
• Customized metadata display on results screen
• Automated system with data maintained in Voyager
• Demo

9
DVDs and Videos
Library website user interface
Cold Fusion UI queries SQL

• Scheduled PERL script
• Parse the MARC record
• Conditional logic
• Regular expression cleanup
• Save flat-text file

• Scheduled ColdFusion script
• Import flat-text file
• Populate SQL database

Record cleanup in Voyager
Voyager (Library Catalog)
Web OPAC
Oracle
PERL
10
DVDs and Videos (Phase 2)

• Need to provide availability information on
  result selection screen
• Copied data not up-to-the minute
• Live circulation status on results screen

11
DVDs and Videos (Phase 2)
Library website user interface

1. SQL query to local database
2. We have BIB and MFHD IDs
3. SQL query to Voyager

Voyager(Library Catalog)
Web OPAC
Circulation Status
Oracle
PERL
12
DVDs and Videos (etc)

• Based on DVDs and Videos, we built another
  system called CDs and Sound Recordings
• Highlights
• Staff only access to the physical CDs
• Record manipulation for Record Store subject
  browsing
• Data extraction was similar to DVDs and Videos

13
Measuring Success
14
Can we handle this?
15
A Few More Numbers

• The current Student DVD collection has 1,866 DVDS
• They have circulated a total of 93,475 times!
• 170 out of 171 students surveyed said the Video
  DVD collection was a good use of SA funds.

16
Top 10 DVDs

• Title Circulations
• Chocolat 198
• English Patient 194
• Monsters Ball 190
• Big Lebowski 189
• Seven 188
• Training Day 183
• Spy Game 182
• Family Man 181
• American Beauty 180
• Traffic 179

17
Creating an Alternative Video and DVD Catalog

• Nora Dimmock
• Media Librarian, Multimedia Center
• ndimmock_at_library.rochester.edu
• Jeff Suszczynski
• Senior Web Developer
• jeffs_at_library.rochester.edu