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

Impact of a probiotic fermented milk in the gut ecosystem and in the systemic immunity using a non-severe protein-energy-malnutrition model in mice

<p>Abstract</p> <p>Background</p> <p>Malnutrition affects the immune response, causing a decrease of defence mechanisms and making the host more susceptible to infections. Probiotics can reconstitute the intestinal mucosa and stimulate local and systemic immunity. The aim of this work was evaluate the effects of a probiotic fermented milk as a complement of a re-nutrition diet, on the recovery of the intestinal barrier, and mucosal and systemic immune functions in a murine model of non-severe protein-energy-malnutrition. Its potential protection against <it>Salmonella enterica </it>serovar Typhimurium (<it>S</it>. Typhimurium) infection was also analyzed.</p> <p>Methods</p> <p>Mice were undernourished and divided into 3 groups according to the dietary supplement received during re-nutrition (milk, probiotic fermented milk or its bacterial free supernatant) and compared to well-nourished and malnourished mice. They were sacrificed previous to the re-nutrition and 5 days post re-nutrition. The phagocytic activity of macrophages from spleen and peritoneum and the changes in the intestinal histology and microbiota were evaluated. Different immune cell populations and cytokine productions were analyzed in the small intestine tissues. The effect of the re-nutrition supplements on the systemic immunity using OVA antigen and against an infection with <it>S. </it>Typhimurium was also studied.</p> <p>Results</p> <p>Probiotic fermented milk was the most effective re-nutrition diet that improved the intestinal microbiota. Its administration also increased the number of IgA+ cells, macrophages and dendritic cells. The production of different cytokine (IFN-γ, TNF-α, IL-12) by these cells and the phagocytic activity in peritoneum and spleen was also increased. This re-nutrition diet also stimulated the systemic immune response against OVA antigen which was diminished after the malnutrition period and also improved the host response against <it>S. </it>Typhimurium, decreasing the spread of pathogenic bacteria to the liver and the spleen. The importance of the metabolites released during milk fermentation was also demonstrated through the analysis of the bacterial free supernatant obtained from the probiotic fermented milk, but the whole product showed the best effects in the parameters evaluated in this study.</p> <p>Conclusions</p> <p>The administration of probiotic fermented milk as a dietary supplement during the re-nutrition process in a murine immunodeficiency model by malnutrition could be a good adjuvant diet to improve the gut and systemic immune response for the protection against <it>Salmonella </it>infection.</p

Effects of Terrestrial Buffer Zones on Amphibians on Golf Courses

A major cause of amphibian declines worldwide is habitat destruction or alteration. Public green spaces, such as golf courses and parks, could serve as safe havens to curb the effects of habitat loss if managed in ways to bolster local amphibian communities. We reared larval Blanchard's cricket frogs (Acris blanchardi) and green frogs (Rana clamitans) in golf course ponds with and without 1 m terrestrial buffer zones, and released marked cricket frog metamorphs at the golf course ponds they were reared in. Larval survival of both species was affected by the presence of a buffer zone, with increased survival for cricket frogs and decreased survival for green frogs when reared in ponds with buffer zones. No marked cricket frog juveniles were recovered at any golf course pond in the following year, suggesting that most animals died or migrated. In a separate study, we released cricket frogs in a terrestrial pen and allowed them to choose between mown and unmown grass. Cricket frogs had a greater probability of using unmown versus mown grass. Our results suggest that incorporating buffer zones around ponds can offer suitable habitat for some amphibian species and can improve the quality of the aquatic environment for some sensitive local amphibians

Control of Tungiasis through Intermittent Application of a Plant-Based Repellent: An Intervention Study in a Resource-Poor Community in Brazil

