Pharmacy World and Science

, Volume 25, Issue 4, pp 156–161 | Cite as

Design and implementation of a common drug information database for a university hospital

  • M. Dugas
  • J. Hasford
  • S. Weinzierl
  • A. Pecar
  • S. Endres


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.Conclusion: 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.

Database Development Drug information Intranet Germany Knowledge management 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    McGettigan P, Golden J, Fryer J, Chan R, Feely J. Prescribers prefer people: The sources of information used by doctors for prescribing suggest that the medium is more important than the message. Br J Clin Pharmacol 2001; 51: 184–9.Google Scholar
  2. 2.
    Alvan G, Ohman B, Sjoqvist F. Problem-oriented drug information: a clinical pharmacological service. Lancet 1983; 2(8364): 1410–2.Google Scholar
  3. 3.
    Nilsson G, Hjemdahl P, Hassler A, Vitols S, Wallen NH, Krakau I. Feedback on prescribing rate combined with problem-oriented pharmacotherapy education as a model to improve prescribing behaviour among general practitioners. Eur J Clin Pharmacol 2001; 56: 843–8.Google Scholar
  4. 4.
    Beaird SL, Coley RM, Blunt JR. Assessing the accuracy of drug information responses from drug information centers. Ann Pharmacother 28: 707–11.Google Scholar
  5. 5.
    Bond CA, Raehl CL, Franke T. Clinical Pharmacy Services and Hospital Mortality Rates. Pharmacotherapy 1999; 19: 556–64.Google Scholar
  6. 6.
    Forrester LP, Scoggin JA, Valle RD. Pharmacy management company-negotiated contract for drug information services. Am J Health Syst Pharm 1995; 52: 1074–7.Google Scholar
  7. 7.
    Kinky DE, Erush SC, Laskin MS et al. Economic Impact of a Drug Information Service. Ann Pharmacother 1999; 33: 11–6.Google Scholar
  8. 8.
    Neal T. Justifying an information system. Am J Hosp Pharm 1993; 50: 476–82.Google Scholar
  9. 9.
    Ohman B, Lyrvall H, Tornquist E, Alvan G, Sjoqvist F. Clinical pharmacology and the provision of drug information. Eur J Clin Pharmacol 1992; 42: 563–68.Google Scholar
  10. 10.
    Angaran DM Telemedicine and telepharmacy: Current status and future implications. Am J Health Syst Pharm 2000; 56: 1405–26.Google Scholar
  11. 11.
    Kramer I. How to implement scientific knowledge in clinical practice. Pharm World Sci 2000; 22: A9.Google Scholar
  12. 12.
    Medical Subject Headings, US National Library of Medicine Home Page. Retrieved from meshhome.html on 9 December 2002.Google Scholar
  13. 13.
    Dugas M, Weinzierl S, Pecar A, Hasford J. Intranet Database for a University Hospital Drug Information Center. Am J Health Syst Pharm 2001; 58: 799–802.Google Scholar
  14. 14.
    Troger U, Meyer FP. The regional drug-therapy consultation service centre - a conception that has been serving patients and physicians alike for 30 years in Magdeburg (Germany). Eur J Clin Pharmacol 2000; 55: 707–11.Google Scholar
  15. 15.
    Computerized Systems Used in Clinical Trials. FDA Home Page. Retrieved from compliance_ref/bimo/ffinalcct.PDF. on 9 December 2002.Google Scholar
  16. 16.
    SuSE Linux Home Page. Retrieved from on 9 December 2002.Google Scholar
  17. 17.
    The Apache Software Foundation Home Page. Retrieved from on 9 December 2002.Google Scholar
  18. 18.
    Wall L, Schwartz RL Programming PERL. Sebastopol, California: O'Reilly & Associates, 1992.Google Scholar
  19. 19.
    PostgreSQL Home Page. Retrieved from http://www. on 9 December 2002.Google Scholar
  20. 20.
    Dugas M, Uberla K. Intranet based clinical workstations. In: Victor N, editor. Medical Iinformatics, biostatistics and epidemiology for efficient health care and medical research. Munich, Germany: Urban und Vogel, 1999: 235–8.Google Scholar
  21. 21.
    Dugas M, Uberla K. Intranet-based clinical data entry. In Lorenzi NM, editor. AMIA Proceedings. Philadelphia: Hanky & Belfus, 1999: 1051.Google Scholar
  22. 22.
    Extensible Markup Language (XML). Retrieved from on 9 December 2002.Google Scholar
  23. 23.
    Azaz-Livshits T, Levy M, Sadan B, Shalit M, Geisslinger G, Brune K. Computerized survelliance of adverse drug reactions in hospital: pilot study. Br J Clin Pharmacol 45: 309–14.Google Scholar
  24. 24.
    Walsh PJ. E-pharmacy systems - prescription and medication fulfillment come of age. MD Computing 2001; 17: 45–8.Google Scholar
  25. 25.
    Anderson JG. Evaluating clinical information systems: a step towards reducing medical errors. MD Computing 17: 21–3.Google Scholar

Copyright information

© Kluwer Academic Publishers 2003

Authors and Affiliations

  • M. Dugas
    • 1
  • J. Hasford
    • 1
  • S. Weinzierl
    • 2
  • A. Pecar
    • 3
  • S. Endres
    • 4
  1. 1.Department of Medical Informatics, Biometrics and Epidemiology (IBE)University of MunichMunichGermany E‐mail
  2. 2.Bavarian Chamber of Pharmacists, Maria‐ Theresia‐MünchenGermany
  3. 3.Pettenkoferstraáe 8a, D‐University Hospital PharmacyMunichGermany
  4. 4.Division of Clinical PharmacologyUniversity of MunichMunichGermany

Personalised recommendations