USING ORACLE QUERY PLAN FOR AUTOMATED ASSESSMENT OF SQL

In our second-year undergraduate database foundations module students are exposed to using the Oracle cloud environment for developing SQL (Structured Query Language) queries. Their first summative assessment for the module is of a problem-solving nature, whereby they are expected to repair a partially developed SQL schema for a given scenario, before subsequently developing SQL queries based on the scenario. Marking this work can be laborious, error prone and time consuming, as well as requiring multiple sample solutions for each query which cater for all potential solutions that the students could produce. The aim of this paper is therefore to describe an early-stage prototype automated assessment system for marking the SQL queries developed by the students

Human rhinovirus infection up-regulates MMP-9 production in airway epithelial cells via NF-{kappa}B

Human rhinovirus (HRV) infections up-regulate proinflammatory mediators and growth factors that are associated with exacerbations of inflammatory airway diseases, such as asthma and chronic obstructive pulmonary disease (COPD). Matrix metalloproteinase (MMP)-9 was shown to be increased in the airways of patients with asthma and COPD. We sought to determine whether HRV infection modulated the expression of MMP-9 and its highest-affinity inhibitor, the tissue inhibitor of metalloproteinase (TIMP)-1, and we explored the mechanism by which this modulation occurs. In vitro studies, using RT-PCR, ELISA, zymography, and a fluorescent activity assay, demonstrated that MMP-9 mRNA, protein, and activity were increased upon infection with HRV, whereas TIMP-1 mRNA and protein remained unchanged. These results were verified in vivo, using nasal lavage samples obtained from subjects with confirmed rhinovirus infections. Human rhinovirus infections were shown to up-regulate NF-kappaB, and NF-kappaB has also been reported to play a role in the expression of MMP-9. We therefore investigated the role of NF-kappaB in HRV-induced MMP-9 expression. Using two inhibitors of IkappaBalpha kinase beta, we observed a concentration-dependent decrease in HRV-induced MMP-9 expression. The role of NF-kappaB in HRV-induced MMP-9 expression was further confirmed using MMP-9 promoter luciferase constructs, which demonstrated that an NF-kappaB site at -620/-607 base pairs was necessary for HRV-induced MMP-9 expression. Electrophoretic mobility shift assays and supershift assays confirmed the nuclear translocation and binding of p50/p65 NF-kappaB subunits to an MMP-9-specific NF-kappaB oligonucleotide. This increase in MMP-9 may be a mechanism by which rhinovirus infections contribute to airway inflammation and, potentially, to airway remodeling

A satellite chronology of plumes from the April 2021 eruption of La Soufrière, St Vincent

Satellite instruments play a valuable role in detecting, monitoring and characterising emissions of ash and gas into the atmosphere during volcanic eruptions. This study uses two satellite instruments, the Infrared Atmospheric Sounding Interferometer (IASI) and the Advanced Baseline Imager (ABI), to examine the plumes of ash and sulfur dioxide (SO2) from the April 2021 eruption of La Soufrière, St Vincent. The frequent ABI data have been used to construct a 14 d chronology of a series of explosive events at La Soufrière, which is then complemented by measurements of SO2 from IASI, which is able to track the plume as it is transported around the globe. A minimum of 35 eruptive events were identified using true, false and brightness temperature difference maps produced with the ABI data. The high temporal resolution images were used to identify the approximate start and end times, as well as the duration and characteristics of each event. From this analysis, four distinct phases within the 14 d eruption have been defined, each consisting of multiple explosive events with similar characteristics: (1) an initial explosive event, (2) a sustained event lasting over 9 h, (3) a pulsatory phase with 25 explosive events in a 65.3 h period and (4) a waning sequence of explosive events. It is likely that the multiple explosive events during the April 2021 eruption contributed to the highly complex plume structure that can be seen in the IASI measurements of the SO2 column amounts and heights. The bulk of the SO2 from the first three phases of the eruption was transported eastwards, which based on the wind direction at the volcano implies that the SO2 was largely in the upper troposphere. Some of the SO2 was carried to the south and west of the volcano, suggesting a smaller emission of the gas into the stratosphere, there being a shift in wind direction around the height of the tropopause. The retrieved SO2 heights show that the plume had multiple layers but was largely concentrated between 13 and 19 km, with the majority of the SO2 being located in the upper troposphere and around the height of the tropopause, with some emission into the stratosphere. An average e-folding time of 6.07±4.74 d was computed based on the IASI SO2 results: similar to other tropical eruptions of this magnitude and height. The SO2 was trackable for several weeks after the eruption and is shown to have circulated the globe, with parts of it reaching as far as 45∘ S and 45∘ N. Using the IASI SO2 measurements, a time series of the total SO2 mass loading was produced, with this peaking on 13 April (descending orbits) at 0.31±0.09 Tg. Converting these mass values to a temporally varying SO2 flux demonstrated that the greatest emission occurred on 10 April with that measurement incorporating SO2 from the second phase of the eruption (sustained emission) and the beginning of the pulsatory phase. The SO2 flux is then shown to fall during the later stages of the eruption: suggesting a reduction in eruptive energy, something also reflected in ash height estimates obtained with the ABI instrument. A total SO2 emission of 0.63±0.5 Tg of SO2 has been derived, although due to limitations associated with the retrieval, particularly in the first few days after the eruption began, this, the retrieved column amounts and the total SO2 mass on each day should be considered minimum estimates. There are a number of similarities between the 1979 and 2021 eruptions at La Soufrière, with both eruptions consisting of a series of explosive events with varied heights and including some emission into the stratosphere. These similarities highlight the importance of in-depth investigations into eruptions and the valuable contribution of satellite data for this purpose; as these studies aid in learning about a volcano's behaviour, which may allow for better preparation for future eruptive activity

