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

---

View full specifications (PDF)

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

• HIS-20 directory structure
• Uniface assignment files
• Command procedures/shell scripts

4. Relational Database Architecture

• File structures
• Memory and process structures
• Logical data structures and transactions

5. Introduction to SQL

• Tables, columns, data types
• The SELECT statement
• Where clauses
• Functions, ordering, grouping
• Other SQL statements

6. Database System Management

• Database management utilities
• Monitoring database structures
• Creating, altering, deleting database structures
• Maintaining database users
• Setting database parameters

7. Database Backup and Recovery

• Backup/recovery database structures
• How to perform backups: offline and online
• Database crash scenarios
• How to recover the database after a crash

View full specifications (PDF)

---

Top of Page