Construcció i explotació d'un magatzem de dades per a l'anàlisi estadístic dels resultats del Campionat de Fórmula 1

En els darrers anys les organitzacions han anat agafant consciència de la importància de la gestió de la seva informació. D'aquesta necessitat d'organitzar les pròpies dades d'una forma coherent i eficient per al seu anàlisi sorgeixen els magatzems de dades. El projecte "Construcció i explotació d'un magatzem de dades per a l'anàlisi estadístic dels resultats del Campionat de Fórmula 1" s'emmarca dins aquest context i te com a objectiu el disseny d'un magatzem de dades per a cobrir les necessitats del Institut Català d'Esports de Motor (ICEM) en la gestió de les seves dades referents a la Fórmula 1. En aquest projecte s'han executat les diferents fases necessàries per a la creació d'un nou magatzem. En primer lloc s'ha fet l'anàlisi de requeriments i de les dades disponibles. A continuació s'ha fet el disseny i la implementació física del magatzem de dades. Seguidament s'ha procedit amb l'extracció, transformació i càrrega de dades originals (ETL) i per finalitzar s'han creat els informes. Com a resultat s'han obtingut una sèrie d'informes per a ser consumits de manera immediata pels usuaris del ICEM. Aquests informes han de permetre l'anàlisi de les dades d'una forma senzilla i àgil. A més s'ha implementat un sistema d'actualització automàtic de les dades que per al manteniment de la informació del magatzem.La implementació del magatzem de dades s'ha fet sobre una base de dades Oracle 10g Express Edition i els informes s'ha dissenyat amb l'eina Oracle Discoverer. Per a l'automatització de les dades s'ha fet servir a més visual basic script i l'eina de càrrega SQL*Loader.

A randomized controlled trial of the effectiveness of a Computer-Assisted Cognitive Remediation (CACR) program in adolescents with psychosis or at high risk of psychosis: Short term and long term outcomes

The present study investigates the short- and long-term outcomes of a computer-assisted cognitive remediation (CACR) program in adolescents with psychosis or at high risk. 32 adolescents participated in a blinded 8-week randomized controlled trial of CACR treatment compared to computer games (CG). Clinical and neuropsychological evaluations were undertaken at baseline, at the end of the program and at 6-month. At the end of the program (n = 28), results indicated that visuospatial abilities (Repeatable Battery for the Assessment of Neuropsychological Status, RBANS; P = .005) improved signifi cantly more in the CACR group compared to the CG group. Furthermore, other cognitive functions (RBANS), psychotic symptoms (Positive and Negative Symptom Scale) and psychosocial functioning (Social and Occupational Functioning Assessment Scale) improved signifi cantly, but at similar rates, in the two groups. At long term (n = 22), cognitive abilities did not demonstrated any amelioration in the control group while, in the CACR group, signifi cant long-term improvements in inhibition (Stroop; P = .040) and reasoning (Block Design Test; P = .005) were observed. In addition, symptom severity (Clinical Global Improvement) decreased signifi cantly in the control group (P = .046) and marginally in the CACR group (P = .088). To sum up, CACR can be successfully administered in this population. CACR proved to be effective over and above CG for the most intensively trained cognitive ability. Finally, on the long-term, enhanced reasoning and inhibition abilities, which are necessary to execute higher-order goals or to adapt behavior to the ever-changing environment, were observed in adolescents benefi ting from a CACR.

Depression with atypical features and increase in obesity, body mass index, waist circumference, and fat mass: a prospective, population-based study.

