Disseny i implementació d'una base de dades relacional per al manteniment d'aparells d'una empresa

Aquest projecte neix de la necessitat de la nostra empresa client de controlar la gestió del manteniment de tots els equips que té instal·lats en 32 centres i del qual s'encarreguen diverses empreses de serveis especialitzades. Així, per una banda, es tracta de fer l'anàlisi i disseny de la base de dades operacional, els scripts de creació necessaris per a crear la base de dades e implementar els procediments mitjançant els quals es gestionarà i accedirà a la informació de la base de dades. I per una altra banda, es tracta de fer l'anàlisi, disseny e implementació d'un magatzem de dades, per tal de poder explotar la informació per a la presa de decisions.

Comparison of HIV-infected patients' characteristics, healthcare resources use and cost between native and migrant patients

OBJECTIVES: To assess whether patients' characteristics and healthcare resources consumption and costs were different between native and migrant populations in Switzerland. METHODS: All adult patients followed-up in the Swiss HIV-cohort study in our institution during 2000-2003 were considered. Patients' characteristics were retrieved from the cohort database. Hospital and outpatient resource use were extracted from individual charts and valued with 2002 tariffs. RESULTS: The 66 migrants were younger (29 +/- 8 years versus 37 +/- 11, p < 0.001), less often of male gender (38 % versus 70 %, p < 0.001), predominantly infected via heterosexual contact (87 % versus 52 %, p < 0.01), with lower mean CD4 level at enrollment (326 +/- 235 versus 437 +/- 305, p = 0.002) than their 200 native counterparts. Migrants had fewer hospitalizations, more frequent outpatient visits, laboratory tests, and lower total cost of care per year of follow-up (<euro> 2'215 +/- 4'206 versus 4'155 +/- 12'304, p = 0.037). Resource use and costs were significantly higher in people with < 200 CD4 cell counts in both groups. CONCLUSIONS: Migrant population had more advanced disease, more outpatient visits but less hospitalizations, resulting in lower costs of care when compared with native population.

Disagreements among cohabiting and married couples in 22 European countries

Background: Cross-national research suggests that married people have higher levels of well-being than cohabiting people. However, relationship quality has both positive and negative dimensions. Researchers have paid little attention to disagreements within cohabiting and married couples. Objective: This study aims to improve our understanding of the meaning of cohabitation by examining disagreements within marital and cohabiting relationships. We examine variations in couples' disagreements about housework, paid work and money by country and gender. Methods: The data come from the 2004 European Social Survey. We selected respondents living in a heterosexual couple relationship and aged between 18 and 45. In total, the study makes use of data from 22 European countries and 9,657 people. Given that our dependent variable was dichotomous, we estimated multilevel logit models, with (1) disagree and (0) never disagree. Results: We find that cohabitors had more disagreements about housework, the same disagreements about money, but fewer disagreements about paid work than did married people. These findings could not be explained by socio-economic or demographic measures, nor did we find gender or cross-country differences in the association between union status and conflict. Conclusions: Cohabiting couples have more disagreements about housework but fewer disagreements about paid work than married people. There are no gender or cross-country differences in these associations. The results provide further evidence that the meaning of cohabitation differs from that of marriage, and that this difference remains consistent across nations.

Dementia, lesbians and gay men: Alzheimer's Australia

This paper was commissioned by Alzheimer's Australia to promote an informed discussion about the issues affecting lesbians or gay men with dementia or caring for someone with dementia. It addresses the issues associated with the interaction between service providers and lesbian and gay men with dementia and their family carers, including the complexity of family relationships and barriers that may affect care provision and quality of life.The focus of this paper is on lesbian and gay seniors, including their same-sex partners. Not all people with dementia are seniors; however younger lesbians and gay men living with dementia may have a number of similar concerns and needs to those of lesbian and gay seniors. This paper also includes information about the needs of younger lesbians and gay men who are supporting a heterosexual family member living with dementia.Some issues and concerns identified in this paper are shared by transgender people, as well as additional specific issues such as the impact of medical interventions on ageing, including surgical changes and hormone treatments over a long period of time. This paper encompasses the needs of those members of the transgender community to the extent to which they identify themselves as gay or lesbian, but does not address the specific needs of transgender people.This paper seeks to contextualise the issues involved and inform readers by way of discussion and case examples.Full paper available at: http://www.apo.org.au/node/23373

