Disseny i implementació d'una base de dades relacional per a la gestió d'apostes de futbol

Memòria del projecte final de carrera on es desenvolupen la planificació de les tasques, la definició i anàlisi dels requeriments, l'enumeració dels casos d'ús, el disseny de la base de dades operacional i de data warehouse, implementació dels esquemes, realització de proves unitàries i procedimentació i tasques d'extracció, transformació i càrrega. L'usuari s'haurà de validar usant la funció login i per poder accedir a la informació haurà d'usar els paquets de la base de dades sense poder accedir directament a les dades de les taules.

La figura del mediador intercultural a les institucions escolars catalanes: perfil real i ideal segons els propis actors

A Catalunya, en els darrers anys, han anat proliferant una sèrie de «professionals» que realitzen, amb més o menys adequació a la definició teòrica, la funció de mediadors inter-culturals. Primerament, es tractava de gitanos, però darrerament, fruit de l’increment de la presència d’infants d’origen immigrant a les escoles catalanes, s’ha vist créixer el nombre i el protagonisme dels estrangers pel reconeixement que se’ls ha donat des de l’Administració i des de les institucions. Els mediadors han intentat intervenir en qüestions com ara la participació dels pares d’origen minoritari, l’adaptació del currículum a la diversitat cultural, la negociació de conflictes culturals, la desescolarització, l’absentisme i l’abandonament escolar dels alumnes durant el període d’escolarització obligatòria, la traducció lingüística i la interpretació sociocultural, etc. Concretament, la nostra recerca ha consistit en vint-i-set entrevistes en profunditat a mediadors interculturals de tot Catalunya.

Relación entre variables de personalidad e interés por temas morbosos y sexuales en los mass media: réplica del estudio de Zuckerman y Litle en una muestra española

Este trabajo pretende replicar con muestras españolas un estudio americano diseñado para evaluar las relaciones entre el rasgo Búsquesa de Sensaciones, Extraversión, Neuroticismo y Psicoticismo, con el interés por la contemplación o lectura de sucesos violentos, morbosos y sexuales en los medios de comunicación (o reales). El estudio se realizó a partir de inventarios autoinformados de curiosidad morbosa, cuestionarios de personalidad y autopuntuaciones de asistencia a películas pornográficas y de terror. Los resultados obtenidos informan de una relación positiva entre las escalas de Búsqueda de Sensaciones (EBS) y las escalas de Curiosidad Morbosa (CTM-CTS). Ello sugiere como hipótesis que los altos buscadores de sensaciones podrían estar interesados en estímulos que aumentan la actividad del sistema central de catecolaminas. Para ello se parte de hallazgos experimentales previos que apuntan que películas morbosas de terror o sexuales aumentan los niveles de las catecolaminas periféricas.

A genetic risk score combining 32 SNPs is associated with body mass index and improves obesity prediction in people with major depressive disorder.

BACKGROUND: Obesity is strongly associated with major depressive disorder (MDD) and various other diseases. Genome-wide association studies have identified multiple risk loci robustly associated with body mass index (BMI). In this study, we aimed to investigate whether a genetic risk score (GRS) combining multiple BMI risk loci might have utility in prediction of obesity in patients with MDD. METHODS: Linear and logistic regression models were conducted to predict BMI and obesity, respectively, in three independent large case-control studies of major depression (Radiant, GSK-Munich, PsyCoLaus). The analyses were first performed in the whole sample and then separately in depressed cases and controls. An unweighted GRS was calculated by summation of the number of risk alleles. A weighted GRS was calculated as the sum of risk alleles at each locus multiplied by their effect sizes. Receiver operating characteristic (ROC) analysis was used to compare the discriminatory ability of predictors of obesity. RESULTS: In the discovery phase, a total of 2,521 participants (1,895 depressed patients and 626 controls) were included from the Radiant study. Both unweighted and weighted GRS were highly associated with BMI (P <0.001) but explained only a modest amount of variance. Adding 'traditional' risk factors to GRS significantly improved the predictive ability with the area under the curve (AUC) in the ROC analysis, increasing from 0.58 to 0.66 (95% CI, 0.62-0.68; χ(2) = 27.68; P <0.0001). Although there was no formal evidence of interaction between depression status and GRS, there was further improvement in AUC in the ROC analysis when depression status was added to the model (AUC = 0.71; 95% CI, 0.68-0.73; χ(2) = 28.64; P <0.0001). We further found that the GRS accounted for more variance of BMI in depressed patients than in healthy controls. Again, GRS discriminated obesity better in depressed patients compared to healthy controls. We later replicated these analyses in two independent samples (GSK-Munich and PsyCoLaus) and found similar results. CONCLUSIONS: A GRS proved to be a highly significant predictor of obesity in people with MDD but accounted for only modest amount of variance. Nevertheless, as more risk loci are identified, combining a GRS approach with information on non-genetic risk factors could become a useful strategy in identifying MDD patients at higher risk of developing obesity.

