SQL Query Completion for Data Exploration

Within the big data tsunami, relational databases and SQL are still there and remain mandatory in most of cases for accessing data. On the one hand, SQL is easy-to-use by non specialists and allows to identify pertinent initial data at the very beginning of the data exploration process. On the other hand, it is not always so easy to formulate SQL queries: nowadays, it is more and more frequent to have several databases available for one application domain, some of them with hundreds of tables and/or attributes. Identifying the pertinent conditions to select the desired data, or even identifying relevant attributes is far from trivial. To make it easier to write SQL queries, we propose the notion of SQL query completion: given a query, it suggests additional conditions to be added to its WHERE clause. This completion is semantic, as it relies on the data from the database, unlike current completion tools that are mostly syntactic. Since the process can be repeated over and over again -- until the data analyst reaches her data of interest --, SQL query completion facilitates the exploration of databases. SQL query completion has been implemented in a SQL editor on top of a database management system. For the evaluation, two questions need to be studied: first, does the completion speed up the writing of SQL queries? Second , is the completion easily adopted by users? A thorough experiment has been conducted on a group of 70 computer science students divided in two groups (one with the completion and the other one without) to answer those questions. The results are positive and very promising

Protection against myxomatosis and rabbit viral hemorrhagic disease with recombinant myxoma viruses expressing rabbit hemorrhagic disease virus capsid protein

Two myxoma virus-rabbit hemorrhagic disease virus (RHDV) recombinant viruses were constructed with the SG33 strain of myxoma virus to protect rabbits against myxomatosis and rabbit viral hemorrhagic disease. These recombinant viruses expressed the RHDV capsid protein (VP60). The recombinant protein, which is 60 kDa in size, was antigenic, as revealed by its reaction in immunoprecipitation with antibodies raised against RHDV. Both recombinant viruses induced high levels of RHDV- and myxoma virus-specific antibodies in rabbits after immunization. Inoculations by the intradermal route protected animals against virulent RHDV and myxoma virus challenges

Combination of 3D Scanning, Modeling and Analyzing Methods around the Castle of Coatfrec Reconstitution

International audienceThe castle of Coatfrec is a medieval castle in Brittany constituting merely a few remaining ruins currently in the process of restoration. Beyond its great archeological interest, it has become, over the course of the last few years, the subject of experimentation in digital archeology. Methods of 3D scanning were implored in order to gauge comparisons between the remaining structures and their absent hypothetical ones, resulting in the first quantitative results of its kind. This paper seeks to introduce the methods which carried out said research, as well as to present the subsequent results obtained using these new digital tools

Taste at first (person) sight: visual perspective modulates brain activity implicitly associated with viewing unhealthy but not healthy foods

Every day, people are exposed to images of appetizing foods that can lead to high-calorie intake and contribute to overweight and obesity. Research has documented that manipulating the visual perspective from which eating is viewed helps resist temptation by altering the appraisal of unhealthy foods. However, the neural basis of this effect has not yet been examined using neuroimaging methods. Moreover, it is not known whether the benefits of this strategy can be observed when people, especially overweight, are not explicitly asked to imagine themselves eating. Last, it remains to be investigated if visual perspective could be used to promote healthy foods. The present work manipulated camera angles and tested whether visual perspective modulates activity in brain regions associated with taste and reward processing while participants watch videos featuring a hand grasping (unhealthy or healthy) foods from a plate during functional magnetic resonance imagining (fMRI). The plate was filmed from the perspective of the participant (first-person perspective; 1PP), or from a frontal view as if watching someone else eating (third-person perspective; 3PP). Our findings reveal that merely viewing unhealthy food cues from a 1PP (vs. 3PP) increases activity in brain regions that underlie representations of rewarding (appetitive) experiences (amygdala) and food intake (superior parietal gyrus). Additionally, our results show that ventral striatal activity is positively correlated with body mass index (BMI) during exposure to unhealthy foods from a 1PP (vs. 3PP). These findings suggest that unhealthy foods should be promoted through third-person (video) images to weaken the reward associated with their simulated consumption, especially amongst overweight people. It appears however that, as such, manipulating visual perspective fails to enhance the perception of healthy foods. Their promotion thus requires complementary solutions

Evaluation of the Effect of Chemical or Enzymatic Synthesis Methods on Biodegradability of Polyesters

International audienceThis work compares the biodegradability of polyesters produced by an esterification reaction between glycerol and oleic di-acid (D 18:1) issued from green chemical pathways, via either classical thermo-chemical methods, or an enzymatic method using the immobilized lipase of Candida antartica B (Novozym 435). An elastomeric polymer synthesized by enzymatic catalysis is more biodegradable than an elastomeric thermo-chemical polyester synthesized by a standard chemical procedure. This difference lies in percentage of the dendritic motifs, in values of the degree of substitution, and certainly in cross-links inducing an hyper-branched structure less accessible to the lipolytic enzymes in a waste treatment plant. However, when the elastomeric polymer synthesized by enzymatic catalysis is processed at high temperature as required for certain industrial applications, it presents an identical rate of biodegradation than the chemical polyester. The advantages of the thermo-chemical methods are greater speed and lower cost. Enzymatic synthesis appears be suited to producing polyesters, devoid of metallic catalysts, which must be used without processing at high temperature to keep a high biodegradability