Optimizing group-by and aggregation using GPU-CPU co-processing

While GPU query processing is a well-studied area, real adoption is limited in practice as typically GPU execution is only significantly faster than CPU execution if the data resides in GPU memory, which limits scalability to small data scenarios where performance tends to be less critical. Another problem is that not all query code (e.g. UDFs) will realistically be able to run on GPUs. We therefore investigate CPU-GPU co-processing, where both the CPU and GPU are involved in evaluating the query in scenarios where the data does not fit in the GPU memory.As we wish to deeply explore opportunities for optimizing execution speed, we narrow our focus further to a specific well-studied OLAP scenario, amenable to such co-processing, in the form of the TPC-H benchmark Query 1.For this query, and at large scale factors, we are able to improve performance significantly over the state-of-the-art for GPU implementations; we present competitive performance of a GPU versus a state-of-the-art multi-core CPU baseline a novelty for data exceeding GPU memory size; and finally, we show that co-processing does provide significant additional speedup over any of the processors individually.We achieve this performance improvement by utilizing parallelism-friendly compression to alleviate the PCIe transfer bottleneck, query-compilation-like fusion of the processing operations, and a simple yet effective scheduling mechanism. We hope that some of these features can inspire future work on GPU-focused and heterogeneous analytic DBMSes.</p

Effectiveness of XP-endo finisher in the reduction of bacterial load in oval-shaped root canals

This study investigated the effectiveness of XP-Endo Finisher (XPF) associated with XP-Endo Shaper (XPS) or Reciproc Blue (RB) files in reducing bacterial load in oval-shaped root canals (RC) during chemomechanical preparation (CMP) using 0.9% saline solution (NaCl) or 2.5% sodium hypochlorite (NaOCl). Eighty mandibular incisors with single oval-shaped RC were contaminated with Enterococcus faecalis. The teeth were randomly assigned to eight experimental groups (n = 10) according to the CMP, as follows: G1: XPS, G2: XPS + XPF, G3: RB, and G4: RB + XPF. CMP was performed with NaCl or NaOCl. The reduction of bacterial load was assessed by colony-forming unit count before (S1) and after (S2) CMP. Data normality was verified by using Shapiro-Wilk test. ANOVA, Tukey's test, and Bonferroni post-hoc test were used at a 5% significance level. Culturable bacteria were present in all S1 samples (p>0.05). All instrumentation techniques were effective in reducing bacterial load, irrespective of the irrigating solution (p < 0.05). With the use of NaCl, RB was more effective than XPS (p = 0.035). With the use of NaOCl, XPS and RB presented similar effectiveness (p = 0.779). XPF enhanced the bacterial reduction of both systems tested (p < 0.05). The use of NaOCl improved the CMP, irrespective of the instrumentation technique used (p < 0.05). In conclusion, XPS and RB files are effective in reducing bacterial levels in oval-shaped RC. The use of XPF as a method of agitation of the irrigating solution improved the cleaning efficiency of both file systems tested. Mechanical preparation performed with saline solution decreased culturable bacteria from the root canal, but antimicrobial substances such as NaOCl should be used to achieve a significantly better disinfection33CONSELHO NACIONAL DE DESENVOLVIMENTO CIENTÍFICO E TECNOLÓGICO - CNPQCOORDENAÇÃO DE APERFEIÇOAMENTO DE PESSOAL DE NÍVEL SUPERIOR - CAPESFUNDAÇÃO DE AMPARO À PESQUISA DO ESTADO DE SÃO PAULO - FAPESP308162/2014-5não tem2015/23479-

Susceptibilidade antimicrobiana de cepas de estafilococcos coagulase-negativa isolados de ovinos de corte com mastite