The last taboo: A guide to dementia, sexuality, intimacy and sexual behaviour in care homes ILC-UK

The International Longevity Centre - UK��launched a new paper (Wednesday, 6th July 2011). The last taboo: A guide to dementia, sexuality, intimacy and sexual behaviour in care homes, provides care home workers and managers with information and practical advice on this complex, controversial and sensitive issue.The need for affection, intimacy and relationships for people with dementia in care homes has too often been ignored and side-lined in policy and practice. The onset of old age or a cognitive impairment does not erase the need for affection, intimacy and/or relationships. While the issues involved can be complex, controversial and sensitive and may challenge our own beliefs and value system, it is essential that we understand more about them to foster a more person-centred approach to dementia care. Care home residents with dementia often have complex care needs and trying to understand and respond to the more intimate and sexual aspects of a resident’s personality can be challenging.Aimed at care home workers and managers, the guide not only provides essential information on this aspect of dementia care but offers practical advice to support current work-based practices. Set out in an accessible and easy-to-read format, this guide includes case studies, questions, suggestions and a self assessment quiz to promote easy learning. It also provides a possible pathway for care home managers to develop a guiding policy on sexual expression in dementia.The guide for care staff is summarised in 10 key points:1. Some residents with dementia will have sexual or sensual needs.2. Affection and intimacy contribute to overall health and wellbeing for residents.3. Some residents with dementia will have the capacity to make decisions about their needs.4. If an individual in care is not competent to decide, the home has a duty of care towards the individual to ensure they are protected from harm.5. There are no hard and fast rules. Assess each situation on an individual basis6. Remember not everyone with dementia is heterosexual.7. Inappropriate sexual behaviour is not particularly common in dementia.8. Confront your own attitudes and behaviour towards older people and sex generally.9. Communicate – look at how you can improve communication with your colleagues, managers, residents and carers on this subject10. Look after yourself and remember your own needs as a care professional��The full paper is available: The Last Taboo

Autochthonous horizontal transmission of a CRF02_AG strain revealed by a human immunodeficiency virus type 1 diversity survey in a small city in inner state of Rio de Janeiro, Southeast Brazil

As part of an ongoing study on the features of AIDS spread towards small cities and rural areas, we present a molecular survey of human immunodeficiency virus type 1 (HIV-1) polymerase sequences recovered between 2004 and 2006 from 71 patients receiving care in the city of Saquarema, inner state of Rio de Janeiro. Phylogenetic reconstructions found the two prevalent lineages in the state (subtypes B [59 strains, 83.1%], F1 [6 strains; 8.4%], and BF1 recombinants [four strains; 5.6%]), as well as two (2.8%) CRF02_AG strains, which seems to be an emerging lineage in the capital. These CRF02_AG sequences were recovered from a married heterosexual couple who never traveled abroad, thus providing the first molecular evidence of autochthonous horizontal transmission of this lineage of major global importance. Also, three phylogenetic clusters of strains recovered from a total of 18.3% of the cohort were uncovered. Their close genetic relatedness suggests they were recovered from patients who probably took part in the same chain of viral spread. In conjunction with our previous surveys from inner Rio de Janeiro, these results suggest that although small cities harbor unique molecular features of HIV-1 infection, they also clearly reflect and may rapidly absorb the diversity recorded in large urban centers.

A deterministic model to assess the impact of AIDS interventions in countries with generalized HIV epidemic. An application to Botswana

