6 Access Methods and Query Processing Techniques

The performance of a database management system (DBMS) is fundamentally dependent on the access methods and query processing techniques available to the system. Traditionally, relational DBMSs have relied on well-known access methods, such as the ubiquitous B +-tree, hashing with chaining, and, in som

ReporTree: a surveillance-oriented tool to strengthen the linkage between pathogen genetic clusters and epidemiological data

OHEJP Project: BeONE https://doi.org/10.1186/s13073-023-01196-1 This repository contains the Open Access PDF file of the article: Mixão, V., Pinto, M., Sobral, D. et al. ReporTree: a surveillance-oriented tool to strengthen the linkage between pathogen genetic clusters and epidemiological data. Genome Med 15, 43 (2023). ----------------------------------- Open Access This article is licensed under a Creative Commons Attribution 4.0 International License, which permits use, sharing, adaptation, distribution and reproduction in any medium or format, as long as you give appropriate credit to the original author(s) and the source, provide a link to the Creative Commons licence, and indicate if changes were made. The images or other third party material in this article are included in the article's Creative Commons licence, unless indicated otherwise in a credit line to the material. If material is not included in the article's Creative Commons licence and your intended use is not permitted by statutory regulation or exceeds the permitted use, you will need to obtain permission directly from the copyright holder. To view a copy of this licence, visit http://creativecommons.org/licenses/by/4.0/. The Creative Commons Public Domain Dedication waiver (http://creativecommons.org/publicdomain/zero/1.0/) applies to the data made available in this article, unless otherwise stated in a credit line to the data. ----------------------------------- Acknowledgements The authors thank Dr. Holger Brendebach, Dr. Carlus Deneke, and Dr. Simon Tausch from the German Federal Institute for Risk Assessment for their support during the genome assembly of the samples used in ReporTree benchmarking and Dr. João André Carriço for the productive discussions throughout ReporTree development. We would also like to thank the National Distributed Computing Infrastructure of Portugal (INCD) for providing the necessary resources to run the genome assemblies. INCD was funded by FCT and FEDER under the project 22153-01/SAICT/2016. Funding This work was supported by funding from the European Union’s Horizon 2020 Research and Innovation program under grant agreement No 773830: One Health European Joint Programme (2020–2022) and by national funds through FCT—Foundation for Science and Technology, I.P., in the frame of Individual CEEC 2022.00851.CEECIND/CP1748/CT0001 (2023 onwards)

Characterization and performance of a toluene-degrading biofilm developed on pumice stones

BACKGROUND: Hydrocarbon-degrading biofilms in the treatment of contaminated groundwaters have received increasing attention due to the role played in the so-called "biobarriers". These are bioremediation systems in which a microbial consortium adherent to a solid support is placed across the flow of a contaminated plume, thus promoting biodegradation of the pollutant. RESULTS: A microbial consortium adherent to pumice granules (biofilm) developed from a toluene-enriched microflora in a mini-scale system, following continuous supply of a mineral medium containing toluene, over a 12-month period. Observation by scanning electron microscopy, together with quantification of the biomass attached to pumice, evidenced the presence of abundant exopolymeric material surrounding the cells in the biofilm. Toluene removal monitored during 12-month operation, reached 99%. Identification of the species, based on comparative 16S ribosomal DNA (rDNA) sequence analysis, revealed that Rhodococcus erythropolis and Pseudomonas marginalis were the predominant bacterial species in the microbial consortium. CONCLUSION: A structurally complex toluene-degrading biofilm, mainly formed by Rhodococcus erythropolis and Pseudomonas marginalis, developed on pumice granules, in a mini-scale apparatus continuously fed with toluene

Phase-contrast breast CT: the effect of propagation distance

X-ray phase imaging has the potential to dramatically improve soft tissue contrast sensitivity, which is a crucial requirement in many diagnostic applications such as breast imaging. In this context, a program devoted to perform in-vivo phase-contrast synchrotron radiation breast computed tomography is ongoing at the Elettra facility (Trieste, Italy). The used phase-contrast technique is the propagation-based configuration, which requires a spatially coherent source and a sufficient object-to-detector distance. In this work the effect of this distance on image quality is quantitatively investigated scanning a large breast surgical specimen at 3 object-to-detector distances (1.6, 3, 9 m) and comparing the images both before and after applying the phase-retrieval procedure. The sample is imaged at 30 keV with a 60 \ub5m pixel pitch CdTe single-photon-counting detector, positioned at a fixed distance of 31.6~m from the source. The detector fluence is kept constant for all acquisitions. The study shows that, at the largest distance, a 20-fold SNR increase can be obtained by applying the phase-retrieval procedure. Moreover, it is shown that, for phase-retrieved images, changing the object-to-detector distance does not affect spatial resolution while boosting SNR (4-fold increase going from the shortest to the largest distance). The experimental results are supported by a theoretical model proposed by other authors, whose salient results are presented in this paper

