Implementation of a Material Safety Data Sheets System Using Oracle.

摘要

A Material Safety Data Sheets (MSDS) system for the Department of Energy's (DOE's) Pittsburgh Energy Technology Center was implemented to run on a VAX running Oracle under VMS. This MSDS system was modelled after an existing one implemented under a non-relational DBMS on an IBM/MVS machine. The need to redesign the database for a relational system and the special consideration of Oracle LONG fields is discussed. An attempt was made to use SQL*Forms to create a user interface for the new system. Difficulty in creating a sufficiently ''friendly'' interface for occasional users, combined with the need to handle LONG fields outside of Forms, resulted in a decision to write the interface in C and use the VAX Screen Management Facility or full-screen capabilities. 3 refs., 1 tab.