Gestión integral de un concesionario

El resultado del TFC es una aplicación distribuida para gestionar varios departamentos de una red de concesionarios. El trabajo se ha realizado utilizando las tecnologías de la plataforma .NET de Microsoft.

Bases de datos en el contexto de la web semántica

Comparativa sobre sistemas de gestión de bases de datos orientados a la web semántica, tanto nativos como habilitados para esta función.

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

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

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

En aquest projecte es recullen totes les fases necessàries per dissenyar i implementar una base de dades relacional que asseguri la persistència de les dades relatives a les entitats implicades.

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

En aquest projecte final de carrera es realitzarà un projecte simulat d'una situació en què una organització contracta els serveis d'una empresa per desenvolupar una base de dades per gestionar aplicacions mòbils. El que es pretén amb el projecte és simular totes les etapes d'un projecte real des de la presa de requeriments fins a la implementació.

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

Desenvolupament d'una base de dades per a aplicacions de mòbils intel·ligents.

Producción y Productividad Agrícolas en la Isla de Mallorca, 1590-1860

This paper proposes a detailed measurement of the agricultural development of the island of Majorca from the late sixteenth century to the midnineteenth century, with an emphasis on the products which made up the bulk of the island’s agricultural production. The authors have organized most of the existing databases in the island’s archives and have also incorporated quantitative and qualitative material from their own research and that of other colleagues. Due to their quality and regularity, the data are among the richest known for pre-industrial Europe. These sources lead to some conclusions which link with recent debates in European economic history concerning the calculation of economic growth in economies for periods before statistics were kept. The text presents a methodological analysis covering almost 80 per cent of agricultural production of the island of Majorca and leaves conclusions to be supplemented by further studies of the manufacturing and service sectors

DEL FESTIVAL A LA ACADEMIA. Informe sobre la institucionalización de una disciplina híbrida (arte digital)

Aquest document és un esborrany. Amb l'objectiu d'aprofundir en el procés d'institucionalització, vam dissenyar una investigació empírica que permetés visualitzar les tendències discursives i àmbits d'activitats de les pràctiques relacionades amb les interseccions entre l'art, la ciència i la tecnologia. La metodologia va consistir en la implementació de tres bases de dades que recullen l'activitat dels últims anys en relació a: 1) els congressos (i festivals associats) realitzats a nivell internacional 2) les publicacions acadèmiques i divulgatives centrades en aquest àmbit interdisciplinar 3) els programes acadèmics.

NQL, Natural Query Language

Desarrollo de un sistema capaz de procesar consultas en lenguaje natural introducidas por el usuario mediante el teclado. El sistema es capaz de responder a consultas en castellano, relacionadas con un dominio de aplicación representado mediante una base de datos relacional.

Diseño e implementación de una base de datos relacional para la gestión sanitaria

El ejercicio que se nos plantea es desarrollar una base de datos para la gestión integral del sistema sanitario. Además, también tendremos que crear un almacén de datos para facilitar el análisis de la situación del sistema.

Human synthetic lethal inference as potential anti-cancer target gene detection

Background: Two genes are called synthetic lethal (SL) if mutation of either alone is not lethal, but mutation of both leads to death or a significant decrease in organism's fitness. The detection of SL gene pairs constitutes a promising alternative for anti-cancer therapy. As cancer cells exhibit a large number of mutations, the identification of these mutated genes' SL partners may provide specific anti-cancer drug candidates, with minor perturbations to the healthy cells. Since existent SL data is mainly restricted to yeast screenings, the road towards human SL candidates is limited to inference methods. Results: In the present work, we use phylogenetic analysis and database manipulation (BioGRID for interactions, Ensembl and NCBI for homology, Gene Ontology for GO attributes) in order to reconstruct the phylogenetically-inferred SL gene network for human. In addition, available data on cancer mutated genes (COSMIC and Cancer Gene Census databases) as well as on existent approved drugs (DrugBank database) supports our selection of cancer-therapy candidates.Conclusions: Our work provides a complementary alternative to the current methods for drug discovering and gene target identification in anti-cancer research. Novel SL screening analysis and the use of highly curated databases would contribute to improve the results of this methodology.

Knowledge management for systems biology a general and visually driven framework applied to translational medicine

