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

• Voyager (WebVoyage) just didnt cut it
• Not browse-able
• Cumbersome limits page to work through
• UC Berkeley
• 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

8
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
9
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

10
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
11
DVDs and Videos (etc)

• DVDs and Videos is related to FRBR
• Primary language expression level attribute
• Genre work-level attribute
• User needs for metadata
• Unknowingly implemented aspects of FRBR

12
Measuring Success
13
Can we handle this?
14
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.

15
Top 10 DVDs

1. Chocolat
2. English Patient
3. Monsters Ball
4. Big Lebowski
5. Seven
6. Training Day
7. Spy Game
8. Family Man
9. American Beauty
10. Traffic

16
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