GestAMic : Treball Fi de Carrera - Interacció Humana amb els Ordinadors

El TFC és un estudi de millores a implantar pel que fa a usabilitat en una aplicació anomenada GestAMic mitjançant els coneixements adquirits en la assignatura d'IHO.GestAMic (Gestió d'Actius de Microinformàtica) és una eina que conté tota la base de dades de l'inventari d'actius del parc microinformàtic (CMDB) del Grup VW a Espanya, l'eina és gestionada per T-Systems Iberia. Aquesta aplicació permet fer-ne Altes, Baixes, Modificacions i Consultes dels actius sobre la CMDB.

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.

Construcció i explotació d'un magatzem de dades de planificació hidrològica

El projecte que constitueix la base de aquest TFC, consisteix en la construcció d'un magatzem de dades, com a eina de treball, per als tècnics de la Confederació Hidrogràfica Nord-Est (CHNE), que és l'entitat encarregada de la gestió de l'aigua i infraestructures hidràuliques del nord-est de la península ibèrica. Aquest magatzem ha de permetre automatitzar la recollida de la informació provinent de fulls Excel i explotar aquesta informació amb eines de Business Intelligence adients.

Optimization of treatment with interferon beta in multiple sclerosis. Usefulness of automatic system application criteria

Background. A software based tool has been developed (Optem) to allow automatize the recommendations of the Canadian Multiple Sclerosis Working Group for optimizing MS treatment in order to avoid subjective interpretation. METHODS: Treatment Optimization Recommendations (TORs) were applied to our database of patients treated with IFN beta1a IM. Patient data were assessed during year 1 for disease activity, and patients were assigned to 2 groups according to TOR: "change treatment" (CH) and "no change treatment" (NCH). These assessments were then compared to observed clinical outcomes for disease activity over the following years. RESULTS: We have data on 55 patients. The "change treatment" status was assigned to 22 patients, and "no change treatment" to 33 patients. The estimated sensitivity and specificity according to last visit status were 73.9% and 84.4%. During the following years, the Relapse Rate was always higher in the "change treatment" group than in the "no change treatment" group (5 y; CH: 0.7, NCH: 0.07; p < 0.001, 12 m - last visit; CH: 0.536, NCH: 0.34). We obtained the same results with the EDSS (4 y; CH: 3.53, NCH: 2.55, annual progression rate in 12 m - last visit; CH: 0.29, NCH: 0.13). CONCLUSION: Applying TOR at the first year of therapy allowed accurate prediction of continued disease activity in relapses and disability progression.

Consensus statement of the European guidelines on clinical management of HIV-1 tropism testing

Introduction: Testing for HIV tropism is recommended before prescribing a chemokine receptor blocker. To date, in most European countries HIV tropism is determined using a phenotypic test. Recently, new data have emerged supporting the use of a genotypic HIV V3-loop sequence analysis as the basis for tropism determination. The European guidelines group on clinical management of HIV-1 tropism testing was established to make recommendations to clinicians and virologists. Methods: We searched online databases for articles from Jan 2006 until March 2010 with the terms: tropism or CCR5-antagonist or CCR5 antagonist or maraviroc or vicriviroc. Additional articles and/or conference abstracts were identified by hand searching. This strategy identified 712 potential articles and 1240 abstracts. All were reviewed and finally 57 papers and 42 abstracts were included and used by the panel to reach a consensus statement. Results: The panel recommends HIV-tropism testing for the following indications: i) drug-naïve patients in whom toxicity or limited therapeutic options are foreseen; ii) patients experiencing therapy failure whenever a treatment change is considered. Both the phenotypic Enhanced Trofile assay (ESTA) and genotypic population sequencing of the V3-loop are recommended for use in clinical practice. Although the panel does not recommend one methodology over another it is anticipated that genotypic testing will be used more frequently because of its greater accessibility, lower cost and shorter turnaround time. The panel also provides guidance on technical aspects and interpretation issues. If using genotypic methods, triplicate PCR amplification and sequencing testing is advised using the G2P interpretation tool (clonal model) with an FPR of 10%. If the viral load is below the level of reliable amplification, proviral DNA can be used, and the panel recommends performing triplicate testing and use of an FPR of 10%. If genotypic DNA testing is not performed in triplicate the FPR should be increased to 20%. Conclusions: The European guidelines on clinical management of HIV-1 tropism testing provide an overview of current literature, evidence-based recommendations for the clinical use of tropism testing and expert guidance on unresolved issues and current developments. Current data support both the use of genotypic population sequencing and ESTA for co-receptor tropism determination. For practical reasons genotypic population sequencing is the preferred method in Europe.