General introductionThe Human Immunodeficiency/Acquired Immunodeficiency Syndrome (HIV/AIDS) epidemic, despite recent encouraging announcements by the World Health Organization (WHO) is still today one of the world's major health care challenges.The present work lies in the field of health care management, in particular, we aim to evaluate the behavioural and non-behavioural interventions against HIV/AIDS in developing countries through a deterministic simulation model, both in human and economic terms. We will focus on assessing the effectiveness of the antiretroviral therapies (ART) in heterosexual populations living in lesser developed countries where the epidemic has generalized (formerly defined by the WHO as type II countries). The model is calibrated using Botswana as a case study, however our model can be adapted to other countries with similar transmission dynamics.The first part of this thesis consists of reviewing the main mathematical concepts describing the transmission of infectious agents in general but with a focus on human immunodeficiency virus (HIV) transmission. We also review deterministic models assessing HIV interventions with a focus on models aimed at African countries. This review helps us to recognize the need for a generic model and allows us to define a typical structure of such a generic deterministic model.The second part describes the main feed-back loops underlying the dynamics of HIV transmission. These loops represent the foundation of our model. This part also provides a detailed description of the model, including the various infected and non-infected population groups, the type of sexual relationships, the infection matrices, important factors impacting HIV transmission such as condom use, other sexually transmitted diseases (STD) and male circumcision. We also included in the model a dynamic life expectancy calculator which, to our knowledge, is a unique feature allowing more realistic cost-efficiency calculations. Various intervention scenarios are evaluated using the model, each of them including ART in combination with other interventions, namely: circumcision, campaigns aimed at behavioral change (Abstain, Be faithful or use Condoms also named ABC campaigns), and treatment of other STD. A cost efficiency analysis (CEA) is performed for each scenario. The CEA consists of measuring the cost per disability-adjusted life year (DALY) averted. This part also describes the model calibration and validation, including a sensitivity analysis.The third part reports the results and discusses the model limitations. In particular, we argue that the combination of ART and ABC campaigns and ART and treatment of other STDs are the most cost-efficient interventions through 2020. The main model limitations include modeling the complexity of sexual relationships, omission of international migration and ignoring variability in infectiousness according to the AIDS stage.The fourth part reviews the major contributions of the thesis and discusses model generalizability and flexibility. Finally, we conclude that by selecting the adequate interventions mix, policy makers can significantly reduce the adult prevalence in Botswana in the coming twenty years providing the country and its donors can bear the cost involved.Part I: Context and literature reviewIn this section, after a brief introduction to the general literature we focus in section two on the key mathematical concepts describing the transmission of infectious agents in general with a focus on HIV transmission. Section three provides a description of HIV policy models, with a focus on deterministic models. This leads us in section four to envision the need for a generic deterministic HIV policy model and briefly describe the structure of such a generic model applicable to countries with generalized HIV/AIDS epidemic, also defined as pattern II countries by the WHO.

Molecular epidemiology reveals long-term changes in HIV type 1 subtype B transmission in Switzerland.

BACKGROUND: Sequence data from resistance testing offer unique opportunities to characterize the structure of human immunodeficiency virus (HIV) infection epidemics. METHODS: We analyzed a representative set of HIV type 1 (HIV-1) subtype B pol sequences from 5700 patients enrolled in the Swiss HIV Cohort Study. We pooled these sequences with the same number of sequences from foreign epidemics, inferred a phylogeny, and identified Swiss transmission clusters as clades having a minimal size of 10 and containing >or=80% Swiss sequences. RESULTS: More than one-half of Swiss patients were included within 60 transmission clusters. Most transmission clusters were significantly dominated by specific transmission routes, which were used to identify the following patient groups: men having sex with men (MSM) (38 transmission clusters; average cluster size, 29 patients) or patients acquiring HIV through heterosexual contact (HETs) and injection drug users (IDUs) (12 transmission clusters; average cluster size, 144 patients). Interestingly, there were no transmission clusters dominated by sequences from HETs only. Although 44% of all HETs who were infected between 1983 and 1986 clustered with injection drug users, this percentage decreased to 18% for 2003-2006 (P<.001), indicating a diminishing role of injection drug users in transmission among HETs over time. CONCLUSIONS: Our analysis suggests (1) the absence of a self-sustaining epidemic of HIV-1 subtype B in HETs in Switzerland and (2) a temporally decreasing clustering of HIV infections in HETs and IDUs.

Eligibility for and outcome of treatment of latent tuberculosis infection in a cohort of HIV-infected people in Spain

