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

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

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

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

Integrating forensic information in a crime intelligence database

Since 2008, Intelligence units of six states of the western part of Switzerland have been sharing a common database for the analysis of high volume crimes. On a daily basis, events reported to the police are analysed, filtered and classified to detect crime repetitions and interpret the crime environment. Several forensic outcomes are integrated in the system such as matches of traces with persons, and links between scenes detected by the comparison of forensic case data. Systematic procedures have been settled to integrate links assumed mainly through DNA profiles, shoemarks patterns and images. A statistical outlook on a retrospective dataset of series from 2009 to 2011 of the database informs for instance on the number of repetition detected or confirmed and increased by forensic case data. Time needed to obtain forensic intelligence in regard with the type of marks treated, is seen as a critical issue. Furthermore, the underlying integration process of forensic intelligence into the crime intelligence database raised several difficulties in regards of the acquisition of data and the models used in the forensic databases. Solutions found and adopted operational procedures are described and discussed. This process form the basis to many other researches aimed at developing forensic intelligence models.

Use of DNA profiles for investigation using a simulated national DNA database: Part II. Statistical and ethical considerations on familial searching.

Familial searching consists of searching for a full profile left at a crime scene in a National DNA Database (NDNAD). In this paper we are interested in the circumstance where no full match is returned, but a partial match is found between a database member's profile and the crime stain. Because close relatives share more of their DNA than unrelated persons, this partial match may indicate that the crime stain was left by a close relative of the person with whom the partial match was found. This approach has successfully solved important crimes in the UK and the USA. In a previous paper, a model, which takes into account substructure and siblings, was used to simulate a NDNAD. In this paper, we have used this model to test the usefulness of familial searching and offer guidelines for pre-assessment of the cases based on the likelihood ratio. Siblings of "persons" present in the simulated Swiss NDNAD were created. These profiles (N=10,000) were used as traces and were then compared to the whole database (N=100,000). The statistical results obtained show that the technique has great potential confirming the findings of previous studies. However, effectiveness of the technique is only one part of the story. Familial searching has juridical and ethical aspects that should not be ignored. In Switzerland for example, there are no specific guidelines to the legality or otherwise of familial searching. This article both presents statistical results, and addresses criminological and civil liberties aspects to take into account risks and benefits of familial searching.

New electrocardiographic criteria for discriminating between Brugada types 2 and 3 patterns and incomplete right bundle branch block.

OBJECTIVES: The aim of this study was to evaluate new electrocardiographic (ECG) criteria for discriminating between incomplete right bundle branch block (RBBB) and the Brugada types 2 and 3 ECG patterns. BACKGROUND: Brugada syndrome can manifest as either type 2 or type 3 pattern. The latter should be distinguished from incomplete RBBB, present in 3% of the population. METHODS: Thirty-eight patients with either type 2 or type 3 Brugada pattern that were referred for an antiarrhythmic drug challenge (AAD) were included. Before AAD, 2 angles were measured from ECG leads V(1) and/or V(2) showing incomplete RBBB: 1) α, the angle between a vertical line and the downslope of the r'-wave, and 2) β, the angle between the upslope of the S-wave and the downslope of the r'-wave. Baseline angle values, alone or combined with QRS duration, were compared between patients with negative and positive results on AAD. Receiver-operating characteristic curves were constructed to identify optimal discriminative cutoff values. RESULTS: The mean β angle was significantly smaller in the 14 patients with negative results on AAD compared to the 24 patients with positive results on AAD (36 ± 20° vs. 62 ± 20°, p < 0.01). Its optimal cutoff value was 58°, which yielded a positive predictive value of 73% and a negative predictive value of 87% for conversion to type 1 pattern on AAD; α was slightly less sensitive and specific compared with β. When the angles were combined with QRS duration, it tended to improve discrimination. CONCLUSIONS: In patients with suspected Brugada syndrome, simple ECG criteria can enable discrimination between incomplete RBBB and types 2 and 3 Brugada patterns.

Disseny BD sistema de descàrrega d'aplicacions per a mòbils

Per tal de gestionar tota la informació necessària per a permetre la pujada i gestió de les aplicacions en l'àmbit de l'associació mundial de desenvolupadors d'aplicacions per a mòbils intel·ligents s'ha dissenyat i implementat la base de dades que donarà persistència als valors que seran tractats per les futures aplicacions de gestió.

Disseny i implementació de la base de dades d'un sistema de descàrrega d'aplicacions per a mòbils intel·ligents

Aquest projecte incorpora el disseny i implementació d'una base de dades relacional que facilita la gestió d'un sistema de descàrregues d'aplicacions per a mòbils intel·ligents.

Disseny i implementació d'una base de dades relacional per a un concessionari de vehicles

Disseny i implementació d'una base de dades relacional per a un concessionari de vehicles.

Diseño e implementación de un sistema de descarga de aplicaciones para móviles inteligentes

El proyecto detalla la planificación, diseño y creación de un sistema de base de datos que permita la gestión de una futura plataforma centralizada para la difusión de aplicaciones móviles a nivel mundial. Se tratarán los datos correspondientes a los usuarios y desarrolladores de aplicaciones así como los correspondientes a las propias aplicaciones y sus descargas.

SwissBioisostere: a database of molecular replacements for ligand design.

The SwissBioisostere database (http://www.swissbioisostere.ch) contains information on molecular replacements and their performance in biochemical assays. It is meant to provide researchers in drug discovery projects with ideas for bioisosteric modifications of their current lead molecule, as well as to give interested scientists access to the details on particular molecular replacements. As of August 2012, the database contains 21 293 355 datapoints corresponding to 5 586 462 unique replacements that have been measured in 35 039 assays against 1948 molecular targets representing 30 target classes. The accessible data were created through detection of matched molecular pairs and mining bioactivity data in the ChEMBL database. The SwissBioisostere database is hosted by the Swiss Institute of Bioinformatics and available via a web-based interface.