Databases information management

Establish the data dictionaries and entity-relationship models of relational databases as well as the classes and structure of object-oriented databases. Information Management is most often concerned with the integration of databases, requirements management tools, and any computer-generated media such as interactive training manuals, websites, intranets, and any other forms of media that trace the history of system information throughout the project life cycle. 

Private (EPA) Databases. The U.S. EPA maintains a Hst of approximately 600 current information systems, as weU as some of the models and databases used within the organi2ation. The Hst is pubHshed in Information Systems Inventoy (ISI) which is updated yearly and maintained by the Information Management and Services Division of the Office of Information Resources Management (109). ISI Hsts the system name and acronym, system level, responsible organi2ation, contact person, legislative authorities, database descriptors, access information, hardware and software, system abstract, and keywords. 

CALS combines sample tracking facilities with a database for management and documentation of information in the environmental wa.sie monitoring laboratory. EWOBS provides a reporting format that prints data on the NPDLiS form. 

Software manages and tracks MSDS database information by chemical ID, supplier, synonyms, components, registry numbers, completion status, uses, and hazard classes. Subscription updating. Requires 640K memory and hard disk. 

All that changed in 1992 when Waters introduced its revolutionary new CDS product Millennium . This was the first commercially available CDS to use an embedded relational database (Oracle) to manage all aspects of the system. System security, user privileges, method versions and their respective results were all managed by the database. While this technology was new to CDS, it had been widely used by the Faboratory Information Management System (FIMS) market. All of the... 

From a practical viewpoint, there are two key benefits to this technology. First, it makes retrieval of data very fast and simple. No one wants to search through reports and notebooks in order to find the associated data for a result that is in question. Second, during a regulatory audit it is crucial that your laboratory is able to produce the specific information with as much detail as is required by the auditor. Again, this task is much simpler when a relational database is managing the information (see Figure 7). 

On completion of an analysis, the results are checked and vahdated by the analyst and compared with preset Hmits based on permitted concentration values or consented values, before being sent electronically to the database. Any result which breaches a particular Hmit can be repeated for confirmation. About 80% of the work is fully automated in this way, with most of the major items of equipment being interfaced to the Laboratory Information Management System (LIMS). 

HasweU and Barclay [3] have described a microwave system coupled to an atomic absorption detection system for the analysis of sludges and soils. A major constraint at the present time is that the preferred operation of these types of systems is for sample matrices to be closely matched. A widely varying sample, which exhibits different heating characteristics, wiU either show up as an invaHd result or the time required to cope with this procedure for aU the samples wiU greatly extend the on-Hne analyses time scales. As more of these instrumental systems become Hnked to laboratory information management systems, it wiU become feasible to interact between the control database and the instrumentation so that each sample is treated in an appropriate manner and the optimum time frame is selected for each sample type. When new samples are analysed, the steps could be monitored so that the required time scales are obtained and then stored for future reference. 

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. 

Most corporate databases of chemical compounds (libraries) are of the 2D type. The databases are managed using software that allows fast registration of new structures, fast retrieval of previously stored compounds, and fast substructure searching. (For more information about chemical database management software, see www.mdl.com or www.daylight.com.)... 

Accord Enterprise Informatics (AEI) products integrate to offer an Oracle-based enterprise-wide solution for chemical information management. These products draw on the power of the Accord Chemistry Engine and Oracle databases to store, search, and analyze chemical structures, related biological and chemical data, experimental results, and registration information. 

For the analytical chemist, databases are an essential resource when carrying out their day-to-day activities in product identification. All the major spectroscopic techniques have large databases associated with them, these are used to compare spectra derived from unknown chemicals etc. and so the whole process of product identification is made faster. These are dealt with using a laboratory information management system (LIMS) (see Section B, 2.9.1). 

Current procedures emphasise the importance of storing the laboratory recorded data ( raw data ) and the XRFS analyses are now direcdy transferred via a Laboratory Information Management System (LIMS) to data tables in the BGS corporate geochemistry database. Conditioned data is loaded to different data tables and importantly every analyte result has an accompanying qualifier field that can be provided to the user to explain any data quality issues. 

---