Database Design for Preservation Project Management: The California Newspaper Project

Abstract

In this article, database design for preservation project management is addressed. The system described manages a serials preservation project in which issues from multiple repositories are gathered and collated for preservation microfilming. The system accommodates the ongoing standardization of bibliographic data in the MARC format to facilitate the comparison of holdings among collections. It imports holdings records in the OCLC format and provides for the addition of condition reports and information about existing microfilm service copies, filmers, and the locations of master negative microfilm. Boolean search strategies, employing data from both bibliographic and holdings records, facilitate the identification of newsprint available for microfilming. Management information, added to bibliographic and holdings records, supports the production of reports tracking preservation activity.