Affiliation: | a Edinburgh University Computing Service, 1 Roxburgh Street, Edinburgh EH8 9LN, Gt. Britain b University of Edinburgh, Royal (Dick) School of Veterinary Studies, Department of Veterinary Clinical Studies, Veterinary Field Station, Easter Bush, Roslin, Midlothian EH25 9RG, Gt. Britain |
Abstract: | A mainframe relational database management system (RDBMS), ORACLE, has been applied to small animal clinical records to facilitate storage and querying of case data for clinical and epidemiological use. Coded records are entered into the computer via a “user-friendly” interface which validates the input. Clinicians' queries similarly utilise an interface that generates query commands from four simple queries. Epidemiologists' queries, in contrast, require considerable flexibility and so use the main RDBMS language, SQL*Plus. A data administrator manages the security and integrity of the RDBMS. |