IVA in addition to BMD can change the osteoporosis management in 25% of clinical routine patients

Introduction: Vertebral fracture is one of the major osteoporotic fractures which are unfortunately very often undetected. In addition, it is well known that prevalent vertebral fracture increases dramatically the risk of future additional fracture. Instant Vertebral Assessment (IVA) has been introduced in DXA device couple years ago to ease the detection of such fracture when routine DXA are performed. To correctly use such tool, ISCD provided clinical recommendation on when and how to use it. The aim of our study was to evaluate the ISCD guidelines in clinical routine patients and see how often it may change of patient management. Methods: During two months (March and April 2010), a medical questionnaire was systematically given to our clinical routine patient to check the validity of ISCD IVA recommendations in our population. In addition, all women had BMD measurement at AP spine, Femur and 1/3 radius using a Discovery A System (Hologic, Waltham, USA). When appropriate, IVA measurement had been performed on the same DXA system and had been centrally evaluated by two trained Doctors for fracture status according to the semi-quantitative method of Genant. The reading had been performed when possible between L5 and T4. Results: Out of 210 women seen in the consultation, 109 (52%) of them (mean age 68.2 ± 11.5 years) fulfilled the necessary criteria to have an IVA measurement. Out of these 109 women, 43 (incidence 39.4%) had osteoporosis at one of the three skeletal sites and 31 (incidence 28.4%) had at least one vertebral fracture. 14.7% of women had both osteoporosis and at least one vertebral fracture classifying them as "severe osteoporosis" while 46.8% did not have osteoporosis nor vertebral fracture. 24.8% of the women had osteoporosis but no vertebral fracture while 13.8% of women did have osteoporosis and vertebral fracture (clinical osteoporosis). Conclusion: In conclusion, in 52% of our patients, IVA was needed according to ISCD criteria. In half of them the IVA test influenced of patient management either by changing the type of treatment of simply by classifying patient as "clinical osteoporosis". IVA appears to be an important tool in clinical routine but unfortunately is not yet very often used in most of the centers.

Inventory and perspectives of chronic disease management programs in Switzerland: an exploratory survey.

OBJECTIVE: To describe chronic disease management programs active in Switzerland in 2007, using an exploratory survey. METHODS: We searched the internet (Swiss official websites and Swiss web-pages, using Google), a medical electronic database (Medline), reference lists of pertinent articles, and contacted key informants. Programs met our operational definition of chronic disease management if their interventions targeted a chronic disease, included a multidisciplinary team (>/=2 healthcare professionals), lasted at least six months, and had already been implemented and were active in December 2007. We developed an extraction grid and collected data pertaining to eight domains (patient population, intervention recipient, intervention content, delivery personnel, method of communication, intensity and complexity, environment, clinical outcomes). RESULTS: We identified seven programs fulfilling our operational definition of chronic disease management. Programs targeted patients with diabetes, hypertension, heart failure, obesity, psychosis and breast cancer. Interventions were multifaceted; all included education and half considered planned follow-ups. The recipients of the interventions were patients, and healthcare professionals involved were physicians, nurses, social workers, psychologists and case managers of various backgrounds. CONCLUSIONS: In Switzerland, a country with universal healthcare insurance coverage and little incentive to develop new healthcare strategies, chronic disease management programs are scarce. For future developments, appropriate evaluations of existing programs, involvement of all healthcare stakeholders, strong leadership and political will are, at least, desirable.

IVA in addition to BMD can change the osteoporosis management in 25% of clinical routine patients.

