Application of a general database manager in a clinical medical librarian program

The morning report reference file was automated at the Stollerman Library because the manual system was time-intensive to maintain and cumbersome to search. A general database management system (DBMS) was chosen so that it could be used in the future for other data management functions in the library. DBMS features that should be examined before use with a bibliographic application include size limitations, data entry forms, data types, search options, index files, sort options, report generation, query and programming languages, command and/or menu files, file interaction, interface with other software, and documentation. Desired requirements for this application are discussed. It is noted that a general database manager probably will not meet all of the desired requirements. For some bibliographic applications, software specifically designed for bibliographic information management and retrieval should be used. A database for the purposes of searching the morning report reference file and producing a weekly reference list and a yearly index was developed using CONDOR 3. The structure of the database is described, and examples of the reports are given. The system has been in operation since December 1984 and has been well-received by staff and patrons.