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.     

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.     

Orbifolds, Sheaves and Groupoids

We characterize orbifolds in terms of their sheaves, and show that orbifolds correspond exactly to a specific class of smooth groupoids. As an application, we construct fibered products of orbifolds and prove a change-of-base formula for sheaf cohomology.     

Small angle neutron scattering from oxygen precipitates in silicon

The formation of silicon oxide precipitates from Czochralski grown silicon depends on the time and temperature of the heat treatment as well as on the initial content of interstitially dissolved oxygen. Samples containing between 5×10¹⁷ O_i/cm³ and 13×10¹⁷ O_i/cm³ have been heated at 750° C for 96 h. SiO₂ precipitates of various shape and size have been obtained and investigated by means of small angle neutron scattering (SANS) in the Q-range 0.05 Å^–1<Q<0.2 Å^–1. The obtained SANS patterns reveal a typical anisotropy of their intensity distribution, which splits into a central peak at Q<0.1 Å^–1 due to the shape of the individual particles and a number of weak intensities for large Q-values, originating from a correlation between defects, possibly between the precipitates. While these correlation peaks in the SANS patterns are seen best for rather low values of about (5–7)×10¹⁷ O_i/cm³ oxygen content, the central peak anisotropy is most pronounced for higher values of ca 10×10¹⁷ O_i/cm³. The integrated intensity of the central peak increases with increasing initial oxygen content. For comparison, untreated samples of the same initial oxygen content do not reveal any anisotropic SAN scattering or a broadened central peak beam.     

Spline prewavelets for non-uniform knots

Summary In this paper, we develop a framework suitable for performing a multiresolution analysis using univariate spline spaces of arbitrary degree and with non-uniform knot-sequences. To this end, we show, among other things, the existence of compactly supported prewavelets and of prewavelets that are globally supported, but decay exponentially. In each case we obtain a decomposition of a fine spline space as a sum of a coarse spline space plus a spline space spanned by prewavelets.     

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.     

Magnetic resonance imaging: a new window into industrial processing.

Although the most important use of nuclear magnetic resonance imaging (MRI) continues to be for diagnostic medicine, recognition is being gained for many nonmedical applications. Examples include the following areas: petrogeology, food, agriculture, polymers and polymer-composites, and pharmaceuticals. These areas all involve studies of species that have short spin-spin relaxation times, and consequently need far fast gradient switching. These technical details are discussed and typical applications given.     

Optical Tunnelling from One-Dimensional Square-Well Potentials

The authors study a one-dimensional model for optical tunnellingwith a refractive index in the shape of a square well. The relevanceof the model and its limiting cases are discussed. The mainresult is the leading behaviour of the exponentially small imaginarypart of the eigenvalue which determines the radiation loss.The leading behaviour of the imaginary part is calculated usingBerry's formula which controls the asymptotic expansion of theAiry function Bi(z) to better-than-exponential accuracy.