DataBase Managment System

Figure 5-2. The database(s) (DB) with organized data and metadata are part of the Database SysteiTi (DBS), which is managed by the Database Management System (DBMS).

A disadvantage of the relational database management system (RDBMS) might be the overload of hardware and operating systems, which make the system slower. 

MACCS-II enables direct interface with other database management systems, such as the Relational Database Management System (RDBMS) and Oracle, so that databases which contain text and numeric data for which special interfaces are normally needed can be constmcted. Eor example, an Oracle MACCS-II linked system is currendy being used by the National Institute on Dmg Abuse (113) to develop a database that will allow scientists to determine the molecular stmctures of cocaine and other controlled substances as well as designer dmgs. 

The hardware and software used to implement LIMS systems must be vahdated. Computers and networks need to be examined for potential impact of component failure on LIMS data. Security concerns regarding control of access to LIMS information must be addressed. Software, operating systems, and database management systems used in the implementation of LIMS systems must be vahdated to protect against data cormption and loss. Mechanisms for fault-tolerant operation and LIMS data backup and restoration should be documented and tested. One approach to vahdation of LIMS hardware and software is to choose vendors whose products are precertified however, the ultimate responsibihty for vahdation remains with the user. Vahdating the LIMS system s operation involves a substantial amount of work, and an adequate vahdation infrastmcture is a prerequisite for the constmction of a dependable and flexible LIMS system. 

A database management system (DBMS) is used by most LIMS systems for storing data. Examples of commercially available DBMS are DB2, DBASE, Informix, INGRES, ORACLE, and RDB. AH of these DBMS conform to the "relational" model developed by Codd (19). Eigure 3 demonstrates the use of a relational DBMS for storing LIMS data. Here data is grouped by type so customer and analysis requests are stored separately from sets of sample information which are, in turn, stored separately from sets of analysis results. Individual records are linked or related by unique identification data. 

Database management system for MSDS information. Modules include SARA, for assistance in creating reports for Title III, and SAFETY for accident and incident recordkeeping. 

File manager systems—Maintain files and handle data input to and output from the files. Database management systems (DBMS) contain integrated sets of files related by their use and provide uniform software interfaces for accessing data. The essential relationships between records in the files may be of several types, including sequential, associative, or hierarchical. 

The explosion of graphical software and the ability of database management systems to store graphical data provide a mechanism for designing and implementing clip art to convey certain meaning to the user. For example traffic lights have been used to convey the status of data collection forms. 

Harder, Mark E., and Koski, Peter A., A Microprocessor-based Scientific database Management System" American Laboratory. SEPT 1983... 

This paper highlights the procedures, QA/QC, and database management system implemented by Tournigan to ensure a reliable and secure data set. The effective QA/QC by Tournigan also helped to establish that Pressed Pellet and Borate Fusion XRF are a more accurate assaying method compared to ICP. 

MAECIS contains five major sections that are integrated into a single system. At its center is a database management system that handles the storage and updating of data and chemical structures. Associated with this section is an information retrieval section that allows one to search the database for specific information composed of any combination of data and/or substructures. Once information is retrieved, it can be displayed on a computer terminal or sent to a printer for hardcopy output using the display section of MAECIS which includes the ability to display chemical structures in various formats. The final two sections of MAECIS allow for the manipulation of chemical structures and the calculation of various molecular properties that are related to chemical structures. 

MACCS-II enables direct interface with other database management systems, such as Ihe Relational Database Management System RDBMS) and Oracle, so that databases that contain text and numeric data, for which special interfaces arc normally needed, can be constructed. 

---