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

This paper outlines the realization of rich retrieval facilities and comprehensive data administration in an existing, large, integrated Hospital Information System (HIS) using SQL as a query-language and using a large collection of formal data descriptions stored in the Data Dictionary and Directory System (DD/DS). It is emphasized that the approach to enhance the access to the database is more important than the technology. Nevertheless, the facilities are presented that support non-routine retrieval. The Data Dictionary and Directory System functions as a catalog of the information system. The vehicle that facilitates the communication with the database is an implementation of SQL-in a number of appearances. It is stressed that only full benefit can be gained through a combined action of a large integrated HIS, a complete and correct DD/DS, and strong retrieval functions.