Enabling generative AI to produce SQL statements:a framework for the auto-generation of knowledge based on EBNF context-free grammars

The motivation of this paper is to be able to generate high-quality (Structured Query Language) SQL language sentences in terms of syntax and semantics so that they are intended to achieve a concrete predefined and well-known aim. For example, generating SQL sentences that are capable of detecting a cyber-attack from a set of metrics available in a database table. Two solutions are needed to achieve so, a tool that enables and performs the syntactically valid generation of SQL sentences and an (Artificial intelligence) AI algorithm able to guide the semantics of such generations to the achievement of the best sentences for the intended purpose. The main contribution of this manuscript is the first of these solutions. To be concrete, this paper proposes a tool to enable and generate syntactic-valid language sentences. The tool can deal with any language defined as an ANTLR4 EBNF (Extended Backus-Naur Form) grammar. The paper also provides a methodology to help achieve an EBNF grammar suitable for addressing concerns related to ambiguity and recursion as a direct result of the generation process. The paper further implements a prototype utilizing ANTLR4’s recognizer and its Augmented Transition Network for language generation using EBNF grammars. In-depth design and logic implementation are provided, showcasing areas of interest for AI integration. The achieved prototype showed an ability to easily generate syntactically valid SQL statements at various depths, with observable problems becoming more apparent during the exponential recursive growth. Our mitigation controls for such scenarios proved to be successful and were able to complete the recursion whilst also moving the push-down automata forward until query completion. Experimental validation was performed against a SQL EBNF grammar feeding the generated SQL statement into an SQL parser to validate the syntax

Positive and negative regulation of a sterol biosynthetic gene (ERG3) in the post-squalene portion of the yeast ergosterol pathway

AbstractRegulation of sterol biosynthesis in the terminal portion of the pathway represents an efficient mechanism by which the cell can control the production of sterol without disturbing the production of other essential mevalonate pathway products. We demonstrate that mutations affecting early and late steps in sterol homeostasis modulate the expression of the ERG3 gene: a late step in sterol biosynthesis in yeast. Expression of ERG3 is increased in response to a mutation in the major isoform of HMG CoA reductase which catalyzes the rate-limiting step of sterol biosynthesis. Likewise, mutations in non-auxotrophic ergosterol biosynthetic genes downstream of squalene production (erg2, erg3, erg4, erg5, and erg6) result in an up-regulation of ERG3 expression. Deletion analysis of the ERG3 promoter identified two upstream activation sequences: UAS1, which when deleted reduces ERG3 gene expression 3–4-fold but maintains sterol regulation and UAS2, which when deleted further reduces ERG3 expression and abolishes sterol regulation. The recent isolation of two yeast genes responsible for the esterification of intracellular sterol (ARE1 and ARE2) has enabled us to directly analyze the relationship between sterol esterification and de novo biosynthesis. Our results demonstrate that the absence of sterol esterification leads to a decrease in total intracellular sterol and ERG3 is a target of this negative regulation

Lex Maritima in a changing world: development and prospect of rules governing carriage of goods by sea

This chapter examines the attempts to unifying law governing carriage of goods by sea and the background to these attempts over the past hundred years or so. It finds that a repetition of the current mode of negotiating static conventions will not unify these rules. Moreover, from historic and legal perspectives, the attempts to unify the international carriage of goods by sea regimes in the past century have remained transitional. The active players have shifted from private entrepreneurs to government delegates. This research probes into the new trade practice for the shipping industry in the twenty-first century and argues that new ‘landscape’ calls for innovative modifications of the conventional approach to unifying carriage of goods by sea rules. This research also forecasts the prospects of the Rotterdam Rules and discusses several countries’ current attitudes, including the UK, the Netherlands, Scandinavian countries and, particularly, the USA

Effect of perchlorate and thiocyanate exposure on thyroid function of pregnant women from South-West England: a cohort study

This article is freely available via Open Access. Click on the Additional Link above to access the full-text via the publisher's site

The limited scope of seaborne cargo liability regime: new political–economic environments in the 21st Century

The scope of uniformity of seaborne cargo regimes under the UN’s conventional approach seems to be more extensive than is desirable. The new business pattern of shipping subsectors, the rising influence of developing countries, and containerisation, are creating new shipping environments. These environments show that imperfect competition is only found in parts of the shipping markets nowadays, unlike that in/under the conventional approach to uniformity. Thus, these new economic and political realities call for innovative modifications to the conventional approach and a refocusing of international uniformity towards a limited degree of restriction [limited number of restrictions] of freedom of contract in legal shipping regimes

Progress Towards Using Linked Population-Based Data For Geohealth Research: Comparisons Of Aotearoa New Zealand And The United Kingdom

Globally, geospatial concepts are becoming increasingly important in epidemiological and public health research. Individual level linked population-based data afford researchers with opportunities to undertake complex analyses unrivalled by other sources. However, there are significant challenges associated with using such data for impactful geohealth research. Issues range from extracting, linking and anonymising data, to the translation of findings into policy whilst working to often conflicting agendas of government and academia. Innovative organisational partnerships are therefore central to effective data use. To extend and develop existing collaborations between the institutions, in June 2019, authors from the Leeds Institute for Data Analytics and the Alan Turing Institute, London, visited the Geohealth Laboratory based at the University of Canterbury, New Zealand. This paper provides an overview of insight shared during a two-day workshop considering aspects of linked population-based data for impactful geohealth research. Specifically, we discuss both the collaborative partnership between New Zealand’s Ministry of Health (MoH) and the University of Canterbury’s GeoHealth Lab and novel infrastructure, and commercial partnerships enabled through the Leeds Institute for Data Analytics and the Alan Turing Institute in the UK. We consider the New Zealand Integrated Data Infrastructure as a case study approach to population-based linked health data and compare similar approaches taken by the UK towards integrated data infrastructures, including the ESRC Big Data Network centres, the UK Biobank, and longitudinal cohorts. We reflect on and compare the geohealth landscapes in New Zealand and the UK to set out recommendations and considerations for this rapidly evolving discipline

