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.

El diagnóstico precoz del VIH, clave en la prevención del SIDA

Boletín semanal para profesionales sanitarios de la Secretaría General de Salud Pública y Participación Social de la Consejería de Salud

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.

Single cell analysis reveals similar functional competence of dominant and nondominant CD8 T-cell clonotypes.

Immune protection from infectious diseases and cancer is mediated by individual T cells of different clonal origin. Their functions are tightly regulated but not yet fully characterized. Understanding the contribution of each T cell will improve the prediction of immune protection based on laboratory assessment of T-cell responses. Here we developed techniques for simultaneous molecular and functional assessment of single CD8 T cells directly ex vivo. We studied two groups of patients with melanoma after vaccination with two closely related tumor antigenic peptides. Vaccination induced T cells with strong memory and effector functions, as found in virtually all T cells of the first patient group, and fractions of T cells in the second group. Interestingly, high functionality was not restricted to dominant clonotypes. Rather, dominant and nondominant clonotypes acquired equal functional competence. In parallel, this was also found for EBV- and CMV-specific T cells. Thus, the nondominant clonotypes may contribute similarly to immunity as their dominant counterparts.

The Universal Protein Resource (UniProt) in 2010.

The primary mission of UniProt is to support biological research by maintaining a stable, comprehensive, fully classified, richly and accurately annotated protein sequence knowledgebase, with extensive cross-references and querying interfaces freely accessible to the scientific community. UniProt is produced by the UniProt Consortium which consists of groups from the European Bioinformatics Institute (EBI), the Swiss Institute of Bioinformatics (SIB) and the Protein Information Resource (PIR). UniProt is comprised of four major components, each optimized for different uses: the UniProt Archive, the UniProt Knowledgebase, the UniProt Reference Clusters and the UniProt Metagenomic and Environmental Sequence Database. UniProt is updated and distributed every 3 weeks and can be accessed online for searches or download at http://www.uniprot.org.

La infección por VIH y las intoxicaciones agudas por plaguicidas, incluidas en la lista de enfermedades de declaración obligatoria

Boletín semanal para profesionales sanitarios de la Secretaría General de Salud Pública y Participación Social de la Consejería de Salud

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.

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.

Biomarqueurs en immunologie générale [Biomarkers in clinical immunology].

In a current perspective of individualized medicine, biomarkers appear as a simple and readily available aid to assist clinicians in the identification and monitoring of diseases whose diagnosis is difficult. Basically, we know the limited performance of medical history and of clinical examination; therefore, the use of laboratory tests is often seen as the panacea to solve the clinical enigma. The purpose of this article is to analyze a few biomarkers commonly processed in the immunology laboratory (AAN, ANCA, anti-tTG, rheumatoid factor and anti-CCP) and to review the principle, the usefulness and the performance of these tests in specific clinical situations. We will see that, far from supplanting history and physical examination, these immunological biomarkers take their full value as a supplement to clinical information!

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.

Antigenic proteins involved in occupational rhinitis and asthma caused by obeche wood (Triplochiton scleroxylon).

BACKGROUND Obeche wood dust is a known cause of occupational asthma where an IgE-mediated mechanism has been demonstrated. OBJECTIVE To characterize the allergenic profile of obeche wood dust and evaluate the reactivity of the proteins by in vitro, ex vivo and in vivo assays in carpenters with confirmed rhinitis and/or asthma MATERIALS AND METHODS An in-house obeche extract was obtained, and two IgE binding bands were purified (24 and 12 kDa) and sequenced by N-terminal identity. Specific IgE and IgG, basophil activation tests and skin prick tests (SPTs) were performed with whole extract and purified proteins. CCD binding was analyzed by ELISA inhibition studies. RESULTS Sixty-two subjects participated: 12 with confirmed occupational asthma/rhinitis (ORA+), 40 asymptomatic exposed (ORA-), and 10 controls. Of the confirmed subjects, 83% had a positive SPT to obeche. There was a 100% recognition by ELISA in symptomatic subjects vs. 30% and 10% in asymptomatic exposed subjects and controls respectively (p<0.05). Two new proteins were purified, a 24 kDa protein identified as a putative thaumatin-like protein and a 12 kDa gamma-expansin. Both showed allergenic activity in vitro, with the putative thaumatin being the most active, with 92% recognition by ELISA and 100% by basophil activation test in ORA+ subjects. Cross-reactivity due to CCD was ruled out in 82% of cases. CONCLUSIONS Two proteins of obeche wood were identified and were recognized by a high percentage of symptomatic subjects and by a small proportion of asymptomatic exposed subjects. Further studies are required to evaluate cross reactivity with other plant allergens.