Extraction of fact tables from a relational database: an effort to establish rules in denormalization

Relational databases are supported by very well established models. However, some neglected problems can occur with the join operator: semantic mistakes caused by the multiple access path problem and faults when connection traps arise. In this paper we intend to identify and overcome those problems and to establish rules for relational data denormalization. Two denormalization forms are proposed and a case study is presented.info:eu-repo/semantics/publishedVersio

Chimpanzees overcome the tragedy of the commons with dominance

Competition over common-pool resources (CPR) is a ubiquitous challenge for social animals. Many species face similar dilemmas, yet our understanding of the evolutionary trajectory of CPR social strategies remains unexplored. Here, we provide a first look at the social strategies of our closest living relatives, chimpanzees (Pan troglodytes), in two novel resource dilemma experiments. Dyads of chimpanzees were presented with renewable resource systems, collapsible at a quantity-dependent threshold. Dyads had to continuously resist overconsumption to maximize collective gains. In study 1, dyads of chimpanzees sustained a renewing juice source. Inequality of juice acquisition between partners predicted sustaining success, indicating that one individual dominated the task while the partner inhibited. Dyads in study 2 fed together on accumulating carrot pieces but could end the accumulation any time by grabbing an immediate selfish source of carrots. Dyads with low tolerance were more successful at collectively sustaining the resource than highly tolerant dyads. Further, the dominant individual was more likely to cause collapse in dyads with low tolerance than dyads with high tolerance. These results indicate that chimpanzees use a dominance-based monopolisation strategy moderated by social tolerance to overcome the tragedy of the commons

Group Decisions in Biodiversity Conservation: Implications from Game Theory

. This paper shows how game theory may be used to inform group decisions in biodiversity conservation scenarios by modeling conflicts between stakeholders to identify Pareto–inefficient Nash equilibria. These are cases in which each agent pursuing individual self–interest leads to a worse outcome for all, relative to other feasible outcomes. Three case studies from biodiversity conservation contexts showing this feature are modeled to demonstrate how game–theoretical representation can inform group decision-making.–agent fish and coral conservation scenario from the Philippines. In each case there is reason to believe that traditional mechanism–design solutions that appeal to material incentives may be inadequate, and the game–theoretical analysis recommends a resumption of further deliberation between agents and the initiation of trust—and confidence—building measures. that formal mechanism–design solutions may backfire in certain cases. Such scenarios demand a return to group deliberation and the creation of reciprocal relationships of trust

Strength of Social Tie Predicts Cooperative Investment in a Human Social Network

Social networks – diagrams which reflect the social structure of animal groups – are increasingly viewed as useful tools in behavioural ecology and evolutionary biology. Network structure may be especially relevant to the study of cooperation, because the action of mechanisms which affect the cost:benefit ratio of cooperating (e.g. reciprocity, punishment, image scoring) is likely to be mediated by the relative position of actor and recipient in the network. Social proximity could thus affect cooperation in a similar manner to biological relatedness. To test this hypothesis, we recruited members of a real-world social group and used a questionnaire to reveal their network. Participants were asked to endure physical discomfort in order to earn money for themselves and other group members, allowing us to explore relationships between willingness to suffer a cost on another's behalf and the relative social position of donor and recipient. Cost endured was positively correlated with the strength of the social tie between donor and recipient. Further, donors suffered greater costs when a relationship was reciprocated. Interestingly, participants regularly suffered greater discomfort for very close peers than for themselves. Our results provide new insight into the effect of social structure on the direct benefits of cooperation

The experience of low back pain in people with incomplete spinal cord injury in the USA, UK and Greece

Engineering and Physical Sciences Research Council's (EPSRC

Hsf1 Activation Inhibits Rapamycin Resistance and TOR Signaling in Yeast Revealed by Combined Proteomic and Genetic Analysis

