• Publicationsclose
• Research softwareclose
• Mémoires en Sciences de l'Information et de la Communication close

International audience; Although the problem of computing frequent queries in relational databases is known to be intractable, it has been argued in our previous work that using functional and inclusion dependencies, computing frequent conjunctive queries becomes feasible for databases operating over a star schema. However, the implementation considered in this previous work showed severe limitations for large fact tables. The main contribution of this paper is to overcome these limitations using appropriate auxiliary tables. We thus introduce a novel algorithm, called Frequent Query Finder (FQF), and we report on experiments showing that our algorithm allows for an effective and efficient computation of frequent queries.

International audience; Deterministic networking allows carrying data flows with low data-loss rates and with bounded latency. A typical use-case is the convergence of Operational Technology (OT) with Information Technology (IT), also known as the Industrial Internet. Wireless networks operate on a shared communication medium where the potential external interference along with multi-path fading impact data packet delivery. Since the medium is shared, it is not necessarily possible to employ wired techniques, such as preemption, to guarantee timely delivery. By employing diversity in the time, frequency and spatial domains, wireless technologies with scheduled transmissions, such as IEEE 802.15.4 Time Slot Channel Hopping (TSCH), can mitigate those effects and provide Reliable and Available Wireless communications that approach determinism. Nevertheless, a radio link operating in the ISM band, such as IEEE 802.15.4-TSCH, still needs to handle collisions and possibly re-transmission. Therefore, a single link cannot reliably ensure delivery at all times within bounded latency. It takes redundant links and paths to provide both the high availability and the near consistent reliability that industrial applications require. In this paper, we present the Packet Automatic Repeat reQuest (ARQ), Replication and Elimination (RE), and Overhearing (PAREO) functions to further increase the Quality of Service (QoS) in industrial networks, even when implemented on top of best-effort traffic in a shared network.

Abstract Fluorescein (F) species were encapsulated inside nanosized zeolites L and Y by their synthesis from adsorbed precursors (phthalic anhydride (Ph) and resorcinol (R)). The applied nanozeolites were modified either with H+ or Zn2+ cations and they played roles of the catalysts for synthesis of F and of the matrices for resulting dye molecules. The F loading, its tautomeric forms and optical properties of obtained composites depended on zeolite structure, morphology and on introduced cations. The composites usually showed higher fluorescence intensity than the pristine dye. The highest fluorescence intensity was noticed for the sample with nano-ZnL matrix. This intensity was much higher than that observed for composite with conventional micro-sized Zn L zeolite. Regarding an efficient fluorescence and nanosize of the obtained composites they seem promising fluorescent tracer for medical (theranostic) applications.

Trophy hunting is one of the most controversial issues in the field of biodiversity conservation. In particular, proponents and opponents debate fiercely over whether it poses a threat to hunted populations. Here, we show that trophy hunting constitutes a greater menace to threatened species than previously realized. Because humans value rarity, targeted species that are threatened are likely to be disproportionately hunted, thereby becoming even more vulnerable, which could eventually push them to extinction. With the ten felid species currently hunted for their trophies, we present evidence that (1) the number of killed individuals increases with time, in several cases exponentially, despite population declines, (2) the price of trophies is strongly dependent on species protection status, (3) changes of protection status coincide with counter-intuitive changes of hunting pressures: protection intensification with augmented hunting effort, and protection relaxation with lower effort. This suggests an over-exploitation of trophy-hunted felids and the necessity of a better quota system coupled with reconsidered protection methods.

International audience; Attenuated total reflectance Fourier transform spectroscopy (ATR-FTIR) was applied on fresh (NF), freeze-dried (FD) and cell wall materials (AIS) of raw and processed apples. These samples prepared from 36 apple sets and the corresponding 72 purees, issued from different varieties, agricultural practices, storage periods and processing conditions, were used to build models including exploratory analysis, supervised classification and multivariate calibration. Fresh and freeze-dried samples presented similar fingerprint spectral variations due to processing. ATR-FTIR directly on fresh purees satisfactorily predicted textural properties such as particle average size and volume (RPD > 3.0), while freeze-drying improved assessment of chemical (RPD > 3.2) and rheological (RPD > 3.1) parameters using partial least-squares regression. The assessment of texture and macrocomponents of purees can be obtained with a limited sample preparation. For research applications because of a need of sample preparation, changes of cell wall composition during fruit processing could be assessed in relationship with pectin degradation.