BACKGROUND Previous studies have demonstrated the efficacy of treatment for latent tuberculosis infection (TLTBI) in persons infected with the human immunodeficiency virus, but few studies have investigated the operational aspects of implementing TLTBI in the co-infected population.The study objectives were to describe eligibility for TLTBI as well as treatment prescription, initiation and completion in an HIV-infected Spanish cohort and to investigate factors associated with treatment completion. METHODS Subjects were prospectively identified between 2000 and 2003 at ten HIV hospital-based clinics in Spain. Data were obtained from clinical records. Associations were measured using the odds ratio (OR) and its 95% confidence interval (95% CI). RESULTS A total of 1242 subjects were recruited and 846 (68.1%) were evaluated for TLTBI. Of these, 181 (21.4%) were eligible for TLTBI either because they were tuberculin skin test (TST) positive (121) or because their TST was negative/unknown but they were known contacts of a TB case or had impaired immunity (60). Of the patients eligible for TLTBI, 122 (67.4%) initiated TLTBI: 99 (81.1%) were treated with isoniazid for 6, 9 or 12 months; and 23 (18.9%) with short-course regimens including rifampin plus isoniazid and/or pyrazinamide. In total, 70 patients (57.4%) completed treatment, 39 (32.0%) defaulted, 7 (5.7%) interrupted treatment due to adverse effects, 2 developed TB, 2 died, and 2 moved away. Treatment completion was associated with having acquired HIV infection through heterosexual sex as compared to intravenous drug use (OR:4.6; 95% CI:1.4-14.7) and with having taken rifampin and pyrazinamide for 2 months as compared to isoniazid for 9 months (OR:8.3; 95% CI:2.7-24.9). CONCLUSIONS A minority of HIV-infected patients eligible for TLTBI actually starts and completes a course of treatment. Obstacles to successful implementation of this intervention need to be addressed.

Lung cancer in HIV-infected patients

Purpose: Several studies have shown that HIV patients are at higher risk of lung cancer. Our aim is to analyse the prevalence and features of lung cancer in HIV-infected patients. Methods: The clinical charts of 4,721 HIV-infected patients seen in three hospitals of southeast Spain (study period 1992-2012) were reviewed, and all patients with a lung cancer were analysed. Results: There were 61 lung cancers, giving a prevalence of 1.2%. There was a predominance of men (82.0%), and smokers (96.6%; mean pack-years 35.2), with a median age of 48.0 (41.7-52.9) years, and their distribution according to risk group for HIV was: intravenous drug use 58.3%, homosexual 20.0%, and heterosexual 16.7%. Thirty-four (56.7%) patients were Aids cases, and 29 (47.5%) had prior pulmonar events: tuberculosis 16, bacterial pneumonia 9, and P. jiroveci pneumonia 4. The median nadir CD4 count was 149/mm3 (42-232), the median CD4 count at the time of diagnosis of the lung cancer was 237/mm3 (85-397), and 66.1% <350/mm3. 66.7% were on ART, and 70% of them had undetectable HIV viral load. The most common histological types of lung cancer were adenocarcinoma and epidermoid, with 24 (40.0%) and 23 (38.3%) cases, respectively. There were 49 (80.3%) cases with advanced stages (III and IV) at diagnosis. The distribution of treatments was: only palliative 23 (39.7%), chemotherapy 14 (24.1%), surgery and chemotherapy 8 (13.8%), radiotherapy 7 (12.1%), surgery 4 (6.9%), and other combined treatments 2 (3.4%). Forty-six (76.7%) patients died, with a median survival time of 3 months. The Kaplan-Meier survival rate at 6 months was 42.7% (at 12 months 28.5%). Conclusions: The prevalence of lung cancer in this cohort of HIV-patients is high. People affected are mainly men, smokers, with transmission of HIV by intravenous drug use, and around half of them with prior opportunistic pulmonary events. Most patients had low nadir CD4 count, and were immunosuppressed at the time of diagnosis. Adenocarcinoma is the most frequent histological type. The diagnosis is usually made at advanced stages of the neoplasm, and mortality is high.

Detection of the B"-GWGR variant in the southernmost region of Brazil: unveiling the complexity of the human immunodeficiency virus-1 subtype B epidemic

