title: Retrieval from a large, integrated HIS-database through formal descriptions and SQL.
abstract: 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.
authors.affiliation: BAZIS Foundation, Leiden, The Netherlands.
authors.forename: M P
authors.initials: MP
authors.lastname: Hooymans
authors.forename: H
authors.initials: H
authors.lastname: Liefkes
authors.forename: J A
authors.initials: JA
authors.lastname: Schipper
authors.forename: A R
authors.initials: AR
authors.lastname: Bakker
mesh_terms: D006751:Hospital Information Systems; D016247:Information Storage and Retrieval; D018875:Vocabulary, Controlled