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.

Molecular evolutionary patterns in the Glomeromycota;

Abstract Arbuscular mycorrhizal fungi (AMF) form symbiosis with roots of approximately 80% of known land plants. These fungi play a key role in the ecology and adaptation of plants to various ecosystems.by increasing the plant resources for various nutrients. Despite their important ecological role, we still have poor understanding of their genetic structure and their molecular evolution. The work presented in this thesis aims to isolate and analyse AMF genes with various molecular techniques, in order to obtain new insights about their genetics, phylogeny and molecular evolution. Some AMF genes were shown through phylogenetic analyses to be more related with plants or mycoparasites than with other fungal organisms. These results led to the prediction that lateral gene transfers (LGT) occurred between AMF and plants during their long-term co-évolution. By phylogenetic and molecular analyses, in the chapter 2 I demonstrate that the hypothesis of LGT is most likely a consequence of analyses carried out on contaminant non AMF-DNA. In addition, various features characteristic of AMF genes have been determined, allowing researchers to scan their own sequence databases for potential non-AMF contaminants. Phylogenetic relationships of AMF with other fungi has been mostly analysed using molecular markers of ribosomal origin. In chapter 2 I successfully isolated gene encoding α- and ß-tubulins from several AMF genera. Consequently, phylogenetic analyses showed that AMF possess an unexpected relationship with ancestral aquatic fungi (chytrids). These results are consistent with the prediction stating that AMF may have played an important role in the colonisation of land by green plants through the establishment of a symbiosis and after the divergence of AMF from aquatic ancestors. In Chapter 4 I tried to isolate the entire AMF gene family encoding P-Type II ATPases, in order to determine their molecular evolution with the fungal kingdom. These genes were further analysed to detect the level of sequence polymorphism that is present within an AMF population. The results obtained show that mutational events previously thought as occurring only among divergent evolutionary lineages (gene duplications, indel mutations in coding regions) can occur within a single population of AMF. These results have far reaching consequences for our understanding of the genetics and ecology of AMF. Résumé Les champignons endomycorrhiziens arbusculaires (CEA) forment une symbiose racinaire avec environ 80% des plantes vasculaires connues. Ces champignons possèdent un rôle important dans l'écologie et l'adaptation des plantes au sein de différents écosystèmes en .augmentant leurs ressources en nutriments. Le travail présenté dans cette thèse se propose d'isoler et d'analyser certains gènes de CEA avec différentes techniques moléculaires à fin d'obtenir de pÌus amples informations concernant l'évolution moléculaire, la phylogénie et leur diversité génétique à diverses échelles taxonomiques. Certaines analyses phylogénétiques des CEA ont conduit à l'hypothèse que des transferts horizontaux de gènes (THG) ont pu avoir lieu durant leur longue co-évolution avec les plantes vasculaires. Dans le chapitre 2 de cette thèse nous démontrons par analyses moléculaire et phylogénétique que l'hypothèse de THG est une conséquence de contaminations à partir d'ADN de plante ou d'autres micro-organismes. De plus, de nombreuses caractéristiques moléculaires de CEA ont pu être déterminées, permettant la mise en place d'un plan à suivre lors de l'analyse de gènes de CEA dans les études futures. Les relations évolutives des. CEA avec d'autres champignons ont été analysées majoritairement à l'aide de marqueurs moléculaires d'origine ribosomiale. Dans les chapitres 2 et 3 j'ai isolé des gènes codant pour l'a- et la ß-tubuline chez différents genres, de CEA. Les analyses phylogénétiques ont démontré une parenté entre les CEA et des champignons aquatiques ancestraux (chytrides). Ces résultats sont en accord avec l'hypothèse selon laquelle les CEA ont probablement joué un rôle primordial dans l'établissement des plantes sur terre à travers une symbiose et suite à leur évolution à partir d'ancêtres vivant dans des milieux aquatiques: Dans le chapitre 4 j'ai isolé une entière famille de gènes chez les CEA codant des ATPases de la membrane plasmique, et étudié leur évolution moléculaire dans le règne des champignons. Ces mêmes gènes ont été analysés ultérieurement à fin de déterminer le degré de polymorphisme de séquence qui peut être présent au sein d'une population de CEA. Les résultats obtenus montrent que des évènements mutationnels considérés comme apparaissant exclusivement dans des lignées évolutives très divergentes (duplication de gènes, insertions/délétions dans des régions transcrites du génome) ont lieu sein d'une même population de CEA. Cette découverte a un impact important sur nos connaissances concernant la génétique des populations des CEA et leur écologie.

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