Tungiasis is a parasitic skin disease caused by the female sand flea Tunga penetrans. The disease is frequent in resource-poor communities in South America and sub-Saharan Africa and affects the poorest of the poor. Sand flea disease is associated with a considerable morbidity and may lead to tetanus in non-vaccinated individuals. The degree of morbidity depends on the intensity of infestation, i.e., the number of embedded sand fleas a person has. Since tungiasis is a zoonosis involving a host of animal reservoirs, and because an effective treatment is not at hand, in resource-poor settings elimination is not feasible. Preventing morbidity to develop is therefore the only means to protect exposed individuals from sand flea disease. Similar to other arthropods, sand fleas can be repelled before they penetrate into the skin. In this study we show that the intermittent application of a plant-based repellent, of which the major component is coconut oil, reduces the intensity of infestation dramatically during the whole transmission season and prevents tungiasis-associated morbidity from developing. The prevention can be performed at the household level by the affected individuals themselves with minimal input from the health sector

A chemical survey of exoplanets with ARIEL

Thousands of exoplanets have now been discovered with a huge range of masses, sizes and orbits: from rocky Earth-like planets to large gas giants grazing the surface of their host star. However, the essential nature of these exoplanets remains largely mysterious: there is no known, discernible pattern linking the presence, size, or orbital parameters of a planet to the nature of its parent star. We have little idea whether the chemistry of a planet is linked to its formation environment, or whether the type of host star drives the physics and chemistry of the planet’s birth, and evolution. ARIEL was conceived to observe a large number (~1000) of transiting planets for statistical understanding, including gas giants, Neptunes, super-Earths and Earth-size planets around a range of host star types using transit spectroscopy in the 1.25–7.8 μm spectral range and multiple narrow-band photometry in the optical. ARIEL will focus on warm and hot planets to take advantage of their well-mixed atmospheres which should show minimal condensation and sequestration of high-Z materials compared to their colder Solar System siblings. Said warm and hot atmospheres are expected to be more representative of the planetary bulk composition. Observations of these warm/hot exoplanets, and in particular of their elemental composition (especially C, O, N, S, Si), will allow the understanding of the early stages of planetary and atmospheric formation during the nebular phase and the following few million years. ARIEL will thus provide a representative picture of the chemical nature of the exoplanets and relate this directly to the type and chemical environment of the host star. ARIEL is designed as a dedicated survey mission for combined-light spectroscopy, capable of observing a large and well-defined planet sample within its 4-year mission lifetime. Transit, eclipse and phase-curve spectroscopy methods, whereby the signal from the star and planet are differentiated using knowledge of the planetary ephemerides, allow us to measure atmospheric signals from the planet at levels of 10–100 part per million (ppm) relative to the star and, given the bright nature of targets, also allows more sophisticated techniques, such as eclipse mapping, to give a deeper insight into the nature of the atmosphere. These types of observations require a stable payload and satellite platform with broad, instantaneous wavelength coverage to detect many molecular species, probe the thermal structure, identify clouds and monitor the stellar activity. The wavelength range proposed covers all the expected major atmospheric gases from e.g. H2O, CO2, CH4 NH3, HCN, H2S through to the more exotic metallic compounds, such as TiO, VO, and condensed species. Simulations of ARIEL performance in conducting exoplanet surveys have been performed – using conservative estimates of mission performance and a full model of all significant noise sources in the measurement – using a list of potential ARIEL targets that incorporates the latest available exoplanet statistics. The conclusion at the end of the Phase A study, is that ARIEL – in line with the stated mission objectives – will be able to observe about 1000 exoplanets depending on the details of the adopted survey strategy, thus confirming the feasibility of the main science objectives.Peer reviewedFinal Published versio

An injury audit in high-level male youth soccer players from English, Spanish, Uruguayan and Brazilian academies.

