Database Considerations

Archiving the biomarker results in a database in association with clinical data is a requirement for many studies. Standards for data collection should be established prior to study initiation. Standard conventions for reporting time of day of sample collection, common analyte reporting units, and subject identification and sample identification conventions should be established. Capturing assay-related information may be valuable for some studies, including date of sample analysis, platform, and assay kit information. 

---

To extend the electrolytic conductivity reference database considerably above 1200 K, Cap2 has also been adopted as a standard by them, with extension of the temperature range for the electrolytic conductivities of KNO3 and NaCl. Their provisional recommendations as of 1991 are given in Table 3. New data recommended for molten alkah chlorides will be discussed in Section VI. 

This chapter presents the main concepts of warehouse management. First, there is a functional description of a typical warehouse operation, with emphasis on order picking because that is where most of the labor costs in a warehouse are incurred. This is followed by a discussion of strategic and tactical factors for warehouse operation, and then a discussion of database considerations for WMS. The last part of the chapter describes how users interact with a WMS and what functions they should expect it to perform. The purpose here is not to describe how the WMS is structured, since that varies with the software vendors, but rather to present a user s viewpoint of the major aspects of the system. 

Chemical Database Considerations. Most researchers found the menu-driven chemical database operations of MACCS friendly and with a good selection of features for their work. They also appreciated the data integration that DATACCS provided between MACCS databases and data from other programs, but the separation of the programs made some applications cumbersome, at was needed was a system that combined the capabilities of MACCS and DATACCS and that interfaced to other programs more directly. 

Biological Database Considerations. Since MACCS was oriented to the needs of the research chemist, biological test data and inventory information were easier to treat externally. Many chemical/pharmaceutical companies utilised a general DBMS for data related to chemical structures. These systems served their purpose well, except when chemical structures needed to be inserted into reports or otherwise keyed directly. What was needed was a system that could key both structures and general DBMS data. This required a system that interfaced MACCS with general DBMS s directly. 

Environmental information is available extensively on the free Internet. Two main reasons aeeount for this. First, the freedom of environmental information law and, secondly, the fact that many environmental databases which used to be available only commercially are now accessible on the free Internet. This section focuses on environmental information which is available free of charge on the Internet. Three main paths are distinguished for searching environmental information effectively. In general, all three routes should be taken into consideration for achieving a sound search result for environmental information on chemical stibstances... 

In all of the 3D search methods the conformational flexibility creates considerable difficulties. Large databases of multiple conformations for each structure have been developed which make the solution of this problem possible. 

In the simplest terms, a fault-tree for risk analysis requires the following information probabiUty of detection of a particular anomaly for an NDE system, repair or replacement decision for an item judged defective, probabiUty of failure of the anomaly, cost of failure, cost of inspection, and cost of repair. Implementation of a risk-based inspection system should lead to an overall improvement in the inspection costs as well as in the safety in operation for a plant, component, or a system. Unless the database is well estabUshed, however, costs may fluctuate considerably. 

Other Individual Country Databases and Auxiliary Files. The USPatents files on ORBIT, supphed by Derwent, are similar ia their contents to the CLAIMS-Bibliographic files, including all the front page information and the full claims language. These files do not iaclude the two-dimensional stmctures provided by IFI, nor do they have IFI s standardization of assignee names. Citation searching is available at a cost considerably less than that for the portion of the CLAIMS-Citation file that covers the same period. 

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. 

Although government databases have decreased percentagewise, many commercial databases are built on government data. Census data, for example, are collected at considerable governmental expense. Commercial database producers can take these data, add value to them, and then resell this information as a commercial database product. 

Many sophisticated models and correlations have been developed for consequence analysis. Millions of dollars have been spent researching the effects of exposure to toxic materials on the health of animals the effects are extrapolated to predict effects on human health. A considerable empirical database exists on the effects of fires and explosions on structures and equipment. And large, sophisticated experiments are sometimes performed to validate computer algorithms for predicting the atmospheric dispersion of toxic materials. All of these resources can be used to help predict the consequences of accidents. But, you should only perform those consequence analysis steps needed to provide the information required for decision making. 

Homologous proteins have similar three-dimensional structures. They contain a core region, a scaffold of secondary structure elements, where the folds of the polypeptide chains are very similar. Loop regions that connect the building blocks of the scaffolds can vary considerably both in length and in structure. From a database of known immunoglobulin structures it has, nevertheless, been possible to predict successfully the conformation of hyper-variable loop regions of antibodies of known amino acid sequence. 

This chapter has only scratched the surface of the multitude of databases and data reviews that are now available. For instance, more than 100 materials databases of many kinds are listed by Wawrousek et al. (1989), in an article published by one of the major repositories of such databases. More and more of them are accessible via the internet. The most comprehensive recent overview of Electronic access to factual materials information the state of the art is by Westbrook et al. (1995), This highly informative essay includes a taxonomy of materials information , focusing on the many different property considerations and property types which an investigator can be concerned with. Special attention is paid to mechanical properties. The authors focus also on the quality and relutbility of data, quality of source, reproducibility, evaluation status, etc., all come into this, and alarmingly. 

CAD databases can be helpful, but this depends much on the software set available. Architectural CAD data often contain too many data that have to be simplified and reduced considerably. 

There is considerable interest in developing a database on human error probabilities for use in chemical process quantitative risk assessment (CPQRA). Nevertheless, there have been very few attempts to develop such a database for the CPI compared, for example, with the nuclear industry. Some of the reasons for this are obvious. The nuclear industry is much more highly integrated than the CPI, with a much greater similarity of plant equipment... 

If some fields may be empty in the sublevels, all the fields in the main level are required for each entry. A new chiral separation record can be added in CHIRBASE solely if the authors correctly identify both sample and CSP. Since the beginning of the project, our policy has been to contact the authors of all publications containing incomplete, ambiguous or inconsistent data and to ask for additional information. Providing the separations with unique case numbers helps us considerably in this essential task, and also facilitates avoiding redundancies in the database. When chiral separations are reported for the second time in a new publication with exactly the same chromatographic conditions, this is stated in a footnote added in the field comments . In this field, miscellaneous information that cannot appear elsewhere are listed (detection limit, description of a reported chromatogram, racemization study, mobile phase limitations, etc.). 

These first-created enantiophores are rudimentary, but may serve as useful guidelines for a further design of more sophisticated and efficient search queries in consideration of possible alternative modes of binding and conformational changes in the CSP receptor structure. Undoubtedly, this query optimization will soon take advantage of the backgrounds of our new 3D-database project called CHIR-SOURCE. 

In fact, when chemical class searches are chosen, the user should change as many of the "U" designations in Chemical Attributes as possible. When a U" is left, the system assigns a "worst case" value to that attribute in order to make the most conservative choice of materials. Thus, if the answer to the question, "Is the chemical a known or potential carcinogen " is "U," the system assigns it a "yes" because that is the worst case and will produce the most conservative selections when the database is evaluated for materials that have been tested against the class of compounds under consideration. 

Compound selection methods usually involve selecting a relatively small set of a few tens or hundreds of compounds from a large database that could consist of hundreds of thousands or even millions of compounds. Identifying the n most dissimilar compounds in a database containing N compounds, when typically n N, is computationally infeasible because it requires consideration of all possible n-member subsets of the database, and therefore approximate methods have been developed as described below. 

---