TOR kinases integrate environmental and nutritional signals to regulate cell growth in eukaryotic organisms. Here, we describe results from a study combining quantitative proteomics and comparative expression analysis in the budding yeast, S. cerevisiae, to gain insights into TOR function and regulation. We profiled protein abundance changes under conditions of TOR inhibition by rapamycin treatment, and compared this data to existing expression information for corresponding gene products measured under a variety of conditions in yeast. Among proteins showing abundance changes upon rapamycin treatment, almost 90% of them demonstrated homodirectional (i.e., in similar direction) transcriptomic changes under conditions of heat/oxidative stress. Because the known downstream responses regulated by Tor1/2 did not fully explain the extent of overlap between these two conditions, we tested for novel connections between the major regulators of heat/oxidative stress response and the TOR pathway. Specifically, we hypothesized that activation of regulator(s) of heat/oxidative stress responses phenocopied TOR inhibition and sought to identify these putative TOR inhibitor(s). Among the stress regulators tested, we found that cells (hsf1-R206S, F256S and ssa1-3 ssa2-2) constitutively activated for heat shock transcription factor 1, Hsf1, inhibited rapamycin resistance. Further analysis of the hsf1-R206S, F256S allele revealed that these cells also displayed multiple phenotypes consistent with reduced TOR signaling. Among the multiple Hsf1 targets elevated in hsf1-R206S, F256S cells, deletion of PIR3 and YRO2 suppressed the TOR-regulated phenotypes. In contrast to our observations in cells activated for Hsf1, constitutive activation of other regulators of heat/oxidative stress responses, such as Msn2/4 and Hyr1, did not inhibit TOR signaling. Thus, we propose that activated Hsf1 inhibits rapamycin resistance and TOR signaling via elevated expression of specific target genes in S. cerevisiae. Additionally, these results highlight the value of comparative expression analyses between large-scale proteomic and transcriptomic datasets to reveal new regulatory connections

Measurement of substructure-dependent jet suppression in Pb+Pb collisions at 5.02 TeV with the ATLAS detector

The ATLAS detector at the Large Hadron Collider has been used to measure jet substructure modification and suppression in Pb+Pb collisions at a nucleon–nucleon center-of-mass energy √sNN = 5.02 TeV in comparison with proton–proton (pp) collisions at √s = 5.02 TeV. The Pb+Pb data, collected in 2018, have an integrated luminosity of 1.72 nb−1, while the ppdata, collected in 2017, have an integrated luminosity of 260 pb−1. Jets used in this analysis are clustered using the anti-kt algorithm with a radius parameter R = 0.4. The jet constituents, defined by both tracking and calorimeter information, are used to determine the angular scale rg of the first hard splitting inside the jet by reclustering them using the Cambridge–Aachen algorithm and employing the soft-drop grooming technique. The nuclear modification factor, RAA, used to characterize jet suppression in Pb+Pb collisions, is presented differentially in rg, jet transverse momentum, and in intervals of collision centrality. The RAA value is observed to depend significantly on jet rg. Jets produced with the largest measured rg are found to be twice as suppressed as those with the smallest rg in central Pb+Pb collisions. The RAA values do not exhibit a strong variation with jet pT in any of the rg intervals. The rg and pT dependence of jet RAA is qualitatively consistent with a picture of jet quenching arising from coherence and provides the most direct evidence in support of this approach

Impaired mitochondrial calcium efflux contributes to disease progression in models of Alzheimer’s disease

Impairments in neuronal intracellular calcium (iCa2+) handling may contribute to Alzheimer’s disease (AD) development. Metabolic dysfunction and progressive neuronal loss are associated with AD progression, and mitochondrial calcium (mCa2+) signaling is a key regulator of both of these processes. Here, we report remodeling of the mCa2+ exchange machinery in the prefrontal cortex of individuals with AD. In the 3xTg-AD mouse model impaired mCa2+ efflux capacity precedes neuropathology. Neuronal deletion of the mitochondrial Na+/Ca2+ exchanger (NCLX, Slc8b1 gene) accelerated memory decline and increased amyloidosis and tau pathology. Further, genetic rescue of neuronal NCLX in 3xTg-AD mice is sufficient to impede AD-associated pathology and memory loss. We show that mCa2+ overload contributes to AD progression by promoting superoxide generation, metabolic dysfunction and neuronal cell death. These results provide a link between the calcium dysregulation and metabolic dysfunction hypotheses of AD and suggest mCa2+ exchange as potential therapeutic target in AD

