Relational data base management system

Sandowdki C, Lawler G. A relational data base management system for LIMS. Amer Lab 21(3) 70-79, March 1989. SARTORIOUS. Self-calibrating balances for quality assurance systems. Pharm Mfg Rev 8.5 38, 1996. 

Explain relational data base management systems. 

SQL. SQL is the Structured Query Language standard promulgated by IBM. It is the de facto standard for relational data base management systems (RDBMSs). The standard defines the syntax of commands that can be used to access and retrieve information from data stored in one or more flat two-dimensional tables. Most... 

Real-time access to the data base is possible through a data base management system. In addition to safety-related system data, data for interfacing (auxiliary) system components are also available. The data base management system provides in-depth flexibility for generation of specific output reports. Although access has been limited to members of the Swedish Utility Consortium and the Swedish Power Board Directorate, a Reliability Data Book is available with generic failure rates based primarily on this data base. 

Data base management system (DBMS) The computer program that is used to control and provide rapid access to a database. A language is used with the DBMS to control the functions that a DBMS provides. For example, SQL is the language that is used to control all of the functions that a relational architecture based DBMS provides for its users, including data definition, data retrieval,... 

The new system is resident on a Fortune 32 16 super micro computer operating under unix. The data base management system chosen is Informix which is a relational type. The relational data base model is based on two dimension tables, all the records in a single table are of the same type. The relationship between records of tables are not held in lists of pointers but by holding common values in each related table. The rows of the tables are the records and the columns the attributes or fields. All records of one table have the same structure. 

Once many in-house, chemical structure data bases had been built, the users began to realize that it was more efficient to use commercially-available structure handling software for structures alone (or structures and a minimal amount of related property data) and to take advantage of data base management systems to handle property data. Molecular Design Limited (MDL) and Telesystemes modified their MACCS and DARC software, respectively, to allow for the appropriate interfacing of structures and data. 

A chemical information system, in a chemical or pharmaceutical company requires access to 2 different types of data the chemical structures handled by a chemical data base system and the information related to chemical structures including biological activity and toxicology handled by a data base management system (DBMS). 

These cross-referenced numbers are the key to the electronic relational data bases. Key field data and sample storage data are entered into location and sample number files in QUIZ Software (4). Laboratory analysis information is contained in files generated using Perkin-Elmer Laboratory Information Management System (LIMS) and Chromatographic Laboratory Analysis System (CLAS) software. 

The data obtained from measurements are analysed and the subsequent information is used for fact-based decision-making. Such data are used to demonstrate the suitabihty and effectiveness of the quahty management system and to evaluate the continual improvement. The analysis of the data provides information relating to... 

The SGX Laboratory Information Management System (LIMS) is based on an Oracle database platform. As an enterprise level relational database, Oracle is robust and can be expanded to meet any future needs. The expense to implement and maintain the database and to create the tools to retrieve the data stored within, including an administrator dedicated to managing the system, can be significant. At SGX, use of the LIMS to monitor all of our scientific activities reduces the incremental cost to the beamline to an acceptable level. 

Laboratory Information Management Systems (LIMS) are widely used in the laboratories of pharmaceuticals and related industries. LIMS is typically based on client server technology supported by a Relational Database Management System (RDBMS) as a storage repository (see Figure 21.1). They can be used to manage and process large amounts of electroiuc analysis data locally within a laboratory or company-wide between sites. 

As another example, the storage area offers the basic models for file storage inside a document management system, relating file-based documents with their conceptual representation inside the Process Data Warehouse. This allows accessing the documents contents and their physical storage places, including the visualization or modification inside appropriate tools. 

We are very accustomed to using forms and reports, often prepared in a standard fashion for a particular application. Record-based models are computer implementations of these spreadsheet-like forms. Two types can be identified. The first of these, common in the early days of file processing systems (FPSs) or file management systems (FMSs), is the individual record model. This is little more than an electronic file drawer in which records are stored. It is useful for a great many applications. More sophisticated, however, is the relational database data model, in which mathematical relations are used to electronically cut and paste reports from a variety of files. Relational database systems have been developed to a considerable degree of sophistication, and many commercial products are available. Oracle and Informix are two leading providers. 

---