Hypo- and Hyper-Virulent Listeria monocytogenes Clones Persisting in Two Different Food Processing Plants of Central Italy

A total of 66 Listeria monocytogenes (Lm) isolated from 2013 to 2018 in a small-scale meat processing plant and a dairy facility of Central Italy were studied. Whole Genome Sequencing and bioinformatics analysis were used to assess the genetic relationships between the strains and investigate persistence and virulence abilities. The biofilm forming-ability was assessed in vitro. Cluster analysis grouped the Lm from the meat plant into three main clusters: two of them, both belonging to CC9, persisted for years in the plant and one (CC121) was isolated in the last year of sampling. In the dairy facility, all the strains grouped in a CC2 four-year persistent cluster. All the studied strains carried multidrug efflux-pumps genetic determinants (sugE, mdrl, lde, norM, mepA). CC121 also harbored the Tn6188 specific for tolerance to Benzalkonium Chloride. Only CC9 and CC121 carried a Stress Survival Islet and presented high-level cadmium resistance genes (cadA1C1) carried by different plasmids. They showed a greater biofilm production when compared with CC2. All the CC2 carried a full-length inlA while CC9 and CC121 presented a Premature Stop Codon mutation correlated with less virulence. The hypo-virulent clones CC9 and CC121 appeared the most adapted to food-processing environments; however, even the hyper-virulent clone CC2 warningly persisted for a long time. The identification of the main mechanisms promoting Lm persistence in a specific food processing plant is important to provide recommendations to Food Business Operators (FBOs) in order to remove or reduce resident Lm

JRP24-FBZSH9-BEONE WP1 deliverable 1.3 (Clustering congruence and thresholds)

Foodborne pathogens pose an important and serious threat to human and animal health. Therefore, genomics-based surveillance systems able to track the circulation of these pathogens and monitor their clinical and epidemiological relevant features have been implemented at the reference laboratories of multiple countries and sectors. However, there is a lack of harmonization between them that challenges the integration and comparison of data at international and intersectoral levels, and, ultimately, the establishment of fully integrative and efficient One Health genomic surveillance frameworks. In the BeONE project, we aimed to perform a massive comparison between different bioinformatics pipelines used for genomic surveillance of foodborne bacterial pathogens, as a way to assess the congruence and comparability of their clustering results. Specifically, BeONE WP1-T3 had as main objectives the: Evaluation of the behavior of different surveillance-oriented genomics pipelines in the definition of genetic clusters, through the identification of threshold ranges with high resolution for outbreak detection or stable threshold ranges for nomenclature design (useful for longitudinal surveillance); Determination of the congruence with traditional typing nomenclatures, such as Sequence Type (ST) or serovar; Identification of congruent resolution levels between pipelines, as a way to facilitate international data sharing and cooperation; Assessment of the similarities and discrepancies between pipelines in the identification of outbreak-related isolates In this repository, we provide the Deliverable of BeONE WP1-T3 with a brief overview of its activities and the preliminary results obtained until the end of the BeONE project. We anticipate that this study will provide important information regarding the behavior of each pipeline and facilitate the direct comparability of their results

LHCb upgrade software and computing : technical design report

This document reports the Research and Development activities that are carried out in the software and computing domains in view of the upgrade of the LHCb experiment. The implementation of a full software trigger implies major changes in the core software framework, in the event data model, and in the reconstruction algorithms. The increase of the data volumes for both real and simulated datasets requires a corresponding scaling of the distributed computing infrastructure. An implementation plan in both domains is presented, together with a risk assessment analysis

Search for supersymmetry in final states with photons and missing transverse momentum in proton-proton collisions at 13 TeV