Ongoing and future developments at the Universal Protein Resource.

The primary mission of Universal Protein Resource (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 4 weeks and can be accessed online for searches or download at http://www.uniprot.org.

EUROCAT website data on prenatal detection rates of congenital anomalies.

The EUROCAT website www.eurocat-network.eu publishes prenatal detection rates for major congenital anomalies using data from European population-based congenital anomaly registers, covering 28% of the EU population as well as non-EU countries. Data are updated annually. This information can be useful for comparative purposes to clinicians and public health service managers involved in the antenatal care of pregnant women as well as those interested in perinatal epidemiology.

Cross-species and cross-platform gene expression studies with the Bioconductor-compliant R package 'annotationTools'.

Background: The variety of DNA microarray formats and datasets presently available offers an unprecedented opportunity to perform insightful comparisons of heterogeneous data. Cross-species studies, in particular, have the power of identifying conserved, functionally important molecular processes. Validation of discoveries can now often be performed in readily available public data which frequently requires cross-platform studies.Cross-platform and cross-species analyses require matching probes on different microarray formats. This can be achieved using the information in microarray annotations and additional molecular biology databases, such as orthology databases. Although annotations and other biological information are stored using modern database models ( e. g. relational), they are very often distributed and shared as tables in text files, i.e. flat file databases. This common flat database format thus provides a simple and robust solution to flexibly integrate various sources of information and a basis for the combined analysis of heterogeneous gene expression profiles.Results: We provide annotationTools, a Bioconductor-compliant R package to annotate microarray experiments and integrate heterogeneous gene expression profiles using annotation and other molecular biology information available as flat file databases. First, annotationTools contains a specialized set of functions for mining this widely used database format in a systematic manner. It thus offers a straightforward solution for annotating microarray experiments. Second, building on these basic functions and relying on the combination of information from several databases, it provides tools to easily perform cross-species analyses of gene expression data.Here, we present two example applications of annotationTools that are of direct relevance for the analysis of heterogeneous gene expression profiles, namely a cross-platform mapping of probes and a cross-species mapping of orthologous probes using different orthology databases. We also show how to perform an explorative comparison of disease-related transcriptional changes in human patients and in a genetic mouse model.Conclusion: The R package annotationTools provides a simple solution to handle microarray annotation and orthology tables, as well as other flat molecular biology databases. Thereby, it allows easy integration and analysis of heterogeneous microarray experiments across different technological platforms or species.

Improving blood pressure control through pharmacist interventions: a meta-analysis of randomized controlled trials.

BACKGROUND: Control of blood pressure (BP) remains a major challenge in primary care. Innovative interventions to improve BP control are therefore needed. By updating and combining data from 2 previous systematic reviews, we assess the effect of pharmacist interventions on BP and identify potential determinants of heterogeneity. METHODS AND RESULTS: Randomized controlled trials (RCTs) assessing the effect of pharmacist interventions on BP among outpatients with or without diabetes were identified from MEDLINE, EMBASE, CINAHL, and CENTRAL databases. Weighted mean differences in BP were estimated using random effect models. Prediction intervals (PI) were computed to better express uncertainties in the effect estimates. Thirty-nine RCTs were included with 14 224 patients. Pharmacist interventions mainly included patient education, feedback to physician, and medication management. Compared with usual care, pharmacist interventions showed greater reduction in systolic BP (-7.6 mm Hg, 95% CI: -9.0 to -6.3; I(2)=67%) and diastolic BP (-3.9 mm Hg, 95% CI: -5.1 to -2.8; I(2)=83%). The 95% PI ranged from -13.9 to -1.4 mm Hg for systolic BP and from -9.9 to +2.0 mm Hg for diastolic BP. The effect tended to be larger if the intervention was led by the pharmacist and was done at least monthly. CONCLUSIONS: Pharmacist interventions - alone or in collaboration with other healthcare professionals - improved BP management. Nevertheless, pharmacist interventions had differential effects on BP, from very large to modest or no effect; and determinants of heterogeneity could not be identified. Determining the most efficient, cost-effective, and least time-consuming intervention should be addressed with further research.

Adaptive divergence of ancient gene duplicates in the avian MHC class II beta.

Gene duplication and neofunctionalization are known to be important processes in the evolution of phenotypic complexity. They account for important evolutionary novelties that confer ecological adaptation, such as the major histocompatibility complex (MHC), a multigene family crucial to the vertebrate immune system. In birds, two MHC class II β (MHCIIβ) exon 3 lineages have been recently characterized, and two hypotheses for the evolutionary history of MHCIIβ lineages were proposed. These lineages could have arisen either by 1) an ancient duplication and subsequent divergence of one paralog or by 2) recent parallel duplications followed by functional convergence. Here, we compiled a data set consisting of 63 MHCIIβ exon 3 sequences from six avian orders to distinguish between these hypotheses and to understand the role of selection in the divergent evolution of the two avian MHCIIβ lineages. Based on phylogenetic reconstructions and simulations, we show that a unique duplication event preceding the major avian radiations gave rise to two ancestral MHCIIβ lineages that were each likely lost once later during avian evolution. Maximum likelihood estimation shows that following the ancestral duplication, positive selection drove a radical shift from basic to acidic amino acid composition of a protein domain facing the α-chain in the MHCII α β-heterodimer. Structural analyses of the MHCII α β-heterodimer highlight that three of these residues are potentially involved in direct interactions with the α-chain, suggesting that the shift following duplication may have been accompanied by coevolution of the interacting α- and β-chains. These results provide new insights into the long-term evolutionary relationships among avian MHC genes and open interesting perspectives for comparative and population genomic studies of avian MHC evolution.