IMPORTANCE: Depression and obesity are 2 prevalent disorders that have been repeatedly shown to be associated. However, the mechanisms and temporal sequence underlying this association are poorly understood. OBJECTIVE: To determine whether the subtypes of major depressive disorder (MDD; melancholic, atypical, combined, or unspecified) are predictive of adiposity in terms of the incidence of obesity and changes in body mass index (calculated as weight in kilograms divided by height in meters squared), waist circumference, and fat mass. DESIGN, SETTING, AND PARTICIPANTS: This prospective population-based cohort study, CoLaus (Cohorte Lausannoise)/PsyCoLaus (Psychiatric arm of the CoLaus Study), with 5.5 years of follow-up included 3054 randomly selected residents (mean age, 49.7 years; 53.1% were women) of the city of Lausanne, Switzerland (according to the civil register), aged 35 to 66 years in 2003, who accepted the physical and psychiatric baseline and physical follow-up evaluations. EXPOSURES: Depression subtypes according to the DSM-IV. Diagnostic criteria at baseline and follow-up, as well as sociodemographic characteristics, lifestyle (alcohol and tobacco use and physical activity), and medication, were elicited using the semistructured Diagnostic Interview for Genetic Studies. MAIN OUTCOMES AND MEASURES: Changes in body mass index, waist circumference, and fat mass during the follow-up period, in percentage of the baseline value, and the incidence of obesity during the follow-up period among nonobese participants at baseline. Weight, height, waist circumference, and body fat (bioimpedance) were measured at baseline and follow-up by trained field interviewers. RESULTS: Only participants with the atypical subtype of MDD at baseline revealed a higher increase in adiposity during follow-up than participants without MDD. The associations between this MDD subtype and body mass index (β = 3.19; 95% CI, 1.50-4.88), incidence of obesity (odds ratio, 3.75; 95% CI, 1.24-11.35), waist circumference in both sexes (β = 2.44; 95% CI, 0.21-4.66), and fat mass in men (β = 16.36; 95% CI, 4.81-27.92) remained significant after adjustments for a wide range of possible cofounding. CONCLUSIONS AND RELEVANCE: The atypical subtype of MDD is a strong predictor of obesity. This emphasizes the need to identify individuals with this subtype of MDD in both clinical and research settings. Therapeutic measures to diminish the consequences of increased appetite during depressive episodes with atypical features are advocated.

Mandibular osteoradionecrosis in squamous cell carcinoma of the oral cavity and oropharynx: incidence and risk factors.

Objective. Mandibular osteoradionecrosis (ORN) is a serious complication of radiotherapy (RT) in head and neck cancer patients. The aim of this study was to analyze the incidence of and risk factors for mandibular ORN in squamous cell carcinoma (SCC) of the oral cavity and oropharynx.Study Design. Case series with chart review.Setting. University tertiary care center for head and neck oncology.Subjects and Methods. Seventy-three patients treated for stage I to IV SCC of the oral cavity and oropharynx between 2000 and 2007, with a minimum follow-up of 2 years, were included in the study. Treatment modalities included both RT with curative intent and adjuvant RT following tumor surgery. The log-rank test and Cox model were used for univariate and multivariate analyses.Results. The incidence of mandibular ORN was 40% at 5 years. Using univariate analysis, the following risk factors were identified: oral cavity tumors (P < .01), bone invasion (P < .02), any surgery prior to RT (P < .04), and bone surgery (P < .0001). By multivariate analysis, mandibular surgery proved to be the most important risk factor and the only one reaching statistical significance (P < .0002).Conclusion. Mandibular ORN is a frequent long-term complication of RT for oral cavity and oropharynx cancers. Mandibular surgery before irradiation is the only independent risk factor. These aspects must be considered when planning treatment for these tumors.

Effect of untreated bed nets on blood-fed Phlebotomus argentipes in kala-azar endemic foci in Nepal and India

Observational studies in the Indian subcontinent have shown that untreated nets may be protective against visceral leishmaniasis (VL). In this study, we evaluated the effect of untreated nets on the blood feeding rates of Phlebotomus argentipes as well as the human blood index (HBI) in VL endemic villages in India and Nepal. The study had a "before and after intervention" design in 58 households in six clusters. The use of untreated nets reduced the blood feeding rate by 85% (95% CI 76.5-91.1%) and the HBI by 42.2% (95% CI 11.1-62.5%). These results provide circumstantial evidence that untreated nets may provide some degree of personal protection against sand fly bites.

Influences of body weight, body composition, and substrate oxidation rate on resting postabsorptive glucose production and gluconeogenesis.

OBJECTIVE: To determine the influence of body weight, fat mass, and fat distribution on resting endogenous glucose production in healthy lean and overweight individuals. DESIGN: measurements were performed in the resting postabsorptive state in individuals receiving an unrestricted diet. SETTING: Institute of Physiology of Lausanne University. MEASUREMENTS: resting post absorptive glucose production, glycogenolysis and gluconeogenesis; resting energy expenditure and net substrate oxidation. RESULTS: Endogenous glucose production was positively correlated with body weight, lean body mass, energy expenditure and carbohydrate oxidation. Gluconeogenesis was positively correlated with net lipid oxidation and energy expenditure, and negatively correlated with net carbohydrate oxidation. No correlation with body fat or fat distribution was observed. CONCLUSIONS: Gluconeogenesis shows a large interindividual variability. Net lipid oxidation and not body fat appears to be a major determinant of gluconeogenesis.

Adolescents' beliefs about marijuana use: a comparison of regular users, past users and never/occasional users.

