A Generic business rules validation system for ORACLE Applications

Picture this : You have just spent the remainder of your IT budget on a new software package for Human Resources. Despite its excellent functionality, it does not perform all of the complex validation that your old in-house-developed system did. How can you improve the standard software package given the following constraints : You cannot afford to pay the vendor for modifications to the package Modifying the package yourself is out of the question. We describe a tool designed to implement the validation of complex business rules for any ORACLE database application - without incurring any modification to the user interface. It enhances your productís standard capabilities and improves data quality as soon as data has been entered or modified. . Our initial implementations was for the ORACLE Human Resources package. Our tool consists of four independent components: A description of the data and its location, A set of rules (written in a simple pseudo-code), A generic on-line change detection system, A core engine that checks data consistency by applying the rules to relevant changes. The Validation system makes extensive use of state of the art techniques with database triggers and dynamic PL/SQL

Distinguishing an ejected blob from alternative flare models at the Galactic centre with GRAVITY

The black hole at the Galactic centre exhibits regularly flares of radiation, the origin of which is still not understood. In this article, we study the ability of the near-future GRAVITY infrared instrument to constrain the nature of these events. We develop realistic simulations of GRAVITY astrometric data sets for various flare models. We show that the instrument will be able to distinguish an ejected blob from alternative flare models, provided the blob inclination is >= 45deg, the flare brightest magnitude is 14 <= mK <= 15 and the flare duration is >= 1h30.Comment: 11 pages, 9 figures, accepted by MNRA

The unreasonable effectiveness of equilibrium-like theory for interpreting non-equilibrium experiments

There has been great interest in applying the results of statistical mechanics to single molecule experiements. Recent work has highlighted so-called non-equilibrium work-energy relations and Fluctuation Theorems which take on an equilibrium-like (time independent) form. Here I give a very simple heuristic example where an equilibrium result (the barometric law for colloidal particles) arises from theory describing the {\em thermodynamically} non-equilibrium phenomenon of a single colloidal particle falling through solution due to gravity. This simple result arises from the fact that the particle, even while falling, is in {\em mechanical} equilibrium (gravitational force equal the viscous drag force) at every instant. The results are generalized by appeal to the central limit theorem. The resulting time independent equations that hold for thermodynamically non-equilibrium (and even non-stationary) processes offer great possibilities for rapid determination of thermodynamic parameters from single molecule experiments.Comment: 6 page

Implications of the spatial variability of infiltration-water chemistry for the investigation of a karst aquifer: a field study at Milandre test site, Swiss Jura

The Milandre test site is an ideal karstic aquifer for studying the spatial heterogeneity of groundwater chemistry. Numerous observation points can be sampled: the spring, the underground river and its tributaries, and boreholes at different depths. The main causes of the spatial variability of the chemical parameters are: nature and localisation of the input, the structure of the infiltration zone, chemical reactions (transit time vs. reaction kinetics) and mixing of different waters. Physico-chemical data on springs discharging from the karstic system represent the sum of this spatial heterogeneity. Therefore, it is difficult to interpret the global-chemical response with a simple mixing model of the aquifer subsystems (runoff, matrix reservoir, epikarst). Chemical constituents related to agricultural inputs show important seasonal variations (coefficient of variation approximately 15%) and parameters linked to rainfall (δ18O) and to the aquifer (Ca2+, HCO3 −) present variations of less than 5%. This result indicates the importance of water storage in the epikarstic aquifer for periods of a few month

An Example of Quantum Anomaly in the Physics of Ultra-Cold Gases

In this article, we propose an experimental scheme for observation of a quantum anomaly---quantum-mechanical symmetry breaking---in a two-dimensional harmonically trapped Bose gas. The anomaly manifests itself in a shift of the monopole excitation frequency away from the value dictated by the Pitaevskii-Rosch dynamical symmetry [L. P. Pitaevskii and A. Rosch, Phys. Rev. A, 55, R853 (1997)]. While the corresponding classical Gross-Pitaevskii equation and the derived from it hydrodynamic equations do exhibit this symmetry, it is---as we show in our paper---violated under quantization. The resulting frequency shift is of the order of 1% of the carrier, well in reach for modern experimental techniques. We propose using the dipole oscillations as a frequency gauge.Comment: Misprints corrected, a discussion on damping added, text is polished and shortened. 5 pages, 1 figur