Vertebral fracture is one of the major osteoporotic fractures which are unfortunately very often undetected. In addition, it is well known that prevalent vertebral fracture increases dramatically the risk of future additional fracture. Instant Vertebral Assessment (IVA) has been introduced in DXA device couple years ago to ease the detection of such fracture when routine DXA are performed. To correctly use such tool, ISCD provided clinical recommendation on when and how to use it. The aim of our study was to evaluate the ISCD guidelines in clinical routine patients and see how often it may change of patient management. During two months (March and April 2010), a medical questionnaire was systematically given to our clinical routine patient to check the validity of ISCD IVA recommendations in our population. In addition, all women had BMD measurement at AP spine, Femur and 1/3 radius using a Discovery A System (Hologic, Waltham, USA). When appropriate, IVA measurement had been performed on the same DXA system and had been centrally evaluated by two trained Doctors for fracture status according to the semi-quantitative method of Genant. The reading had been performed when possible between L5 and T4. Out of 210 women seen in the consultation, 109 (52%) of them (mean age 68.2±11.5 years) fulfilled the necessary criteria to have an IVA measurement. Out of these 109 women, 43 (incidence 39.4%) had osteoporosis at one of the three skeletal sites and 31 (incidence 28.4%) had at least one vertebral fracture. 14.7% of women had both osteoporosis and at least one vertebral fracture classifying them as "severe osteoporosis" while 46.8% did not have osteoporosis not vertebral fracture. 24.8% of the women had osteoporosis but no vertebral fracture while 13.8% of women did have osteoporosis but vertebral fracture (Clinical osteoporosis). In conclusion, in 52% of our patients, IVA was needed according to ISCD criteria. In half of them the IVA test influenced of patient management either my changing the type of treatment of simply by classifying patient as "clinical osteoporosis". IVA appears to be an important tool in clinical routine but unfortunately is not yet very often use in most of the centers.

A validated clinical approach for the management of aspergillosis in critically ill patients: ready, steady, go!

The clinical relevance of recovering Aspergillus species in intensive care unit patients is unknown. Diagnosis of invasive pulmonary aspergillosis is extremely difficult because there are no specific tests sensitive enough to detect it. The rapidly fatal prognosis of this infection without treatment justifies early antifungal therapy. A clinical algorithm may aid clinicians to manage critically ill patients from whose respiratory specimens Aspergillus spp. have been isolated. This new tool needs to be validated in a large cohort of patients before it can be recommended.

Iron deficiency and anaemia in bariatric surgical patients: causes, diagnosis and proper management

Obesity-induced chronic inflammation leads to activation of the immune system that causes alterations of iron homeostasis including hypoferraemia, iron-restricted erythropoiesis, and finally mild-to-moderate anaemia. Thus, preoperative anaemia and iron deficiency are common among obese patients scheduled for bariatric surgery (BS). Assessment of patients should include a complete haematological and biochemical laboratory work-up, including measurement of iron stores, vitamin B12 and folate. In addition, gastrointestinal evaluation is recommended for most patients with iron-deficiency anaemia. On the other hand, BS is a long-lasting inflammatory stimulus in itself and entails a reduction of the gastric capacity and/or exclusion from the gastrointestinal tract which impair nutrients absorption, including dietary iron. Chronic gastrointestinal blood loss and iron-losingenteropathy may also contribute to iron deficiency after BS. Perioperative anaemia has been linked to increased postoperative morbidity and mortality and decreased quality of life after major surgery, whereas treatment of perioperative anaemia, and even haematinic deficiency without anaemia, has been shown to improve patient outcomes and quality of life. However, long-term follow-up data in regard to prevalence, severity, and causes of anaemia after BS are mostly absent. Iron supplements should be administered to patients after BS, but compliance with oral iron is no good. In addition, once iron deficiency has developed, it may prove refractory to oral treatment. In these situations, IV iron (which can circumvent the iron blockade at enterocytes and macrophages) has emerged as a safe and effective alternative for perioperative anaemia management. Monitoring should continue indefinitely even after the initial iron repletion and anaemia resolution, and maintenance IV iron treatment should be provided as required. New IV preparations, such ferric carboxymaltose, are safe, easy to use and up to 1000 mg can be given in a single session, thus providing an excellent tool to avoid or treat iron deficiency in this patient population.

Impactia: automating the study of the scientific production

