On the Impact of Memory Allocation on High-Performance Query Processing

Somewhat surprisingly, the behavior of analytical query engines is crucially affected by the dynamic memory allocator used. Memory allocators highly influence performance, scalability, memory efficiency and memory fairness to other processes. In this work, we provide the first comprehensive experimental analysis on the impact of memory allocation for high-performance query engines. We test five state-of-the-art dynamic memory allocators and discuss their strengths and weaknesses within our DBMS. The right allocator can increase the performance of TPC-DS (SF 100) by 2.7x on a 4-socket Intel Xeon server

Counting Zariski chambers on Del Pezzo surfaces

Zariski chambers provide a natural decomposition of the big cone of an algebraic surface into rational locally polyhedral subcones that are interesting from the point of view of linear series. In the present paper we present an algorithm that allows to effectively determine Zariski chambers when the negative curves on the surface are known. We show how the algorithm can be used to compute the number of chambers on Del Pezzo surfaces

Foreign National Patients in German Prison Psychiatry

Introduction: Over the past few years, the share of foreign national prisoners in the European and American justice systems has increased at a disproportionately high rate, yet studies on mental health issues among this diverse group are rare. Recent research suggests a range of factors leading to mental health vulnerability in foreign national prisoners, including language barriers, isolation, cultural misunderstanding, and legal standing. Relevant findings of topic-related studies indicate that under-referral to mental health services due to missed or misinterpreted symptoms is a major risk for foreign national prisoners. Aims: We aimed to investigate the disparities regarding the percentage of foreign national patients who were treated in high-security hospitals compared to the psychiatric ward of prison hospitals-after adjusting for diagnosis, age, marital status, and substance abuse. We hypothesized that foreign national patients were underrepresented in compulsory, high-security mental health care. We also aimed to explore citizenship-related institutional disparities concerning diagnoses and self-harmful behavior. Method: From 2010 to 2015, data collected from high-security hospitals in the federal state of Baden-Wurttemberg and the psychiatric ward of a Berlin prison hospital was evaluated by comparing nationality, diagnosis, and self-harm using Fisher's exact test and χ²-test. The odds ratios for citizenship-related differences in diagnosis and institution of treatment were evaluated by using logistic regression. Results: Mentally ill foreign national patients were significantly less likely to be treated in high-security hospitals rather than prison hospital psychiatry (adjusted for diagnosis, age at admission, marital status, and substance abuse; adjusted OR = 0.5). Foreign nationals and Germans in prison hospital psychiatry showed no significant disparities in diagnosis; however, in high-security hospitals, foreign nationals were more likely to have been diagnosed with schizophrenia/psychotic or neurotic/stress-related disorders and were less likely to have been diagnosed with personality disorders than German patients. Additionally, foreign nationals were more likely to commit self-harm than Germans in prison hospital psychiatry, but significant citizenship-related differences could not be verified in high-security hospital patients. Conclusion: Treatment conditions of foreign national patients in prison psychiatry must be improved. To achieve this, the psychiatric assessment and (mental) health-related aspects of these patients should be further investigated

Massively Parallel Sort-Merge Joins in Main Memory Multi-Core Database Systems

Two emerging hardware trends will dominate the database system technology in the near future: increasing main memory capacities of several TB per server and massively parallel multi-core processing. Many algorithmic and control techniques in current database technology were devised for disk-based systems where I/O dominated the performance. In this work we take a new look at the well-known sort-merge join which, so far, has not been in the focus of research in scalable massively parallel multi-core data processing as it was deemed inferior to hash joins. We devise a suite of new massively parallel sort-merge (MPSM) join algorithms that are based on partial partition-based sorting. Contrary to classical sort-merge joins, our MPSM algorithms do not rely on a hard to parallelize final merge step to create one complete sort order. Rather they work on the independently created runs in parallel. This way our MPSM algorithms are NUMA-affine as all the sorting is carried out on local memory partitions. An extensive experimental evaluation on a modern 32-core machine with one TB of main memory proves the competitive performance of MPSM on large main memory databases with billions of objects. It scales (almost) linearly in the number of employed cores and clearly outperforms competing hash join proposals - in particular it outperforms the "cutting-edge" Vectorwise parallel query engine by a factor of four.Comment: VLDB201

Is the Albert H Kritzer Database Telling Us More Than We Know?

This article is the first in a series of articles attempting to provide a geographical and temporal overview of the application practice of the United Nations Convention on Contracts for the International Sale of Goods (CISG). In this first article, the success of CISG is explored. The article develops the idea of using the Albert H. Kritzer Database to achieve an overview of the success of the Convention in practice. It is argued that the success of the Convention is useful to measure by its uniformity in practice, and therefore a set of criteria relating to the Convention’s application by domestic courts are developed. The article contains a cursory study according to which the success of the Convention in Germany and China is considered, and the feasibility of the proposed study is assessed. The article concludes that a geographical and temporal overview of the Convention’s application would add to current discussions of revising the Convention and provide the basis for considering alternative ways to promote uniformity. The proposed study concludes that the Albert H. Kritzer Database is capable of shedding a new light on topics like transparency of decisions, the courts’ protection of their home industries, and the use of the concept of good faith. The article exposes a number of limitations when it comes to generalising about the entire trading community and providing detailed overview of uniformity over time

Commensurability classes of (-2,3,n) pretzel knot complements

Let K be a hyperbolic (-2,3,n) pretzel knot and M = S^3 K its complement. For these knots, we verify a conjecture of Reid and Walsh: there are at most three knot complements in the commensurability class of M. Indeed, if n \neq 7, we show that M is the unique knot complement in its class. We include examples to illustrate how our methods apply to a broad class of Montesinos knots.Comment: 15 pages, 1 figur

Critical market shares for investors and access seekers and competitive models in fibre networks

In this paper we consider and evaluate NGA architectures which meet the foreseeable future bandwidth demand and allow for highest bandwidth and quality for end-users and which no longer rely on copper cable elements. These are FTTH architectures only. From all available FTTH architectures we concentrate on the two most relevant architectures in Europe, Ethernet Point-to-Point and GPON. We assume the incumbent to be the investor in the NGA network infrastructure. If the NGA architecture is based on a Point-to-Point fibre plant we have modelled the competitors as using unbundled fibre loops as the wholesale access service. If the architecture is based on a Point-to-Multipoint fibre plant, we consider an active wholesale access (bitstream access) at the MPoP or at the core network node locations. Our basic modelling relies upon an engineering bottom-up cost modelling approach. We model the total cost of the services considered under efficient conditions, taking into account the cost of all network elements needed to produce these services in the specific architecture deployed. This approach is coherent with a Long Run Incremental Cost approach as applied in regulatory economics. Our modelling approach generates a broad set of results including the relative performance of the various network architectures, investment requirements and the degree of profitable coverage. In this paper, however, we focus on the results on the potential for competition and potential market structures in an NGA environment. --NGA architecture,cost modelling,FTTH,coverage,access models,unbundling

The Roots and Fruits of Good Faith in Domestic Court Practice

Good faith—most lawyers have an opinion on these two words. While the notion of good faith may play specific roles at domestic and regional levels, it remains an elusive siren at the international level. The concept was subject to controversy at the birth of the 1980 United Nations Convention on Contracts for the International Sale of Goods (CISG) and has been debated by scholars ever since. Considering that the Convention has now been in force for over thirty years, it is agreed that time is ripe for “a call to arms for further research into a uniform standard of good faith. This Article contributes to such further research as it unravels the life of good faith in court practice on a scale never before seen