Long-term spectropolarimetric monitoring of the cool supergiant Betelgeuse

We report on a long-term monitoring of the cool supergiant Betelgeuse, using the NARVAL and ESPaDOnS high-resolution spectropolarimeters, respectively installed at Telescope Bernard Lyot (Pic du Midi Observatory, France) and at the Canada-France-Hawaii Telescope (Mauna Kea Observatory, Hawaii). The data set, constituted of circularly polarized (Stokes V) and intensity (Stokes I) spectra, was collected between 2010 and 2012. We investigate here the temporal evolution of magnetic field, convection and temperature at photospheric level, using simultaneous measurements of the longitudinal magnetic field component, the core emission of the Ca II infrared triplet, the line-depth ratio of selected photospheric lines and the radial velocity of the star.Comment: Proceedings of the Betelgeuse Workshop, Paris, 26-29 Nov 201

First-principles quantum dynamics for fermions: Application to molecular dissociation

We demonstrate that the quantum dynamics of a many-body Fermi-Bose system can be simulated using a Gaussian phase-space representation method. In particular, we consider the application of the mixed fermion-boson model to ultracold quantum gases and simulate the dynamics of dissociation of a Bose-Einstein condensate of bosonic dimers into pairs of fermionic atoms. We quantify deviations of atom-atom pair correlations from Wick's factorization scheme, and show that atom-molecule and molecule-molecule correlations grow with time, in clear departures from pairing mean-field theories. As a first-principles approach, the method provides benchmarking of approximate approaches and can be used to validate dynamical probes for characterizing strongly correlated phases of fermionic systems.Comment: Final published versio

Determination of Fluorescence Polarization and Absorption Anisotropy in Molecular Complexes Having Threefold Rotational Symmetry

The current work concerns investigation of the polarization properties of complex molecular ensembles exhibiting threefold (C3) rotational symmetry, particularly with regard to the interplay between their structure and dynamics of internal energy transfer. We assume that the molecules or chromophores in such complexes possess strongly overlapped spectra both for absorption and fluorescence. Such trimeric structures are widely found in biological preparations, as for example the trimer of C-phycocyanin (C-PC). Higher order aggregates, e.g. hex-amers and three-hexamer rods, are also investigated and compared with the trimer case. The theory addresses both steady-state and 8-pulse excitation and establishes some links between them. Monochromophoric, bichro-mophoric and trichromophoric molecular complexes are individually examined. For steady-state excitation, analytical formulas are reported for the degree of fluorescence polarization and absorption anisotropy. It is shown that the polarization is dependent on the chromophore inclination relative to the symmetry axis, the relative efficiencies of absorption and fluorescence by chromophores of different spectral types, and the rates of energy equilibration. To assess the validity of the theory, it has been applied to C-PC aggregates. Here it was found that different C-PC aggregates provide practically identical polarization response. For S-pulse excitation we give analytical formulas for determination of the fluorescence depolarization, and also the depolarization associated with absorption recovery, both for a monochromophoric trimer and some particular cases of bichromophoric trimer. More complicated systems are analyzed by computer modeling. Thus it transpires that the initial polarization anisotropy r(t = 0) takes the value 0.4 for all considered aggregates; the long-time limit r(t →∞) has about the same value as is associated with steady-state excitation. We also show that with steady-state excitation the degree of fluorescence polarization is practically equal for various C3 aggregates of C-PC, and that the major factor determining the polarization is the chromophore orientation relative to the symmetry axis

Can a multi-model approach improve hydrological ensemble forecasting? A study on 29 French catchments using 16 hydrological model structures

An operational hydrological ensemble forecasting system based on a meteorological ensemble prediction system (M-EPS) coupled with a hydrological model searches to capture the uncertainties associated with the meteorological prediction to better predict river flows. However, the structure of the hydrological model is also an important source of uncertainty that has to be taken into account. This study aims at evaluating and comparing the performance and the reliability of different types of hydrological ensemble prediction systems (H-EPS), when ensemble weather forecasts are combined with a multi-model approach. The study is based on 29 catchments in France and 16 lumped hydrological model structures, driven by the weather forecasts from the European centre for medium-range weather forecasts (ECMWF). Results show that the ensemble predictions produced by a combination of several hydrological model structures and meteorological ensembles have higher skill and reliability than ensemble predictions given either by one single hydrological model fed by weather ensemble predictions or by several hydrological models and a deterministic meteorological forecast