Modulation of genetic associations with serum urate levels by body-mass-index in humans.

We tested for interactions between body mass index (BMI) and common genetic variants affecting serum urate levels, genome-wide, in up to 42569 participants. Both stratified genome-wide association (GWAS) analyses, in lean, overweight and obese individuals, and regression-type analyses in a non BMI-stratified overall sample were performed. The former did not uncover any novel locus with a major main effect, but supported modulation of effects for some known and potentially new urate loci. The latter highlighted a SNP at RBFOX3 reaching genome-wide significant level (effect size 0.014, 95% CI 0.008-0.02, Pinter= 2.6 x 10-8). Two top loci in interaction term analyses, RBFOX3 and ERO1LB-EDARADD, also displayed suggestive differences in main effect size between the lean and obese strata. All top ranking loci for urate effect differences between BMI categories were novel and most had small magnitude but opposite direction effects between strata. They include the locus RBMS1-TANK (men, Pdifflean-overweight= 4.7 x 10-8), a region that has been associated with several obesity related traits, and TSPYL5 (men, Pdifflean-overweight= 9.1 x 10-8), regulating adipocytes-produced estradiol. The top-ranking known urate loci was ABCG2, the strongest known gout risk locus, with an effect halved in obese compared to lean men (Pdifflean-obese= 2 x 10-4). Finally, pathway analysis suggested a role for N-glycan biosynthesis as a prominent urate-associated pathway in the lean stratum. These results illustrate a potentially powerful way to monitor changes occurring in obesogenic environment.

Disponibilitat per a les plantes de Mn, Cu, Zn i Cd en els sòls de diferents sistemes agrícoles a Catalunya

Es va avaluar el contingut del sòl en Mn, Cu, Zn, Ni i Cd fent una extracció amb DTPA, segons el mètode de Lindsay i Norvell (1969). Les mostres analitzades procedien de parcel·les agrícoles d'arreu de Catalunya, conservades al Banc de Mostres de Sòls del Mapa de Sòls de Catalunya del DARP. Els resultats es van agrupar per sistemes agrícoles en funció de l'origen de les mostres, ja que dins de cada un es pot assumir una reducció important en l'interval de variació de diferents factors. Es va realitzar una comparació estadística entre els valors mitjans dels diferents sistemes agrícoles, entre els valors mitjans de les dues profunditats de sòl considerades, i una interpretació agronòmica. Els resultats van indicar que els sòls procedents d'horticultura intensiva del Maresme són els que tenen continguts disponibles més elevats dels metalls considerats. D'altra banda, es fa palès que els valors estan condicionats tant pel material originari del sòl com per l'acció antròpica. Per al Cu i el Zn en les mostres de sòls del Maresme els continguts trobats estan molt per sobre dels mínims considerats com a agronòmicament satisfactoris.

Mutations in NDUFB11, Encoding a Complex I Component of the Mitochondrial Respiratory Chain, Cause Microphthalmia with Linear Skin Defects Syndrome.

Microphthalmia with linear skin defects (MLS) syndrome is an X-linked male-lethal disorder also known as MIDAS (microphthalmia, dermal aplasia, and sclerocornea). Additional clinical features include neurological and cardiac abnormalities. MLS syndrome is genetically heterogeneous given that heterozygous mutations in HCCS or COX7B have been identified in MLS-affected females. Both genes encode proteins involved in the structure and function of complexes III and IV, which form the terminal segment of the mitochondrial respiratory chain (MRC). However, not all individuals with MLS syndrome carry a mutation in either HCCS or COX7B. The majority of MLS-affected females have severe skewing of X chromosome inactivation, suggesting that mutations in HCCS, COX7B, and other as-yet-unidentified X-linked gene(s) cause selective loss of cells in which the mutated X chromosome is active. By applying whole-exome sequencing and filtering for X-chromosomal variants, we identified a de novo nonsense mutation in NDUFB11 (Xp11.23) in one female individual and a heterozygous 1-bp deletion in a second individual, her asymptomatic mother, and an affected aborted fetus of the subject's mother. NDUFB11 encodes one of 30 poorly characterized supernumerary subunits of NADH:ubiquinone oxidoreductase, known as complex I (cI), the first and largest enzyme of the MRC. By shRNA-mediated NDUFB11 knockdown in HeLa cells, we demonstrate that NDUFB11 is essential for cI assembly and activity as well as cell growth and survival. These results demonstrate that X-linked genetic defects leading to the complete inactivation of complex I, III, or IV underlie MLS syndrome. Our data reveal an unexpected role of cI dysfunction in a developmental phenotype, further underscoring the existence of a group of mitochondrial diseases associated with neurocutaneous manifestations.

