SQL Tester: An online SQL assessment tool and its impact

Learning SQL can be surprisingly difficult, given the relative simplicity of its syntax. Automated tools for teaching and assessing SQL have existed for over two decades. Early tools were only designed for teaching and offered increased feedback and personalised learning, but not summative assessment. More recently, however, the trend has turned towards automated assessment, with learning as a side-effect. These tools offer more limited feedback and are not personalised. In this paper, we present SQL Tester, an online assessment tool and an assessment of its impact. We show that students engaged with SQL Tester as a learning tool, taking an average of 10 practice tests each and spending over 4 hours actively engaged in those tests. A student survey also found that over 90% of students agreed that they wanted to keep trying practice tests until they got a “good” mark. Finally, we present some evidence that taking practice tests increased student achievement, with a strong correlation between the number of practice tests a student took and their score on the assessed test

A scalable implementation of information theoretic feature selection for high dimensional data

With the growth of high dimensional data, feature selection is a vital component of machine learning as well as an important stand alone data analytics tool. Without it, the computation cost of big data analytics can become unmanageable and spurious correlations and noise can reduce the accuracy of any results. Feature selection removes irrelevant and redundant information leading to faster, more reliable data analysis. Feature selection techniques based on information theory are among the fastest known and the Manchester AnalyticS Toolkit (MAST) provides an efficient, parallel and scalable implementation of these methods. This paper considers a number of data structures for storing the frequency counters that underpin MAST. We show that preprocessing the data to reduce the number of zero-valued counters in an array structure results in an order of magnitude reduction in both memory usage and execution time compared to state of the art structures that use explicit mappings to avoid zero-valued counters. We also describe a number of parallel processing techniques that enable MAST to scale linearly with the number of processors even on NUMA architectures. MAST targets scale-up servers rather than scale-out clusters and we show that it performs orders of magnitude faster than existing tools. Moreover, we show that MAST is 3.5 times faster than a scale-out solution built for Spark running on the same server. As an example of the performance of MAST, we were able to process a dataset of 100 million examples and 100,000 features in under 10 minutes on a four socket server which each socket containing an 8-core Intel Xeon E5-4620 processor

Chemical cues and pheromones in the sea lamprey (Petromyzon marinus)

Chemical cues and pheromones guide decisions in organisms throughout the animal kingdom. The neurobiology, function, and evolution of olfaction are particularly well described in insects, and resulting concepts have driven novel approaches to pest control. However, aside from several exceptions, the olfactory biology of vertebrates remains poorly understood. One exception is the sea lamprey (Petromyzon marinus), which relies heavily upon olfaction during reproduction. Here, we provide a broad review of the chemical cues and pheromones used by the sea lamprey during reproduction, including overviews of the sea lamprey olfactory system, chemical cues and pheromones, and potential applications to population management. The critical role of olfaction in mediating the sea lamprey life cycle is evident by a well-developed olfactory system. Sea lamprey use chemical cues and pheromones to identify productive spawning habitat, coordinate spawning behaviors, and avoid risk. Manipulation of olfactory biology offers opportunities for management of populations in the Laurentian Great Lakes, where the sea lamprey is a destructive invader. We suggest that the sea lamprey is a broadly useful organism with which to study vertebrate olfaction because of its simple but well-developed olfactory organ, the dominant role of olfaction in guiding behaviors during reproduction, and the direct implications for vertebrate pest management

Teriparatide treatment exerts differential effects on the central and peripheral skeleton: results from the MOAT study

The central and peripheral skeleton was characterised using imaging techniques during 104 weeks of teriparatide treatment. Teriparatide exerts differential effects on the central and the peripheral skeleton. Overall, we did not observe a change in total body bone mineral. Our conclusions are constrained by the study limitations. INTRODUCTION: Teriparatide stimulates bone formation and resorption and therefore can cause bone gain and loss. We simultaneously characterised the central and peripheral skeleton using imaging techniques to better understand the mechanism of action of teriparatide. METHODS: Postmenopausal, osteoporotic women (n = 20, 65.4 ± 5.5 years) were recruited into a 104-week study of teriparatide. Imaging techniques included DXA, quantitative computed tomography (QCT), and high-resolution peripheral quantitative computed tomography (HR-pQCT). RESULTS: Total lumbar spine areal bone mineral content (aBMC) (+ 11.2%), total lumbar spine areal bone mineral density (aBMD) (+ 8.1%), subregional thoracic spine aBMD (+ 7.5%), lumbar spine aBMC (+ 23.5%), lumbar spine aBMD (+ 11.9%), pelvis aBMC (+ 9.3%), and pelvis aBMD (+ 4.3%) increased. However, skull aBMC (- 5.0%), arms aBMC (- 5.1%), legs aBMC (- 2.9%), and legs aBMD (- 2.5%) decreased. Overall, we did not observe a change in total body bone mineral. Increases in L1-L3 volumetric BMD (vBMD) (+ 28.5%) occurred but there was no change in total proximal femur vBMD. Radius and tibia cortical vBMD (- 3.3 and - 3.4%) and tissue mineral density (- 3.2 and - 3.8%) decreased and there was an increase in porosity (+ 21.2 and + 10.3%). Tibia, but not radius, trabecular inhomogeneity (+ 3.2%), and failure load (+ 0.2%) increased, but cortical thickness (- 3.1%), area (- 2.9%), and pore volume (- 1.6%) decreased. CONCLUSIONS: Teriparatide exerts differential effects on the central and the peripheral skeleton. Central trabecular vBMD (L1-L3) is improved, but there is a concomitant decrease in peripheral cortical vBMD and an increase in porosity. Overall, we did not observe a change in total body bone mineral. We acknowledge that our conclusions may be speculative and are constrained by the technical limitations of the imaging techniques used, the lack of a control group, and the small sample size studied