Write-limited sorts and joins for persistent memory

To mitigate the impact of the widening gap between the memory needs of CPUs and what standard memory technology can deliver, system architects have introduced a new class of memory technology termed persistent memory. Persistent memory is byteaddressable, but exhibits asymmetric I/O: writes are typically one order of magnitude more expensive than reads. Byte addressability combined with I/O asymmetry render the performance profile of persistent memory unique. Thus, it becomes imperative to find new ways to seamlessly incorporate it into database systems. We do so in the context of query processing. We focus on the fundamental operations of sort and join processing. We introduce the notion of write-limited algorithms that effectively minimize the I/O cost. We give a high-level API that enables the system to dynamically optimize the workflow of the algorithms; or, alternatively, allows the developer to tune the write profile of the algorithms. We present four different techniques to incorporate persistent memory into the database processing stack in light of this API. We have implemented and extensively evaluated all our proposals. Our results show that the algorithms deliver on their promise of I/O-minimality and tunable performance. We showcase the merits and deficiencies of each implementation technique, thus taking a solid first step towards incorporating persistent memory into query processing. 1

Improving DRAM Performance by Parallelizing Refreshes with Accesses

Modern DRAM cells are periodically refreshed to prevent data loss due to leakage. Commodity DDR DRAM refreshes cells at the rank level. This degrades performance significantly because it prevents an entire rank from serving memory requests while being refreshed. DRAM designed for mobile platforms, LPDDR DRAM, supports an enhanced mode, called per-bank refresh, that refreshes cells at the bank level. This enables a bank to be accessed while another in the same rank is being refreshed, alleviating part of the negative performance impact of refreshes. However, there are two shortcomings of per-bank refresh. First, the per-bank refresh scheduling scheme does not exploit the full potential of overlapping refreshes with accesses across banks because it restricts the banks to be refreshed in a sequential round-robin order. Second, accesses to a bank that is being refreshed have to wait. To mitigate the negative performance impact of DRAM refresh, we propose two complementary mechanisms, DARP (Dynamic Access Refresh Parallelization) and SARP (Subarray Access Refresh Parallelization). The goal is to address the drawbacks of per-bank refresh by building more efficient techniques to parallelize refreshes and accesses within DRAM. First, instead of issuing per-bank refreshes in a round-robin order, DARP issues per-bank refreshes to idle banks in an out-of-order manner. Furthermore, DARP schedules refreshes during intervals when a batch of writes are draining to DRAM. Second, SARP exploits the existence of mostly-independent subarrays within a bank. With minor modifications to DRAM organization, it allows a bank to serve memory accesses to an idle subarray while another subarray is being refreshed. Extensive evaluations show that our mechanisms improve system performance and energy efficiency compared to state-of-the-art refresh policies and the benefit increases as DRAM density increases.Comment: The original paper published in the International Symposium on High-Performance Computer Architecture (HPCA) contains an error. The arxiv version has an erratum that describes the error and the fix for i

School-Based Telemedicine Interventions for Asthma: A Systematic Review.

BackgroundSchool health systems are increasingly investing in telemedicine platforms to address acute and chronic illnesses. Asthma, the most common chronic illness in childhood, is of particular interest given its high burden on school absenteeism.ObjectiveConduct a systematic review evaluating impact of school-based telemedicine programs on improving asthma-related outcomes.Data sourcesPubMed, Cochrane CENTRAL, CINAHL, ERIC, PsycINFO, Embase, and Google Scholar.Study eligibility criteriaOriginal research, including quasi-experimental studies, without restriction on the type of telemedicine.ParticipantsSchool-aged pediatric patients with asthma and their families.InterventionsSchool-based telemedicine.Study appraisal and synthesis methodsTwo authors independently screened each abstract, conducted full-text review, assessed study quality, and extracted information. A third author resolved disagreements.ResultsOf 371 articles identified, 7 were included for the review. Outcomes of interest were asthma symptom-free days, asthma symptom frequency, quality of life, health care utilization, school absences, and spirometry. Four of 7 studies reported significant increases in symptom-free days and/or decrease in symptom frequency. Five of 6 reported increases in at least one quality-of-life metric, 2 of 7 reported a decrease in at least 1 health care utilization metric, 1 of 3 showed reductions in school absences, and 1 of 2 reported improvements in spirometry measures.LimitationsVariability in intervention designs and outcome measures make comparisons and quantitative analyses across studies difficult. Only 2 of 7 studies were randomized controlled trials.Conclusions and implications of key findingsHigh-quality evidence supporting the use of school-based telemedicine programs to improve patient outcomes is limited. While available evidence suggests benefit, only 2 comparative trials were identified, and the contribution of telemedicine to these studies' results is unclear