Results are reported of a search for supersymmetry in final states with photons and missing transverse momentum in proton-proton collisions at the LHC. The data sample corresponds to an integrated luminosity of 35.9 fb collected at a center-of-mass energy of 13 TeV using the CMS detector. The results are interpreted in the context of models of gauge-mediated supersymmetry breaking. Production cross section limits are set on gluino and squark pair production in this framework. Gluino masses below 1.86 TeV and squark masses below 1.59 TeV are excluded at 95% confidence levelIndividuals have received support from the Marie-Curie program and the European Research Council and Horizon 2020 Grant, contract No. 675440 (European Union); the Leventis Foundation; the A.P. Sloan Foundation; the Alexander von Humboldt Foundation; the Belgian Federal Science Policy Office; the Fonds pour la Formation a la Recherche dans l’Industrie et dans l’Agriculture (FRIA-Belgium); the Agentschap voor Innovatie door Wetenschap en Technologie (IWT-Belgium); the F.R.S.-FNRS and FWO (Belgium) under the “Excellence of Science — EOS” — be.h project n. 30820817; the Ministry of Education, Youth and Sports (MEYS) of the Czech Republic; the Lendület (“Momentum”) Program and the J´anos Bolyai Research Scholarship of the Hungarian Academy of Sciences, the New National Excellence Program UNKP, the NKFIA research grants 123842, 123959, 124845, 124850 and 125105 (Hungary); the Council of Science and Industrial Research, India; the HOMING PLUS program of the Foundation for Polish Science, cofinanced from European Union, Regional Development Fund, the Mobility Plus program of the Ministry of Science and Higher Education, the National Science Center (Poland), contracts Harmonia 2014/14/M/ST2/00428, Opus 2014/13/B/ST2/02543, 2014/15/B/ST2/03998, and 2015/19/B/ST2/02861, Sonata-bis 2012/07/E/ST2/01406; the National Priorities Research Program by Qatar National Research Fund; the Programa Estatal de Fomento de la Investigación Científica y Técnica de Excelencia María de Maeztu, grant MDM-2015-0509 and the Programa Severo Ochoa del Principado de Asturias; the Thalis and Aristeia programs cofinanced by EU-ESF and the Greek NSRF; the Rachadapisek Sompot Fund for Postdoctoral Fellowship, Chulalongkorn University and the Chulalongkorn Academic into Its 2nd Century Project Advancement Project (Thailand); the Welch Foundation, contract C-1845; and the Weston Havens Foundation (U.S.A.)

Measurement of the t(t)over-barb(b)over-bar production cross section in the all-jet final state in pp collisions at root s=13 TeV

A measurement of the production cross section of top quark pairs in association with two b jets (t (t) over barb (b) over bar) is presented using data collected in proton-proton collisions at root s=13 TeV by the CMS detector at the LHC corresponding to an integrated luminosity of 35.9 fb(-1). The cross section is measured in the all-jet decay channel of the top quark pair by selecting events containing at least eight jets, of which at least two are identified as originating from the hadronization of b quarks. A combination of multivariate analysis techniques is used to reduce the large background from multijet events not containing a top quark pair, and to help discriminate between jets originating from top quark decays and other additional jets. The cross section is determined for the total phase space to be 5.5 +/- 0.3 (stat)(-1.3)(+)(1.6) (syst)pb and also measured for two fiducial t (t) over barb (b) over bar, definitions. The measured cross sections are found to be larger than theoretical predictions by a factor of 1.5-2.4, corresponding to 1-2 standard deviations. (C) 2020 The Author. Published by Elsevier B.V.Peer reviewe

Electroweak production of two jets in association with a Z boson in proton-proton collisions root s =13 TeV

A measurement of the electroweak (EW) production of two jets in association with a Z boson in proton-proton collisions at root s = 13 TeV is presented, based on data recorded in 2016 by the CMS experiment at the LHC corresponding to an integrated luminosity of 35.9 fb(-1). The measurement is performed in the lljj final state with l including electrons and muons, and the jets j corresponding to the quarks produced in the hard interaction. The measured cross section in a kinematic region defined by invariant masses m(ll) > 50 GeV, m(jj) > 120 GeV, and transverse momenta P-Tj > 25 GeV is sigma(EW) (lljj) = 534 +/- 20 (stat) fb (syst) fb, in agreement with leading-order standard model predictions. The final state is also used to perform a search for anomalous trilinear gauge couplings. No evidence is found and limits on anomalous trilinear gauge couplings associated with dimension-six operators are given in the framework of an effective field theory. The corresponding 95% confidence level intervals are -2.6 <cwww/Lambda(2) <2.6 TeV-2 and -8.4 <cw/Lambda(2) <10.1 TeV-2. The additional jet activity of events in a signal-enriched region is also studied, and the measurements are in agreement with predictions.Peer reviewe