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.     

Directed metalation/ligand coupling approach to the enantioselective synthesis of 1,1′-binaphthyls

Introduction of a 2-isopropoxycarbonyl or 2-NN-dimethylcarbamoyl group into homochiral 1-p-tolyl- or 1-t-butyl-sulfinylnaphthalenes, via directed metalation reaction, followed by ligand coupling reaction with 1-naphthylmagnesium bromide, furnished atropisomeric 1,1′-binaphthyls in 82–95% enantiomeric excess (e.e.).     

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.     

Symmetry and non-lie reduction of the nonlinear Schrödinger equation

The nonlinear Schrödinger-type equations invariant with respect to the extended Galilean group are described. We study the conditional symmetry of such equations, realize the reduction procedure, and construct the classes of exact solutions.Translated from Ukrainskii Matematicheskii Zhurnal, Vol. 45, No. 4, pp. 539–551, April, 1993.     

Dependence of an equilibrium state of a two-phase medium on surface tension coefficient and on temperature

An existence theorem for the variational problem for the two-phase medium energy functional is proved. Dependence of the solution on the surface tension coefficient and on the temperature is investigated. Bibliography: 7 titles. Dedicated to V. A. Solonnikov on his sixtieth anniversary Translated fromZapiski Nauchnykh Seminarov POMI, Vol. 213, 1994, pp. 131–150. Translated by S. Yu. Pilyugin.     

Using completely implicit methods to solve the direct problem of nozzle theory

An iterative method from the class of completely implicit methods (CIM) is proposed for solving the equation of the velocity potential of elliptical-hyperbolic type. The advantage of the proposed method compared to other CIM schemes is demonstrated in application to mixed perfect gas flows in a nozzle of a given shape. Accuracy issues, rate of convergence, and various techniques of ensuring stability in the hyperbolic region are discussed. Translated from Chislennye Metody v Matematicheskoi Fizike, Published by Moscow University, Moscow, 1996, pp. 39–51.     

Effective potentials and Bogoliubov’s quasi-averages

The effective potential method, used in quantum field theory to study spontaneous symmetry violation, is discussed from the point of view of Bogoliubov’s quasi-averaging procedure. It is shown that the effective potential method is a disguised type of this procedure. The catastrophe theory approach to the study of phase transitions is discussed and the existence of the potentials used in that approach is proved from the statistical point of view. It is shown that in the case of broken symmetry, the nonconvex effective potential is not a Legendre transform of the generating functional for connected Green’s functions. Instead, it is a part of the potential used in catastrophe theory. The relationship between the effective potential and the Legendre transform of the generating functional for connected Green’s functions is given by Maxwell’s rule. A rigorous rule for evaluating quasi-averaged quantities within the framework of the effective potential method is established. Translated from Teoreticheskaya i Matematicheskaya Fizika, Vol. 113, No. 1, pp. 149–161, October, 1997.