Retrieval from a large, integrated HIS-database through formal descriptions and SQL

Area of Science:

• Health Informatics
• Database Management
• Information Systems

Background:

• Large-scale Hospital Information Systems (HIS) often face challenges in data retrieval and administration.
• Existing systems may lack comprehensive facilities for non-routine data access.
• The integration of formal data descriptions is crucial for efficient information management.

Purpose of the Study:

• To outline the implementation of advanced data retrieval and administration capabilities within an existing HIS.
• To demonstrate the utility of SQL as a query language for complex data access.
• To highlight the importance of a robust Data Dictionary and Directory System (DD/DS) in conjunction with HIS.

Main Methods:

• Utilizing SQL (Structured Query Language) for database querying.
• Leveraging a comprehensive Data Dictionary and Directory System (DD/DS) for formal data descriptions.
• Integrating these components within a large, existing Hospital Information System (HIS).

Main Results:

• Successful realization of rich retrieval facilities for enhanced data access.
• Implementation of comprehensive data administration capabilities.
• Demonstration of SQL's effectiveness in facilitating complex database communication.

Conclusions:

• The approach to enhancing database access is paramount, surpassing mere technological implementation.
• A synergistic combination of a large integrated HIS, a complete DD/DS, and strong retrieval functions maximizes benefits.
• Effective data management and retrieval are critical for optimizing HIS functionality.