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.     

Kinetics of benzonitrile nitration with mixed acid under homogeneous conditions

Chemical kinetics of benzonitrile nitration with mixed acid is investigated in the temperature range 283–299 K. Pseudo-first-order rate constants are evaluated by means of rate experiments on homogeneous reacting mixtures having large stoichiometric excesses of nitric acid. The second-order kinetic constants for nitronium ion attack to the aromatic substrate are derived on the basis of the assessed nitration mechanism. An activation energy of 604 ± 37 kJ mol^?1 is calculated for this reaction step. © 1993 John Wiley & Sons, Inc.     

The amplitude and phase of a transmission holographic grating due to four-wave interaction in a photorefractive medium

Based on a previously developed two-level model of four-wave interaction in photorefractive crystals, expressions for the amplitude and phase of a transmission holographic grating have been obtained. The analysis of these expressions points to the dependence of both the amplitude and the phase of the grating on the intensity of the readout beam.     

Hybrid free radical/cationic frontal photopolymerizations

The irradiation of hybrid photopolymer systems consisting of a free radically polymerizable multifunctional acrylate monomer and a cationically polymerizable epoxide or oxetane monomer was conducted under conditions where only the free radical polymerization takes place. This results in the formation of a free‐standing polyacrylate network film containing quiescent oxonium ions along with the unreacted cyclic ether monomer. The subsequent application of a point source of heat to the film ignites a cationic ring‐opening frontal polymerization that emanates from that site and propagates to all portions of the irradiated sample. This article examines the impact of various molecular structural and experimental parameters on these novel hybrid frontal polymerizations that produce interpenetrating network polymers. © 2007 Wiley Periodicals, Inc. J Polym Sci Part A: Polym Chem 45: 4331–4340, 2007     

Aqueous solution and solid state interactions of lanthanide ions with a methacrylic ester polymer bearing pendant 15‐crown‐5 moieties

The interaction between trivalent lanthanide ions and poly(1,4,7,10,13‐pentaoxacyclopentadecan‐2‐yl‐methyl methacrylate), PCR5, in aqueous solution and in the solid state have been studied. In aqueous solution, evidence of a weak interaction between the lanthanides and PCR5 comes from the small red shift of the Ce(III) emission spectra and the slight broadening of the Gd(III) EPR spectra. From the Tb(III) lifetimes in the presence of H₂O and D₂O the loss of one or two water coordinated molecules is confirmed when Tb(III) is bound to PCR5. An association constant of the order of 200 M^?1 was obtained for a 1:1 (lanthanide:15‐crown‐5) complex from the shift of the polymer NMR signals induced by Tb(III). A similar association constant is obtained from the differences of the molar conductivity of Ce(III) solution at various concentrations in presence and absence of PCR5. When Tb(III) is adsorbed on PCR5 membranes, lifetime experiments in H₂O and D₂O confirm the loss of 5 or 6 water coordinated molecules indicating that in solid state the lanthanide(III)‐PCR5 interaction is stronger than in solution. The adsorption of Ce(III) in PCR5 membranes shows a Langmuir type isotherm, from which an equilibrium constant of 39 M^?1 has been calculated. SEM shows that the membrane morphology is not much affected by lanthanide adsorption. Support for lanthanide ion–crown interactions comes from ab initio calculations on 15‐crown‐5/La(III) complex. © 2007 Wiley Periodicals, Inc. J Polym Sci Part A: Polym Chem 45: 1788–1799, 2007     

Curcumin: A naturally occurring long‐wavelength photosensitizer for diaryliodonium salts

Curcumin, a naturally occurring, intensely yellow dye extracted from the spice turmeric, is an efficient photosensitizer for diaryliodonium salt photoinitiators at wavelengths ranging from 340 to 535 nm. With curcumin as a photosensitizer, it is possible to carry out the cationic photopolymerization of a wide variety of epoxide, oxetane, and vinyl monomers with long‐wavelength UV and visible light. An example of the photopolymerization of an epoxide monomer with ambient solar irradiation is provided. Several other curcumin analogues were synthesized, and their use as photosensitizers is examined. With such photosensitizers, the range of spectral sensitivity can be extended well into the visible region of the electromagnetic spectrum. © 2005 Wiley Periodicals, Inc. J Polym Sci Part A: Polym Chem 43: 5217–5231, 2005     

Nonlinear optical properties of regioregular main‐chain polyesters

We have prepared new polyesters containing quadratic, nonlinear optical (NLO) active chromophores covalently incorporated into the main chain. In these polymers, the sequence of the chromophore units along the main chain is rigorously head to tail. All the polyesters are processable, both in the melt and in solution. For one polyester, a full second‐order NLO characterization has been performed. An out‐of‐resonance d₃₃ coefficient of 21 pm/V at 1368 nm has been measured. © 2007 Wiley Periodicals, Inc. J Polym Sci Part A: Polym Chem 45: 2719–2725, 2007     

Glass transitions and mixed phases in block SBS

Differential scanning calorimetry (DSC) does not allow for easy determination of the glass‐transition temperature (T_g) of the polystyrene (PS) block in styrene–butadiene–styrene (SBS) block copolymers. Modulated DSC (MDSC), which deconvolutes the standard DSC signal into reversing and nonreversing signals, was used to determine the (T_g) of both the polybutadiene (PB) and PS blocks in SBS. The T_g of the PB block was sharp, at ?92 °C, but that for the PS blocks was extremely broad, from ?60 to 125 °C with a maximum at 68 °C because of blending with PB. PS blocks were found only to exist in a mixed PS–PB phase. This concurred with the results from dynamic mechanical analysis. Annealing did not allow for a segregation of the PS blocks into a pure phase, but allowed for the segregation of the mixed phase into two mixed phases, one that was PB‐rich and the other that was PS‐rich. It is concluded that three phases coexist in SBS: PB, PB‐rich, and PS‐rich phases. © 2004 Wiley Periodicals, Inc. J Polym Sci Part B: Polym Phys 43: 276–279, 2005