Experience in developing a web application for relational databases modeling with a forward engineering function for training students of technical specialties

The article actualizes the need to develop software for modeling relational databases for use in the process of teaching students of technical specialties in disciplines related to databases.The problem is considered from the point of view of assessing modern software used in the process of teaching students database design skills. Based on the shortcomings identified during the software review, a number of requirements for the actual software were determined. Formed key requirements are mobility, accessibility, versatility and openness of the development platform.The article describes the process of solving key problems that arose during the implementation of a project to develop a web application for modeling relational databases in accordance with the generated requirements. The practical implementation of the following functions is sequentially considered: creation of a logical relational data model, creation of a physical data model, direct engineering into relational database software. The main technological solutions used in the development of a web application to ensure the qualities specified in the condition are described.The result of the work is the successful testing of the development results in the process of creating a real web application, both within the framework of laboratory and practical work in the disciplines “Design and administration of databases” and “Data management”, and at the stage of writing graduate works for technical directions of training.

Unlocking the Potential of Electrical Submersible Pumps: The Successful Testing and Deployment of a Real-Time Artificially Intelligent System, for Failure Prediction, Run Life Extension, and Production Optimization

This paper is a summary of the collaborative work between a Gulf Cooperation Council (GCC) national oil company (NOC) and Nybl, a deep tech development company, and the results of applying Nybl's proprietary science-based AI to the GCC NOC ESP wells in real-time applications. The paper demonstrates the potential benefits of the real-life application of AI / Machine Learning in conjunction with traditional Petroleum Engineering concepts and algorithms to predict imminent and future failures, extend and monitor run life, and maximize the production of Electrical Submersible Pumps (ESP's). This paper will highlight the NOC's innovative approach to pilot new technology through successful deployment on 27 wells, spread onshore and offshore, in real-time, with prescriptive actions.

The Same Drift Monodiameter Completion System in Solving Drilling and Well Infrastructure Challenges

The public domain contains many work efforts that document the advantages of expandable drilling and completions systems within the industry (Filippov 1999, Lohoefer 2000). The ability to place a solid steel liner or patch into a well and transform it by cold working to a larger diameter provides an opportunity to drill deeper while maintaining sufficient wellbore diameter. The use of expandable technology has led to the development of a formable and retractable-segmented cone. The cone supports an expandable system capable of passing through the drift of a base casing that can then result in an expansion providing the equivalent drift diameter. The technology allows the placement of additional liner points in a well that can extend liner lengths as well as isolate sections of open hole that were previously impossible to isolate due to wellbore geometry restriction. There are no limitations on the number of open hole patches installed in a given well which are helpful when wells experience multiple drilling hazards. Each patch can pass through a previously installed patch. The idea of monodiameter expandable liners began in the early 2000s (Dupal 2002, Dean 2003). This paper presents the technical challenges, solutions, and testing of a novel monodiameter system that expands 11-3/4 in. 47 lb/ft pipe which can result in a post-expansion drift diameter of 12-1/4 in. Finite element analysis helped transform the concept from the theoretical system to field execution. The work efforts show the successful testing of the monobore system at surface, and the resulting field trials demonstrate the ability of the technology to fulfil the installation objectives. In addition, the success of the methodology has led to the development of additional monobore system sizes.

Loop Transient Performance With a Closed Loop sCO2 Brayton Cycle

Recent testing has been completed on a 1 MWe supercritical carbon dioxide (sCO2) closed loop recuperated cycle under funding from the US Department of Energy (DOE) Sunshot initiative and industry partners. Some of the goals of this funding included the development of a 1 MWe loop, a 10 MWe turbine, and performance and mechanical testing. One of the key challenges that presented itself was the filling, start-up, and shut down of the entire system. Understanding the loop transient performance is important when having to bring a turbine online, transitioning from peak to partial loading, and also managing routine and emergency shut downs. Due to large changes in density near the critical point for CO2 and its tendency to form dry ice when expanded to atmospheric pressure, managing loop filling and venting is critical in ensuring that components are not damaged. With successful testing up to 715°C and 234 bar, this paper will provide updated data to, “Loop Filling and Start Up with a Closed Loop sCO2 Brayton Cycle [1].” While the previous paper focused on early trips and start up challenges, this paper will focus on the specific challenges at maximum operating conditions, and how the loop was managed when getting up to these high temperatures and pressures and how the loop behaved during a high temperature trip when compared to a controlled shut down from maximum operating conditions.

