.

Digital Images

35mm Slides

Collection Policies

Circulation

Student Employment

Emergency resources

Web Resources

Mission Statement

2008 Images of the Month

Past images of the Month

Newsletter 2001

Newsletter 2002

News 2006

News 2007

VRC Brochure0

FAQ

8:30AM -

5:00PM Mon-Fri

Heather Seneff, Director
Gould Hall, Room 330
8:30AM - 5:00PM Mon-Fri
206-543-7598
hs3@u.washington.edu

, Director ld Hall,

Database

The Collection's main management database was created in Fall of 2001 using Microsoft Access. It is a relational database that uses natural language and recognizable abbreviations and phrases (rather than numeric codes). It is based on the standard Dublin Core format (though not slavishly so), with some influence from VRA (Visual Resources Association) Core.

The key to the database is the unique accession number which is assigned to each image added to the Collection. This unique number identifies the individual record, ties the record to an actual image (digital and/or analog), and links that record to the information that is unique to that record (such as the Source for the image). The Collection's accession number format also indicates the year the image was acquired (or cataloged into the database).

A series of related tables of authority data interact with the main set of image records in the Collection's relational database.

In addition to the authority files, there are other fields of information in the database that describe the image (such as the Title, View, Date of photograph), provide information about the building or site (such as the Attribution of the work, the location of the building, or the material used in the building), and place the building or work in historical context (Time Period, Movement)


Some fields are formatted especially for use on slide labels, others are used exclusively in the digital image database. There are also a number of check-box fields that trigger slide label reports, accession record reports, and exporting data. A thumbnail image of each image is imbedded into the main record.

SQL Server

In 2003, the Microsoft Access database was upsized to SQL and now is housed on a dedicated VRC SQL server in the College. In 2007, a new fiber channel SAN Xeon dual proc blade server was implemented for the Collection by the Computing staff of the College. Collection staff continue to address the database through a Microsoft Access front end for data entry and reports.

Digital Image Database

In 2002, the Director implemented the digital image management software developed at James Madison University and fondly called the MDID. This became the digital complement to the Collection's main management database (which remains strictly in-house). The digital image database is accessible over the Internet to CAUP faculty and students. Text information from the Collection's main database is imported into the MDID.

© UW CAUP VRC, Sept 2007