Leveraging range joins for the computation of overlap joins

Joins are essential and potentially expensive operations in database management systems. When data is associated with time periods, joins commonly include predicates that require pairs of argument tuples to overlap in order to qualify for the result. Our goal is to enable built-in systems support for such joins. In particular, we present an approach where overlap joins are formulated as unions of range joins, which are more general purpose joins compared to overlap joins, i.e., are useful in their own right, and are supported well by B+-trees. The approach is sufficiently flexible that it also supports joins with additional equality predicates, as well as open, closed, and half-open time periods over discrete and continuous domains, thus offering both generality and simplicity, which is important in a system setting. We provide both a stand-alone solution that performs on par with the state-of-the-art and a DBMS embedded solution that is able to exploit standard indexing and clearly outperforms existing DBMS solutions that depend on specialized indexing techniques. We offer both analytical and empirical evaluations of the proposals. The empirical study includes comparisons with pertinent existing proposals and offers detailed insight into the performance characteristics of the proposals

Leveraging range joins for the computation of overlap joins

Joins are essential and potentially expensive operations in database management systems. When data is associated with time periods, joins commonly include predicates that require pairs of argument tuples to overlap in order to qualify for the result. Our goal is to enable built-in systems support for such joins. In particular, we present an approach where overlap joins are formulated as unions of range joins, which are more general purpose joins compared to overlap joins, i.e., are useful in their own right, and are supported well by B+-trees. The approach is sufficiently flexible that it also supports joins with additional equality predicates, as well as open, closed, and half-open time periods over discrete and continuous domains, thus offering both generality and simplicity, which is important in a system setting. We provide both a stand-alone solution that performs on par with the state-of-the-art and a DBMS embedded solution that is able to exploit standard indexing and clearly outperforms existing DBMS solutions that depend on specialized indexing techniques. We offer both analytical and empirical evaluations of the proposals. The empirical study includes comparisons with pertinent existing proposals and offers detailed insight into the performance characteristics of the proposals

Molecular gas in the immediate vicinity of Sgr A* seen with ALMA

We report serendipitous detections of line emission with ALMA in band 3, 6, and 7 in the central parsec of the Galactic center at an up to now highest resolution (<0.7''). Among the highlights are the very first and highly resolved images of sub-mm molecular emission of CS, H13CO+, HC3N, SiO, SO, C2H, and CH3OH in the immediate vicinity (~1'' in projection) of Sgr A* and in the circumnuclear disk (CND). The central association (CA) of molecular clouds shows three times higher CS/X (X: any other observed molecule) luminosity ratios than the CND suggesting a combination of higher excitation - by a temperature gradient and/or IR-pumping - and abundance enhancement due to UV- and/or X-ray emission. We conclude that the CA is closer to the center than the CND is and could be an infalling clump consisting of denser cloud cores embedded in diffuse gas. Moreover, we identified further regions in and outside the CND that are ideally suited for future studies in the scope of hot/cold core and extreme PDR/XDR chemistry and consequent star formation in the central few parsecs

Phylogeography of Francisella tularensis subspecies holarctica and epidemiology of tularemia in Switzerland.

Tularemia, an endemic disease that mainly affects wild animals and humans, is caused by Francisella tularensis subsp. holarctica (Fth) in Switzerland. The Swiss Fth population consist of multiple different subclades which are distributed throughout the country. The aim of this study is to characterize the genetic diversity of Fth in Switzerland and to describe the phylogeographic relationship of isolates by single nucleotide polymorphism (SNP) analysis. This analysis is combined with human surveillance data from reported cases over the last 10 years and in vitro and in silico antibiotic resistance tests to provide insight into the epidemiology of tularemia in Switzerland. We sequenced the whole genomes of 52 Fth strains of human or tick origin collected in Switzerland between 2009 and 2022 and analyzed together with all publicly available sequencing data of Swiss and European Fth. Next, we performed a preliminary classification with the established canonical single nucleotide polymorphism nomenclature. Furthermore, we tested 20 isolates from all main Swiss clades for antimicrobial susceptibility against a panel of antimicrobial agents. All 52 sequenced isolates from Switzerland belong to major clade B.6, specifically subclades B.45 and B.46, previously described in Western Europe. We were able to accurately reconstruct the population structure according to the global phylogenetic framework. No resistance to clinically recommended antibiotics could be identified in vitro or in silico in the western B.6 strains

