Disseny i implementació de la base de dades d'un sistema de votació ciutadana a nivell europeu a través d'Internet

Disseny i implementació d'una base de dades per a la realització de votacions a travès d'internet a l'ambit de la Comunitat Europea.

Sistema de votació ciutadana a nivell europeu a través d'Internet

Disseny d'una base de dades que serveixi de magatzem d'informació per a una futura aplicació de votacions ciutadanes a través d'Internet per a la Comunitat Europea.

Disseny i implementació de la base de dades d'un sistema de votació ciutadana a nivell europeu a través d'Internet

Disseny d'una base de dades que serveixi de magatzem d'informació per a una futura aplicació de votacions ciutadanes a través d'Internet per a la Comunitat Europea.

Disseny i implementació d'una base de dades relacional per al manteniment d'aparells d'una empresa

Una empresa ens contracta ja que té la necessitat de controlar la gestió del manteniment de tots els aparells que té instal·lats en els 32 centres de treball de que disposa (com poden ser extintors, calderes, aire condicionat, fotocopiadores, escàners, impressores, plotters, etc.), i el manteniment el porten a terme diferents empreses de serveis especialitzades. Aquesta gestió i l'accés a tota la informació necessària es realitzarà mitjançant procediments de Base de Dades.La Base de Dades que es crearà ha de ser capaç de portar a terme la gestió de manteniment de tot el maquinari existent en cadascun dels centres de l'empresa, i ha de disposar d'eines que permetin, per una banda, tractar correctament la informació referent als diferents tipus de manteniment (preventiu, correctiu, adaptatiu) que es pot aplicar als diferents equips, i per l'altra, que li permetin incorporar a la Base de Dades aquelles necessites futures, és a dir, que li permetin ser escalable.Aquesta Base de Dades també disposarà de mecanismes que li permetin tractar possibles problemes d'integració amb la resta del sistema, com per exemple, la creació d'un log de les diferents accions fetes amb la Base de Dades, o diferents mecanismes per fer diversos tests de les funcionalitats del sistema.A part de la gestió de manteniment, es disposarà també un magatzem de dades (DataWarehouse) per tal de poder analitzar la informació que conté la Base de Dades anteriorment esmentada, amb l'objectiu d'ajudar a prendre decisions sobre les dades existents en un moment donat.El projecte està dividit en dos blocs principals, on el primer es dissenyarà i s'implementarà una Base de Dades relacional, amb la seva definició de requeriments, l'anàlisi i disseny, desenvolupament de procediments de base de dades i proves per testejar el correcte funcionament, mentre que el segon es dissenyarà i s'implementarà un magatzem de dades (DataWarehouse) per explotar les dades existents en la base de dades relacional.

Sistema de votación ciudadana a nivel europeo

Diseño e implementación mediante Oracle de una base de datos relacional de un sistema de votación ciudadana a nivel europeo.

Diseño e implementación de la base de datos de un sistema de votaciones ciudadano a través de internet

Memoria, presentación y producto de una base de datos para realizar votaciones ciudadanas a través de internet.

Generació de documents en application/pdf a partir d'una estructura XML

Aquesta memòria vol mostrar que la tecnologia XML és la millor alternativa per a afrontar el repte tecnològic existent en els sistemes d'extracció d'informació de les aplicacions de nova generació. Aquests sistemes, d'una banda, han de garantir la seva independència respecte dels esquemes de les bases de dades dels quals s'alimenten i, de l'altra, han de ser capaços de mostrar la informació en múltiples formats.

Estudi i avaluació de les funcionalitats de PosgreSQL

En el projecte es mostra un resum dels principals procediments oferts per PosgreSQL, per tal de gestionar les bases de dades i els usuaris, concedint i revocant els seus privilegis

On ubiquitin ligases and cancer.

Protein kinase genes account for almost 10% of all currently known cancer genes, highlighting the role of signal transduction in oncogenesis. A reexamination of the literature and available databases shows that E3 ubiquitin ligases are also key mediators of tumorigenesis. Altogether kinase and E3 genes represent more than 15% of the known cancer genes, underlining the importance of phosphorylation and ubiquitylation signaling pathways in cancer formation. Considering the recent literature reporting correlations between alterations in ubiquitylation processes and oncogenesis, this percentage is likely to increase even further in the future. Finally, E3 genes could serve as baits for the identification of additional cancer genes (e.g. their interacting partners). In contrast, deubiquitinases, like phosphatases, are not overrepresented among cancer genes. The same holds for E1 and E2 genes. Thus, kinase and E3 genes represent primary targets as cancer susceptibility genes for mutation screening and for the design of novel therapies.