Genetics for clinicians: from candidate genes to whole genome scans (technological advances).

Human genetics has progressed at an unprecedented pace during the past 10 years. DNA microarrays currently allow screening of the entire human genome with high level of coverage and we are now entering the era of high-throughput sequencing. These remarkable technical advances are influencing the way medical research is conducted and have boosted our understanding of the structure of the human genome as well as of disease biology. In this context, it is crucial for clinicians to understand the main concepts and limitations of modern genetics. This review will describe key concepts in genetics, including the different types of genetic markers in the human genome, review current methods to detect DNA variation, describe major online public databases in genetics, explain key concepts in statistical genetics and finally present commonly used study designs in clinical and epidemiological research. This review will therefore concentrate on human genetic variation analysis.

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.

Decision-support tools to manage drug incompatibilities: evaluation by nurses

Introduction Preventing drug incompatibilities has a high impact onthe safety of drug therapy. Although there are no internationalguidelines to manage drug incompatibilities, different decision-supporttools such as handbooks, cross-tables and databases are available.In a previous study, two decision-support tools have been pre-selectedby pharmacists as fitting nurses' needs on the wards1. The objective ofthis study was to have these both tools evaluated by nurses todetermine which would be the most suitable for their daily practice.Materials & Methods Evaluated tools were:1. Cross-table of drug pairs (http://files.chuv.ch/internet-docs/pha/medicaments/pha_phatab_compatibilitessip.pdf)2. Colour-table (a colour for each drug according to the pH: red =acid; blue = basic; yellow = neutral; black = to be infused alone)2Tools were assessed by 48 nurses in 5 units (PICU, adult andgeriatric intensive care, surgery, onco-hematology) using a standardizedform1. The scientific accuracy of the tools was evaluated bydetermining the compatibility of five drugs pairs (rate of correctanswers according to the Trissel's Handbook on Injectable Drugs,chi-square test). Their ergonomics, design, reliability and applicabilitywere estimated using visual analogue scales (VAS 0-10; 0 =null, 10 = excellent). Results are expressed as the median and interquartilerange (IQR) for 25% and 75% (Wilcoxon rank sum test).Results The rate of correct answers was above 90% for both tools(cross-table 96.2% vs colour-table 92.5%, p[0.05).The ergonomics and the applicability were higher for the crosstable[7.1 (IQR25 4.0, IQR75 8.0) vs 5.0 (IQR25 2.7, IQR75 7.0), p =0.025 resp. 8.3 (IQR25 7.4, IQR75 9.2) vs 7.6 (IQR25 5.9, IQR75 8.8)p = 0.047].The design of the colour-table was judged better [4.6 (IQR25 2.9,IQR75 7.1) vs 7.1 (IQR25 5.4, IQR75 8.4) p = 0.002].No difference was observed in terms of reliability [7.3 (IQR25 6.5,IQR75 8.4) vs 6.7 (IQR25 5.0, IQR758.6) p[0.05].The cross-table was globally preferred by 65% of the nurses (27%colour-table, 8% undetermined) and 68% would like to have thisdecision-support tool available for their daily practice.Discussion & Conclusion Both tools showed the same accuracy toassess drug compatibility. In terms of ergonomics and applicabilitythe cross-table was better than the colour-table, and was preferred bythe nurses for their daily practice. The cross-table will be implementedin our hospital as decision-support tool to help nurses tomanage drug incompatibilities.