A questionnaire investigating adolescents' opinions and experiences regarding marijuana use was administered to 163 adolescents and young adults (96 boys and 67 girls) aged 13 to 20 (mean age = 16.8, s.d. = 1.5). Items referred to marijuana and other substances' dangerousness, representations regarding the positive and negative consequences of marijuana use. Responses were compared according to marijuana use status (classified into never/occasional use, current regular use and past regular use). Results show that adolescents' opinions differ according to their experience with marijuana use. Current regular users evaluate marijuana as less dangerous, but alcohol and heroin as more dangerous in comparison with never/occasional and past users. Current and past users are more likely to define marijuana as a medical drug and a plant used in agriculture, and less likely to define it as an illegal drug. Current and past users evaluate marijuana use as a way to cope with stress, to relax to a greater extent than do never/occasional users do. The latter attribute more negative consequences to marijuana use such as diminished driving ability and school performance and a pathway to hard drugs.

Do socioeconomic factors shape weight and obesity trajectories over the transition from midlife to old age? Results from the French GAZEL cohort study

BACKGROUND: Obesity is a contemporary epidemic that does not affect all age groups and sections of society equally. OBJECTIVE: The objective was to examine socioeconomic differences in trajectories of body mass index (BMI; in kg/m(2)) and obesity between the ages of 45 and 65 y. DESIGN: A total of 13,297 men and 4532 women from the French GAZEL (Gaz de France Electricité de France) cohort study reported their height in 1990 and their weight annually over the subsequent 18 y. Changes in BMI and obesity between ages 45 and 49 y, 50 and 54 y, 55 and 59 y, and 60 and 65 y as a function of education and occupational position (at age 35 y) were modeled by using linear mixed models and generalized estimating equations. RESULTS: BMI and obesity rates increased between the ages of 45 and 65 y. In men, BMI was higher in unskilled workers than in managers at age 45 y; this difference in BMI increased from 0.82 (95% CI: 0.66, 0.99) at 45 y to 1.06 (95% CI: 0.85, 1.27) at 65 y. Men with a primary school education compared with those with a high school degree at age 45 y had a 0.75 (95% CI: 0.51, 1.00) higher BMI, and this difference increased to 1.32 (95% CI: 1.03,1.62) at age 65 y. Obesity rates were 3.35% and 7.68% at age 45 y and 9.52% and 18.10% at age 65 y in managers and unskilled workers, respectively; the difference in obesity increased by 4.25% (95% CI: 1.87, 6.52). A similar trend was observed in women. Conclusions: Weight continues to increase in the transition between midlife and old age; this increase is greater in lower socioeconomic groups.

Genetic variability in a population of arbuscular mycorrhizal fungi causes variation in plant growth.

Different species of arbuscular mycorrhizal fungi (AMF) alter plant growth and affect plant coexistence and diversity. Effects of within-AMF species or within-population variation on plant growth have received less attention. High genetic variation exists within AMF populations. However, it is unknown whether genetic variation contributes to differences in plant growth. In our study, a population of AMF was cultivated under identical conditions for several generations prior to the experiments thus avoiding environmental maternal effects. We show that genetically different Glomus intraradices isolates from one AMF population significantly alter plant growth in an axenic system and in greenhouse experiments. Isolates increased or reduced plant growth meaning that plants potentially receive benefits or are subject to costs by forming associations with different individuals in the AMF population. This shows that genetic variability in AMF populations could affect host-plant fitness and should be considered in future research to understand these important soil organisms.

Microstructural, chemical and isotopic evidence for the origin of late neolithic leather recovered from an ice field in the Swiss Alps

Archaeological leather samples recovered from the ice field at the Schnidejoch Pass (altitude 2756 m amsl) in the western Swiss Alps were studied using optical, chemical molecular and isotopic (delta(13)C and delta(15)N of the bulk leather, and compound-specific delta(13)C analyses of the organic-solvent extracted fatty acids) methods to obtain insight into the origin of the leather and ancient tanning procedures. For comparison, leathers from modern native animals in alpine environment (red deer, goat, sheep, chamois, and calf/cow) were analyzed using the same approach. Optical and electron microscopically comparisons of Schnidejoch and modern leathers showed that the gross structure (pattern of collagen fibrils and intra-fibrils material) of archaeological leather had survived essentially intact for five millennia. The SEM studies of the hairs from the most important archaeological find, a Neolithic leather legging, show a wave structure of the hair cuticle, which is a diagnostic feature for goatskins. The variations of the bulk delta(13)C and delta(15)N values, and delta(13)C values of the main fatty acids are within the range expected for pre-industrial temperate C(3) environment. The archaeological leather samples contain a mixture of indigenous (from the animal) and exogenous plant/animal lipids. An important amount of waxy n-alkanes, n-alkan-1-ols and phytosterols (beta-sitosterol, sitostanol) in all samples, and abundant biomarker of conifers (nonacosan-10-01) in the legging leathers clearly indicate that the Neolithic people were active in a subalpine coniferous forest, and that they used an aqueous extract of diverse plant material for tanning leather. (C) 2010 Elsevier Ltd. All rights reserved.

