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.     

Silver nitrate-acetonitrile and iodine-benzene complexes as studied by NMR in thermotropic liquid crystals

Silver nitrate-acetonitrile and π iodine-benzene complexes in thermotropic liquid crystals have been studied by ¹H, ²H, and ¹³C NMR spectroscopy and by optical microscopy. Evidence for at least two silver complexes in each liquid crystal is presented.     

On practical metrology and chemical analysis: etalons and traceability systems

 National measurement systems are infrastructures to ensure, for each nation, a consistent and internationally recognised basis for measurement. Such complex systems have historical, technical, legal, organisational and institutional aspects to connect scientific metrology with practical measurements. Underlying any valid measurement is a chain of comparisons linking the measurement to an accepted standard. The ways the links are forged and the etalons (measurement standards) to which they connect are defining characteristics of all measurement systems. This is often referred to as traceability which aims at basing measurements in common measurement units – a key issue for the integration of quantitative chemical analysis with the evolving physical and engineering measurement systems. Adequate traceability and metrological control make possible new technical capabilities and new levels of quality assurance and confidence by users in the accuracy and integrity of quantitative analytical results. Traceability for chemical measurements is difficult to achieve and harder to demonstrate. The supply of appropriate etalons is critical to the development of metrology systems for chemical analysis. An approach is suggested that involves the development of networks of specialised reference laboratories able to make matrix-independent reference measurements on submitted samples, which may then be used as reference materials by an originating laboratory using its practical measurement procedures. Received: 31 July 1995 Accepted: 19 August 1995     

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     

Erratum: Synthesis and characterization of diorganotin(IV) complexes of Schiff bases with ONO‐type donors and crystal structure of [N‐(2‐hydroxy‐4‐nitrophenyl)‐3‐ethoxysalicylideneiminato]diphenyltin(IV)

The article referenced above was first published online on 30 August 2007 with incorrect pagination; the pagination has now been corrected online and in print. Copyright © 2007 John Wiley & Sons, Ltd.     

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