Database reverse engineering: From requirements to CARE tools

This paper analyzes the requirements that CASE tools should meet for effective database reverse engineering (DBRE), and proposes a general architecture for data-centered applications reverse engineering CASE environments. First, the paper describes a generic DBMS-independent DBRE methodology, then it analyzes the main characteristics of DBRE activities in order to collect a set of desirable requirements. Finally, it describes DB-MAIN, an operational CASE tool developed according to these requirements. The main features of this tool that are described in this paper are its unique generic specification model, its repository, its transformation toolkit, its user interface, the text processors, the assistants, the methodological control and its functional extensibility. Finally, the paper describes five real-world projects in which the methodology and the CASE tool were applied. This is a heavily revised and extended version of “Requirements for Information System Reverse Engineering Support” by J.-L. Hainaut, V. Englebert, J. Henrard, J.-M. Hick, D. Roland, which first appeared in the Proceedings of the Second Working Conference on Reverse Engineering, IEEE Computer Society Press, pp. 136–145, July 1995. This paper presents some results of the DB-MAIN project. This project is partially supported by the Région Wallonne, the European Union, and by a consortium comprising ACEC-OSI (Be), ARIANE-II (Be), Banque UCL (Lux), BBL (Be), Centre de recherche public H. Tudor (Lux), CGER (Be), Cockerill-Sambre (Be), CONCIS (Fr), D'Ieteren (Be), DIGITAL, EDF (Fr), EPFL (CH), Groupe S (Be), IBM, OBLOG Software (Port), ORIGIN (Be), Ville de Namur (Be), Winterthur (Be), 3 Suisses (Be). The DB-Process subproject is supported by the Communauté Fran?aise de Belgique.     

Dirac-Hestenes spinor fields on Riemann-Cartan manifolds

In this paper we study Dirac-Hestenes spinor fields (DHSF) on a four-dimensional Riemann-Cartan spacetime (RCST). We prove that these fields must be defined as certain equivalence classes of even sections of the Clifford bundle (over the RCST), thereby being certain particular sections of a new bundle named the spin-Clifford bundle (SCB). The conditions for the existence of the SCB are studied and are shown to be equivalent to Geroch's theorem concerning the existence of spinor structures in a Lorentzian spacetime. We introduce also the covariant and algebraic Dirac spinor fields and compare these with DHSF, showing that all three kinds of spinor fields contain the same mathematical and physical information. We clarify also the notion of (Crumeyrolle's) amorphous spinors (Dirac-Kähler spinor fields are of this type), showing that they cannot be used to describe fermionic fields. We develop a rigorous theory for the covariant derivatives of Clifford fields (sections of the Clifford bundle, CB) and of Dirac-Hestenes spinor fields. We show how to generalize the original Dirac-Hestenes equation in Minkowski spacetime for the case of RCST. Our results are obtained from a variational principle formulated through the multiform derivative approach to Lagrangian field theory in the Clifford bundle.     

Preparation and Eh--pH diagrams of Fe(II)--Fe(III) green rust compounds; hyperfine interaction characteristics and stoichiometry of hydroxy-chloride, -sulphate and -carbonate

Fe(II)--Fe(III) hydroxy-chloride, -sulphate and -carbonate were prepared by oxidation of a ferrous hydroxide precipitate in anion-containing aqueous solutions. The compounds are characterized by monitoring the redox potential E_h and the pH of stochiometric suspension vs time with the appropriate concentration ratios. X-ray diffraction allows us to characterize the crystal structure by distinguishing “green rust one” (GR1) from “green rust two” (GR2). Since green rusts (GRs) are of a pyroaurite-sjögrenite-like structure, i.e., consisting of intercalated foreign anions and water molecules in the interlayers between the brucite-like layers of Fe(OH)₂, their chemical formulae can be determined from the Mössbauer spectra. Three quadrupole doublets are observed: D₁ and D₂ correspond to a ferrous state with isomershift IS of about 1.27 mm s^-1 and quadrupole splittings QS of about 2.85 and 2.60 mm s^-1, respectively, whereas D₃ corresponds to a ferric state with IS and QS of about 0.4 mm s^-1. The hyperfine parameters of these doublets are similar from one green rust to another but their intensity ratios vary considerably. Finally, E_h and pH equilibrium diagrams of the Fe species in the presence of chloride, sulphate and carbonate anions contained within the water solution are drawn and the thermodynamic conditions of existence and degrees of oxidation of green rusts are discussed.     