Collection and classification of influence parameters for safety effectiveness of ADAS

Virtual scenario-based testing has become an acceptable method for evaluating safety effectiveness of advanced driver assistance systems (ADAS). Due to the complexity of the ADAS operating environment, the scenarios that an ADAS could face are almost infinite. Therefore, it is crucial to find critical scenarios to improve the efficiency of testing without compromising credibility. One popular method is to explore the parameterized scenario space using various intelligent search methods. Selecting parameters to parameterize the scenario space is particularly important to achieve good coverage and high efficiency. However, an extensive collection of (relevant) influence parameters is missing, which allows a thorough consideration when selecting parameters regarding specific scenarios. In addition, the general importance definition for individual influence parameters is not provided, regarding the potential influence of their variations on the safety effectiveness of ADAS, which can also be used as a reference while selecting parameters. Combining knowledge from different sources (the published literature, standardized test scenarios, accident analysis, autonomous vehicle disengagement, accident reports, and specific online surveys), this paper has summarized, in total, 94 influence parameters, given the general definitions of importance for 77 influence parameters based on cluster analysis algorithms. The list of influence parameters provides researchers and system developers a comprehensive basis for pre-selecting influence parameters for evaluating the safety effectiveness of ADAS by virtual scenario-based testing and helps check whether certain influence parameters can be a meaningful extension for the evaluation

Unconventional human T cells accumulate at the site of infection in response to microbial ligands and induce local tissue remodeling

The antimicrobial responsiveness and function of unconventional human T cells are poorly understood, with only limited access to relevant specimens from sites of infection. Peritonitis is a common and serious complication in individuals with end-stage kidney disease receiving peritoneal dialysis. By analyzing local and systemic immune responses in peritoneal dialysis patients presenting with acute bacterial peritonitis and monitoring individuals before and during defined infectious episodes, our data show that Vg9/ Vd2+ gd T cells and mucosal-associated invariant T cells accumulate at the site of infection with organisms producing (E)-4- hydroxy-3-methyl-but-2-enyl pyrophosphate and vitamin B2, respectively. Such unconventional human T cells are major producers of IFN-g and TNF-a in response to these ligands that are shared by many microbial pathogens and affect the cells lining the peritoneal cavity by triggering local inflammation and inducing tissue remodeling with consequences for peritoneal membrane integrity. Our data uncover a crucial role for Vg9/Vd2 T cells and mucosal-associated invariant T cells in bacterial infection and suggest that they represent a useful predictive marker for important clinical outcomes, which may inform future stratification and patient management. These findings are likely to be applicable to other acute infections where local activation of unconventional T cells contributes to the antimicrobial inflammatory response

60Co in Cast Steel Matrix: a European Interlaboratory Comparison for the Characterisation of New Activity Standards for Calibration of Gamma-ray Spectrometers in Metallurgy

International audience; Two series of activity standards of Co-60 in cast steel matrix, developed for the calibration of gamma-ray spectrometry systems in the metallurgical sector, were characterised using a European interlaboratory comparison among twelve National Metrology Institutes and one international organisation. The first standard, consisting of 14 disc shaped samples, was cast from steel contaminated during production ("originally"), and the second, consisting of 15 similar discs, from artificially-contaminated ("spiked") steel. The reference activity concentrations of Co-60 in the cast steel standards were (1.077 +/- 0.019) Bq g(-1) on 1 January 2013 12h00 UT and (1.483 +/- 0.022) Bq g(-1) on 1 June 2013 12h00 UT, respectively