Detection rate of FNA cytology in medullary thyroid carcinoma: a meta-analysis.

BACKGROUND: The early detection of medullary thyroid carcinoma (MTC) can improve patient prognosis, because histological stage and patient age at diagnosis are highly relevant prognostic factors. As a consequence, delay in the diagnosis and/or incomplete surgical treatment should correlate with a poorer prognosis for patients. Few papers have evaluated the specific capability of fine-needle aspiration cytology (FNAC) to detect MTC, and small series have been reported. This study conducts a meta-analysis of published data on the diagnostic performance of FNAC in MTC to provide more robust estimates. RESEARCH DESIGN AND METHODS: A comprehensive computer literature search of the PubMed/MEDLINE, Embase and Scopus databases was conducted by searching for the terms 'medullary thyroid' AND 'cytology', 'FNA', 'FNAB', 'FNAC', 'fine needle' or 'fine-needle'. The search was updated until 21 March 2014, and no language restrictions were used. RESULTS: Fifteen relevant studies and 641 MTC lesions that had undergone FNAC were included. The detection rate (DR) of FNAC in patients with MTC (diagnosed as 'MTC' or 'suspicious for MTC') on a per lesion-based analysis ranged from 12·5% to 88·2%, with a pooled estimate of 56·4% (95% CI: 52·6-60·1%). The included studies were statistically heterogeneous in their estimates of DR (I-square >50%). Egger's regression intercept for DR pooling was 0·03 (95% CI: -3·1 to 3·2, P = 0·9). The study that reported the largest MTC series had a DR of 45%. Data on immunohistochemistry for calcitonin in diagnosing MTC were inconsistent for the meta-analysis. CONCLUSIONS: The presented meta-analysis demonstrates that FNAC is able to detect approximately one-half of MTC lesions. These findings suggest that other techniques may be needed in combination with FNAC to diagnose MTC and avoid false negative results.

Developmental and Anatomical Constraints on Vertebrate Genome Evolution

Pendant ma thèse de doctorat, j'ai utilisé des espèces modèles, comme la souris et le poisson-zèbre, pour étudier les facteurs qui affectent l'évolution des gènes et leur expression. Plus précisément, j'ai montré que l'anatomie et le développement sont des facteurs clés à prendre en compte, car ils influencent la vitesse d'évolution de la séquence des gènes, l'impact sur eux de mutations (i.e. la délétion du gène est-elle létale ?), et leur tendance à se dupliquer. Où et quand il est exprimé impose à un gène certaines contraintes ou au contraire lui donne des opportunités d'évoluer. J'ai pu comparer ces tendances aux modèles classiques d'évolution de la morphologie, que l'on pensait auparavant refléter directement les contraintes s'appliquant sur le génome. Nous avons montré que les contraintes entre ces deux niveaux d'organisation ne peuvent pas être transférées simplement : il n'y a pas de lien direct entre la conservation du génotype et celle de phénotypes comme la morphologie. Ce travail a été possible grâce au développement d'outils bioinformatiques. Notamment, j'ai travaillé sur le développement de la base de données Bgee, qui a pour but de comparer l'expression des gènes entre différentes espèces de manière automatique et à large échelle. Cela implique une formalisation de l'anatomie, du développement et de concepts liés à l'homologie grâce à l'utilisation d'ontologies. Une intégration cohérente de données d'expression hétérogènes (puces à ADN, marqueurs de séquence exprimée, hybridations in situ) a aussi été nécessaire. Cette base de données est mise à jour régulièrement et disponible librement. Elle devrait contribuer à étendre les possibilités de comparaison de l'expression des gènes entre espèces pour des études d'évo-devo (évolution du développement) et de génomique. During my PhD, I used model species of vertebrates, such as mouse and zebrafish, to study factors affecting the evolution of genes and their expression. More precisely I have shown that anatomy and development are key factors to take into account, influencing the rate of gene sequence evolution, the impact of mutations (i.e. is the deletion of a gene lethal?), and the propensity of a gene to duplicate. Where and when genes are expressed imposes constraints, or on the contrary leaves them some opportunity to evolve. We analyzed these patterns in relation to classical models of morphological evolution in vertebrates, which were previously thought to directly reflect constraints on the genomes. We showed that the patterns of evolution at these two levels of organization do not translate smoothly: there is no direct link between the conservation of genotype and phenotypes such as morphology. This work was made possible by the development of bioinformatics tools. Notably, I worked on the development of the database Bgee, which aims at comparing gene expression between different species in an automated and large-scale way. This involves the formalization of anatomy, development, and concepts related to homology, through the use of ontologies. A coherent integration of heterogeneous expression data (microarray, expressed sequence tags, in situ hybridizations) is also required. This database is regularly updated and freely available. It should contribute to extend the possibilities for comparison of gene expression between species in evo-devo and genomics studies.