Trends in self-reported past alcoholic beverage consumption and ethanol intake from 1950 to 1995 observed in eight European countries participating in the European Investigation into Cancer and Nutrition (EPIC).

OBJECTIVE To describe the trends of self-reported past consumption of alcoholic beverages and ethanol intake from 1950 to 1995 within the European Prospective Investigation into Cancer and Nutrition (EPIC). DESIGN Data on consumption of beer/cider, wine and liqueur/spirits were obtained retrospectively at age 20, 30 and 40 years to calculate average consumption and ethanol intake for the time periods 1950-1975 (at age 20), 1960-1985 (at age 30) and 1970-1995 (at age 40). Regression analysis was conducted with the time period data to assess trends in past alcoholic beverage consumption and ethanol intake with time. SETTING The EPIC project. SUBJECTS In total, 392 064 EPIC participants (275 249 women and 116 815 men) from 21 study centres in eight European countries. RESULTS Generally, increases in beer/cider consumption were observed for most EPIC centres for 1950-1975, 1960-1985 and 1970-1995. Trends in wine consumption differed according to geographical location: downward trends with time were observed for men in southern European EPIC centres, upward trends for those in middle/northern European study centres. For women, similar but less pronounced trends were observed. Because wine consumption was the major contributor to ethanol intake for both men and women in most study centres, time trends for ethanol intake showed a similar geographical pattern to that of wine consumption. CONCLUSION The different trends in alcoholic beverage consumption and ethanol intake suggest that information depicting lifetime history of ethanol intake should be included in analyses of the relationship between ethanol and chronic diseases, particularly in multi-centre studies such as EPIC.

Disruption of GIP/GIPR axis in human adipose tissue is linked to obesity and insulin resistance.

CONTEXT Glucose-dependent insulinotropic peptide (GIP) has a central role in glucose homeostasis through its amplification of insulin secretion; however, its physiological role in adipose tissue is unclear. OBJECTIVE Our objective was to define the function of GIP in human adipose tissue in relation to obesity and insulin resistance. DESIGN GIP receptor (GIPR) expression was analyzed in human sc adipose tissue (SAT) and visceral adipose (VAT) from lean and obese subjects in 3 independent cohorts. GIPR expression was associated with anthropometric and biochemical variables. GIP responsiveness on insulin sensitivity was analyzed in human adipocyte cell lines in normoxic and hypoxic environments as well as in adipose-derived stem cells obtained from lean and obese patients. RESULTS GIPR expression was downregulated in SAT from obese patients and correlated negatively with body mass index, waist circumference, systolic blood pressure, and glucose and triglyceride levels. Furthermore, homeostasis model assessment of insulin resistance, glucose, and G protein-coupled receptor kinase 2 (GRK2) emerged as variables strongly associated with GIPR expression in SAT. Glucose uptake studies and insulin signaling in human adipocytes revealed GIP as an insulin-sensitizer incretin. Immunoprecipitation experiments suggested that GIP promotes the interaction of GRK2 with GIPR and decreases the association of GRK2 to insulin receptor substrate 1. These effects of GIP observed under normoxia were lost in human fat cells cultured in hypoxia. In support of this, GIP increased insulin sensitivity in human adipose-derived stem cells from lean patients. GIP also induced GIPR expression, which was concomitant with a downregulation of the incretin-degrading enzyme dipeptidyl peptidase 4. None of the physiological effects of GIP were detected in human fat cells obtained from an obese environment with reduced levels of GIPR. CONCLUSIONS GIP/GIPR signaling is disrupted in insulin-resistant states, such as obesity, and normalizing this function might represent a potential therapy in the treatment of obesity-associated metabolic disorders.

Prevalence, characteristics, and publication of discontinued randomized trials.

