Database resources for the tuberculosis community.

Access to online repositories for genomic and associated "-omics" datasets is now an essential part of everyday research activity. It is important therefore that the Tuberculosis community is aware of the databases and tools available to them online, as well as for the database hosts to know what the needs of the research community are. One of the goals of the Tuberculosis Annotation Jamboree, held in Washington DC on March 7th-8th 2012, was therefore to provide an overview of the current status of three key Tuberculosis resources, TubercuList (tuberculist.epfl.ch), TB Database (www.tbdb.org), and Pathosystems Resource Integration Center (PATRIC, www.patricbrc.org). Here we summarize some key updates and upcoming features in TubercuList, and provide an overview of the PATRIC site and its online tools for pathogen RNA-Seq analysis.

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

Treball de final de carrera que consisteix en el disseny i implementació d'una base de dades que ha de donar suport a una aplicació per a la generació d'estadístiques de contol energètic en l'àmbit europeu.

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

El propòsit d'aquest treball és el disseny i la implementació d'una base de dades relacional d'un sistema de control energètic a nivell europeu. Aquesta base de dades emmagatzema tota la informació referent a: línies de comunicació, centrals de producció, centraletes de distribució, comptadors, clients, connexions i contractes, a més dels consums diaris, consums històrics i produccions d'energia històriques. Conseqüentment, pel manteniment de tota aquesta informació s'han creat els diferents procediments d'alta, baixa i modificacions de registres per a cada entitat.

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.

Sistema de geolocalització d'incidències a la ciutat

El servei de geolocalització d'incidències té l'objectiu de facilitar la comunicació de les incidències de l'espai públic de la nostra ciutat a les administracions locals. El ciutadà, al veure un mobiliari urbà defectuós, un arbre trencat o paviment en mal estat, podrà reportar la incidència fàcilment a l'ajuntament per a la seva resolució.

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 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.

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.