Chromosomal gene movements reflect the recent origin and biology of therian sex chromosomes

Mammalian sex chromosomes stem from ancestral autosomes and have substantially differentiated. It was shown that X-linked genes have generated duplicate intronless gene copies (retrogenes) on autosomes due to this differentiation. However, the precise driving forces for this out-of-X gene "movement" and its evolutionary onset are not known. Based on expression analyses of male germ-cell populations, we here substantiate and extend the hypothesis that autosomal retrogenes functionally compensate for the silencing of their X-linked housekeeping parental genes during, but also after, male meiotic sex chromosome inactivation (MSCI). Thus, sexually antagonistic forces have not played a major role for the selective fixation of X-derived gene copies in mammals. Our dating analyses reveal that although retrogenes were produced ever since the common mammalian ancestor, selectively driven retrogene export from the X only started later, on the placental mammal (eutherian) and marsupial (metatherian) lineages, respectively. Together, these observations suggest that chromosome-wide MSCI emerged close to the eutherian-marsupial split approximately 180 million years ago. Given that MSCI probably reflects the spread of the recombination barrier between the X and Y, crucial for their differentiation, our data imply that these chromosomes became more widely differentiated only late in the therian ancestor, well after the divergence of the monotreme lineage. Thus, our study also provides strong independent support for the recent notion that our sex chromosomes emerged, not in the common ancestor of all mammals, but rather in the therian ancestor, and therefore are much younger than previously thought

Current genetic data do not improve the prediction of type 2 diabetes mellitus: the CoLaus study.

CONTEXT: Several genetic risk scores to identify asymptomatic subjects at high risk of developing type 2 diabetes mellitus (T2DM) have been proposed, but it is unclear whether they add extra information to risk scores based on clinical and biological data. OBJECTIVE: The objective of the study was to assess the extra clinical value of genetic risk scores in predicting the occurrence of T2DM. DESIGN: This was a prospective study, with a mean follow-up time of 5 yr. SETTING AND SUBJECTS: The study included 2824 nondiabetic participants (1548 women, 52 ± 10 yr). MAIN OUTCOME MEASURE: Six genetic risk scores for T2DM were tested. Four were derived from the literature and two were created combining all (n = 24) or shared (n = 9) single-nucleotide polymorphisms of the previous scores. A previously validated clinic + biological risk score for T2DM was used as reference. RESULTS: Two hundred seven participants (7.3%) developed T2DM during follow-up. On bivariate analysis, no differences were found for all but one genetic score between nondiabetic and diabetic participants. After adjusting for the validated clinic + biological risk score, none of the genetic scores improved discrimination, as assessed by changes in the area under the receiver-operating characteristic curve (range -0.4 to -0.1%), sensitivity (-2.9 to -1.0%), specificity (0.0-0.1%), and positive (-6.6 to +0.7%) and negative (-0.2 to 0.0%) predictive values. Similarly, no improvement in T2DM risk prediction was found: net reclassification index ranging from -5.3 to -1.6% and nonsignificant (P ≥ 0.49) integrated discrimination improvement. CONCLUSIONS: In this study, adding genetic information to a previously validated clinic + biological score does not seem to improve the prediction of T2DM.

Bases de dades multimedia

Aquest treball vol fer conèixer d'una manera més o menys acurada el concepte de base de dades multimèdia i tot el que hi està relacionat. Amb aquesta finalitat, el treball s'ha estructurat de manera que el lector conegui els conceptes fonamentals de les bases de dades en general i de les multimèdia en concret, com també les tecnologies disponibles per a gestionar-les, saber com funcionen, què ofereixen, etc.