Design and implementation of a common drug information database for a university hospital.
BACKGROUND
Providing high quality problem-oriented drug information relies on the ability to easily collect appropriate background information on clinical cases, to access relevant information from published sources by defined search strategies and to store and retrieve previously answered questions. To do this efficiently, an easy-to-use, flexible and reliable drug information database is necessary.


METHODS
We designed and implemented an Intranet-based drug information database for a major university hospital in Germany. The overall design and the technical details of its design are discussed. We developed a generic, XML-based data model for pharmaceutical inquiries including a MeSH-oriented system of 99 pharmaceutical qualifiers to enable efficient indexing of questions and the searching of indexed questions.


RESULTS
The system provides query statistics and various search algorithms. The software implementation takes into account recent FDA recommendations for software used in clinical trials; internal review for quality control is supported. The database currently consists of 4224 records after 3.5 years of operation. Each inquiry consists of 50 items, 18 of 50 are categorized; 135 text elements support data entry. Our evaluation is focused on technical feasibility, user acceptance and query patterns.


CONCLUSIONS
The intensive use and widespread acceptance of the database indicates a need for a computerized drug information system and suggests that Intranet technology can perform this task.
Dugas
Martin
M
Department of Medical Informatics, Biometrics and Epidemiology (IBE), University of Munich, Marchioninistr. 15, D-81377 Munich, Germany. dug@ibe.med.uni-muenchen.de
Weinzierl
Sonja
S
Pecar
Alenka
A
Endres
Stefan
S
Hasford
Jörg
J
D000043:Abstracting and Indexing; D000465:Algorithms; D003195:Computer Communication Networks; D016208:Databases, Factual / Q000706:statistics & numerical data*; D004346:Drug Information Services; D005858:Germany; D006751:Hospital Information Systems / Q000706:statistics & numerical data; D006785:Hospitals, University; D016247:Information Storage and Retrieval; D004364:Pharmaceutical Preparations; D011786:Quality Control; D012984:Software; D014584:User-Computer Interface
D004364:Pharmaceutical Preparations