Disseny i implementació de la base de dades d'un sistema de control energètic

Aquest projecte consisteix en la creació d'una base de dades per a un sistema de control energètic que vol impulsar la Comunitat Europea. La base de dades haurà d'agrupar tota la informació referent als clients, comptadors, centraletes de distribució, línies de comunicació, centrals de producció, etc.

Pulmonary biomarkers in COPD exacerbations: a systematic review.

Exacerbations of COPD (ECOPD) represent a major burden for patients and health care systems. Innovative sampling techniques have led to the identification of several pulmonary biomarkers. Although some molecules are promising, their usefulness in clinical practice is not yet established. Medline and Highwire databases were used to identify studies evaluating pulmonary sampled biomarkers in ECOPD. We combined 3 terms for ECOPD, 3 for biomarkers and 6 for the sampling method. Seventy-nine studies were considered eligible for inclusion in the review and were analyzed further. Pulmonary biomarkers sampled with non-invasive, semi-invasive and invasive methods were evaluated for their potential to illustrate the disease's clinical course, to correlate to clinical variables and to predict clinical outcomes, ECOPD etiology and response to treatment. According to published data several pulmonary biomarkers assessed in ECOPD have the potential to illustrate the natural history of disease through the modification of their levels. Among the clinically relevant molecules, those that have been studied the most and appear to be promising are spontaneous and induced sputum biomarkers for reflecting clinical severity and symptomatic recovery, as well as for directing towards an etiological diagnosis. Current evidence on the clinical usefulness of exhaled breath condensate and bronchoalveolar lavage biomarkers in ECOPD is limited. In conclusion, pulmonary biomarkers have the potential to provide information on the mechanisms underlying ECOPD, and several correlate with clinical variables and outcomes. However, on the basis of published evidence, no single molecule is adequately validated for wide clinical use. Clinical trials that incorporate biomarkers in decisional algorithms are required.

Diseño e implementación de una base de datos relacional

Con el fin de gestionar el consumo energético en el ámbito de la Comunidad Europea se ha diseñado e implementado una base de datos que dará persistencia a los valores que serán tratados por las futuras aplicaciones de gestión.

Disseny i implementació d'una base de dades relacional per a una empresa de selecció de personal

Base de dades realitzada en Oracle per controlar i ajustar les ofertes de de treball que es reben de les empreses i les demandes de feina i currículums que presenten els treballadors. Tot l'accés a les dades es realitza mitjançant procediments emmagatzemats.

Base de datos histórica dentro del ámbito de la gestión de proyectos

Trabajo de fin de carrera sobre una base de datos histórica de proyectos informáticos para la gestión de proyectos.

Bases de datos : Empresa de selección de personal

Este documento refleja el trabajo realizado durante el diseño e implementación de una base de datos relacional y un almacén de datos para una empresa de gestión de personal.

Disseny i implementació d'una base de dades relacional per a una empresa de selecció de personal

Una empresa de selecció de personal vol incorporar un sistema per controlar i ajustar les ofertes de feina que rep de les empreses i les demandes de feina i currículums que presenten els treballadors.

Disseny i implementació de la base de dades d'un sistema de control energètic

Implementació d'un sistema de base de dades per donar resposta a la necessitat de control energètic plantejada a nivell europeu. La base de dades ha de guardar informació relacionada amb el consum energètic i permetre la generació de dades estadístiques sobre l'ús de l'energia.

The sustainability of a Spanish Regional Virtual Library

Objectives: The Andalusian Health e-Library (BV-SSPA) is the National Health Library in the region of Andalusia (Spain). It is a corporate hospital library created in 2006. The year 2012 is a turning point for the Spanish economy, and the BV-SSPA has to demonstrate that it is cost-effective and sustainable. Methods: Andalusia is a wide Spanish region with more than 8 million inhabitants, more than 100,000 health professionals for 41 hospitals, 1,500 primary health care centers, and 28 centers for nonmedical attention purposes, and the BV-SSPA was created to cover all these health services. It was appointed the only intermediary for contracting electronic resources destined to the Andalusian Health System. Hospitals are not allowed to subscribe any resources, and the same services are offered for the whole system. Results: In 2011, the BV-SSPA reached the biggest electronic health sciences resource collection in Spain: a total amount of 2,431 subscribed titles, besides 8 databases and other scientific information resources. The following goals were also achieved: • Cost-effectiveness: In 2011, the BV-SSPA represented a saving percentage of 25.42% compared to the individual hospital subscription costs if they would have continued their contracting. • Efficiency: Central purchasing has meant for the Andalusian health professionals, the democracy of research resource access. Some services were also created: • integrated and safe remote access to all the library resources independent of the user’s location • citizenship website, where the resources for citizenship are grouped • Centralized Document Supply Service, focusing all the article orders from and for the Andalusian Health System • institutional repository, which contains the whole intellectual, scientific production generated by the Andalusian health professionals • computer application to study the Andalusian health system scientific production • Social media as instrument for communicating with users • science web, a defined space for researchers. Conclusions: Although Andalusia is facing a dreadful economic situation, the BV-SSPA has demonstrated its sustainability: • For 2012 renewals, it carried out a statistics study allowing obtaining enough data for deciding which titles were not being discharged by users. • Titles with no discharges or without impact factor were rejected after strong negotiation with suppliers, as the BV-SSPA after 6 years on, is considered a strong dealer by them. • This meant savings of 14% from the original budget for 2012, which allowed the continuity of the BV-SSPA without decreasing the quality offered to their users.

