Data type conversion function

Since the range data type is not a standard SQL data type, the standard SQL operators cannot be used with this data type. However, new operators can be defined using SQL functions. Since the range data type is so similar to the float data type, implicit conversion to float is appropriate. This automatically allows many of the standard SQL operators to work with exact(=) range values. 

As with the range text conversion, the range float conversion allows range values to be converted to float, whenever possible. This makes the following SQL work without explicit definition of the sqrt function for range data types. 

In order to properly compare range values it is necessary to define functions that operate directly on the range data type, rather than indirectly after the implicit conversion to float. The following functions define how two range values should be compared for equality, less than, greater than, etc. 

The information required here is not concentration versus time, but rate of reaction versus concentration. As will be seen later, some types of chemical reactors give this information directly, but the constant-volume, batch systems discussed here do not [ What does it profit you, anyway —F. Villon], In this case it is necessary to determine rates from conversion-time data by graphical or numerical methods, as indicated for the case of initial rates in Figure 1.25. In Figure 1.27 a curve is shown representing the concentration of a reactant A as a function of time, and we identify the two points Cai and Ca2 for the concentration at times q and t2- The mean value for the rate of reaction we can approximate algebraically by... 

Type conversion functions convert a given value from its present type to a new type. These functions are necessary so that data can be passed between objects of different types while the semantics of die language are preserved. In hardware, the concept of types does not exist but the compiler will still flag type mismatch errors that occur because of their highly ambiguous nature. 

As can be seen in Fig. 3b, it is important to specify whether data are represented as a number distribution (obtained by a counting technique such as microscopy) or as a weight distribution (obtained by methods such as sieving), since the results will not be the same. Hatch and Choate [4] have developed equations for converting one type of diameter to another the relationships between them are summarized in Table 2. Note that caution should be exercised in using the Hatch-Choate conversions if the distributions do not closely fit the log-normal model. While this distribution is the most frequently used to describe pharmaceutical systems, other distribution functions have also been developed [2,5,6],... 

In practice, when one measures the size distributions of aerosols using techniques discussed in Chapter 11, one normally measures one parameter, for example, number or mass, as a function of size. For example, impactor data usually give the mass of particles by size interval. From such data, one can obtain the geometric mass mean diameter (which applies only to the mass distribution), and crg, which, as discussed, is the same for all types of log-normal distributions for this one sample. Given the geometric mass mean diameter (/) ,) in this case and crg, an important question is whether the other types of mean diameters (i.e., number, surface, and volume) can be determined from these data or if separate experimental measurements are required. The answer is that these other types of mean diameters can indeed be calculated for smooth spheres whose density is independent of diameter. The conversions are carried out using equations developed for fine-particle technology in 1929 by Hatch and Choate. 

The rate equations of both these processes are quite complex, and there is little likelihood that the effectiveness could be deduced mathematically from fundamental data as functions of temperature, pressure, conversion, and composition, which is the kind of information needed for practical purposes. Perhaps the only estimate that can be made safely is that, in the particle size range below 1 mm or so, the effectiveness probably is unity. The penetration of small pores by liquids is slight so that the catalysts used in liquid slurry systems are of the low specific surface type or even nonporous. 

The fact that some kinetic profiles are fitted by sums of exponentials, and others are fitted by power functions, suggests that different types of basic mechanisms are at work. In fact, as concluded in Chapter 7, while kinetics from homogeneous media can be fitted by sums of exponentials, heterogeneity shapes kinetic profiles best represented by empirical power-law models. Conversely, when power laws fit the observed data, they suggest that the rate at which a material leaves the site of a process is itself a function of time in the process, i.e., age of material in the process. 

Fundamental deactivation data are more difficult to obtain than fundamental catalytic reaction rate data because the latter must be known before the nature of the deactivation function can be determined. This is largely due to the kinds of reactors that are used to study deactivation. Many of the usual difficulties experienced in trying to get fundamental deactivation data can be obviated by using a reactor system in which the conversion and hence the compositions of the major components remain constant both in time and in space within the reactor. A description of an apparatus of this type and its utilization to study the deactivation of a real catalytic reaction are presented in this paper. The problem of determining the initial activity in a rapidly deactivating system is also discussed. 

Kinetics of a quite different type are observed for the reactions of Bromophenol Blue with aromatic amines. Aromatic amines are such weak bases that only the first acidic function of Bromophenol Blue is involved, and the product of the reaction is of type IV. The overall rate of formation of the ion-pair from the acid and the base is found to be many orders of magnitude less than the diffusion-controlled rate, and, for several amines, has a negative enthalpy of activation [97], These data, listed in Table 21, can be interpreted in terms of the rate-limiting step being the intramolecular conversion of the hydrogen-bonded species ROH—B to the ion-pair RO —HB+. Although the reaction consists of the... 

---