Cell cycle regulation of mitochondrial function.

Specific cellular functions, such as proliferation, survival, growth, or senescence, require a particular adaptive metabolic response, which is fine tuned by members of the cell cycle regulators families. Currently, proteins such as cyclins, CDKs, or E2Fs are being studied in the context of cell proliferation and survival, cell signaling, cell cycle regulation, and cancer. We show in this review that cellular, animal and molecular studies provided enough evidence to prove that these factors play, in addition, crucial roles in the control of mitochondrial function; finally resulting in a dual proliferative and metabolic response.

Chronic NSAID use and long-term decline of renal function in a prospective rheumatoid arthritis cohort study.

OBJECTIVES: Non-steroidal anti-inflammatory drugs (NSAIDs) may cause kidney damage. This study assessed the impact of prolonged NSAID exposure on renal function in a large rheumatoid arthritis (RA) patient cohort. METHODS: Renal function was prospectively followed between 1996 and 2007 in 4101 RA patients with multilevel mixed models for longitudinal data over a mean period of 3.2 years. Among the 2739 'NSAID users' were 1290 patients treated with cyclooxygenase type 2 selective NSAIDs, while 1362 subjects were 'NSAID naive'. Primary outcome was the estimated glomerular filtration rate according to the Cockroft-Gault formula (eGFRCG), and secondary the Modification of Diet in Renal Disease and Chronic Kidney Disease Epidemiology Collaboration formula equations and serum creatinine concentrations. In sensitivity analyses, NSAID dosing effects were compared for patients with NSAID registration in ≤/>50%, ≤/>80% or ≤/>90% of assessments. FINDINGS: In patients with baseline eGFRCG >30 mL/min, eGFRCG evolved without significant differences over time between 'NSAID users' (mean change in eGFRCG -0.87 mL/min/year, 95% CI -1.15 to -0.59) and 'NSAID naive' (-0.67 mL/min/year, 95% CI -1.26 to -0.09, p=0.63). In a multivariate Cox regression analysis adjusted for significant confounders age, sex, body mass index, arterial hypertension, heart disease and for other insignificant factors, NSAIDs were an independent predictor for accelerated renal function decline only in patients with advanced baseline renal impairment (eGFRCG <30 mL/min). Analyses with secondary outcomes and sensitivity analyses confirmed these results. CONCLUSIONS: NSAIDs had no negative impact on renal function estimates but in patients with advanced renal impairment.

Identification of carotenoids using mass spectrometry

The present review compiles positive MS fragmentation data of selected carotenoids obtained using various ionization techniques and matrices. In addition, new experimental data from the analysis of carotenoids in transgenic maize and rice callus are provided. Several carotenes and oxygen-functionalized carotenoids containing epoxy, hydroxyl, and ketone groups were ionized by atmospheric pressure chemical ionization (APCI)-tandem mass spectrometry (MS/MS) in positive ion mode. Thus, on the basis of the information obtained from the literature and our own experiments, we identified characteristic carotenoid ions that can be associated to functional groups in the structures of these compounds. In addition, pigments with a very similar structure were differentiated through comparison of the intensities of their fragments. The data provide a basis for the structural elucidation of carotenoids by mass spectrometry (MS).

Evolution and cellular function of monothiol glutaredoxins: involvement in iron-sulphur cluster assembly

A number of bacterial species, mostly proteobacteria, possess monothiol glutaredoxins homologous to the Saccharomyces cerevisiae mitochondrial protein Grx5, which is involved in iron–sulphur cluster synthesis. Phylogenetic profiling is used to predict that bacterial monothiol glutaredoxins also participate in the iron–sulphur cluster (ISC) assembly machinery, because their phylogenetic profiles are similar to the profiles of the bacterial homologues of yeast ISC proteins. High evolutionary cooccurrence is observed between the Grx5 homologues and the homologues of the Yah1 ferredoxin, the scaffold proteins Isa1 and Isa2, the frataxin protein Yfh1 and the Nfu1 protein. This suggests that a specific functional interaction exists between these ISC machinery proteins. Physical interaction analyses using low-definition protein docking predict the formation of strong and specific complexes between Grx5 and several components of the yeast ISC machinery. Two-hybrid analysis has confirmed the in vivo interaction between Grx5 and Isa1. Sequence comparison techniques and cladistics indicate that the other two monothiol glutaredoxins of S. cerevisiae, Grx3 and Grx4, have evolved from the fusion of a thioredoxin gene with a monothiol glutaredoxin gene early in the eukaryotic lineage, leading to differential functional specialization. While bacteria do not contain these chimaeric glutaredoxins, in many eukaryotic species Grx5 and Grx3/4-type monothiol glutaredoxins coexist in the cell.

