Supply-demand matrix: a process-oriented approach for data warehouses with constellation schemas

Star schema in data warehouses is a very well-established model. However, the increasing number of star schemas creating large constellations schemas add new challenges in the organizations. In this document, we intend to make a contribution in the technical architecture of data warehouses with constellation schemas using an extension of the bus matrix. The proposed supply-demand matrix details the raw data from the original databases, describes the constellation schemas with different dimensions and establishes the information demand requirements.info:eu-repo/semantics/publishedVersio

Distribution pattern of psoriasis, anxiety and depression as possible causes of sexual dysfunction in patients with moderate to severe psoriasis

BACKGROUND: Psoriasis may significantly impair sexual function. Depression and organic factors appear to play a key role in this relation. However, beyond genital psoriasis, the importance of the disease's distribution patterns has not been considered. OBJECTIVES: To research sexual function in psoriasis patients and investigate the roles of anxiety, depression and psoriasis' distribution patterns in sexual dysfunction. METHODS: A comparative study matched for sex and age was performed. Eighty patients with moderate to severe psoriasis and 80 healthy controls were included. The participants completed the Massachusetts General Hospital-Sexual Functioning Questionnaire, the Hospital Anxiety and Depression Scale, and the Self-Administered Psoriasis Area and Severity Index. RESULTS: Psoriasis was associated with sexual dysfunction, odds ratio=5.5 (CI 95% 2.6-11.3; p<0.001). Certain distribution patterns of psoriasis, involving specific body regions, were associated with an increase in sexual dysfunction in the group presenting the disease, odds ratio 7.9 (CI 95% 2.3-33.4; p<0.001). Multivariate logistic regression analysis identified anxiety and depression, and the involvement of these specific areas, as possible independent risk factors for sexual dysfunction in patients with moderate to severe psoriasis. CONCLUSION: This study identifies body areas potentially related to sexual dysfunction, independently of anxiety and depression, in psoriasis patients. The results suggest that the assessment of sexual dysfunction and the involvement of these body areas should be considered as disease severity criteria when choosing the treatment for psoriasis patients

Guidelines for the use and interpretation of assays for monitoring autophagy (4th edition)1.

In 2008, we published the first set of guidelines for standardizing research in autophagy. Since then, this topic has received increasing attention, and many scientists have entered the field. Our knowledge base and relevant new technologies have also been expanding. Thus, it is important to formulate on a regular basis updated guidelines for monitoring autophagy in different organisms. Despite numerous reviews, there continues to be confusion regarding acceptable methods to evaluate autophagy, especially in multicellular eukaryotes. Here, we present a set of guidelines for investigators to select and interpret methods to examine autophagy and related processes, and for reviewers to provide realistic and reasonable critiques of reports that are focused on these processes. These guidelines are not meant to be a dogmatic set of rules, because the appropriateness of any assay largely depends on the question being asked and the system being used. Moreover, no individual assay is perfect for every situation, calling for the use of multiple techniques to properly monitor autophagy in each experimental setting. Finally, several core components of the autophagy machinery have been implicated in distinct autophagic processes (canonical and noncanonical autophagy), implying that genetic approaches to block autophagy should rely on targeting two or more autophagy-related genes that ideally participate in distinct steps of the pathway. Along similar lines, because multiple proteins involved in autophagy also regulate other cellular pathways including apoptosis, not all of them can be used as a specific marker for bona fide autophagic responses. Here, we critically discuss current methods of assessing autophagy and the information they can, or cannot, provide. Our ultimate goal is to encourage intellectual and technical innovation in the field

The proximate composition of three marine pelagic fish: blue whiting (Micromesistius poutassou), boarfish (Capros aper) and Atlantic herring (Clupea harengus)

peer reviewedThis study presents data from an in-depth proximate compositional analysis of three marine fish species: blue whiting (Micromesistius poutassou), boarfish (Capros aper) and Atlantic herring (Clupea harengus). These fish contained significant amounts of protein (16–17%), lipids (4–11%) and minerals (2–6% ash). The proteins, particularly from boarfish, had close to optimum amino acid profiles for human and fish nutrition. They compared favourably with other fish species in terms of total lipids and relative concentration of the omega-3 fatty acids docosahexaenoic acid and eicosapentaenoic acid (11.8–13.3% and 5.9–8.1% in triacylglycerols [TG] and 24.6–35.4% and 5.8–12.0% in phospholipids [PL]). Atlantic herring had the highest lipid content among the three fish and was found to contain high levels of PL poly-unsaturated fatty acids, including omega-3 fatty acids. Minerals detected in the fish included calcium (272–1,520 mg/100 g), phosphorus (363–789 mg/100 g), iron (1.07–2.83 mg/100 g), magnesium (40.70–62.10 mg/100 g), potassium (112.00–267.00 mg/100 g), selenium (0.04–0.06 mg/100 g), sodium (218.00–282.00 mg/100 g) and zinc (1.29–5.57 mg/100 g). Boarfish had the highest ash fraction and also the highest levels of all the minerals, except potassium. Atlantic herring had considerably lower mineral content compared with the other two species and, levels detected were also lower than those reported in previously published studies. Heavy metals contents were quantified, and levels were significantly below the maximum allowable limits for all elements except arsenic, which ranged from 1.34 to 2.44 mg/kg in the three fish species. Data outlined here will be useful for guiding product development. Future studies would benefit from considering catch season, sex and developmental stage of the fish