Galaxy-Gen: A Tool for Building Galaxy model from XML documents

National audienceA galaxy model is a multidimensional model dedicated for XML document warehouses. It can be seen as a network of entities (i.e., dimensions) connected via nodes. After giving an overview of our four-steps semi-automated method for the generation of galaxy models which aims to build data marts from XML documents. This paper focuses on the software tool, called Galaxy-Gen that implements the proposed method. We illustrate the Galaxy-Gen functionalities and make its first assessment through two experiments. The first experiment is applied to a set of twenty XML documents taken from the academic domain. The second one addressed a set of 1691 XML documents issued from the Clef-2007 collection. The assessment is performed by comparing manual design galaxy models with those produced by the Galaxy-Gen tool. The results are very promising

Building an XML document warehouse

International audienceData Warehouses and OLAP (On Line Analytical Processing) technologies are dedicated to analyzing structured data issued from organizations' OLTP (On Line Transaction Processing) systems. Furthermore, in order to enhance their decision support systems, these organizations need to explore XML (eXtensible Markup Language) documents as an additional and important source of unstructured data. In this context, this paper addresses the warehousing of document-centric XML documents. More specifically, we propose a two-method approach to build Document Warehouse conceptual schemas. The first method is for the unification of XML document structures; it aims to elaborate a global and generic view for a set of XML documents belonging to the same domain. The second method is for designing multidimensional galaxy schemas for Document Warehouses

An approach to build XML documents warehouses

Les documents constituent une capitalisation importante des connaissances. Généralement, ces documents sont caractérisés par un contenu peu structuré et il est alors difficile de les intégrer dans les systèmes d’information décisionnels. En conséquence, les décideurs ne peuvent pas tirer profit de ces documents. Pour répondre à cette problématique, nous proposons une approche de construction du schéma de l’entrepôt de documents XML. Cette approche se compose de deux méthodes : une méthode d’unification des structures des documents XML et une méthode de modélisation multidimensionnelle de ces documents. La méthode d’unification permet de définir une structure commune pour décrire les documents XML hétérogènes et appartenant au même domaine. Pour valider cette méthode, un outil logiciel baptisé USD (Unification of Structures of XML Documents) est développé. La méthode de modélisation multidimensionnelle a pour but de concevoir semi-automatiquement le schéma du magasin de documents, selon le modèle multidimensionnel en galaxie, à partir d’une structure XML unifiée. Afin de valider cette méthode, un outil nommé Galaxy-Gen (Galaxy Generation) est développé.Documents represent an important knowledge capitalization. In general, these documents are characterized by unstructured content, and therefore it is difficult to integrate them in the decision information systems. As a result, decision-makers are unable to exploit these documents easily and efficiently. To alleviate this problem, we propose an approach to build the schema of the XML documents warehouse. This approach consists of two methods: a method for unification of the structures of XML documents and a method for multidimensional modeling of these documents. The unification method defines a common structure to describe heterogeneous XML documents belonging to the same domain. To validate this method, a software tool called USD (Unification of Structures of XML Documents) is developed. While the method of multidimensional modeling builds semi-automatically the schema of the documents mart as a galaxy model. To validate this method, the tool called Galaxy-Gen (Galaxy Generation) is developed

Approche de construction d'entrepôts de documents XML

Les documents constituent une capitalisation importante des connaissances. Généralement, ces documents sont caractérisés par un contenu peu structuré et il est alors difficile de les intégrer dans les systèmes d’information décisionnels. En conséquence, les décideurs ne peuvent pas tirer profit de ces documents. Pour répondre à cette problématique, nous proposons une approche de construction du schéma de l’entrepôt de documents XML. Cette approche se compose de deux méthodes : une méthode d’unification des structures des documents XML et une méthode de modélisation multidimensionnelle de ces documents. La méthode d’unification permet de définir une structure commune pour décrire les documents XML hétérogènes et appartenant au même domaine. Pour valider cette méthode, un outil logiciel baptisé USD (Unification of Structures of XML Documents) est développé. La méthode de modélisation multidimensionnelle a pour but de concevoir semi-automatiquement le schéma du magasin de documents, selon le modèle multidimensionnel en galaxie, à partir d’une structure XML unifiée. Afin de valider cette méthode, un outil nommé Galaxy-Gen (Galaxy Generation) est développé.Documents represent an important knowledge capitalization. In general, these documents are characterized by unstructured content, and therefore it is difficult to integrate them in the decision information systems. As a result, decision-makers are unable to exploit these documents easily and efficiently. To alleviate this problem, we propose an approach to build the schema of the XML documents warehouse. This approach consists of two methods: a method for unification of the structures of XML documents and a method for multidimensional modeling of these documents. The unification method defines a common structure to describe heterogeneous XML documents belonging to the same domain. To validate this method, a software tool called USD (Unification of Structures of XML Documents) is developed. While the method of multidimensional modeling builds semi-automatically the schema of the documents mart as a galaxy model. To validate this method, the tool called Galaxy-Gen (Galaxy Generation) is developed

