title: Design and implementation of a common drug information database for a university hospital.
abstract: 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.
authors.affiliation: Department of Medical Informatics, Biometrics and Epidemiology (IBE), University of Munich, Marchioninistr. 15, D-81377 Munich, Germany. dug@ibe.med.uni-muenchen.de
authors.forename: Martin
authors.initials: M
authors.lastname: Dugas
authors.forename: Sonja
authors.initials: S
authors.lastname: Weinzierl
authors.forename: Alenka
authors.initials: A
authors.lastname: Pecar
authors.forename: Stefan
authors.initials: S
authors.lastname: Endres
authors.forename: Jörg
authors.initials: J
authors.lastname: Hasford
mesh_terms: 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
chemical_list: D004364:Pharmaceutical Preparations