Avaliou-se a sensibilidade antimicrobiana in vitro de 121 cepas de estafilococos coagulase-negativa isolada de leite de ovelhas Santa Inês, aos fármacos: penicilina, amoxicilina, ampicilina, estreptomicina, oxaciclina, neomicina, cefalotina, gentamicina e sulfonamida. A resistência à sulfonamida foi a mais frequente (27,3%), seguida pela estreptomicina (14,0%) e pela oxaciclina (14,0%), enquanto da gentamicina (1,6%) foi a menos frequente. Todas as cepas foram sensíveis a pelo menos um antimicrobiano, e 20,3% das cepas apresentaram resistência múltipla. Os resultados mostram a importância de Staphylococci coagulase-negativas como agentes causadores de mastite em ovinos, e o perfil de resistência múltipla indica a importância da determinação da resistência à oxaciclina como indicador da presença de ilhas de patogenicidade que contêm fatores de virulência e resistência a outros antimicrobianos que contribuem para a sobrevivência da bactéria ao tratamento.Fundação de Amparo à Pesquisa do Estado de São Paulo (FAPESP

White-box compression: Learning and exploiting compact table representations

We formulate a conceptual model for white-box compression, which represents the logical columns in tabular data as an openly defined function over some actually stored physical columns. Each block of data should thus go accompanied by a header that describes this functional mapping. Because these compression functions are openly defined, database systems can exploit them using query optimization and during execution, enabling e.g. better filter predicate pushdown. In addition, we show that white-box compression is able to identify a broad variety of new opportunities for compression, leading to much better compression factors. These opportunities are identified using an automatic learning process that learns the functions from the data. We provide a recursive pattern-driven algorithm for such learning. Finally, we demonstrate the effectiveness of white-box compression on a new benchmark we contribute hereby: the Public BI benchmark provides a rich set of real-world datasets.We believe our basic prototype for white-box compression opens the way for future research into transparent compressed data representations on the one hand and database system architectures that can efficiently exploit these on the other, and should be seen as another step into the direction of data management systems that are self-learning and optimize themselves for the data they are deployed on.</p

Ab initio calculations for bromine adlayers on the Ag(100) and Au(100) surfaces: the c(2x2) structure

Ab initio total-energy density-functional methods with supercell models have been employed to calculate the c(2x2) structure of the Br-adsorbed Ag(100) and Au(100) surfaces. The atomic geometries of the surfaces and the preferred bonding sites of the bromine have been determined. The bonding character of bromine with the substrates has also been studied by analyzing the electronic density of states and the charge transfer. The calculations show that while the four-fold hollow-site configuration is more stable than the two-fold bridge-site topology on the Ag(100) surface, bromine prefers the bridge site on the Au(100) surface. The one-fold on-top configuration is the least stable configuration on both surfaces. It is also observed that the second layer of the Ag substrate undergoes a small buckling as a consequence of the adsorption of Br. Our results provide a theoretical explanation for the experimental observations that the adsorption of bromine on the Ag(100) and Au(100) surfaces results in different bonding configurations.Comment: 10 pages, 4 figure, 5 tables, Phys. Rev. B, in pres

How to dissect viral infections and their interplay with the host-proteome by immunoaffinity and mass spectrometry: A tutorial

The capabilities of bioanalytical mass spectrometry to (i) detect and differentiate viruses at the peptide level whilst maintaining high sample throughput and (ii) to provide diagnosis and prognosis for infected patients are presented as a tutorial in this work to aid analytical chemists and physicians to gain insights into the possibilities offered by current high-resolution mass spectrometry technology and bioinformatics. From (i) sampling to sample treatment; (ii) Matrix-Assisted Laser Desorption Ionization- to Electrospray Ionization -based mass spectrometry; and (iii) from clustering to peptide sequencing; a detailed step-by-step guide is provided and exemplified using SARS-CoV-2 Spike Y839 variant and the variant of concern SARS-CoV-2 Alpha (B.1.1.7 lineage), Influenza B, and Influenza A subtypes AH1N1pdm09 and AH3N2.Highlights: - Immunohistochemistry with magnetic core nanoparticles to isolate viruses. - The use of MALDI-MS for rapid virus detection is explained in detail; - The use of ESI-MS/MS to pinpoint host-patient crosstalk is explained in detail. - The absolute quantitative MS is explained for large-scale protein quantitation.This work received financial support from PT national funds (FCT/MCTES) through the projects UIDB/50006/2020 and UIDP/50006/2020 and from PROTEOMASS Scientific Society through the projects #PM001/2019 and #PM003/2016.info:eu-repo/semantics/publishedVersio

Large scale numerical investigation of excited states in poly(phenylene)

A density matrix renormalisation group scheme is developed, allowing for the first time essentially exact numerical solutions for the important excited states of a realistic semi-empirical model for oligo-phenylenes. By monitoring the evolution of the energies with chain length and comparing them to the experimental absorption peaks of oligomers and thin films, we assign the four characteristic absorption peaks of phenyl-based polymers. We also determine the position and nature of the nonlinear optical states in this model.Comment: RevTeX, 10 pages, 4 eps figures included using eps