Databases Software for

CAMPUS, the plastics database CAMPUS is an internationally known database software for plastic materials, developed by close cooperation with leading plastics producing companies. It is available worldwide from leading material suppliers. More than 50 plastics producers are participants of CAMPUS. Information about the latest list of participants and distribution addresses can be found at the CAMPUS homepage http //www.CAMPUSplastics.com/. This web site also includes extensive information about the data content of CAMPUS and links to the participants web sites. It is important to emphasize that only CAMPUS participants distribute CAMPUS diskettes. Each plastic producer distributes his own diskette to his customers without charge. 

All CD s are stored in a CD-jukebox (100 CD s per jukebox), and are accessible to all HP9000 workstations under HP-UX 9.05 via the fXOS software (Ixos-Jukeman VI.3b). The Ixos-Jukeinan software has a slow time response for filenames searches on the jukeboxes. This problem has been encompassed. Laborelec has developed a dedicated static database software. This database is loaded once for all after burning and verifying CD s. All CD s are read from the jukebox and all the filenames are saved in this database. One jukebox can contain more than 65.000 records. This dedicated software retrieves files from jukebox almost instantaneously. 

KnowItAll Bio-Rad s SadtlerT software database solutions for spectroscopy numeric IR, NMR, MS, NIR, and Raman data Bio-Rad Laboratories, Inc. commercial CD-ROM periodi- cally www.bio-rad.- com... 

Stmcture searching and display software are host-specific. The Softon Substmcture Search System (S4) was developed by the Beilstein Institute and Softon of Graefelfing Germany (50). It is a full stmcture and substmcture searching module. The S4 is used in-house by the Beilstein Institute and is operated by DIALOG. STN uses CAS ONLINE s messenger software for on-line stmcture searching of the Beilstein on-line database (51). 

Structure and Nomenclature Search System. This system links the collection of chemical databases found in the Chemical Information System (CIS), one of the first interactive systems for stmcture and substmcture searching. References from the separate files can be retrieved by SANSS using CAS Registry Numbers, and the database of stmctures may be searched for stmctures or substmctures. An adaptation of the SANSS software for substmcture searching has been incorporated in the Dmg Information System of the National Cancer Institute for its own use (54). 

TDS UMERICA. This is another source for numeric databases (58). This company provides different on-line databases and software for chemistry, engineering, and environmental data. A summary of its databases is contained ia Table 7. 

The Chinese patent file with its abstracts can be used to supplement WPI, which at this writing has only tides for Chinese patents. JAPIO provides abstracts based ia particular oa pateat claims, and can help to clarify uncertainties with Japanese abstracts from Derwent and/or CA. PATOLIS, ia Japanese, is a unique source of Japanese legal status information (37). EPIDOS staff carry out PATOLIS searches on request for those with sufficient need to search the PATOLIS database, software is available to enable those who cannot read Japanese to extract key data. 

Form of Data. Databases can be classified in many ways. One method is by form of data representation, ie, data may be in the form of words, numbers, images, or sounds. The corresponding databases may then be considered to be word-oriented, number-oriented, image-oriented (video), or sound-oriented (audio). Data representation affects file stmctures and software for search and data retrieval. Thus the stmctures and search techniques vary considerably among these four basic classes. Table 1 gives databases as classified by form of data representation. 

The historical data is sampled at user-specified intervals. A typical process plant contains a large number of data points, but it is not feasible to store data for all points at all times. The user determines if a data point should be included in the list of archive points. Most systems provide archive-point menu displays. The operators are able to add or delete data points to the archive point hsts. The samphng periods are normally some multiples of their base scan frequencies. However, some systems allow historical data samphng of arbitraiy intei vals. This is necessaiy when intermediate virtual data points that do not have the scan frequency attribute are involved. The archive point lists are continuously scanned bv the historical database software. On-line databases are polled for data. The times of data retrieval are recorded with the data ootained. To consei ve storage space, different data compression techniques are employed by various manufacturers. 

Neither database generally offers the possibility of integrating into it the greater number of values and test data that may already be established by users or processors. These organizations have data for their own internal use, and their goal has been to integrate all these types of data sources. Such in-house databases are at present available under operating system BS 2000 and in conjunction with the database software known as Adabas. 

The Madison Group and its European partner, M-Base, have developed, based on years of research and experience with material data systems, the concepts and software for the management of such application databases. This application database is searchable by part and application. Capability for general component information, multiple classifications, images and text and links to material properties is included. 

Most clinical data management systems used for clinical trials today store their data in relational database software such as Oracle or Microsoft SQL Server. A relational database is composed of a set of rectangular data matrices called tables that relate or associate with one another by certain key fields. The language most often used to work with relational databases is structured query language (SQL). The SAS/ACCESS SQL Pass-Through Facility and the SAS/ACCESS LIBNAME engine are the two methods that SAS provides for extracting data from relational databases. 

A major objective in developing these risk estimation procedures was to provide a method capable of evaluating hundreds of properties in several communities within the DOE Uranium Mill Tailings Remedial Action Program in a timely manner. Therefore, we chose a calculation scheme that could be performed using commercially available database software (dBASE II, a trademark of Ashton-Tate, Culver City, CA), but that at the same time would be flexible enough that assessments for other contaminants could be readily incorporated. 

The technical architecture Apackage structure (for static dependencies) and collaborations (across technology components, such as UI, business object servers, and databases). These cover all domain-independent parts of the system hardware and software platforms infrastructure components such as middleware and databases utilities for logging, exceptions, start-up, and shutdown design standards and tools and the choice of... 

Databases, generally available for a fee, often together with software packages, have been prepared for several types of materials and systems. Typical examples are a database developed for Fe-rich alloys containing data for up to 15 components, and 55 types of phases or similar databases for Mg-rich, Al-rich, Ni-rich, Ti-rich alloys. Other databases are available for different types of materials semiconductors, solder alloys, ceramic systems, slag, molten salts, etc. 

Figure 5 The crystal structures for SEB and TSST-1. These structures were constructed by using data provided by Entrez s 3-D database and software for molecular modeling. Primary references for SEB and TSST-1 crystai structures are Papageorgiou etal. and Prasad ef respectiveiy.

Capabilities of the ChemStation include a full-featured standard reporting package and a custom report designer for analysts with special reporting requirements. An optional database software package provides standard cross-sample and study reports as well as trend analysis. The HP ChemStation also improves data transfer to other software, and networking facilities are available to link into a corporate computing system. 

ChemStore database This optional software package is a powerful extension of ChemStation software for sample organization and results storage. Control charts and cross-sample and cross-study reports are standard and enhance the ChemStation s already versatile reporting software. 

---