Emerging Therapies for Charcot-Marie-Tooth Inherited Neuropathies

Inherited neuropathies known as Charcot-Marie-Tooth (CMT) disease are genetically heterogeneous disorders affecting the peripheral nerves, causing significant and slowly progressive disability over the lifespan. The discovery of their diverse molecular genetic mechanisms over the past three decades has provided the basis for developing a wide range of therapeutics, leading to an exciting era of finding treatments for this, until now, incurable group of diseases. Many treatment approaches, including gene silencing and gene replacement therapies, as well as small molecule treatments are currently in preclinical testing while several have also reached clinical trial stage. Some of the treatment approaches are disease-specific targeted to the unique disease mechanism of each CMT form, while other therapeutics target common pathways shared by several or all CMT types. As promising treatments reach the stage of clinical translation, optimal outcome measures, novel biomarkers and appropriate trial designs are crucial in order to facilitate successful testing and validation of novel treatments for CMT patients.

Pre-pandemic mental and physical health as predictors of COVID-19 vaccine hesitancy: evidence from a UK-wide cohort study

Importance: Although several predictors of COVID-19 vaccine hesitancy have been identified, the role of physical health has not been well-examined, and the association with mental health is unknown. Objective: To examine the association of pre-pandemic mental health, physical health, and shielding with vaccine hesitancy after the announcement of the successful testing of the Oxford University/AstraZeneca vaccine. Design, Setting, and Participants: We used individual-level data from a pandemic-focused investigation (COVID Survey), a prospective cohort study nested within the UK Understanding Society (Main Survey) project. In the week immediately following the announcement of successful testing of the first efficacious inoculation (November/December 2020), data on vaccine intentionality were collected in 12,035 individuals aged 16-95 years. Pre-pandemic, study members had responded to enquiries about diagnoses of mental and physical health, completed the 12-item General Health Questionnaire for symptoms of psychological distress (anxiety and depression), and indicated whether they or someone in their household was shielding. Main outcome measures: Self-reported intention to take up a vaccination for COVID-19. To summarise our results, we computed odds ratios with accompanying 95% confidence intervals for indices of health and shielding adjusted for selected covariates. Results: In an analytical sample of 11,955 people (6741 women), 15.4% indicated that they were vaccine hesitant. Relative to their disease-free counterparts, shielding was associated with a 24% lower risk of being hesitant (odds ratio; 95% confidence interval: 0.76; 0.59, 0.96), after adjustment for a range of covariates which included age, education, and ethnicity. Corresponding results for cardiometabolic disease were 22% (0.78; 0.64, 0.95), and for respiratory disease were 26% (0.74; 0.59, 0.93). Having a pre-pandemic diagnosis of anxiety or depression, or a high score on the distress symptom scale, were all unrelated to the willingness to take up a vaccine. Conclusions and relevance: People who have been prioritised for COVID-19 vaccination owing to a physical condition are more likely to take it up. These effects were not apparent for indices of mental health.

P37 COVID-19 and non-emergency cancer operating: Implementing a successful testing system

Introduction Early evidence has demonstrated poor peri-operative outcomes for patients undergoing cancer surgery with COVID-19 (C-19) . As a tertiary cancer centre, offering major oesophageal and hepatobiliary surgery we were concerned on how the C-19 pandemic would affect our patients. Elective operating was split between our trust and a local private provider as a “clean” site; and an official trust C-19 screening programme started on 24th April. Methods Retrospectively the electronic theatre record was searched for patients undergoing a non-emergency cancer operation between March & May 2020. The data was cross-referenced with investigations and mortality to ascertain swab results (pre-operatively and 30 days postoperatively) and mortality. Results During the 3 months at the height of the pandemic 596 non-emergency cancer operations took place, (compared with 986 in the same time-frame from 2019). In March 6 of 281, April 98 of 141 and May 166 of 175 patients undergoing an operation had a pre-operative swab, with only 6 screening swabs positive (5 in April, 1 in May). In total 4 patients died, only 1 had a positive C-19 test (patient had not been screened pre-operatively). Conclusion Non-emergency cancer surgery was impacted but Screening was successfully implemented in April and by May 95% of patients underwent testing. Six patients were tested positive post-operatively with only one deceased which appears to show a lower mortality rate than currently quoted within the literature. This adds further evidence that with comprehensive screening, cancer surgery can safely take place during a pandemic.

