HIS-20 Database Administration (HS-1105-5)

Purpose:

This five day course is designed for individuals who wish to configure and maintain the HIS-20 application and the database management system underlying it. It teaches how to use HIS-20 management functions, how command procedures and other operating system structures are used by HIS-20, and how to query and maintain the relational database system underlying HIS-20.�

Prerequisites:

Familiar with basic operating system commands, directory structure, and batch job utilities. Familiarity with a system text editor, and the ability to write simple command procedures/shell scripts in the operating system command language.�

Description:

This course is intended for students with some previous experience with the operating system and HIS-20 software applications. The course is a comprehensive introduction to the maintenance of the HIS-20 application and its underlying Database management system.

The course features a review of HIS-20 special management functions, and relational database system and operating system concepts which pertain to successful HIS-20 operation. The student will learn how to customize and maintain the HIS-20 environment, how HIS-20 uses operating system functionality to implement several important functions, and how to maintain the database system underlying HIS-20.

Upon successful completion of this course, the student should be able to customize HIS-20 via lookup tables and site parameters; control the HIS-20 event scheduler and electronic dosimeter reader functions; control user security in the HIS-20 environment; configure HIS-20 printer definitions; understand the directory structure and command files which allow HIS-20 to operate; customize Uniface settings to manage multiple HIS-20 installations on a system; understand the basic architecture of the relational database system underlying HIS-20; query the database using SQL (Structured Query Language); maintain the database structure to optimize HIS-20 performance; and backup and restore the HIS-20 database.

Course Content:

1. HIS-20 User Interface (if necessary)

Relational concepts and HIS-20 forms
Screen conventions
Key functions
Retrieve profiles, text editing

2. HIS-20 Database Management Concepts

Site parameters and lookup tables
Defining user security
Defining printers
Event scheduling-BQMS and HIS-20 Job Manager (BQMS replacement, HIS-20 version 7.0.1)
Electronic dosimeter readers
WACS Client/Server Concepts
Database querying

3. Operating System Structures