OBJECTIVES: To identify the most common injury types/locations in high-level male youth soccer players (YSP). DESIGN: Prospective cohort surveillance study. SETTING: Professional soccer club academies. PARTICIPANTS: Six hundred and twenty-four high-level male YSP [Under 9 (U9) to U23 year-old age groups] from academies in England, Spain, Uruguay and Brazil. MAIN OUTCOME MEASURES: Injury type, location and severity were recorded during one season. Injury severity was compared between age groups, while injury type and location were compared between nations. RESULTS: Four hundred and forty-three training or match injuries were recorded, giving an injury rate of 0.71 per player. Non-contact injuries were most common (58.5%), with most (44.2%) resolved between 8 and 28 days. Most injuries (75.4%) occurred in the lower limbs, with muscle (29.6%) the most commonly injured tissue. U14 and U16 suffered a greater number of severe injuries relative to U12 and U19/U20/U23/Reserves. Tendon injury rate was higher in Brazil vs. Spain (p < 0.05), with low back/sacrum/pelvis injury rate highest in Spain (p < 0.05). CONCLUSIONS: The proportion of severe injuries in U14 and U16 suggests YSP injury risk is maturation-dependent. Minimal differences in type and location between high-level YSP from four different countries suggest injury rates in this population are geographically similar

Cross-sectional interactions between quality of the physical and social environment and self-reported physical activity in adults living in income-deprived communities

Background: Understanding the environmental determinants of physical activity in populations at high risk of inactivity could contribute to the development of effective interventions. Socioecological models of activity propose that environmental factors have independent and interactive effects of physical activity but there is a lack of research into interactive effects. Objectives: This study aimed to explore independent and interactive effects of social and physical environmental factors on self-reported physical activity in income-deprived communities. Methods: Participants were 5,923 adults in Glasgow, United Kingdom. Features of the social environment were self-reported. Quality of the physical environment was objectively-measured. Neighbourhood walking and participation in moderate physical activity [MPA] on ≥5 days/week was self-reported. Multilevel multivariate logistic regression models tested independent and interactive effects of environmental factors on activity. Results: ‘Social support’ (walking: OR:1.22,95%CI=1.06-1.41,p<0.01; MPA: OR:0.79,95%CI=0.67-0.94,p<0.01), ‘social interaction’ (walking: OR:1.25,95%CI=1.10-1.42,p<0.01; MPA: OR:6.16,95%CI=5.14-7.37,p<0.001) and ‘cohesion and safety’ (walking: OR:1.78,95%CI=1.56-2.03,p<0.001; MPA: OR:1.93,95%CI=1.65-2.27,p<0.001), but not ‘trust and empowerment’, had independent effects on physical activity. ‘Aesthetics of built form’ (OR:1.47,95%CI=1.22-1.77,p<0.001) and ‘aesthetics and maintenance of open space’ (OR:1.32, 95%CI=1.13-1.54,p<0.01) were related to walking. ‘Physical disorder’ (OR:1.63,95%CI=1.31-2.03,p<0.001) had an independent effect on MPA. Interactive effects of social and physical factors on walking and MPA were revealed. Conclusions: Findings suggest that intervening to create activity-supportive environments in deprived communities may be most effective when simultaneously targeting the social and physical neighbourhood environment

Nocodazole Treatment Decreases Expression of Pluripotency Markers Nanog and Oct4 in Human Embryonic Stem Cells

Nocodazole is a known destabiliser of microtubule dynamics and arrests cell-cycle at the G2/M phase. In the context of the human embryonic stem cell (hESC) it is important to understand how this arrest influences the pluripotency of cells. Here we report for the first time the changes in the expression of transcription markers Nanog and Oct4 as well as SSEA-3 and SSEA-4 in human embryonic cells after their treatment with nocodazole. Multivariate permeabilised-cell flow cytometry was applied for characterising the expression of Nanog and Oct4 during different cell cycle phases. Among untreated hESC we detected Nanog-expressing cells, which also expressed Oct4, SSEA-3 and SSEA-4. We also found another population expressing SSEA-4, but without Nanog, Oct4 and SSEA-3 expression. Nocodazole treatment resulted in a decrease of cell population positive for all four markers Nanog, Oct4, SSEA-3, SSEA-4. Nocodazole-mediated cell-cycle arrest was accompanied by higher rate of apoptosis and upregulation of p53. Twenty-four hours after the release from nocodazole block, the cell cycle of hESC normalised, but no increase in the expression of transcription markers Nanog and Oct4 was detected. In addition, the presence of ROCK-2 inhibitor Y-27632 in the medium had no effect on increasing the expression of pluripotency markers Nanog and Oct4 or decreasing apoptosis or the level of p53. The expression of SSEA-3 and SSEA-4 increased in Nanog-positive cells after wash-out of nocodazole in the presence and in the absence of Y-27632. Our data show that in hESC nocodazole reversible blocks cell cycle, which is accompanied by irreversible loss of expression of pluripotency markers Nanog and Oct4