Background: To enhance our understanding of complex biological systems like diseases we need to put all of the available data into context and use this to detect relations, pattern and rules which allow predictive hypotheses to be defined. Life science has become a data rich science with information about the behaviour of millions of entities like genes, chemical compounds, diseases, cell types and organs, which are organised in many different databases and/or spread throughout the literature. Existing knowledge such as genotype - phenotype relations or signal transduction pathways must be semantically integrated and dynamically organised into structured networks that are connected with clinical and experimental data. Different approaches to this challenge exist but so far none has proven entirely satisfactory. Results: To address this challenge we previously developed a generic knowledge management framework, BioXM™, which allows the dynamic, graphic generation of domain specific knowledge representation models based on specific objects and their relations supporting annotations and ontologies. Here we demonstrate the utility of BioXM for knowledge management in systems biology as part of the EU FP6 BioBridge project on translational approaches to chronic diseases. From clinical and experimental data, text-mining results and public databases we generate a chronic obstructive pulmonary disease (COPD) knowledge base and demonstrate its use by mining specific molecular networks together with integrated clinical and experimental data. Conclusions: We generate the first semantically integrated COPD specific public knowledge base and find that for the integration of clinical and experimental data with pre-existing knowledge the configuration based set-up enabled by BioXM reduced implementation time and effort for the knowledge base compared to similar systems implemented as classical software development projects. The knowledgebase enables the retrieval of sub-networks including protein-protein interaction, pathway, gene - disease and gene - compound data which are used for subsequent data analysis, modelling and simulation. Pre-structured queries and reports enhance usability; establishing their use in everyday clinical settings requires further simplification with a browser based interface which is currently under development.

SGP-1: prediction and validation of homologous genes based on sequence alignments

Conventional methods of gene prediction rely on the recognition of DNA-sequence signals, the coding potential or the comparison of a genomic sequence with a cDNA, EST, or protein database. Reasons for limited accuracy in many circumstances are species-specific training and the incompleteness of reference databases. Lately, comparative genome analysis has attracted increasing attention. Several analysis tools that are based on human/mouse comparisons are already available. Here, we present a program for the prediction of protein-coding genes, termed SGP-1 (Syntenic Gene Prediction), which is based on the similarity of homologous genomic sequences. In contrast to most existing tools, the accuracy of SGP-1 depends little on species-specific properties such as codon usage or the nucleotide distribution. SGP-1 may therefore be applied to nonstandard model organisms in vertebrates as well as in plants, without the need for extensive parameter training. In addition to predicting genes in large-scale genomic sequences, the program may be useful to validate gene structure annotations from databases. To this end, SGP-1 output also contains comparisons between predicted and annotated gene structures in HTML format. The program can be accessed via a Web server at http://soft.ice.mpg.de/sgp-1. The source code, written in ANSI C, is available on request from the authors.

A general definition and nomenclature for alternative splicing events

Understanding the molecular mechanisms responsible for the regulation of the transcriptome present in eukaryotic cells isone of the most challenging tasks in the postgenomic era. In this regard, alternative splicing (AS) is a key phenomenoncontributing to the production of different mature transcripts from the same primary RNA sequence. As a plethora ofdifferent transcript forms is available in databases, a first step to uncover the biology that drives AS is to identify thedifferent types of reflected splicing variation. In this work, we present a general definition of the AS event along with anotation system that involves the relative positions of the splice sites. This nomenclature univocally and dynamically assignsa specific ‘‘AS code’’ to every possible pattern of splicing variation. On the basis of this definition and the correspondingcodes, we have developed a computational tool (AStalavista) that automatically characterizes the complete landscape of ASevents in a given transcript annotation of a genome, thus providing a platform to investigate the transcriptome diversityacross genes, chromosomes, and species. Our analysis reveals that a substantial part—in human more than a quarter—ofthe observed splicing variations are ignored in common classification pipelines. We have used AStalavista to investigate andto compare the AS landscape of different reference annotation sets in human and in other metazoan species and found thatproportions of AS events change substantially depending on the annotation protocol, species-specific attributes, andcoding constraints acting on the transcripts. The AStalavista system therefore provides a general framework to conductspecific studies investigating the occurrence, impact, and regulation of AS.

EGASP: the human ENCODE Genome Annotation Assessment Project

Background: We present the results of EGASP, a community experiment to assess the state-ofthe-art in genome annotation within the ENCODE regions, which span 1% of the human genomesequence. The experiment had two major goals: the assessment of the accuracy of computationalmethods to predict protein coding genes; and the overall assessment of the completeness of thecurrent human genome annotations as represented in the ENCODE regions. For thecomputational prediction assessment, eighteen groups contributed gene predictions. Weevaluated these submissions against each other based on a ‘reference set’ of annotationsgenerated as part of the GENCODE project. These annotations were not available to theprediction groups prior to the submission deadline, so that their predictions were blind and anexternal advisory committee could perform a fair assessment.Results: The best methods had at least one gene transcript correctly predicted for close to 70%of the annotated genes. Nevertheless, the multiple transcript accuracy, taking into accountalternative splicing, reached only approximately 40% to 50% accuracy. At the coding nucleotidelevel, the best programs reached an accuracy of 90% in both sensitivity and specificity. Programsrelying on mRNA and protein sequences were the most accurate in reproducing the manuallycurated annotations. Experimental validation shows that only a very small percentage (3.2%) of the selected 221 computationally predicted exons outside of the existing annotation could beverified.Conclusions: This is the first such experiment in human DNA, and we have followed thestandards established in a similar experiment, GASP1, in Drosophila melanogaster. We believe theresults presented here contribute to the value of ongoing large-scale annotation projects and shouldguide further experimental methods when being scaled up to the entire human genome sequence.