Designing the Mission Operations for the Pointable Radiometer for Observation of Volcanic Emissions (PROVE) Pathfinder Payload

The PROVE Pathfinder CubeSat payload is a 2U Visual and TIR imaging payload optimized for observation of volcanic ash clouds for 3D reconstruction. Three of the main challenges for the mission operations of payload are optimization of the observation geometry (num. images, angles, etc.), data management of a high data rate payload, and observation scheduling for sporadic eruptions. Example solutions to these problems are presented belo

Diaryltriazenes as antibacterial agents against methicillin resistant Staphylococcus aureus (MRSA) and Mycobacterium smegmatis

Diaryltriazene derivatives were synthesized and evaluated for their antimicrobial properties. Initial experiments showed some of these compounds to have activity against both methicillin-resistant strains of Staphylococus aureus (MRSA) and Mycobacterium smegmatis, with MICs of 0.02 and 0.03 μg/mL respectively. Those compounds with potent anti-staphylococcal and anti-mycobacterial activity were not found to act as growth inhibitors of mammalian cell lines or yeast. Furthermore, we demonstrated that one of the most active anti-MRSA diaryltriazene derivatives was subject to very low frequencies of resistance at <10−9. Whole genome sequencing of resistant isolates identified mutations in the enzyme that lysylates phospholipids. This could result in the modification of phospholipid metabolism and consequently the characteristics of the staphylococcal cell membrane, ultimately modifying the sensitivity of these pathogens to triazene challenge. Our work has therefore extended the potential range of triazenes, which could yield novel antimicrobials with low levels of resistance

Orion Crew Exploration Vehicle Launch Abort System Guidance and Control Analysis Overview

Aborts during the critical ascent flight phase require the design and operation of Orion Crew Exploration Vehicle (CEV) systems to escape from the Crew Launch Vehicle (CLV) and return the crew safely to the Earth. To accomplish this requirement of continuous abort coverage, CEV ascent abort modes are being designed and analyzed to accommodate the velocity, altitude, atmospheric, and vehicle configuration changes that occur during ascent. Aborts from the launch pad to early in the flight of the CLV second stage are performed using the Launch Abort System (LAS). During this type of abort, the LAS Abort Motor is used to pull the Crew Module (CM) safely away from the CLV and Service Module (SM). LAS abort guidance and control studies and design trades are being conducted so that more informed decisions can be made regarding the vehicle abort requirements, design, and operation. This paper presents an overview of the Orion CEV, an overview of the LAS ascent abort mode, and a summary of key LAS abort analysis methods and results

Destructive testing method for specimen and crystal structure on maximum solubility

From non-destructive testing, we have found various flaws in both specimens so no method in the universe is perfect but we can rectify the defects but cannot be removed completely. From destructive testing we have found that First specimen MS (MS) sustain stress without failure due its similar crystal structure (BCC) on the other hand second specimen have failed within the lower stress range due to lack of cohesion, adhesion between the dissimilar metals MS and SS, and also both have different crystal structures BCC and FCC respectively. Thus, to gain maximum strength of weld bead, welding should be done using similar metals with maximum solubility

The <i>Plasmodium</i> eukaryotic initiation factor-2α kinase IK2 controls the latency of sporozoites in the mosquito salivary glands

Sporozoites, the invasive form of malaria parasites transmitted by mosquitoes, are quiescent while in the insect salivary glands. Sporozoites only differentiate inside of the hepatocytes of the mammalian host. We show that sporozoite latency is an active process controlled by a eukaryotic initiation factor-2α (eIF2α) kinase (IK2) and a phosphatase. IK2 activity is dominant in salivary gland sporozoites, leading to an inhibition of translation and accumulation of stalled mRNAs into granules. When sporozoites are injected into the mammalian host, an eIF2α phosphatase removes the PO4 from eIF2α-P, and the repression of translation is alleviated to permit their transformation into liver stages. In IK2 knockout sporozoites, eIF2α is not phosphorylated and the parasites transform prematurely into liver stages and lose their infectivity. Thus, to complete their life cycle, Plasmodium sporozoites exploit the mechanism that regulates stress responses in eukaryotic cells