Introduction The Andalusian Public Health System Virtual Library (Biblioteca Virtual del Sistema Sanitario Público de Andalucía, BV-SSPA) was set up in June 2006. It consists of a regional government action with the aim of democratizing the health professional access to quality scientific information, regardless of the professional workplace. Andalusia is a region with more than 8 million inhabitants, with 100,000 health professionals for 41 hospitals, 1,500 primary healthcare centres, and 28 centres for non-medical attention purposes (research, management, and educational centres). Objectives The Department of Development, Research and Investigation (R+D+i) of the Andalusian Regional Government has, among its duties, the task of evaluating the hospitals and centres of the Andalusian Public Health System (SSPA) in order to distribute its funding. Among the criteria used is the evaluation of the scientific output, which is measured using bibliometry. It is well-known that the bibliometry has a series of limitations and problems that should be taken into account, especially when it is used for non-information sciences, such us career, funding, etc. A few years ago, the bibliometric reports were done separately in each centre, but without using preset and well-defined criteria, elements which are basic when we need to compare the results of the reports. It was possible to find some hospitals which were including Meeting Abstracts in their figures, while others do not, and the same was happening with Erratum and many other differences. Therefore, the main problem that the Department of R+D+i had to deal with, when they were evaluating the health system, was that bibliometric data was not accurate and reports were not comparable. With the aim of having an unified criteria for the whole system, the Department of R+D+i ordered the BV-SSPA to do the year analysis of the scientific output of the system, using some well defined criteria and indicators, among whichstands out the Impact Factor. Materials and Methods As the Impact Factor is the bibliometric indicator that the virtual library is asked to consider, it is necessary to use the database Web of Science (WoS), since it is its owner and editor. The WoS includes the databases Science Citation Index (SCI), Social Sciences Citation Index (SSCI) and Arts & Humanities Citation Index. To gather all the documents, SCI and SSCI are used; to obtain the Impact Factor and quartils, it is used the Journal Citation Reports, JCR. Unlike other bibliographic databases, such us MEDLINE, the bibliometric database WoS includes the address of all the authors. In order to retrieve all the scientific output of the SSPA, we have done general searches, which are afterwards processed by a tool developed by our library. We have done nine different searches using the field ‘address’; eight of them including ‘Spain’ and each one of the eight Andalusian Regions, and the other one combining ‘Spain’ with all those cities where there are health centres, since we have detected that there are some authors that do not use the region in their signatures. These are some of the search strategies: AD=Malaga and AD=Spain AD=Sevill* and AD=Spain AD=SPAIN AND (AD=GUADIX OR AD=BAZA OR AD=MOTRIL) Further more, the field ‘year’ is used to determine the period. To exploit the data, the BV-SSPA has developed a tool called Impactia. It is a web application which uses a database to store the information of the documents generated by the SSPA. Impactia allows the user to automatically process the retrieved documents, assigning them to their correspondent centres. In order to do the classification of documents automaticaly, it was necessary to detect the huge variability of names of the centres that the authors use in their signatures. Therefore, Impactia knows that if an author signs as “Hospital Universitario Virgen Macarena”, “HVM” or “Hosp. Virgin Macarena”, he belongs to the same centre. The figure attached shows the variability found for the Empresa Publica Hospital de Poniente. Besides the documents from WoS, Impactia includes the documents indexed in Scopus and in other databases, where we do bibliographic searches using similar strategies to the later ones. Aware that in the health centres and hospitals there is a lot of grey literature that is not gathered in databases, Impactia allows the centres to feed the application with these documents, so that all the SSPA scientific output is gathered and organised in a centralized place. The ones responsible of localizing this gray literature are the librarians of each one of the centres. They can also do statements to the documents and indicators that are collected and calculated by Impactia. The bulk upload of documents from WoS and Scopus into Impactia is monthly done. One of the main issues that we found during the development of Impactia was the need of dealing with duplicated documents obtained from different sources. Taking into account that sometimes titles might be written differently, with slashes, comas, and so on, Impactia detects the duplicates using the field ‘DOI’ if it is available or comparing the fields: page start, page end and ISSN. Therefore it is possible to guarantee the absence of duplicates. Results The data gathered in Impactia becomes available to the administrative teams and hospitals managers, through an easy web page that allows them to know at any moment, and with just one click, the detailed information of the scientific output of their hospitals, including useful graphs such as percentage of document types, journals where their scientists usually publish, annual comparatives, bibliometric indicators and so on. They can also compare the different centres of the SSPA. Impactia allows the user to download the data from the application, so that he can work with this information or include them in their centres’ reports. This application saves the health system many working hours. It was previously done manually by forty one librarians, while now it is done by only one person in the BV-SSPA during two days a month. To sum up, the benefits of Impactia are: It has shown its effectiveness in the automatic classification, treatment and analysis of the data. It has become an essential tool for all managers to evaluate quickly and easily the scientific production of their centers. It optimizes the human resources of the SSPA, saving time and money. It is the reference point for the Department of R+D+i to do the scientific health staff evaluation.

Fluorodeoxyglucose-positron emission tomography scan-positive recurrent papillary thyroid cancer and the prognosis and implications for surgical management.

