WIQ:Work-intensive query scheduling for in-memory database systems

We propose a novel admission control policy for database queries. Our methodology uses system measurements of CPU utilization and query backlogs to determine interference between queries in execution on the same database server. Query interference may arise due to the concurrent access of hardware and software resources and can affect performance in positive and negative ways. Specifically our admission control considers the mix of jobs in service and prioritizes the query classes consuming CPU resources more efficiently. The policy ignores I/O subsystems and is therefore highly appropriate for in-memory databases. We validate our approach in trace-driven simulation and show performance increases of query slowdowns and throughputs compared to first-come first-served and shortest expected processing time first scheduling. Simulation experiments are parameterized from system traces of a SAP HANA in-memory database installation with TPC-H type workloads. © 2012 IEEE.

Autobiographical memory specificity, depression, and trauma in bipolar disorder

Objectives. In a bipolar disorder (BD) sample, the present study investigated: (i) the prevalence of trauma; (ii) the specificity of autobiographical memory (AM); (iii) the influence of childhood trauma on AM specificity, current inter-episode depressive mood, and BD severity; (iv) if AM specificity moderates the influence of childhood trauma on current inter-episode depressive mood and BD severity.

Methods. Fifty-two participants were recruited from a geographically well-defined mental health service in Northern Ireland. The AM test, self-report measures of lifetime experience of trauma, childhood trauma, and depression were administered. Severity of BD was estimated utilizing a systematic tool for reviewing all available clinical data of participants.

Results. A high prevalence of trauma was found. A total of 94.2% (49/52) of participants reported experiencing a traumatic event in either childhood or adulthood. AM specificity was significantly lower than previous reports of such in major depression. However, whilst childhood trauma predicted current inter-episode depressive mood, childhood trauma was not predictive of BD severity or AM specificity. Moreover, the association between childhood trauma and depressed mood was not moderated by AM specificity.

Conclusions. The findings of this study suggest a relationship between early psychosocial adversity and current inter-episode depressive mood in BD. In addition, levels of overgeneral AM are similar to that reported for depression, but are unrelated to childhood trauma, current inter-episode depressive mood, or BD severity. Clinical implications include the importance of routine assessment of trauma in BD and the need for adjunctive evidenced-based psychological therapies.

A Comparison of Programming Models for Multiprocessors with Explicitly Managed Memory Hierarchies

On multiprocessors with explicitly managed memory hierarchies (EMM), software has the responsibility of moving data in and out of fast local memories. This task can be complex and error-prone even for expert programmers. Before we can allow compilers to handle the complexity for us, we must identify the abstractions that are general enough to allow us to write applications with reasonable effort, yet speci?c enough to exploit the vast on-chip memory bandwidth of EMM multi-processors. To this end, we compare two programming models against hand-tuned codes on the STI Cell, paying attention to programmability and performance. The ?rst programming model, Sequoia, abstracts the memory hierarchy as private address spaces, each corresponding to a parallel task. The second, Cellgen, is a new framework which provides OpenMP-like semantics and the abstraction of a shared address spaces divided into private and shared data. We compare three applications programmed using these models against their hand-optimized counterparts in terms of abstractions, programming complexity, and performance.

Cognitive biases and addiction: an evolution in theory and method

An evolution in theoretical models and methodological paradigms for investigating cognitive biases in the addictions is discussed. Anomalies in traditional cognitive perspectives, and problems with the self-report methods which underpin them, are highlighted. An emergent body of cognitive research, contextualized within the principles and paradigms of cognitive neuropsychology rather than social learning theory, is presented which, it is argued, addresses these anomalies and problems. Evidence is presented that biases in the processing of addiction-related stimuli, and in the network of propositions which motivate addictive behaviours, occur at automatic, implicit and pre-conscious levels of awareness. It is suggested that methods which assess such implicit cognitive biases (e.g. Stroop, memory, priming and reaction-time paradigms) yield findings which have better predictive utility for ongoing behaviour than those biases determined by self-report methods of introspection. The potential utility of these findings for understanding "loss of control" phenomena, and the desynchrony between reported beliefs and intentions and ongoing addictive behaviours, is discussed. Applications to the practice of cognitive therapy are considered.