A Typical Database

The databases associated with geochemical modeling programs consist of a list of the basis species, and a list of secondary or auxiliary species, minerals, and gases, each described in terms of the basis species, and with the equilibrium constant of the reaction linking the secondary species or mineral to the basis species. 

For example, the database for the The Geochemist s Workbench programs looks like the following. We choose this one because it is relatively readable. Databases for other programs contain essentially the same kind of information, but usually in a more condensed format which is harder for humans to understand. 

From this, we can see that secondary species AgCl2 is related ( linked ) to the basis species Ag+ by1 

The practical importance of looking into the database in this way is that the equations relating the secondary species to the corresponding basis species show which basis species can be swapped (see 5.8.1). Thus, AgClj can be swapped for either Ag+ or Cl-, and NaAISisOg can be swapped for Na+, Al3+, SiC 2(aq), or H+. Also, it is often important to see exactly how the data are labeled. For example, the data for sodic feldspar follow the label Albite , not albite , or Na-feldspar . 

---

Furthermore, most psychiatric disorders are chronic, although some may go through intervals of apparent remission (e.g., major depressive disorder), whereas others are persistent but relatively asymptomatic (e.g., schizophrenia) with effective treatment. Flence, treatment with psychotropics is best considered in terms of months or years of continuous or intermittent therapy, rather than a few days or weeks. By contrast, the vast majority of the clinical trials involve short-term use. Thus, a typical database for the approval of a new antidepressant is usually based on experience with 2,000 to 8,000 patients (carefully selected as described earlier), with the majority exposed to the medication for less than 2 months. Often less than 25% will have received medication for more than 4 months, and less than 10% for more than 6 months. When a drug is marketed, most patients will be exposed to it for a minimum of 4 to 6 months. Yet, when treatment goes beyond 2 months, the database on the safety and continued efficacy of a medication is modest at best. Thus, although clinicians commonly use psychotropics for both maintenance and prophylactic purposes, an approved drug only has to be shown effective in the acute phase. 

An automatic search-and-match can be done much faster, and most importantly, using multiple Bragg reflections by seeking through enormous arrays of data, which a typical database contains. The algorithms employed to conduct automatic searches vary extensively, however, parameters that are critical in any search include the following ... 

Figure 4.3 A typical database record. Analogous compound pairs are depicted as a hypothetical transformation with the biosteric fragments highlighted (thick bonds).

Nowadays this database is composed of about a hundred tests and is continually updated with new tests. The tests are summarized for each case by a description of the vessel, the installation of the sensors used, as well as by a typical result and the conclusions of the control. 

The abbreviation QSAR stands for quantitative structure-activity relationships. QSPR means quantitative structure-property relationships. As the properties of an organic compound usually cannot be predicted directly from its molecular structure, an indirect approach Is used to overcome this problem. In the first step numerical descriptors encoding information about the molecular structure are calculated for a set of compounds. Secondly, statistical methods and artificial neural network models are used to predict the property or activity of interest, based on these descriptors or a suitable subset. A typical QSAR/QSPR study comprises the following steps structure entry or start from an existing structure database), descriptor calculation, descriptor selection, model building, model validation. 

A number of other software packages are available to predict NMR spectra. The use of large NMR spectral databases is the most popular approach it utilizes assigned chemical structures. In an advanced approach, parameters such as solvent information can be used to refine the accuracy of the prediction. A typical application works with tables of experimental chemical shifts from experimental NMR spectra. Each shift value is assigned to a specific structural fragment. The query structure is dissected into fragments that are compared with the fragments in the database. For each coincidence, the experimental chemical shift from the database is used to compose the final set of chemical shifts for the... 

Multivariate data analysis usually starts with generating a set of spectra and the corresponding chemical structures as a result of a spectrum similarity search in a spectrum database. The peak data are transformed into a set of spectral features and the chemical structures are encoded into molecular descriptors [80]. A spectral feature is a property that can be automatically computed from a mass spectrum. Typical spectral features are the peak intensity at a particular mass/charge value, or logarithmic intensity ratios. The goal of transformation of peak data into spectral features is to obtain descriptors of spectral properties that are more suitable than the original peak list data. 

Ithough knowledge-based potentials are most popular, it is also possible to use other types potential function. Some of these are more firmly rooted in the fundamental physics of iteratomic interactions whereas others do not necessarily have any physical interpretation all but are able to discriminate the correct fold from decoy structures. These decoy ructures are generated so as to satisfy the basic principles of protein structure such as a ose-packed, hydrophobic core [Park and Levitt 1996]. The fold library is also clearly nportant in threading. For practical purposes the library should obviously not be too irge, but it should be as representative of the different protein folds as possible. To erive a fold database one would typically first use a relatively fast sequence comparison lethod in conjunction with cluster analysis to identify families of homologues, which are ssumed to have the same fold. A sequence identity threshold of about 30% is commonly... 

Another technique employs a database search. The calculation starts with a molecular structure and searches a database of known spectra to find those with the most similar molecular structure. The known spectra are then used to derive parameters for inclusion in a group additivity calculation. This can be a fairly sophisticated technique incorporating weight factors to account for how closely the known molecule conforms to typical values for the component functional groups. The use of a large database of compounds can make this a very accurate technique. It also ensures that liquid, rather than gas-phase, spectra are being predicted. 

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. 

Finally, I should tell you that structural databases invariably contain Cartesian coordinates. A typical paper from the early 1990s addresses the problem. 

Most computer-based systems require data-acquisition routes to be established as part of the database setup. These routes specifically define the sequence of measurement points and, typically, a route is developed for each area or section of the plant. With the exception of limitations imposed by some of the vibration monitoring systems, these routes should define a logical walking route within a specific plant area. A typical measurement is shown in Figure 44.15. 

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. 

To illustrate the number of conformers generated for a typical pharmaceutical like database, OMEGA calculations were carried out for the 450000 compounds... 

Over the years, MS/MS duty cycle of modern MS instruments has constantly been improving, but for simplicity we assume it is equal to 1 s. Considering this it is possible to identify up to 60 peptides per minute and up to 3600 peptides in a LC-MS/MS analysis of 1 h. It is important to mention that only a small percentage of MS/MS scans typically yield a spectrum of sufficient quality that can be matched against a protein database and can result in peptide identification. 

For example, C++ works with an OO model in main memory but leaves persistent data up to you you can t send a message to an object in filestore. If you can secure a good OO database you re in luck but otherwise, typically you re stuck with plain old files or a relational database and must to think how to encode the objects. Your class-layer design should initially defer the question of how objects are distributed between hosts and media. 

Links between types represent ary association of the members of one type with the members of the other type no matter how the association is implemented. Within a single component, associations typically may be implemented with memory address pointers within a single database, associations may be implemented as pairs of keys in a table. Between components, an association represents a form of identification that each one recognizes as referring to a single object within itself. For example, we could draw an association between Person (real ones) and the Personal Records in a national Social Security database the Social Security number identifies members of one type with those of the other. 

In using a relational database, the interlinked object structure is translated into a representation based on tables and rows. Each object typically is a row in a table one table is defined for each class (sans inheritance). 

A typical large business system has human users and a back-end database. The development process for these systems still goes through the levels outlined earlier, with some specialized activities required within the levels. Figure 13.3 outlines these activities and shows how they map to the three essential levels we discussed the corresponding implementation and test activities are not shown. 

For some chemicals a large database was available that allows statistical evaluation. In such cases, mean values were considered as typical PECs and the 90th percentile as a worst-case scenario. 

---