Chemical composition and reaction analysis of single aerosol particles

In situ measurements of gas-liquid surface reactions of single aerosol microdroplets are presented. By means of optical levitation in combination with elastic (Mie) and inelastic (Raman) light scattering it is possible to get information on the chemistry of e.g. acid/base reactions as well as the physical behavior of single microparticles.     

Spin-trapped hydroxyl free radicals studied at low field by Field-Cycled Dynamic Nuclear Polarization

The technique of Field-Cycled Dynamic Nuclear Polarization (FC-DNP) involves the EPR irradiation of a free radical solution and the subsequent observation of the NMR signal, the experiment being carried out at a range of magnetic field strengths in order to measure the free radical’s EPR spectrum. In this work FC-DNP has been used to study the EPR spectrum of DMPO spin-trapped hydroxyl free radicals at magnetic field strengths between 0.5 mT and 13.0 mT (5–130 Gauss). The low-field EPR spectrum contains six separate EPR lines, in contrast to the well-known X-band spectrum where only four are seen. Knowledge of the spin-adduct’s EPR spectrum will be of use to workers involved in low-field EPR, especially those conducting biological or in-vivo spin-trapping experiments.     

Crystal field and magnetic properties of the tetragonal TbNi2Si2 compound

The magnetic properties of a TbNi₂Si₂ single crystal have been investigated experimentally by specific heat, anisotropy of the susceptibility and magnetization, and inelastic neutron scattering, leading to the determination of its fundamental coupling parameters. The lowest crystalline electric field states are two singlets close to each other, that explains the different magnetic structures evidenced in TbNi₂Si₂: an amplitude modulated structure, close to T _N , a simple antiferromagnetic one at low temperature and an antiphase one when an external magnetic field is applied along the c direction.     

Selective saturation and inversion of multiple resonances in high-resolution solid-state 13C experiments using slow spinning CP/MAS and tailored DANTE pulse sequences.

Taking advantage of the long 13C T1 values generally encountered in solids, selective saturation and inversion of more than one resonance in 13C CP/MAS experiments can be achieved by sequentially applying several DANTE pulse sequences centered at different transmitter frequency offsets. A new selective saturation pulse sequence is introduced composed of a series of 90 degrees DANTE sequences separated by interrupted decoupling periods during which the selected resonance is destroyed. Applications of this method, including the simplification of the measurement of the principal values of the 13C chemical shift tensor under slow MAS conditions, are described. The determination of the aromaticity of coal using a relatively slow MAS rate is also described.     

Enhancement of the backscattered intensity from fractal aggregates

Comparative measurements were conducted for the backscattered intensities of light from uniform random and fractal aggregated media. Different features are found for the backscattered intensity peak shapes. A crossover between the θ^1-D and θ^-2 dependences of the backscattered intensity occurs in the case of fractal aggregated medium, where D indicates the fractal dimension.     

Gain depletion due to amplified spontaneous emission in multi-pass laser amplifiers

Calculations of the effects of amplified spontaneous emission (ASE) in laser amplifiers designed to amplify sub-picosecond pulses are presented. A one-dimensional code is used with some simple approximations to account for aspect ratio variation in cases of cylindrical symmetry. Gain depletion due to ASE is compared for various multi-pass geometries. Optimisation for short pulse amplification of a telescopic, beam-expanding, 4-pass amplifier is considered.On leave from Electrotechnical Laboratory, Tsukuba, Ibaraki, Japan