International audience; Thirty lactating dairy cows were used in a 333 Latin-square design to investigate the effects of a raw or extruded blend of linseed and wheat bran (70:30) on plasma and milk fatty-acids (FA). Linseed diets, containing 16.6% linseed blend on a dry-matter basis, decreased milk yield and protein percentage. They decreased the proportions of FA with less than 18 carbons in plasma and milk and resulted in cis -9, cis -12, cis -15 18:3 proportions that were more than three and four times higher in plasma and milk, respectively, whereas cis -9, cis -12 18:2 proportions were decreased by 10–15%. The cis -9, trans -11, cis -15 18:3 isomer of conjugated linolenic acid was not detected in the milk of control cows, but was over 0.15% of total FA in the milk fat of linseed-supplemented cows. Similarly, linseed increased plasma and milk proportions of all biohydrogenation (BH) intermediates in plasma and milk, including the main isomer of conjugated linoleic acid cis -9, trans -11 18:2, except trans -4 18:1 and cis -11, trans -15 18:2 in plasma lipids. In milk fat, compared with raw linseed, extruded linseed further reduced 6:0–16:0 even-chain FA, did not significantly affect the proportions of 18:0, cis -9 18:1 and cis- 9, cis -12 18:2, tended to increase cis -9, cis -12, cis -15 18:3, and resulted in an additional increase in the proportions of most BH intermediates. It was concluded that linseed addition can improve the proportion of conjugated linoleic and linolenic acids, and that extrusion further increases the proportions of intermediates of ruminal BH in milk fat.

International audience; Magnitudes of differential stress in the lithosphere, especially in the crust, are still disputed. Earthquake-based stress drop estimates indicate median values ca. 180 MPa, corresponding to a friction angle of ca. 10° to maintain the topographic relief between lowland and plateau for >10 Ma. The relative contribution of crustal strength to total lithospheric strength varies considerably laterally. In the region between lowland and plateau and inside the plateau the depth-integrated crustal strength is approximately equal to the depth-integrated strength of the mantle lithosphere. Simple analytical formulae predicting the lateral variation of depth-integrated stresses agree with numerically calculated stress fields, which show both the accuracy of the numerical results and the applicability of simple, rheology-independent, analytical predictions to highly variable, rheology-dependent stress fields. Our results indicate that (1) crustal strength can be locally equal to mantle lithosphere strength and that (2) crustal stresses must be at least one order of magnitude larger than median stress drops in order to support the plateau relief over a duration of ca. 10 Ma.

Dans No Thoroughfare de Charles Dickens et Wilkie Collins (f870), le déséquilibre de l’intrigue survient lorsque le « personnage principal » apprend qu’il est, et qu’à la fois, il n’est pas Walter Wilding. Les deux auteurs nous amènent à la limite de l’appellation, un procédé dont ils rappellent la complexité et dont ils proposent diverses déviances. Ils mettent en présence deux personnages, qui pour survivre dans le récit devront se poser la question des rapports complexes entre nom propre et référence. A travers deux modes de construction de personnages, Wilkie Collins et Charles Dickens illustrent le débat des logico-linguistes et y apportent leur participation. In No Thoroughfare by Charles Dickens and Wilkie Collins (1870), the main plot is starts on the “main character’s” learning that he both is and is not Walter Wilding. The two authors thus take us to the limits of naming, reminding us of the complexity of its process while they display various deviances of the naming process. Two characters are involved and their endurance in the narrative they consider the complex relations between proper noun and referent. Through two modes of character framing, Wilkie Collins and Charles Dickens illustrate and take part in the logico-linguists’ long existing debate on this issue.

International audience

International audience