A dBASE III system for managing 35 mm slides in pathology.
We describe the design and management of a 35 mm slide database using a menu-driven dBASE III PLUS programme and a microcomputer in a large department of pathology that also caters for the individual pathologist. Existing systems described in the literature are geared towards slides of general medicine and do not address the needs of the individual pathologist. A total of 11,481 slides in the Department of Pathology, Faculty of Medicine, University of Malaya, were filed into a single database with each record representing one slide. Nine fields which comprised the slide accession number, reference number, slide category, SNOMED codes, and a description of the slide in natural language, seemed adequate for slide definition. The menu-driven programme had functions which included the abilities to add, delete, edit and back-up records, and to search for desired slides. Although slides may be searched for in various fields, we found that searches using natural language alone were both comprehensive and efficient, provided a standard format of description was adhered to and data entries scrutinized carefully for errors. We believe therefore, that for the pathologist working alone, coded language fields are not absolutely necessary, as manual coding and additional data entry can be time consuming. As expected, for databases larger than 10,000 slides, a 80286 microprocessor-based microcomputer was more efficient. We are of the opinion that a system such as ours is very useful for a large department of pathology or the individual pathologist to file and retrieve 35 mm slides.
Wong
K T
KT
Department of Pathology, Faculty of Medicine, University of Malaya, Kuala Lumpur.
Chan
K S
KS
D016208:Databases, Factual; D008838:Microcomputers; D010336:Pathology / Q000295:instrumentation / Q000379:methods*; D012984:Software