Genome-wide association study of kidney function decline in individuals of European descent.

Genome-wide association studies (GWASs) have identified multiple loci associated with cross-sectional eGFR, but a systematic genetic analysis of kidney function decline over time is missing. Here we conducted a GWAS meta-analysis among 63,558 participants of European descent, initially from 16 cohorts with serial kidney function measurements within the CKDGen Consortium, followed by independent replication among additional participants from 13 cohorts. In stage 1 GWAS meta-analysis, single-nucleotide polymorphisms (SNPs) at MEOX2, GALNT11, IL1RAP, NPPA, HPCAL1, and CDH23 showed the strongest associations for at least one trait, in addition to the known UMOD locus, which showed genome-wide significance with an annual change in eGFR. In stage 2 meta-analysis, the significant association at UMOD was replicated. Associations at GALNT11 with Rapid Decline (annual eGFR decline of 3 ml/min per 1.73 m(2) or more), and CDH23 with eGFR change among those with CKD showed significant suggestive evidence of replication. Combined stage 1 and 2 meta-analyses showed significance for UMOD, GALNT11, and CDH23. Morpholino knockdowns of galnt11 and cdh23 in zebrafish embryos each had signs of severe edema 72 h after gentamicin treatment compared with controls, but no gross morphological renal abnormalities before gentamicin administration. Thus, our results suggest a role in the deterioration of kidney function for the loci GALNT11 and CDH23, and show that the UMOD locus is significantly associated with kidney function decline.Kidney International advance online publication, 10 December 2014; doi:10.1038/ki.2014.361.

Adaptations of Natural Killer Cells to Self-MHC Class I.

Natural Killer (NK) cells use germ line encoded receptors to detect diseased host cells. Despite the invariant recognition structures, NK cells have a significant ability to adapt to their surroundings, such as the presence or absence of MHC class I molecules. It has been assumed that this adaptation occurs during NK cell development, but recent findings show that mature NK cells can also adapt to the presence or absence of MHC class I molecules. Here, we summarize how NK cells adjust to changes in the expression of MHC class I molecules. We propose an extension of existing models, in which MHC class I recognition during NK cell development sequentially instructs and maintains NK cell function. The elucidation of the molecular basis of the two effects may identify ways to improve the fitness of NK cells and to prevent the loss of NK cell function due to persistent alterations in their environment.

Spectral analysis of the angular distribution function of back reflectors for thin film silicon solar cells

Nowadays, one of the most important challenges to enhance the efficiency of thin film silicon solar cells is to increase the short circuit intensity by means of optical confinement methods, such as textured back-reflector structures. In this work, two possible textured structures to be used as back reflectors for n-i-p solar cells have been optically analyzed and compared to a smooth one by using a system which is able to measure the angular distribution function (ADF) of the scattered light in a wide spectral range (350-1000 nm). The accurate analysis of the ADF data corresponding to the reflector structures and to the μc-Si:H films deposited onto them allows the optical losses due to the reflector absorption and its effectiveness in increasing light absorption in the μc-Si:H layer, mainly at long wavelengths, to be quantified.

Copeptin is associated with kidney length, renal function, and prevalence of simple cysts in a population-based study.

Arginine vasopressin (AVP) has a key role in osmoregulation by facilitating water transport in the collecting duct. Recent evidence suggests that AVP may have additional effects on renal function and favor cyst growth in polycystic kidney disease. Whether AVP also affects kidney structure in the general population is unknown. We analyzed the association of copeptin, an established surrogate for AVP, with parameters of renal function and morphology in a multicentric population-based cohort. Participants from families of European ancestry were randomly selected in three Swiss cities. We used linear multilevel regression analysis to explore the association of copeptin with renal function parameters as well as kidney length and the presence of simple renal cysts assessed by ultrasound examination. Copeptin levels were log-transformed. The 529 women and 481 men had median copeptin levels of 3.0 and 5.2 pmol/L, respectively (P<0.001). In multivariable analyses, the copeptin level was associated inversely with eGFR (β=-2.1; 95% confidence interval [95% CI], -3.3 to -0.8; P=0.002) and kidney length (β=-1.2; 95% CI, -1.9 to -0.4; P=0.003) but positively with 24-hour urinary albumin excretion (β=0.11; 95% CI, 0.01 to 0.20; P=0.03) and urine osmolality (β=0.08; 95% CI, 0.05 to 0.10; P<0.001). A positive association was found between the copeptin level and the presence of renal cysts (odds ratio, 1.6; 95% CI, 1.1 to 2.4; P=0.02). These results suggest that AVP has a pleiotropic role in renal function and may favor the development of simple renal cysts.