American palm ethnomedicine: A meta-analysis

<p>Abstract</p> <p>Background</p> <p>Many recent papers have documented the phytochemical and pharmacological bases for the use of palms (<it>Arecaceae</it>) in ethnomedicine. Early publications were based almost entirely on interviews that solicited local knowledge. More recently, ethnobotanically guided searches for new medicinal plants have proven more successful than random sampling for identifying plants that contain biodynamic ingredients. However, limited laboratory time and the high cost of clinical trials make it difficult to test all potential medicinal plants in the search for new drug candidates. The purpose of this study was to summarize and analyze previous studies on the medicinal uses of American palms in order to narrow down the search for new palm-derived medicines.</p> <p>Methods</p> <p>Relevant literature was surveyed and data was extracted and organized into medicinal use categories. We focused on more recent literature than that considered in a review published 25 years ago. We included phytochemical and pharmacological research that explored the importance of American palms in ethnomedicine.</p> <p>Results</p> <p>Of 730 species of American palms, we found evidence that 106 species had known medicinal uses, ranging from treatments for diabetes and leishmaniasis to prostatic hyperplasia. Thus, the number of American palm species with known uses had increased from 48 to 106 over the last quarter of a century. Furthermore, the pharmacological bases for many of the effects are now understood.</p> <p>Conclusions</p> <p>Palms are important in American ethnomedicine. Some, like <it>Serenoa repens </it>and <it>Roystonea regia</it>, are the sources of drugs that have been approved for medicinal uses. In contrast, recent ethnopharmacological studies suggested that many of the reported uses of several other palms do not appear to have a strong physiological basis. This study has provided a useful assessment of the ethnobotanical and pharmacological data available on palms.</p

Multi-messenger observations of a binary neutron star merger

On 2017 August 17 a binary neutron star coalescence candidate (later designated GW170817) with merger time 12:41:04 UTC was observed through gravitational waves by the Advanced LIGO and Advanced Virgo detectors. The Fermi Gamma-ray Burst Monitor independently detected a gamma-ray burst (GRB 170817A) with a time delay of ~1.7 s with respect to the merger time. From the gravitational-wave signal, the source was initially localized to a sky region of 31 deg2 at a luminosity distance of 40+8-8 Mpc and with component masses consistent with neutron stars. The component masses were later measured to be in the range 0.86 to 2.26 Mo. An extensive observing campaign was launched across the electromagnetic spectrum leading to the discovery of a bright optical transient (SSS17a, now with the IAU identification of AT 2017gfo) in NGC 4993 (at ~40 Mpc) less than 11 hours after the merger by the One- Meter, Two Hemisphere (1M2H) team using the 1 m Swope Telescope. The optical transient was independently detected by multiple teams within an hour. Subsequent observations targeted the object and its environment. Early ultraviolet observations revealed a blue transient that faded within 48 hours. Optical and infrared observations showed a redward evolution over ~10 days. Following early non-detections, X-ray and radio emission were discovered at the transient’s position ~9 and ~16 days, respectively, after the merger. Both the X-ray and radio emission likely arise from a physical process that is distinct from the one that generates the UV/optical/near-infrared emission. No ultra-high-energy gamma-rays and no neutrino candidates consistent with the source were found in follow-up searches. These observations support the hypothesis that GW170817 was produced by the merger of two neutron stars in NGC4993 followed by a short gamma-ray burst (GRB 170817A) and a kilonova/macronova powered by the radioactive decay of r-process nuclei synthesized in the ejecta