Modeling and implementing a database on drugs into a hospital intranet

Area of Science:

• Pharmacology
• Health Informatics
• Database Management

Background:

• University hospitals require efficient access to comprehensive drug information.
• Existing drug information systems may lack integration or ease of use.
• The Thériaque database offers a centralized resource for French drug information.

Purpose of the Study:

• To develop and implement a drug information service within a university hospital information system.
• To create a user-friendly interface for accessing drug data via an internet environment.
• To leverage the Thériaque database for comprehensive drug information delivery.

Main Methods:

• Object-oriented modeling was used to structure drug content (chemical classes, components, indications, etc.).
• HTML pages were designed to reflect the object-oriented model's structure.
• A relational database stored drug information, dynamically populated through queries.
• Implementation focused on a web-based interface, avoiding client application deployment.

Main Results:

• A functional drug information service was successfully implemented.
• The system provides dynamic access to drug data through an intuitive web interface.
• Fast implementation was achieved without requiring client software on user workstations.
• End-users benefit from easy and natural access to drug information.

Conclusions:

• The developed drug information service effectively integrates the Thériaque database into a hospital information system.
• The object-oriented approach and web-based design facilitated rapid deployment and user accessibility.
• This system offers a scalable and efficient solution for accessing critical drug information in healthcare settings.