Answering Conjunctive Queries under Updates

We consider the task of enumerating and counting answers to $k$-ary conjunctive queries against relational databases that may be updated by inserting or deleting tuples. We exhibit a new notion of q-hierarchical conjunctive queries and show that these can be maintained efficiently in the following sense. During a linear time preprocessing phase, we can build a data structure that enables constant delay enumeration of the query results; and when the database is updated, we can update the data structure and restart the enumeration phase within constant time. For the special case of self-join free conjunctive queries we obtain a dichotomy: if a query is not q-hierarchical, then query enumeration with sublinear$^\ast$ delay and sublinear update time (and arbitrary preprocessing time) is impossible. For answering Boolean conjunctive queries and for the more general problem of counting the number of solutions of k-ary queries we obtain complete dichotomies: if the query's homomorphic core is q-hierarchical, then size of the the query result can be computed in linear time and maintained with constant update time. Otherwise, the size of the query result cannot be maintained with sublinear update time. All our lower bounds rely on the OMv-conjecture, a conjecture on the hardness of online matrix-vector multiplication that has recently emerged in the field of fine-grained complexity to characterise the hardness of dynamic problems. The lower bound for the counting problem additionally relies on the orthogonal vectors conjecture, which in turn is implied by the strong exponential time hypothesis. $^\ast)$ By sublinear we mean $O(n^{1-\varepsilon})$ for some $\varepsilon>0$, where $n$ is the size of the active domain of the current database

Information filtering via Iterative Refinement

With the explosive growth of accessible information, expecially on the Internet, evaluation-based filtering has become a crucial task. Various systems have been devised aiming to sort through large volumes of information and select what is likely to be more relevant. In this letter we analyse a new ranking method, where the reputation of information providers is determined self-consistently.Comment: 10 pages, 3 figures. Accepted for publication on Europhysics Letter

Non-linear photochemical pathways in laser induced atmospheric aerosol formation

We measured the chemical composition and the size distribution of aerosols generated by femtosecond-Terawatt laser pulses in the atmosphere using an aerosol mass spectrometer (AMS). We show that nitric acid condenses in the form of ammonium nitrate, and that oxidized volatile organics also contribute to particle growth. These two components account for two thirds and one third, respectively, of the dry laser-condensed mass. They appear in two different modes centred at 380 nm and 150 nm. The number concentration of particles between 25 and 300 nm increases by a factor of 15. Pre-existing water droplets strongly increase the oxidative properties of the laser-activated atmosphere, substantially enhancing the condensation of organics under laser illumination.Comment: 19 pages, 5 figure

Coprological study on intestinal helminths in Swiss dogs: temporal aspects of anthelminthic treatment

Coproscopic examination of 505 dogs originating from the western or central part of Switzerland revealed the presence (prevalence data) of the following helminthes: Toxocara canis (7.1%), hookworms (6.9%), Trichuris vulpis (5.5%), Toxascaris leonina (1.3%), Taeniidae (1.3%), Capillaria spp. (0.8%), and Diphyllobothrium latum (0.4%). Potential risk factors for infection were identified by a questionnaire: dogs from rural areas significantly more often had hookworms and taeniid eggs in their feces when compared to urban family dogs. Access to small rodents, offal, and carrion was identified as risk factor for hookworm and Taeniidae, while feeding of fresh and uncooked meat did not result in higher prevalences for these helminths. A group of 111 dogs was treated every 3months with a combined medication of pyrantel embonate, praziquantel, and febantel, and fecal samples were collected for coproscopy in monthly intervals. Despite treatment, the yearly incidence of T. canis was 32%, while hookworms, T. vulpis, Capillaria spp., and Taeniidae reached incidences ranging from 11 to 22%. Fifty-seven percent of the 111 dogs had helminth eggs in their feces at least once during the 1-year study period. This finding implicates that an infection risk with potential zoonotic pathogens cannot be ruled out for the dog owner despite regular deworming four times a yea

Evidence for distinct polymer chain orientations in KC60 and RbC60

The KC60 and RbC60 polymer phases exhibit contrasting electronic properties while powder diffraction studies have revealed no definite structural difference. We have performed single crystal X-ray diffraction and diffuse scattering studies of these compounds. It is found that KC60 and RbC60 possess different chain orientations about their axes, which are described by distinct space groups Pmnn and I2/m, respectively. Such a structural difference will be of great importance to a complete understanding of the physical properties.Comment: To be published in Phys. Rev. Let

Two-Stage Rotational Disordering of a Molecular Crystal Surface: C60

We propose a two-stage mechanism for the rotational surface disordering phase transition of a molecular crystal, as realized in C$_{60}$ fullerite. Our study, based on Monte Carlo simulations, uncovers the existence of a new intermediate regime, between a low temperature ordered $(2 \times 2)$ state, and a high temperature $(1 \times 1)$ disordered phase. In the intermediate regime there is partial disorder, strongest for a subset of particularly frustrated surface molecules. These concepts and calculations provide a coherent understanding of experimental observations, with possible extension to other molecular crystal surfaces.Comment: 4 pages, 2 figure