Forecasting the cost of processing multi-join queries via hashing for main-memory databases (Extended version)

Database management systems (DBMSs) carefully optimize complex multi-join queries to avoid expensive disk I/O. As servers today feature tens or hundreds of gigabytes of RAM, a significant fraction of many analytic databases becomes memory-resident. Even after careful tuning for an in-memory environment, a linear disk I/O model such as the one implemented in PostgreSQL may make query response time predictions that are up to 2X slower than the optimal multi-join query plan over memory-resident data. This paper introduces a memory I/O cost model to identify good evaluation strategies for complex query plans with multiple hash-based equi-joins over memory-resident data. The proposed cost model is carefully validated for accuracy using three different systems, including an Amazon EC2 instance, to control for hardware-specific differences. Prior work in parallel query evaluation has advocated right-deep and bushy trees for multi-join queries due to their greater parallelization and pipelining potential. A surprising finding is that the conventional wisdom from shared-nothing disk-based systems does not directly apply to the modern shared-everything memory hierarchy. As corroborated by our model, the performance gap between the optimal left-deep and right-deep query plan can grow to about 10X as the number of joins in the query increases.Comment: 15 pages, 8 figures, extended version of the paper to appear in SoCC'1

Upgrade of the Glasgow photon tagging spectrometer for Mainz MAMI-C

The Glasgow photon tagging spectrometer at Mainz has been upgraded so that it can be used with the 1500 MeV electron beam now available from the Mainz microtron MAMI-C. The changes made and the resulting properties of the spectrometer are discussed.Comment: 20 pages, 12 figure

Textural variations in Neogene pelagic carbonate ooze at DSDP Site 593, southern Tasman Sea, and their paleoceanographic implications

Changes in Neogene sediment texture in pelagic carbonate-rich oozes on the Challenger Plateau, southern Tasman Sea, are used to infer changes in depositional paleocurrent velocities. The most obvious record of textural change is in the mud:sand ratio. Increases in the sand content are inferred to indicate a general up-core trend towards increasing winnowing of sediments resulting from increasing flow velocity of Southern Component Intermediate Water (SCIW), the forerunner of Antarctic Intermediate Water. In particular, the intervals c. 19-14.5 Ma, c. 9.5-8 Ma, and after 5 Ma are suggested to be times of increased SCIW velocity and strong sediment winnowing. Within the mud fraction, the fine silt to coarse clay sizes from 15.6 to 2 µm make the greatest contribution to the sediments and are composed of nannofossil plates. During extreme winnowing events it is the fine silt to very coarse clay material (13-3 µm) within this range that is preferentially removed, suggesting the 10 µm cohesive silt boundary reported for siliciclastic sediments does not apply to calcitic skeletal grains. The winnowed sediment comprises coccolithophore placoliths and spheres, represented by a mode at 4-7 µm. Further support for seafloor winnowing is gained from the presence in Hole 593 of a condensed sedimentary section from c. 18 to 14 Ma where the sand content increases to c. 20% of the bulk sample. Associated with the condensed section is a 6 m thick orange unit representing sediments subjected to particularly oxygen-rich, late early to early middle Miocene SCIW. Together these are inferred to indicate increased SCIW velocity resulting in winnowed sediment associated with faster arrival of oxygen-rich surface water subducted to form SCIW. Glacial development of Antarctica has been recorded from many deep-sea sites, with extreme glacials providing the mechanism to increase watermass flow. Miocene glacial zones Mi1b-Mi6 are identified in an associated oxygen isotope record from Hole 593, and correspond with times of particularly invigorated paleocirculation, bottom winnowing, and sediment textural changes

A cross-sectional study on the deprivation and sex differences in health-related fitness measures in school children

This study aimed to investigate deprivation and sex differences in selected health-relatedfitness measures in 9-12-year-old children. Data were captured on 3,407 children (49.3% boys; aged 10.5 ± 0.6 years). Cardiorespiratory fitness(20 m multistage shuttle run test; 20 m MSRT), muscular strength (handgrip strength) and body mass index (BMI) were measured. Welsh Index of Multiple Deprivation (WIMD) scores were used to make quintile groups. A two-way Analysis of Variance examined differences in BMI z-score by sex and WIMD quintiles. Two-wayAnalysis of Covariances investigated the effect of sex and WIMD quintiles on grip strength and shuttles achieved in 20 m MSRT, adjusting for BMI z-score and maturation, repectively. Independent of sex, children in the middle quintile had a significantly higher mean BMI z-score (p = 0.029) than their least deprived counterparts. There was a significant increase in grip strength (p = 0.005) and20 m MSRT (boys p < 0.001; girls p = 0.028) between most and least deprived quintiles. Significant differences in 20 m MSRT score were more apparent with decreases in deprivation in boys.Overall, inequalities exist in health-related fitness by sex and deprivation. These results can be used to inform focused services to improve current and future health

Promoting Physical Activity in Middle School Girls: Trial of Activity for Adolescent Girls