Nucleotide sequence encoding the carboxyl-terminal half of apolipoprotein B from spontaneously hypercholesterolemic pigs.

Previous studies from this laboratory characterized the hypercholesterolemia of pigs with a mutant allele of apolipoprotein B (apoB), designated Lpb5. This apoB allele is associated with low density lipoprotein (LDL) particles deficient in binding to the LDL receptor. To identify potential causative mutations in Lpb5 DNA, 10.6 kb of genomic DNA, encoding the carboxyl-terminal 58% of apoB were sequenced from the Lpb5 allele and from an allele encoding phenotypically normal apoB. Comparison of the two DNA sequences revealed 33 polymorphisms, 13 of which resulted in amino acid polymorphisms. To determine whether any of the amino acids at the polymorphic positions in Lpb5-encoded apoB were unique to that isoform, those positions were sequenced in four other pig apoB alleles encoding phenotypically normal apoB. None of the amino acids were by themselves uniquely encoded by the Lpb5 allele. However, a unique haplotype consisting of Asp3164 in conjunction with Ala3447 distinguished the Lpb5-encoded apoB from all other allelic isoforms sequenced in this region. To gain insight into changes in the tertiary structure of the mutant apoB, 13C-NMR analysis of LDL reductively methylated with [13C]-formaldehyde was performed. LDL has lysine residues that titrate at pH 10.5 and others that titrate at pH 8.9. The latter residues are thought to include those involved in the interaction of LDL with the LDL receptor. LDL from Lpb5 pigs possessed a smaller proportion of lysine residues titrating at pH 8.9 than did LDL from non-Lpb5 pigs, suggesting that the Lpb5-encoded apoB is altered in a manner affecting the microenvironment of particular lysine residues

Evaluating the potential of agent-based modelling to capture consumer grocery retail store choice behaviours

Evolving consumer behaviours with regards to store and channel choice, shopping frequency, shopping mission and spending heighten the need for robust spatial modelling tools for use within retail analytics. In this paper, we report on collaboration with a major UK grocery retailer to assess the feasibility of modelling consumer store choice behaviours at the level of the individual consumer. We benefit from very rare access to our collaborating retailers’ customer data which we use to develop a proof-of-concept agent-based model (ABM). Utilising our collaborating retailers’ loyalty card database, we extract key consumer behaviours in relation to shopping frequency, mission, store choice and spending. We build these observed behaviours into our ABM, based on a simplified urban environment, calibrated and validated against observed consumer data. Our ABM is able to capture key spatiotemporal drivers of consumer store choice behaviour at the individual level. Our findings could afford new opportunities for spatial modelling within the retail sector, enabling the complexity of consumer behaviours to be captured and simulated within a novel modelling framework. We reflect on further model development required for use in a commercial context for location-based decision-making

Late Endosomal Cholesterol Accumulation Leads to Impaired Intra-Endosomal Trafficking

Background Pathological accumulation of cholesterol in late endosomes is observed in lysosomal storage diseases such as Niemann-Pick type C. We here analyzed the effects of cholesterol accumulation in NPC cells, or as phenocopied by the drug U18666A, on late endosomes membrane organization and dynamics. Methodology/Principal Findings Cholesterol accumulation did not lead to an increase in the raft to non-raft membrane ratio as anticipated. Strikingly, we observed a 2–3 fold increase in the size of the compartment. Most importantly, properties and dynamics of late endosomal intralumenal vesicles were altered as revealed by reduced late endosomal vacuolation induced by the mutant pore-forming toxin ASSP, reduced intoxication by the anthrax lethal toxin and inhibition of infection by the Vesicular Stomatitis Virus. Conclusions/Significance These results suggest that back fusion of intralumenal vesicles with the limiting membrane of late endosomes is dramatically perturbed upon cholesterol accumulation

Clues to Neuro-Degeneration in Niemann-Pick Type C Disease from Global Gene Expression Profiling

BACKGROUND: Niemann-Pick Type C (NPC) disease is a neurodegenerative disease that is characterized by the accumulation of cholesterol and glycosphingolipids in the late endocytic pathway. The majority of NPC cases are due to mutations in the NPC1 gene. The precise function of this gene is not yet known. METHODOLOGY/PRINCIPAL FINDINGS: Using cDNA microarrays, we analyzed the genome-wide expression patterns of human fibroblasts homozygous for the I1061T NPC1 mutation that is characterized by a severe defect in the intracellular processing of low density lipoprotein-derived cholesterol. A distinct gene expression profile was identified in NPC fibroblasts from different individuals when compared with fibroblasts isolated from normal subjects. As expected, NPC1 mutant cells displayed an inappropriate homeostatic response to accumulated intracellular cholesterol. In addition, a number of striking parallels were observed between NPC disease and Alzheimer's disease. CONCLUSIONS/SIGNIFICANCE: Many genes involved in the trafficking and processing of amyloid precursor protein and the microtubule binding protein, tau, were more highly expressed. Numerous genes important for membrane traffic and the cellular regulation of calcium, metals and other ions were upregulated. Finally, NPC fibroblasts exhibited a gene expression profile indicative of oxidative stress. These changes are likely contributors to the pathophysiology of Niemann-Pick Type C disease