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.     

Intersegmental interaction and critical concentrations in PET–HFIP solutions

Spectroscopic determinations of the concentrations associated with the onset of intermolecular interaction in solutions of poly(ethylene terephthalate) (PET) are described. The intersegment forces perturb the electronic spectra and induce ground-state aggregation. These phenomena become observable at different chain densities, reflecting the influence of concentration on the coil dimensions, as well as the dynamical nature of the interactions. An estimate of the equilibrium constant for PET dimer formation in hexafluoroisopropanol is reported.     

A new interpretation of quantum mechanics and its consequences in epistemology

A rather recent interpretation of quantum mechanics, known under the various names of consistent histories, decohering histories, or logical interpretation, has brought interpretation into a standard deductive theory and is now investigated in many places. A key difference with the Copenhagen interpretation is the status of classical physics, now derived completely from quantum principles in both its dynamical and logical aspects. After describing briefly this new interpretation in its essentials, leaving aside technical details, it is shown how its consequences in epistemology differ drastically from the familiar outcomes of the Copenhagen interpretation, leading in particular to a well-defined theory of knowledge. Some more speculative philosophical consequences associated with the unsolved problem of actuality are also mentioned.     

The synthesis and chemical reactions of certain pyrazolo[1,5-a]-1,3,5-triazines

3-Aminopyrazole was utilized as a starting material for the preparation of certain pyrazolo-[1,5-a]-1,3,5-triazines. 4-Chloro-2-methylthiopyrazolo[1,5-a]-1,3,5-triazine was prepared and used for studies of nucleophilic displacement reactions, and it has been found that both the chloro and methylthio groups may be displaced by nucleophiles. By modifications of these procedures we have prepared the adenine, hypoxanthine, and xanthine analogs of the pyrazolo-[1,5-a]-1,3,5-triazine ring system. Electrophilic substitution occurs in the 8-position of this ring system. The methyl group was introduced into the 4-position by a novel ring opening and ring closing of the 1,3,5-triazine ring.     

MECHANISM OF PHOTOREDUCTION OF THIAZINE DYES BY EDTA STUDIED BY FLASH PHOTOLYSIS-II. pH DEPENDENCE OF ELECTRON ABSTRACTION RATE CONSTANT OF THE DYES IN THEIR TRIPLET STATE

Abstract— The pH dependence of the apparent reactivity of thiazine dyes in their triplet states has been studied in aqueous solutions, using as electron donor HY^-3, the trianionic species of ethylene diamine tetraacetic acid (EDTA), in the pH range 4–8. The pH dependence is found to be related to a change in the degree of protonation of the triplet excited dye. The apparent reactivity and lifetime of two differently protonated forms of thionine, azur B and methylene blue were determined by classical and dye-laser flash techniques, making it possible to evaluate the rate constant for electron abstraction of these molecules in their triplet states. It is found that: (a) protonation on the ring nitrogen increases the electron-abstraction rate constant of the triplet-state species about twenty-fold, and (b) methylation on the side amino groups decreases it.     

19F-Kernresonanzuntersuchungen an Imidoschwefeloxiddifluoriden

¹⁹F nuclear magnetic resonance studies on imidosulphuroxide difluorides Non equivalent fluorine atoms bounded to hexavalent sulphur of the NSOF₂ group in thionyl compounds give extreme AB-spectra.     

Jod-spezifischer Detektor für einen Gas-Chromatographen

The In-flame detector earlier applied to the specific chlorine (359.9 nm) and bromine (372.7 nm) analysis has now been employed for the iodine determination at 409.9 nm. It is shown that the resolution power of a GC column can be improved by such a specific detector. After calibration quantitative measurements of the iodine contents of the GC fractions are possible. The detection limits are 0.01–1.4 μg of iodine.     

QUENCHING OF OXONINE EXCITED STATES BY EDTA VIA ELECTRON TRANSFER AND DEACTIVATION PROCESSES. A COMPARATIVE STUDY OF EXCITED SINGLET AND TRIPLET STATE REACTIVITY

The quenching of excited singlet oxonine by EDTA in aqueous solution leads mainly to deactivation of the dye to the ground state and, to a lesser extent, to electron abstraction. The rate constants for these processes have been measured and compared to those for the same reactions involving the oxonine triplet state. The rate constant of electron abstraction is about ten times greater via the singlet state than via the triplet state. However, the rate constant of deactivation to the ground state is 10³-10⁴ times greater for the excited singlet state than for the triplet state, so that the efficiency of electron transfer is much smaller for the singlet state.