A Sampling of Differences

It is not feasible to detail every difference among the various RDBMS. There are several commonly encountered differences that merit some attention here. 

In standard SQL, a text column may contain data, or not. The null value is used to denote that no value is contained in that column of any particular row. The null value can be used in SQL statements, for example  

Select smiles from nci.structure where name is null  

In Oracle, an empty text string is considered equivalent to the null value. In PostgreSQL, an empty string is a valid, nonnull value. Neither approach is more correct than the other, but it may require some programming adjustments when moving from PostgreSQL to Oracle, or the other way around. 

---

In their seminal work from 1983, Davis and Giddings used a statistical theory to define the number of peaks observable in 1DLC separation upon the injection of a sample of different complexity on a column of a given peak capacity (Davis and Giddings, 1983). The theory was later extended into 2D separation space (Davis, 2005 Shi and Davis, 1993), also discussed in Chapter 2 of this book. The theory implies that when the 1D or 2D separation space is randomly covered with the number of peaks equal to the separation space peak capacity (area), the normalized surface coverage is... 

When working with natural products, for example, it frequently happens that the racemate or a sample of different enrichment is not available. When this is the case, the positions of both diastereotopic resonances may still be determined, by examining the solute in the presence of first one, then the other CSA enantiomer (15). Since, in this circumstance, one is comparing actual field positions of a single resonance in different spectra and these differences may be... 

In the present context, it is worth noting that quantitation becomes more difficult if, in the course of a measurement, there is a change in the d-spacing of the relevant reflection. Such a change implies a sampling of different parts of the form or structure factor which alone, can effect large changes in scattered intensity (See Ref. [130] as a example). 

Having reminded students about the different states in which substances are found, and how this depends upon their melting and boiling temperatures, another useftd activity focuses on solids. Students can be presented with a sample of different solids in sealed test tubes, and asked to suggest how these different solid samples of substances may have different properties. A suitable selection might include ... 

Students in a lab exercise were asked to choose among a sample of different metals to react with a solution of nickel(II) chloride. Which of the following metals should they choose Write balanced equations for all that will react and explain why each will or will not react. 

Fig. 2 X-ray refraction topographs of a series of /OyPOj/s samples of different impact energies. The total damage of the laminates is characterized by addition of all debonded layers of0° and 90° fiber direction.

MAS Si speetnim of a sample of sodium disilieate (Na Si O,) erystallized from a glass is shown as an example. Whilst the statie speetnim elearly indieates an axial ehemieal shift powder pattern, it gives no evidenee of more than one silieon site. The MAS speetnim elearly shows four resolved lines from the different polymorphs present in die material whose widths are 100 times less than the ehemieal shift anisotropy. 

Figure C2.17.12. Exciton energy shift witli particle size. The lowest exciton energy is measured by optical absorjDtion for a number of different CdSe nanocrystal samples, and plotted against tire mean nanocrystal radius. The mean particle radii have been detennined using eitlier small-angle x-ray scattering (open circles) or TEM (squares). The solid curve is tire predicted exciton energy from tire Bms fonnula.

The molar diamagnetic susceptibility of thiazole and some derivatives was initially determined by the classical Curie-Cheneveau method (5,315,316) and later confirmed by a method (317) based on the difference of NMR proton chemical shift of a sample of tetramethylsilane immersed in the liquid to be investigated, according to the shape (cylindrical or spherical) of the sample tube (Table 1-47) (318),... 

Phenolic compounds are commonplace natural products Figure 24 2 presents a sampling of some naturally occurring phenols Phenolic natural products can arise by a number of different biosynthetic pathways In animals aromatic rings are hydroxylated by way of arene oxide intermediates formed by the enzyme catalyzed reaction between an aromatic ring and molecular oxygen... 

The t test can be applied to differences between pairs of observations. Perhaps only a single pair can be performed at one time, or possibly one wishes to compare two methods using samples of differing analytical content. It is still necessary that the two methods possess the same inherent standard deviation. An average difference d calculated, and individual deviations from d are used to evaluate the variance of the differences. 

Fig. 4.13 The pre-adsorption method (a) adsorption isotherms of nitrogen at 77 K on a sample of Mogul I carbon black charged with different amounts x of pre-adsorbed nonane. Values ofx (mg g (A) 63 (B)48 (C) 29 (D) 16 (E) 0. (See Table 4.5.) (Some points at low pressures omitted for the sake of clarity.)...

Values of the uptake at saturation, of butane, carbon dioxide and nitrogen, by a sample of carbon, expressed as a volume of liquid v,. The carbon had been "burnt off" to different extents by heating in oxygen at 500°C on a sorption... 

This experiment describes a method for determining the acidity, reported as an equivalent molarity of H2SO4, of rain water. Because the volume of standard base needed to titrate a sample of rain water is small, the analysis is done by a standard addition. A 10.00-mL sample of nominally 0.005 M H2SO4 is diluted with 100.0 mL of distilled water and standardized by titrating with 0.0100 M NaOH. A second 10.00-mL sample of the sulfuric acid is mixed with 100.0 mL of rain water and titrated with the same solution of NaOH. The difference between the two equivalence point volumes... 

The following experiments may he used to illustrate the application of chromatography and electrophoresis to a number of different types of samples. Experiments are grouped by the type of technique, and each is briefly annotated. 

The first set of experiments describes the application of gas chromatography. These experiments encompass a variety of different types of samples, columns, and detectors. Most experiments maybe easily modified to use available equipment and detectors. 

When an analyst performs a single analysis on a sample, the difference between the experimentally determined value and the expected value is influenced by three sources of error random error, systematic errors inherent to the method, and systematic errors unique to the analyst. If enough replicate analyses are performed, a distribution of results can be plotted (Figure 14.16a). The width of this distribution is described by the standard deviation and can be used to determine the effect of random error on the analysis. The position of the distribution relative to the sample s true value, p, is determined both by systematic errors inherent to the method and those systematic errors unique to the analyst. For a single analyst there is no way to separate the total systematic error into its component parts. 

In the two-sample collaborative test, each analyst performs a single determination on two separate samples. The resulting data are reduced to a set of differences, D, and a set of totals, T, each characterized by a mean value and a standard deviation. Extracting values for random errors affecting precision and systematic differences between analysts is relatively straightforward for this experimental design. 

Figure 2.5 shows some actual experimental data for versus 7, measured on a sample of polyethylene at 126°C. Note that the data are plotted on log-log coordinates. In spite of the different coordinates. Fig. 2.5 is clearly an example of pseudoplastic behavior as defined in Fig. 2.2. In this and the next several sections, we discuss shear-dependent viscosity. In this section the approach is strictly empirical, and its main application is in correcting viscosities measured...

Taylorf carefully fractionated a sample of nylon-6,6 and determined the weight fraction of different n-mers in the resulting mixture. The following results were obtained ... 

Table 9.3 lists the intrinsic viscosity for a number of poly(caprolactam) samples of different molecular weight. The M values listed are number average figures based on both end group analysis and osmotic pressure experiments. Tlie values of [r ] were measured in w-cresol at 25°C. In the following example we consider the evaluation of the Mark-Houwink coefficients from these data. 

We begin with a consideration of notation, defining Iq as the intensity of light incident (subscript 0) upon a sample and as the intensity of the light transmitted (subscript t) through a sample of thickness x. There are two different mechanisms that can account for the fact that L < L... 

---