Generating SQL queries from visual specifications

Abstract: Structured Query Language (SQL) is the most widely used declarative language for accessing relational databases, and an essential topic in introductory database courses in higher learning institutions. Despite the intuitiveness of SQL, formulating and comprehending written queries can be confusing, especially for undergraduate students. One major reason for this is that the simple syntax of SQL is often misleading and hard to comprehend. A number of tools have been developed to aid the comprehension of queries and improve the mental models of students concerning the underlying logic of SQL. Some of these tools employed visualisation and animation in their approach to aid the comprehension of SQL. This paper presents an interactive comprehension aid based on visualisation, specifically designed to support the SQL SELECT statement, an area identified in the literature as problematic for students. The visualisation tool uses visual specifications depicting SQL operations to build queries. This is expected to reduce the cognitive load of a student who is learning SQL. We have shown with an online survey that adopting visual specifications in teaching systems assist students in attaining a richer learning experience in introductory database courses

Maximum (prior) brain size, not atrophy, correlates with cognition in community-dwelling older people: a cross-sectional neuroimaging study

<p>Abstract</p> <p>Background</p> <p>Brain size is associated with cognitive ability in adulthood (correlation ~ .3), but few studies have investigated the relationship in normal ageing, particularly beyond age 75 years. With age both brain size and fluid-type intelligence decline, and regional atrophy is often suggested as causing decline in specific cognitive abilities. However, an association between brain size and intelligence may be due to the persistence of this relationship from earlier life.</p> <p>Methods</p> <p>We recruited 107 community-dwelling volunteers (29% male) aged 75–81 years for cognitive testing and neuroimaging. We used principal components analysis to derived a 'general cognitive factor' (g) from tests of fluid-type ability. Using semi-automated analysis, we measured whole brain volume, intracranial area (ICA) (an estimate of maximal brain volume), and volume of frontal and temporal lobes, amygdalo-hippocampal complex, and ventricles. Brain atrophy was estimated by correcting WBV for ICA.</p> <p>Results</p> <p>Whole brain volume (WBV) correlated with general cognitive ability (g) (r = .21, P < .05). Statistically significant associations between brain areas and specific cognitive abilities became non-significant when corrected for maximal brain volume (estimated using ICA), i.e. there were no statistically significant associations between atrophy and cognitive ability. The association between WBV and g was largely attenuated (from .21 to .03: i.e. attenuating the variance by 98%) by correcting for ICA. ICA accounted for 6.2% of the variance in g in old age, whereas atrophy accounted for < 1%.</p> <p>Conclusion</p> <p>The association between brain regions and specific cognitive abilities in community dwelling people of older age is due to the life-long association between whole brain size and general cognitive ability, rather than atrophy of specific regions. Researchers and clinicians should therefore be cautious of interpreting global or regional brain atrophy on neuroimaging as contributing to cognitive status in older age without taking into account prior mental ability and brain size.</p

Faculty verbal evaluations reveal strategies used to promote medical student performance

Background: Preceptors rarely follow medical students&#x2019; developing clinical performance over time and across disciplines. This study analyzes preceptors&#x2019; descriptions of longitudinal integrated clerkship (LIC) students&#x2019; clinical development and their identification of strategies to guide students&#x2019; progress. Methods: We used a common evaluation framework, reporter-interpreter-manager-educator, to guide multidisciplinary LIC preceptors&#x2019; discussions of students&#x2019; progress. We conducted thematic analysis of transcripts from preceptors&#x2019; (seven longitudinal ambulatory preceptors per student) quarterly group discussions of 15 students&#x2019; performance over one year. Results: All students&#x2019; clinical development progressed, although most experienced obstacles. Lack of structure in the history and physical exam commonly obstructed progression. Preceptors used templates for data gathering, and modeling or experiences in the inpatient setting to provide time and solidify structure. To advance students&#x2019; knowledge acquisition, many preceptors identified focused learning topics with their students; to promote application of knowledge, preceptors used reasoning strategies to teach the steps involved in synthesizing clinical data. Preceptors shared accountability for helping students advance as the LIC allowed them to follow students&#x2019; response to teaching strategies. Discussion: These results depict preceptors&#x2019; perceptions of LIC students&#x2019; developmental continuum and illustrate how multidisciplinary preceptors can use a common evaluation framework to identify strategies to improve performance and follow students&#x2019; performance longitudinally

An integrated systems biology approach to the study of preterm birth using "-omic" technology - a guideline for research

Preterm birth is the leading cause of neonatal mortality and perinatal morbidity. The etiology of preterm is multi-factorial and still unclear. As evidence increases for a genetic contribution to PTB, so does the need to explore genomics, transcriptomics, proteomics and metabolomics in its study. This review suggests research guidelines for the conduct of high throughput systems biology investigations into preterm birth with the expectation that this will facilitate the sharing of samples and data internationally through consortia, generating the power needed to study preterm birth using integrated "-omics" technologies. The issues to be addressed include: (1) integrated "-omics" approaches, (2) phenotyping, (3) sample collection, (4) data management-integrative databases, (5) international consortia and (6) translational feasibility. This manuscript is the product of discussions initiated by the "-Omics" Working Group at the Preterm Birth International Collaborative Meeting held at the World Health Organization, Geneva, Switzerland in April 2009

Enteric Microbiome Metabolites Correlate with Response to Simvastatin Treatment