A Semi-automatic Approach to Build XML Document Warehouse

International audienceDocuments represent an interesting source for decisional analyses. They help decision makers to better understand the evolution of their business activities. Therefore, they merit to be warehoused for decision purposes within organizations. Generally, these documents exist in XML format and are described by multiple structures. In this paper, we present a semi-automatic approach to build the XML Document Warehouse. This approach is made up of two methods namely: Unification of structures of XML Structures, and Multidimensional modeling. More specifically, this paper focuses on the experiment and evaluation of the proposed approach for warehousing document-centric XML documents

Aspergillus flavus genetic structure at a turkey farm

Abstract Background The ubiquitous environmental fungus Aspergillus flavus is also a life‐threatening avian pathogen. Objectives This study aimed to assess the genetic diversity and population structure of A. flavus isolated from turkey lung biopsy or environmental samples collected in a poultry farm. Methods A. flavus isolates were identified using both morphological and ITS sequence features. Multilocus microsatellite genotyping was performed by using a panel of six microsatellite markers. Population genetic indices were computed using FSTAT and STRUCTURE. A minimum‐spanning tree (MST) and UPGMA dendrogram were drawn using BioNumerics and NTSYS‐PC, respectively. Results The 63 environmental (air, surfaces, eggshells and food) A. flavus isolates clustered in 36 genotypes (genotypic diversity = 0.57), and the 19 turkey lung biopsies isolates clustered in 17 genotypes (genotypic diversity = 0.89). The genetic structure of environmental and avian A. flavus populations were clearly differentiated, according to both F‐statistics and Bayesian model‐based analysis’ results. The Bayesian approach indicated gene flow between both A. flavus populations. The MST illustrated the genetic structure of this A. flavus population split in nine clusters, including six singletons. Conclusions Our results highlight the distinct genetic structure of environmental and avian A. flavus populations, indicative of a genome‐based adaptation of isolates involved in avian aspergillosis

Low incidence of SARS-CoV-2, risk factors of mortality and the course of illness in the French national cohort of dialysis patients

International audienceThe aim of this study was to estimate the incidence of COVID-19 disease in the French national population of dialysis patients, their course of illness and to identify the risk factors associated with mortality. Our study included all patients on dialysis recorded in the French REIN Registry in April 2020. Clinical characteristics at last follow-up and the evolution of COVID-19 illness severity over time were recorded for diagnosed cases (either suspicious clinical symptoms, characteristic signs on the chest scan or a positive reverse transcription polymerase chain reaction) for SARS-CoV-2. A total of 1,621 infected patients were reported on the REIN registry from March 16th, 2020 to May 4th, 2020. Of these, 344 died. The prevalence of COVID-19 patients varied from less than 1% to 10% between regions. The probability of being a case was higher in males, patients with diabetes, those in need of assistance for transfer or treated at a self-care unit. Dialysis at home was associated with a lower probability of being infected as was being a smoker, a former smoker, having an active malignancy, or peripheral vascular disease. Mortality in diagnosed cases (21%) was associated with the same causes as in the general population. Higher age, hypoalbuminemia and the presence of an ischemic heart disease were statistically independently associated with a higher risk of death. Being treated at a selfcare unit was associated with a lower risk. Thus, our study showed a relatively low frequency of COVID-19 among dialysis patients contrary to what might have been assumed