Update of the FANTOM web resource: from mammalian transcriptional landscape to its dynamic regulation.

The international Functional Annotation Of the Mammalian Genomes 4 (FANTOM4) research collaboration set out to better understand the transcriptional network that regulates macrophage differentiation and to uncover novel components of the transcriptome employing a series of high-throughput experiments. The primary and unique technique is cap analysis of gene expression (CAGE), sequencing mRNA 5'-ends with a second-generation sequencer to quantify promoter activities even in the absence of gene annotation. Additional genome-wide experiments complement the setup including short RNA sequencing, microarray gene expression profiling on large-scale perturbation experiments and ChIP-chip for epigenetic marks and transcription factors. All the experiments are performed in a differentiation time course of the THP-1 human leukemic cell line. Furthermore, we performed a large-scale mammalian two-hybrid (M2H) assay between transcription factors and monitored their expression profile across human and mouse tissues with qRT-PCR to address combinatorial effects of regulation by transcription factors. These interdependent data have been analyzed individually and in combination with each other and are published in related but distinct papers. We provide all data together with systematic annotation in an integrated view as resource for the scientific community (http://fantom.gsc.riken.jp/4/). Additionally, we assembled a rich set of derived analysis results including published predicted and validated regulatory interactions. Here we introduce the resource and its update after the initial release.

Disseminació, integració i visualització de dades biològiques

La recent revolució en les tècniques de generació de dades genòmiques ha portat a una situació de creixement exponencial de la quantitat de dades generades i fa més necessari que mai el treball en la optimització de la gestió i maneig d'aquesta informació. En aquest treball s'han atacat tres vessants del problema: la disseminació de la informació, la integració de dades de diverses fonts i finalment la seva visualització. Basant-nos en el Sistema d'Anotacions Distribuides, DAS, hem creat un aplicatiu per a la creació automatitzada de noves fonts de dades en format estandaritzat i accessible programàticament a partir de fitxers de dades simples. Aquest progrtamari, easyDAS, està en funcionament a l'Institut Europeu de Bioinformàtica. Aquest sistema facilita i encoratja la compartició i disseminació de dades genòmiques en formats usables. jsDAS és una llibreria client de DAS que permet incorporar dades DAS en qualsevol aplicatiu web de manera senzilla i ràpida. Aprofitant els avantatges que ofereix DAS és capaç d'integrar dades de múltiples fonts de manera coherent i robusta. GenExp és el prototip de navegador genòmic basat en web altament interactiu i que facilita l'exploració dels genomes en temps real. És capaç d'integrar dades de quansevol font DAS i crear-ne una representació en client usant els últims avenços en tecnologies web.

Mycobacterium leprae virulence-associated peptides are indicators of exposure to M. leprae in Brazil, Ethiopia and Nepal