Influence of Social Motivations on Spectator Consumption Behavior of a Formula One Grand Prix Event

The purpose of this study was to examine the relationship between spectator motivation and sport consumption behavior in the context of F-1 events. Respondents were spectators from three Formula One (F-1) races held in Shanghai, China. Through a structural equation modeling analysis, Achievement Seeking and Salubrious Effects were found to be related to repurchase intentions. Three motivating factors (i.e., Achievement Seeking, Entertainment, and Catharsis) were also found to be associated with Word-of-Mouth intentions concerning F-1 events

Recruitment, growth and mortality of an Antarctic hexactinellid sponge, Anoxycalyx joubini.

Polar ecosystems are sensitive to climate forcing, and we often lack baselines to evaluate changes. Here we report a nearly 50-year study in which a sudden shift in the population dynamics of an ecologically important, structure-forming hexactinellid sponge, Anoxycalyx joubini was observed. This is the largest Antarctic sponge, with individuals growing over two meters tall. In order to investigate life history characteristics of Antarctic marine invertebrates, artificial substrata were deployed at a number of sites in the southern portion of the Ross Sea between 1967 and 1975. Over a 22-year period, no growth or settlement was recorded for A. joubini on these substrata; however, in 2004 and 2010, A. joubini was observed to have settled and grown to large sizes on some but not all artificial substrata. This single settlement and growth event correlates with a region-wide shift in phytoplankton productivity driven by the calving of a massive iceberg. We also report almost complete mortality of large sponges followed over 40 years. Given our warming global climate, similar system-wide changes are expected in the future

Simplified three-dimensional tissue clearing and incorporation of colorimetric phenotyping.

Tissue clearing methods promise to provide exquisite three-dimensional imaging information; however, there is a need for simplified methods for lower resource settings and for non-fluorescence based phenotyping to enable light microscopic imaging modalities. Here we describe the simplified CLARITY method (SCM) for tissue clearing that preserves epitopes of interest. We imaged the resulting tissues using light sheet microscopy to generate rapid 3D reconstructions of entire tissues and organs. In addition, to enable clearing and 3D tissue imaging with light microscopy methods, we developed a colorimetric, non-fluorescent method for specifically labeling cleared tissues based on horseradish peroxidase conversion of diaminobenzidine to a colored insoluble product. The methods we describe here are portable and can be accomplished at low cost, and can allow light microscopic imaging of cleared tissues, thus enabling tissue clearing and imaging in a wide variety of settings

Evaluating User Satisfaction and Organisational Benefits of Electronic Medication Management System in an Australian Hospital

In this conceptual paper, we speculate on the possibility that a PhD by Artefact and Exegesis (A&E) may be legitimate in the Information Systems (IS) discipline. Research, as creative process and product with the intention of yielding new knowledge, takes many forms across the spectrum of academic disciplines. Other disciplines, particularly in the humanities’ fields of arts and design, have artefacts as a discrete part of their PhD product accompanied by an exegesis of one form or another. It may be that some research in the IS discipline lends itself to the A&E approach. This paper considers A&E PhDs in Humanities and how practice-based research is presented. We explore how A&E might apply to IS research, through comparison with the design science approach. We suggest tentative impacts on candidates, supervisors and examiners then conclude with the issues and open questions raised by our investigations

Vesicular glutamatergic transmission in noise-induced loss and repair of cochlear ribbon synapses

Noise-induced excitotoxicity is thought to depend on glutamate. However, the excitotoxic mechanisms are unknown, and the necessity of glutamate for synapse loss or regeneration is unclear. Despite absence of glutamatergic transmission from cochlear inner hair cells in mice lacking the vesicular glutamate transporter-3