IMPORTANCE: The discontinuation of randomized clinical trials (RCTs) raises ethical concerns and often wastes scarce research resources. The epidemiology of discontinued RCTs, however, remains unclear. OBJECTIVES: To determine the prevalence, characteristics, and publication history of discontinued RCTs and to investigate factors associated with RCT discontinuation due to poor recruitment and with nonpublication. DESIGN AND SETTING: Retrospective cohort of RCTs based on archived protocols approved by 6 research ethics committees in Switzerland, Germany, and Canada between 2000 and 2003. We recorded trial characteristics and planned recruitment from included protocols. Last follow-up of RCTs was April 27, 2013. MAIN OUTCOMES AND MEASURES: Completion status, reported reasons for discontinuation, and publication status of RCTs as determined by correspondence with the research ethics committees, literature searches, and investigator surveys. RESULTS: After a median follow-up of 11.6 years (range, 8.8-12.6 years), 253 of 1017 included RCTs were discontinued (24.9% [95% CI, 22.3%-27.6%]). Only 96 of 253 discontinuations (37.9% [95% CI, 32.0%-44.3%]) were reported to ethics committees. The most frequent reason for discontinuation was poor recruitment (101/1017; 9.9% [95% CI, 8.2%-12.0%]). In multivariable analysis, industry sponsorship vs investigator sponsorship (8.4% vs 26.5%; odds ratio [OR], 0.25 [95% CI, 0.15-0.43]; P < .001) and a larger planned sample size in increments of 100 (-0.7%; OR, 0.96 [95% CI, 0.92-1.00]; P = .04) were associated with lower rates of discontinuation due to poor recruitment. Discontinued trials were more likely to remain unpublished than completed trials (55.1% vs 33.6%; OR, 3.19 [95% CI, 2.29-4.43]; P < .001). CONCLUSIONS AND RELEVANCE: In this sample of trials based on RCT protocols from 6 research ethics committees, discontinuation was common, with poor recruitment being the most frequently reported reason. Greater efforts are needed to ensure the reporting of trial discontinuation to research ethics committees and the publication of results of discontinued trials.

Association of alcohol consumption and HIV surrogate markers in participants of the swiss HIV cohort study.

BACKGROUND: Alcohol consumption may affect the course of HIV infection and/or antiretroviral therapy (ART). The authors investigated the association between self-reported alcohol consumption and HIV surrogate markers in both treated and untreated individuals. DESIGN: Prospective cohort study. METHODS: Over a 7-year period, the authors analyzed 2 groups of individuals in the Swiss HIV Cohort Study: (1) ART-naïve individuals remaining off ART and (2) individuals initiating first ART. For individuals initiating first ART, time-dependent Cox proportional hazards models were used to assess the association between alcohol consumption, virological failure, and ART interruption. For both groups, trajectories of log-transformed CD4 cell counts were analyzed using linear mixed models with repeated measures. RESULTS: The authors included 2982 individuals initiating first ART and 2085 ART naives. In individuals initiating first ART, 241 (8%) experienced virological failure. Alcohol consumption was not associated with virological failure. ART interruption was noted in 449 (15%) individuals and was more prevalent in severe compared with none/light health risk drinkers [hazard ratio: 2.24, 95% confidence interval: 1.42 to 3.52]. The association remained significant even after adjusting for nonadherence. The authors did not find an association between alcohol consumption and change in CD4 cell count over time in either group. CONCLUSIONS: No effect of alcohol consumption on either virological failure or CD4 cell count in both groups of ART-initiating and ART-naive individuals was found. However, severe drinkers were more likely to interrupt ART. Efforts on ART continuation should be especially implemented in individuals reporting high alcohol consumption.

Social meets molecular: Combining phylogenetic and latent class analyses to understand HIV-1 transmission in Switzerland.

Switzerland has a complex human immunodeficiency virus (HIV) epidemic involving several populations. We examined transmission of HIV type 1 (HIV-1) in a national cohort study. Latent class analysis was used to identify socioeconomic and behavioral groups among 6,027 patients enrolled in the Swiss HIV Cohort Study between 2000 and 2011. Phylogenetic analysis of sequence data, available for 4,013 patients, was used to identify transmission clusters. Concordance between sociobehavioral groups and transmission clusters was assessed in correlation and multiple correspondence analyses. A total of 2,696 patients were infected with subtype B, 203 with subtype C, 196 with subtype A, and 733 with recombinant subtypes (mainly CRF02_AG and CRF01_AE). Latent class analysis identified 8 patient groups. Most transmission clusters of subtype B were shared between groups of gay men (groups 1-3) or between the heterosexual groups "heterosexual people of lower socioeconomic position" (group 4) and "injection drug users" (group 8). Clusters linking homosexual and heterosexual groups were associated with "older heterosexual and gay people on welfare" (group 5). "Migrant women in heterosexual partnerships" (group 6) and "heterosexual migrants on welfare" (group 7) shared non-B clusters with groups 4 and 5. Combining approaches from social and molecular epidemiology can provide insights into HIV-1 transmission and inform the design of prevention strategies.