BACKGROUND To compare outcomes for patients with recurrent or persistent papillary thyroid cancer (PTC) who had metastatic tumors that were fluorodeoxyglucose-positron emission tomography (FDG-PET) positive or negative, and to determine whether the FDG-PET scan findings changed the outcome of medical and surgical management. METHODS From a prospective thyroid cancer database, we retrospectively identified patients with recurrent or persistent PTC and reviewed data on demographics, initial stage, location and extent of persistent or recurrent disease, clinical management, disease-free survival and outcome. We further identified subsets of patients who had an FDG-PET scan or an FDG-PET/CT scan and whole-body radioactive iodine scans and categorized them by whether they had one or more FDG-PET-avid (PET-positive) lesions or PET-negative lesions. The medical and surgical treatments and outcome of these patients were compared. RESULTS Between 1984 and 2008, 41 of 141 patients who had recurrent or persistent PTC underwent FDG-PET (n = 11) or FDG-PET/CT scans (n = 30); 22 patients (54%) had one or more PET-positive lesion(s), 17 (41%) had PET-negative lesions, and two had indeterminate lesions. Most PET-positive lesions were located in the neck (55%). Patients who had a PET-positive lesion had a significantly higher TNM stage (P = 0.01), higher age (P = 0.03), and higher thyroglobulin (P = 0.024). Only patients who had PET-positive lesions died (5/22 vs. 0/17 for PET-negative lesions; P = 0.04). In two of the seven patients who underwent surgical resection of their PET-positive lesions, loco-regional control was obtained without evidence of residual disease. CONCLUSION Patients with recurrent or persistent PTC and FDG-PET-positive lesions have a worse prognosis. In some patients loco-regional control can be obtained without evidence of residual disease by reoperation if the lesion is localized in the neck or mediastinum.

Timetable database restructuring

Heriot-Watt University uses a software package called Syllabus Plus for its timetabling. This package can perform scheduling functions however it is currently employed only as a room booking system at present. In academic session 2008-2009 the university will be restructuring its academic year from 3 terms of 10 weeks to semesters of 14 weeks and therefore major changes will be required to the timetabling information. This project has two functions, both with practical and relevant applications to the timetabling of the university. The aims of the project are the ability to change population number of modules and activities, delete term 3 modules and activities, the ability to change module and activity name, and change the teaching week pattern from the semester

M.A.M. (Mobile Applications Management)

L'objectiu fonamental d'aquest treball és implementar un sistema de base de dades per donar resposta a la necessitat dels desenvolupadors d'aplicacions mòbils a nivell mundial per unificar i millorar l'experiència dels seus usuaris a l'hora de descarregar les seves aplicacions.

IVA in addition to BMD can change the osteoporosis management in 25% of clinical routine patients

Introduction Vertebral fracture is one of the major osteoporoticfractures which are unfortunately very often undetected. In addition,it is well known that prevalent vertebral fracture increases dramaticallythe risk of future additional fracture. Instant Vertebral Assessment(IVA) has been introduced in DXA device a couple of years ago toease the detection of such fracture when routine DXA are performed.To correctly use such tool, ISCD provided clinical recommendationon when and how to use it. The aim of our study was to evaluate theISCD guidelines in clinical routine patients and see how often itmay change of patient management.Methods During two months (March and April 2010), a medicalquestionnaire was systematically given to our clinical routine patientto check the validity of ISCD IVA recommendations in our population.In addition, all women had BMD measurement at AP spine,femur and 1/3 radius using a Discovery A System (Hologic, Waltham,USA). When appropriate, IVA measurement had been performedon the same DXA system and had been centrally evaluated by twotrained doctors for fracture status according to the semi-quantitativemethod of Genant. The reading had been performed when possiblebetween L5 and T4.Results Out of 210 women seen in the consultation, 109 (52 %)of them (mean age 68.2 ± 11.5 years) fulfilled the necessary criteriato have an IVA measurement. Out of these 109 women, 43 (incidence39.4 %) had osteoporosis at one of the three skeletal sitesand 31 (incidence 28.4 %) had at least one vertebral fracture. 14.7 %of women had both osteoporosis and at least one vertebral fractureclassifying them as "severe osteoporosis" while 46.8 % did not haveosteoporosis and no vertebral fracture. 24.8 % of the women hadosteoporosis but no vertebral fracture while 13.8 % of women didhave osteoporosis but vertebral fracture (clinical osteoporosis).Conclusions In 52 % of our patients, IVA was needed accordingto ISCD criteria. In half of them the IVA test influenced of patientmanagement either may changing the type of treatment of simplyby classifying patient as "clinical osteoporosis". IVA appears to bean important tool in clinical routine but unfortunately is not yetvery often use in most of the centers.