Pre-pandemic Cognitive Function and COVID-19 Vaccine Hesitancy: Prospective Cohort Study

Importance: Whereas several predictors of COVID-19 vaccine hesitancy have been examined, the role of cognitive function following the widely publicised development of an inoculation is unknown. Objective: To test the association between scores from an array of cognitive function tests and self-reported vaccine hesitancy after the announcement of the successful testing of the Oxford University/AstraZeneca vaccine. Design, Setting, and Participants: We used individual-level data from a pandemic-focused study (COVID Survey), a prospective cohort study nested within Understanding Society (Main Survey). In the week immediately following the announcement of successful testing of the first efficacious inoculation (November/December 2020), data on vaccine intentionality were collected in 11740 individuals (6702 women) aged 16-95. Pre-pandemic scores on general cognitive function, ascertained from a battery of six tests, were captured in 2011/12 wave of the Main Survey. Main Outcomes and Measures: Self-reported intention to take up a vaccination for COVID-19. To summarise our results, we computed odds ratios with accompanying 95% confidence intervals for general cognitive function adjusted for selected covariates. Results: Of the study sample, 17.2% (N=1842) indicated they were hesitant about having the vaccine. After adjustment for age, sex, and ethnicity, study members with a lower baseline cognition score were markedly more likely to be vaccine hesitant (odds ratio per standard deviation lower score in cognition; 95% confidence interval: 1.76; 1.62, 1.90). Adjustment for mental and physical health plus household shielding status had no impact on these results, whereas controlling for educational attainment led to partial attenuation but the probability of hesitancy was still elevated (1.52; 1.37, 1.67). There was a linear association for vaccine hesitancy across the full range of cognition scores (p for trend: p<0.0001). Conclusions and Relevance: Erroneous social media reports might have complicated personal decision-making, leading to people with lower cognitive ability test scores being vaccine-hesitant. With people with lower cognition also experiencing higher rates of COVID-19 in studies conducted prior to vaccine distribution, these new findings are suggestive of a potential additional disease burden.

Implementation of an approach for variable data insertion procedures synthesis for structureindependent databases

The aim of this work is to implement an approach for the synthesis of variable data insertion procedures for structureindependent databases. This approach makes it possible to synthesize procedures for inserting data into databases, in which two types of inhomogeneities will be absent: inhomogeneities associated with various forms of representation of minimal structural units; semantic heterogeneities associated with the use of elements that are semantically heterogeneous to the elements of the structure of a structure-independent database. Due to the absence of these inhomogeneities, the productivity of the procedures will be increased in comparison with the initial one. The approbation is carried out on the example of a structure-independent database based on the Tenzer data model. As a result of the work carried out, the following were obtained: the minimum unit of data storage for the database, built on the basis of the Tenzer model; algorithm of action using the developed minimum data storage unit; procedure code. As the minimum data storage unit, a triple of the form <Object, Property, Value> was chosen, and checking the obtained algorithm of actions showed that all the elements present are homogeneous to the database structure based on the Tenzer data model, which indicates the successful testing of this approach.

Study of clustered DNA lesions in the liver in acute toxic injury

Objective: to test and optimize a method for detecting clustered DNA lesions with an assessment of the quantitative characteristics of hepatic changes using an experimental model of acute toxic hepatitis.Material and methods: Laboratory C57Bl/6 mice at the age of 10 weeks were used for the study. Acute toxic liver injury was induced by means of a single intraperitoneal injection of 30 % CCI4 solution in olive oil. The withdrawal of the animals from the experiment was made after 72 hours. For the detection of clustered DNA lesions, a liver fragment was resected.Results. The electrophoretic parameters which are the most optimal for obtaining primary data for the subsequent calculation of the number of clustered DNA lesions have been proposed. The number of clusters in the DNA samples from the animals of the control group is significantly lower than in the experimental group and amounts to 54.80 [37.65; 59.24] and 76.82 [60.95; 92.41] APE1 clusters per million bp., respectively.Conclusion. Successful testing and optimization of the OCDL method for the detection of clustered lesions in liver DNA have been performed. The study has shown an increase in the number of APE1 clusters and double-strand breaks in the DNA of the C57Bl laboratory mice with induced acute toxic hepatitis, which indicates significant derangement of DNA integrity and a high risk of developing progressive liver diseases in its toxic damage.