Background - Physical activity is important for weight control and good health; however, activity levels decline in the adolescent years, particularly in girls. Design - Group randomized controlled trial. Setting/participants - Middle school girls with English-speaking skills and no conditions to prevent participation in physical activity in 36 schools in six geographically diverse areas of the United States. Random, cross-sectional samples were drawn within schools: 6th graders in 2003 (n=1721) and 8th graders in 2005 (n=3504) and 2006 (n=3502). Intervention - A 2-year study-directed intervention (fall 2003 to spring 2005) targeted schools, community agencies, and girls to increase opportunities, support, and incentives for increased physical activity. Components included programs linking schools and community agencies, physical education, health education, and social marketing. A third-year intervention used school and community personnel to direct intervention activities. Main outcome measures - The primary outcome, daily MET-weighted minutes of moderate-to-vigorous physical activity (MET-weighted MVPA), was assessed using accelerometry. Percent body fat was assessed using anthropometry. Results - After the staff-directed intervention (pre-stated primary outcome), there were no differences (mean=-0.4, 95% CI=-8.2 to 7.4) in adjusted MET-weighted MVPA between 8th-grade girls in schools assigned to intervention or control. Following the Program Champion-directed intervention, girls in intervention schools were more physically active than girls in control schools (mean difference 10.9 MET-weighted minutes of MVPA, 95% CI=0.52-21.2). This difference is about 1.6 minutes of daily MVPA or 80 kcal per week. There were no differences in fitness or percent body fat at either 8th-grade timepoint. Conclusion - A school-based, community-linked intervention modestly improved physical activity in girls

The toilet debate: stalling trans possibilities and defending ‘women's protected spaces’

As one of the few explicitly gender-separated spaces, the toilet has become a prominent site of conflict and a focal point for ‘gender-critical’ feminism. In this article we draw upon an AHRC-funded project, Around the Toilet, to reflect upon and critique trans-exclusionary and trans-hostile narratives of toilet spaces. Such narratives include ciscentric, heteronormative and gender essentialist positions within toilet research and activism which, for example, equate certain actions and bodily functions (such as menstruation) to a particular gender, decry the need for all-gender toilets, and cast suspicion upon the intentions of trans women in public toilet spaces. These include explicitly transmisogynist discourses perpetuated largely by those calling themselves ‘gender-critical’ feminists, but also extend to national media, right-wing populist discourses and beyond. We use Around the Toilet data to argue that access to safe and comfortable toilets plays a fundamental role in making trans lives possible. Furthermore, we contend that – whether naive, ignorant or explicitly transphobic – trans-exclusionary positions do little to improve toilet access for the majority, instead putting trans people, and others with visible markers of gender difference, at a greater risk of violence, and participating in the dangerous homogenisation of womanhood

Maternal nutritional status, food intake and pregnancy weight gain in Nepal

This is the author's accepted version (version 2) of an article published by SAGE in Journal of Health Management, March 2016. The published version is available at http://pss.sagepub.com/lookup/doi/10.1177/0972063415625537Poor maternal nutrition during pregnancy may predispose to intrauterine growth restriction (IUGR), immunological and metabolic adaptations which manifest as low birth weight and increase the risk of adult non-communicable disease. This study examined the relationships between maternal nutritional status, food intake and pregnancy weight gain (PWG) which may account for risk of low birth weight (LBW) in Nepal

Epigenome-wide analysis links SMAD3 methylation at birth to asthma in children of asthmatic mothers

Background The timing and mechanisms of asthma inception remain imprecisely defined. Although epigenetic mechanisms likely contribute to asthma pathogenesis, little is known about their role in asthma inception. Objective We sought to assess whether the trajectory to asthma begins already at birth and whether epigenetic mechanisms, specifically DNA methylation, contribute to asthma inception. Methods We used the Methylated CpG Island Recovery Assay chip to survey DNA methylation in cord blood mononuclear cells from 36 children (18 nonasthmatic and 18 asthmatic subjects by age 9 years) from the Infant Immune Study (IIS), an unselected birth cohort closely monitored for asthma for a decade. SMAD3 methylation in IIS (n = 60) and in 2 replication cohorts (the Manchester Asthma and Allergy Study [n = 30] and the Childhood Origins of Asthma Study [n = 28]) was analyzed by using bisulfite sequencing or Illumina 450K arrays. Cord blood mononuclear cell–derived IL-1β levels were measured by means of ELISA. Results Neonatal immune cells harbored 589 differentially methylated regions that distinguished IIS children who did and did not have asthma by age 9 years. In all 3 cohorts methylation in SMAD3, the most connected node within the network of asthma-associated, differentially methylated regions, was selectively increased in asthmatic children of asthmatic mothers and was associated with childhood asthma risk. Moreover, SMAD3 methylation in IIS neonates with maternal asthma was strongly and positively associated with neonatal production of IL-1β, an innate inflammatory mediator. Conclusions The trajectory to childhood asthma begins at birth and involves epigenetic modifications in immunoregulatory and proinflammatory pathways. Maternal asthma influences epigenetic mechanisms that contribute to the inception of this trajectory