Typical human immunodeficiency virus-1 subtype B (HIV-1B) sequences present a GPGR signature at the tip of the variable region 3 (V3) loop; however, unusual motifs harbouring a GWGR signature have also been isolated. Although epidemiological studies have detected this variant in approximately 17-50% of the total infections in Brazil, the prevalence of B"-GWGR in the southernmost region of Brazil is not yet clear. This study aimed to investigate the C2-V3 molecular diversity of the HIV-1B epidemic in southernmost Brazil. HIV-1 seropositive patients were ana-lysed at two distinct time points in the state of Rio Grande do Sul (RS98 and RS08) and at one time point in the state of Santa Catarina (SC08). Phylogenetic analysis classified 46 individuals in the RS98 group as HIV-1B and their molecular signatures were as follows: 26% B"-GWGR, 54% B-GPGR and 20% other motifs. In the RS08 group, HIV-1B was present in 32 samples: 22% B"-GWGR, 59% B-GPGR and 19% other motifs. In the SC08 group, 32 HIV-1B samples were found: 28% B"-GWGR, 59% B-GPGR and 13% other motifs. No association could be established between the HIV-1B V3 signatures and exposure categories in the HIV-1B epidemic in RS. However, B-GPGR seemed to be related to heterosexual individuals in the SC08 group. Our results suggest that the established B"-GWGR epidemics in both cities have similar patterns, which is likely due to their geographical proximity and cultural relationship.

Cas d'ús HTCondor & Amazon EC2

En aquest Treball Final de Grau s'ha implementat un clúster d'alta eficiència (HTC) amb nodes físics d'una aula d'informàtica i nodes virtuals a partir d'instàncies d'Amazon EC2 (Elastic Compute Cloud). Mitjançant la creació de dos bash scripts es gestionarà la posada en marxa dels nodes del clúster, tant físics com virtuals, per tal d'optimitzar l'ús dels recursos físics, reduir el cost energètic i disposar de la flexibilitat que ofereix el sistema de màquines virtuals d'Amazon EC2.

Modelat d'edificis basats en extrusions procedurals per a skylineEngine

Actualment ens trobem en un món on tot gira al voltant de les noves tecnologies, i un pilar fonamental és l'oci i l'entreteniment. Això engloba principalment les indústries del cinema, videojocs i realitat virtual. Un dels problemes que tenen aquestes indústries és com crear l'escenari on es produeix la història. L'objectiu d'aquest projecte de final de carrera és crear una eina integrada al skylineEngine, que serveixi per crear edificis de manera procedural, on l'usuari pugui definir l'estètica d'aquest edifici, introduint la seva planta i els perfils adequats. El que s'implementarà serà una eina de modelatge per a dissenyadors, que a partir d'una planta i perfils pugui crear l'edifici.Aquest projecte es desenvoluparà a sobre del mòdul de generació d'edificis del skylineEngine, una eina pel modelatge de ciutats que s'executa sobre el Houdini 3D, que és una plataforma genèrica pel modelatge procedural d'objectes.El desenvolupament d'aquest projecte implica:• Estudi de la plataforma de desenvolupament Houdini 3D i de les llibreries necessàries per la incorporació de scripts Python. Estudi de les EEDD internes de Houdini.• Aprendre i manejar el llenguatge de programació Python.• Estudi del codi de l'article Interactive Architectural Modeling with Procedural Extrusions, per en Tom Kelly i en Peter Wonka, publicat a la revista ACM Transactions on Graphics (2011).• Desenvolupament d'algorismes de conversió de geometria d'una estructura tipus face-vertex a una de tipus half-edge, i viceversa.• Modificació del codi Java per acceptar crides sense interfície d'usuari i amb estructures de dades generades des de Python.• Aprendre el funcionament de la llibreria JPype per permetre enllaçar el Java dins el Python.• Estudi del skylineEngine i de les llibreries per la creació d'edificis.• Integració del resultat dintre del skylineEngine.• Verificació i ajust de les regles i paràmetres de la simulació per a diferents edificis

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.

Creació d'un entorn Servidor d'accés wi-fi, usuaris i configuracions, fent servir un Live CD

El projecte consisteix en crear un entorn servidor-client, el servidor del qual controlarà les dades dels usuaris, les configuracions i validacions d'aquest. A més el servidor controlarà l'accés wi-fi dels usuaris a la xarxa inal·làmbrica. Per últim s'estableixen els mecanismes per realitzar les còpies de seguretat i restauració de les dades. També s'inclouen els scripts per al tractament de les dades dels usuaris.