Although statins are widely prescribed medications, there remains considerable variability in therapeutic response. Genetics can explain only part of this variability. Metabolomics is a global biochemical approach that provides powerful tools for mapping pathways implicated in disease and in response to treatment. Metabolomics captures net interactions between genome, microbiome and the environment. In this study, we used a targeted GC-MS metabolomics platform to measure a panel of metabolites within cholesterol synthesis, dietary sterol absorption, and bile acid formation to determine metabolite signatures that may predict variation in statin LDL-C lowering efficacy. Measurements were performed in two subsets of the total study population in the Cholesterol and Pharmacogenetics (CAP) study: Full Range of Response (FR), and Good and Poor Responders (GPR) were 100 individuals randomly selected from across the entire range of LDL-C responses in CAP. GPR were 48 individuals, 24 each from the top and bottom 10% of the LDL-C response distribution matched for body mass index, race, and gender. We identified three secondary, bacterial-derived bile acids that contribute to predicting the magnitude of statin-induced LDL-C lowering in good responders. Bile acids and statins share transporters in the liver and intestine; we observed that increased plasma concentration of simvastatin positively correlates with higher levels of several secondary bile acids. Genetic analysis of these subjects identified associations between levels of seven bile acids and a single nucleotide polymorphism (SNP), rs4149056, in the gene encoding the organic anion transporter SLCO1B1. These findings, along with recently published results that the gut microbiome plays an important role in cardiovascular disease, indicate that interactions between genome, gut microbiome and environmental influences should be considered in the study and management of cardiovascular disease. Metabolic profiles could provide valuable information about treatment outcomes and could contribute to a more personalized approach to therapy

13C Metabolic Flux Analysis Identifies an Unusual Route for Pyruvate Dissimilation in Mycobacteria which Requires Isocitrate Lyase and Carbon Dioxide Fixation

Mycobacterium tuberculosis requires the enzyme isocitrate lyase (ICL) for growth and virulence in vivo. The demonstration that M. tuberculosis also requires ICL for survival during nutrient starvation and has a role during steady state growth in a glycerol limited chemostat indicates a function for this enzyme which extends beyond fat metabolism. As isocitrate lyase is a potential drug target elucidating the role of this enzyme is of importance; however, the role of isocitrate lyase has never been investigated at the level of in vivo fluxes. Here we show that deletion of one of the two icl genes impairs the replication of Mycobacterium bovis BCG at slow growth rate in a carbon limited chemostat. In order to further understand the role of isocitrate lyase in the central metabolism of mycobacteria the effect of growth rate on the in vivo fluxes was studied for the first time using 13C-metabolic flux analysis (MFA). Tracer experiments were performed with steady state chemostat cultures of BCG or M. tuberculosis supplied with 13C labeled glycerol or sodium bicarbonate. Through measurements of the 13C isotopomer labeling patterns in protein-derived amino acids and enzymatic activity assays we have identified the activity of a novel pathway for pyruvate dissimilation. We named this the GAS pathway because it utilizes the Glyoxylate shunt and Anapleurotic reactions for oxidation of pyruvate, and Succinyl CoA synthetase for the generation of succinyl CoA combined with a very low flux through the succinate – oxaloacetate segment of the tricarboxylic acid cycle. We confirm that M. tuberculosis can fix carbon from CO2 into biomass. As the human host is abundant in CO2 this finding requires further investigation in vivo as CO2 fixation may provide a point of vulnerability that could be targeted with novel drugs. This study also provides a platform for further studies into the metabolism of M. tuberculosis using 13C-MFA

Global report on preterm birth and stillbirth (2 of 7): discovery science

<p>Abstract</p> <p>Background</p> <p>Normal and abnormal processes of pregnancy and childbirth are poorly understood. This second article in a global report explains what is known about the etiologies of preterm births and stillbirths and identifies critical gaps in knowledge. Two important concepts emerge: the continuum of pregnancy, beginning at implantation and ending with uterine involution following birth; and the multifactorial etiologies of preterm birth and stillbirth. Improved tools and data will enable discovery scientists to identify causal pathways and cost-effective interventions.</p> <p>Pregnancy and parturition continuum</p> <p>The biological process of pregnancy and childbirth begins with implantation and, after birth, ends with the return of the uterus to its previous state. The majority of pregnancy is characterized by rapid uterine and fetal growth without contractions. Yet most research has addressed only uterine stimulation (labor) that accounts for <0.5% of pregnancy.</p> <p>Etiologies</p> <p>The etiologies of preterm birth and stillbirth differ by gestational age, genetics, and environmental factors. Approximately 30% of all preterm births are indicated for either maternal or fetal complications, such as maternal illness or fetal growth restriction. Commonly recognized pathways leading to preterm birth occur most often during the gestational ages indicated: (1) inflammation caused by infection (22-32 weeks); (2) decidual hemorrhage caused by uteroplacental thrombosis (early or late preterm birth); (3) stress (32-36 weeks); and (4) uterine overdistention, often caused by multiple fetuses (32-36 weeks). Other contributors include cervical insufficiency, smoking, and systemic infections. Many stillbirths have similar causes and mechanisms. About two-thirds of late fetal deaths occur during the antepartum period; the other third occur during childbirth. Intrapartum asphyxia is a leading cause of stillbirths in low- and middle-income countries.</p> <p>Recommendations</p> <p>Utilizing new systems biology tools, opportunities now exist for researchers to investigate various pathways important to normal and abnormal pregnancies. Improved access to quality data and biological specimens are critical to advancing discovery science. Phenotypes, standardized definitions, and uniform criteria for assessing preterm birth and stillbirth outcomes are other immediate research needs.</p> <p>Conclusion</p> <p>Preterm birth and stillbirth have multifactorial etiologies. More resources must be directed toward accelerating our understanding of these complex processes, and identifying upstream and cost-effective solutions that will improve these pregnancy outcomes.</p