Diagnosis of chronic conditions with modifiable lifestyle risk factors in selected urban and rural areas of Bangladesh and sociodemographic variability therein

<p>Abstract</p> <p>Background</p> <p>Bangladesh suffers from a lack of healthcare providers. The growing chronic disease epidemic's demand for healthcare resources will further strain Bangladesh's limited healthcare workforce. Little is known about how Bangladeshis with chronic disease seek care. This study describes chronic disease patients' care seeking behavior by analyzing which providers diagnose these diseases.</p> <p>Methods</p> <p>During 2 month periods in 2009, a cross-sectional survey collected descriptive data on chronic disease diagnoses among 3 surveillance populations within the International Center for Diarrheal Disease Research, Bangladesh (ICDDR, B) network. The maximum number of respondents (over age 25) who reported having ever been diagnosed with a chronic disease determined the sample size. Using SAS software (version 8.0) multivariate regression analyses were preformed on related sociodemographic factors.</p> <p>Results</p> <p>Of the 32,665 survey respondents, 8,591 self reported having a chronic disease. Chronically ill respondents were 63.4% rural residents. Hypertension was the most prevalent disease in rural (12.4%) and urban (16.1%) areas. In rural areas chronic disease diagnoses were made by MBBS doctors (59.7%) and Informal Allopathic Providers (IAPs) (34.9%). In urban areas chronic disease diagnoses were made by MBBS doctors (88.0%) and IAP (7.9%). Our analysis identified several groups that depended heavily on IAP for coverage, particularly rural, poor and women.</p> <p>Conclusion</p> <p>IAPs play important roles in chronic disease care, particularly in rural areas. Input and cooperation from IAPs are needed to minimize rural health disparities. More research on IAP knowledge and practices regarding chronic disease is needed to properly utilize this potential healthcare resource.</p

Skeletal muscle and performance adaptations to high-intensity training in elite male soccer players: speed endurance runs versus small-sided game training.

PURPOSE: To examine the skeletal muscle and performance responses across two different exercise training modalities which are highly applied in soccer training. METHODS: Using an RCT design, 39 well-trained male soccer players were randomized into either a speed endurance training (SET; n = 21) or a small-sided game group (SSG; n = 18). Over 4 weeks, thrice weekly, SET performed 6-10 × 30-s all-out runs with 3-min recovery, while SSG completed 2 × 7-9-min small-sided games with 2-min recovery. Muscle biopsies were obtained from m. vastus lateralis pre and post intervention and were subsequently analysed for metabolic enzyme activity and muscle protein expression. Moreover, the Yo-Yo Intermittent Recovery level 2 test (Yo-Yo IR2) was performed. RESULTS: Muscle CS maximal activity increased (P < 0.05) by 18% in SET only, demonstrating larger (P < 0.05) improvement than SSG, while HAD activity increased (P < 0.05) by 24% in both groups. Na(+)-K(+) ATPase α1 subunit protein expression increased (P < 0.05) in SET and SSG (19 and 37%, respectively), while MCT4 protein expression rose (P < 0.05) by 30 and 61% in SET and SSG, respectively. SOD2 protein expression increased (P < 0.05) by 28 and 37% in SET and SSG, respectively, while GLUT-4 protein expression increased (P < 0.05) by 40% in SSG only. Finally, SET displayed 39% greater improvement (P < 0.05) in Yo-Yo IR2 performance than SSG. CONCLUSION: Speed endurance training improved muscle oxidative capacity and exercise performance more pronouncedly than small-sided game training, but comparable responses were in muscle ion transporters and antioxidative capacity in well-trained male soccer players