Silent transmission of Mycobacterium leprae, as evidenced by stable leprosy incidence rates in various countries, remains a health challenge despite the implementation of multidrug therapy worldwide. Therefore, the development of tools for the early diagnosis of M. leprae infection should be emphasised in leprosy research. As part of the continuing effort to identify antigens that have diagnostic potential, unique M. leprae peptides derived from predicted virulence-associated proteins (group IV.A) were identified using advanced genome pattern programs and bioinformatics. Based on human leukocyte antigen (HLA)-binding motifs, we selected 21 peptides that were predicted to be promiscuous HLA-class I T-cell epitopes and eight peptides that were predicted to be HLA-class II restricted T-cell epitopes for field-testing in Brazil, Ethiopia and Nepal. High levels of interferon (IFN)-γ were induced when peripheral blood mononuclear cells (PBMCs) from tuberculoid/borderline tuberculoid leprosy patients located in Brazil and Ethiopia were stimulated with the ML2055 p35 peptide. PBMCs that were isolated from healthy endemic controls living in areas with high leprosy prevalence (EChigh) in Ethiopia also responded to the ML2055 p35 peptide. The Brazilian EChigh group recognised the ML1358 p20 and ML1358 p24 peptides. None of the peptides were recognised by PBMCs from healthy controls living in non-endemic region. In Nepal, mixtures of these peptides induced the production of IFN-γ by the PBMCs of leprosy patients and EChigh. Therefore, the M. leprae virulence-associated peptides identified in this study may be useful for identifying exposure to M. leprae in population with differing HLA polymorphisms.

Trends in yearly prevalence of third-generation cephalosporin and fluoroquinolone resistant Enterobacteriaceae infections and antimicrobial use in Spanish hospitals, Spain, 1999 to 2010.

Escherichia coli, Klebsiella pneumoniae, and Enterobacter spp. are a major cause of infections in hospitalised patients. The aim of our study was to evaluate rates and trends of resistance to third-generation cephalosporins and fluoroquinolones in infected patients, the trends in use for these antimicrobials, and to assess the potential correlation between both trends. The database of national point prevalence study series of infections and antimicrobial use among patients hospitalised in Spain over the period from 1999 to 2010 was analysed. On average 265 hospitals and 60,000 patients were surveyed per year yielding a total of 19,801 E. coli, 3,004 K. pneumoniae and 3,205 Enterobacter isolates. During the twelve years period, we observed significant increases for the use of fluoroquinolones (5.8%-10.2%, p<0.001), but not for third-generation cephalosporins (6.4%-5.9%, p=NS). Resistance to third-generation cephalosporins increased significantly for E. coli (5%-15%, p<0.01) and for K. pneumoniae infections (4%-21%, p<0.01) but not for Enterobacter spp. (24%). Resistance to fluoroquinolones increased significantly for E. coli (16%30%, p<0.01), for K. pneumoniae (5%-22%, p<0.01), and for Enterobacter spp. (6%-15%, p<0.01). We found strong correlations between the rate of fluoroquinolone use and the resistance to fluoroquinolones, third-generation cephalosporins, or co-resistance to both, for E. coli (R=0.97, p<0.01, R=0.94, p<0.01, and R=0.96, p<0.01, respectively), and for K. pneumoniae (R=0.92, p<0.01, R=0.91, p<0.01, and R=0.92, p<0.01, respectively). No correlation could be found between the use of third-generation cephalosporins and resistance to any of the latter antimicrobials. No significant correlations could be found for Enterobacter spp.. Knowledge of the trends in antimicrobial resistance and use of antimicrobials in the hospitalised population at the national level can help to develop prevention strategies.

Disseny i implementació de la base de dades: Sistema de votació ciutadana a nivell Europeu a través d'Internet

La Unió Europea necessita i per tant ens encarrega, un disseny de base de dades per tald'emmagatzemar la informació de futures eleccions ciutadanes a través d'Internet.

Induction of protective T-helper 1 immune responses against Echinococcus granulosus in mice by a multi-T-cell epitope antigen based on five proteins

In this study, we designed an experiment to predict a potential immunodominant T-cell epitope and evaluate the protectivity of this antigen in immunised mice. The T-cell epitopes of the candidate proteins (EgGST, EgA31, Eg95, EgTrp and P14-3-3) were detected using available web-based databases. The synthesised DNA was subcloned into the pET41a+ vector and expressed in Escherichia coli as a fusion to glutathione-S-transferase protein (GST). The resulting chimeric protein was then purified by affinity chromatography. Twenty female C57BL/6 mice were immunised with the antigen emulsified in Freund's adjuvant. Mouse splenocytes were then cultured in Dulbecco's Modified Eagle's Medium in the presence of the antigen. The production of interferon-γ was significantly higher in the immunised mice than in the control mice (> 1,300 pg/mL), but interleukin (IL)-10 and IL-4 production was not statistically different between the two groups. In a challenge study in which mice were infected with 500 live protoscolices, a high protectivity level (99.6%) was demonstrated in immunised BALB/C mice compared to the findings in the control groups [GST and adjuvant (Adj) ]. These results demonstrate the successful application of the predicted T-cell epitope in designing a vaccine against Echinococcus granulosus in a mouse model.