Precise design of environmental data warehouses

People use data warehouses to help them make decisions. For example, public policy decision-makers can improve their decisions by using this technology to analyze the environmental effects of human activity. In production systems, data warehouses provide structures for extracting the knowledge required to optimize systems. Designing data warehouses is a complex task; designers need flexible and precise methods to help them create data warehouses and adapt their analysis criteria to developments in the decision-making process. In this paper, we introduce a flexible method based on UML (Unified Modeling Language). We introduce a UML profile for building multi-dimensional models and for choosing different criteria according to analysis requirements. This profile makes it possible to specify integrity constraints in OCL (Object Constraint Language). We apply our method to the construction of an environmental system for analyzing the use of certain agricultural fertilizers. We integrate various data sources into a multi-dimensional model showing several categories of analysis, and the consistency of data can be checked with OCL constraints

MULTIPASS: gestion des consentements pour accéder aux données des exploitations dans une chaîne de confiance afin de favoriser l'émergence de nouveaux services pour les agriculteurs

12th EFITA International Conference, Rhode island, GRC, 27-/06/2019 - 29/06/2019International audienceWith the emergence of digital technologies, farms become a relevant source of data to meet the challenges of multi-performance agriculture. Beyond the services provided, access to farmers' data depends on a clear understanding of their use, which must be done in a transparent way. Several codes of conduct at a national or international level push for a voluntary commitment to respect some good practices in the use of agricultural data. To provide a tool and answer farmer's questions on the control of their data and the transparency of the data processing, the partners of the MULTIPASS project, have imagined an interoperable ecosystem of farmer consents management, protecting farmers from no consented uses of their data.Farmers' expectations of such an ecosystem have been expressed during workshops. They want to better identify existing data flows, including actors, data processes, and data clusters. Based on the farmers' expectations, the MULTIPASS project stakeholders have proposed the architecture of an ecosystem integrating two consent management tools as "pilots". This ecosystem should take in charge the interoperability between each consent management tools or with future tools. This solution is based on a shared typology of data and data processes as well as on the specifications of the consent message content. All these elements should be easily accessible to meet the interoperability need of the ecosystem. It is also based on a router, which provides unified access to consent management tools (using API). In particular, it provides the farmer (beneficiary) with an exhaustive view of his/her consents (which can be distributed on several consent management systems), meeting farmers' expectations for transparency. It is also the point where a data provider can check whether the consent required to provide data exists, without needing to know which consent management system is concerned. In this project, the stakeholders want to demonstrate to agricultural professional organizations the benefits and feasibility of a consent management ecosystem. By strengthening the confidence of farmers to share data, the project will allow the emergence of new knowledge and new services

An adverbial approach for the formal specification of topological constraints involving regions with broad boundaries

Topological integrity constraints control the topological properties of spatial objects and the validity of their topological relationships in spatial databases. These constraints can be specified by using formal languages such as the spatial extension of the Object Constraint Language (OCL). Spatial OCL allows the expression of topological constraints involving crisp spatial objects. However, topological constraints involving spatial objects with vague shapes (e.g., regions with broad boundaries) are not supported by this language. Shape vagueness requires using appropriate topological operators (e.g., strongly Disjoint, fairly Meet) to specify valid relations between these objects; otherwise, the constraints cannot be respected. This paper addresses the problem of the lack of terminology to express topological constraints involving regions with broad boundaries. We propose an extension of Spatial OCL based on a geometric model for objects with vague shapes and an adverbial approach for topological relations between regions with broad boundaries. This extension of Spatial OCL is then tested on an agricultural database

Igneous mineralogy at Bradbury Rise: The first ChemCam campaign at Gale crater

Textural and compositional analyses using Chemistry Camera (ChemCam) remote microimager and laser-induced breakdown spectroscopy (LIBS) have been performed on five float rocks and coarse gravels along the first 100 m of the Curiosity traverse at Bradbury Rise. ChemCam, the first LIBS instrument sent to another planet, offers the opportunity to assess mineralogic diversity at grain-size scales (~ 100 µm) and, from this, lithologic diversity. Depth profiling indicates that targets are relatively free of surface coatings. One type of igneous rock is volcanic and includes both aphanitic (Coronation) and porphyritic (Mara) samples. The porphyritic sample shows dark grains that are likely pyroxene megacrysts in a fine-grained mesostasis containing andesine needles. Both types have magnesium-poor basaltic compositions and in this respect are similar to the evolved Jake Matijevic rock analyzed further along the Curiosity traverse both with Alpha-Particle X-ray Spectrometer and ChemCam instruments. The second rock type encountered is a coarse-grained intrusive rock (Thor Lake) showing equigranular texture with millimeter size crystals of feldspars and Fe-Ti oxides. Such a rock is not unique at Gale as the surrounding coarse gravels (such as Beaulieu) and the conglomerate Link are dominated by feldspathic (andesine-bytownite) clasts. Finally, alkali feldspar compositions associated with a silica polymorph have been analyzed in fractured filling material of Preble rock and in Stark, a putative pumice or an impact melt. These observations document magmatic diversity at Gale and describe the first fragments of feldspar-rich lithologies (possibly an anorthosite) that may be ancient crust transported from the crater rim and now forming float rocks, coarse gravel, or conglomerate clasts

Management of hepatic epithelioid haemangio-endothelioma in children: what option?

Hepatic epithelioid haemangio-endothelioma (HEHE) is an endothelium-derived tumour of low-to-medium grade malignancy. It is predominantly seen in adults and is unresponsive to chemotherapy. Liver transplantation is an accepted indication when the tumour is unresectable. Hepatic epithelioid haemangio-endothelioma is very rare in children and results after transplantation are not reported. The aim of this study is to review the experience of three European centres in the management of HEHE in children. A retrospective review of all paediatric patients with HEHE managed in three European centres is presented. Five children were identified. Four had unresectable tumours. The first had successful resection followed by chemotherapy and is alive, without disease 3 years after diagnosis. One child died of sepsis and one of tumour recurrence in the graft and lungs 2 and 5 months, respectively, after transplant. Two children who had progressive disease with ifosfamide-based chemotherapy have had a reduction in clinical symptoms and stabilisation of disease up to 18 and 24 months after the use of platinum-based chemotherapy. HEHE seems more aggressive in children than reported in adults and the curative role of transplantation must be questioned. Ifosfamide-based chemotherapy was not effective. Further studies are necessary to confirm if HEHE progression in children may be influenced by platinum-based chemotherapy

Dissecting the action of an evolutionary conserved non-coding region on renin promoter activity

Elucidating the mechanisms of the human transcriptional regulatory network is a major challenge of the post-genomic era. One important aspect is the identification and functional analysis of regulatory elements in non-coding DNA. Genomic sequence comparisons between related species can guide the discovery of cis-regulatory sequences. Using this technique, we identify a conserved region CNSmd of ∼775 bp in size, ∼14 kb upstream of the renin gene. Renin plays a pivotal role for mammalian blood pressure regulation and electrolyte balance. To analyse the cis-regulatory role of this region in detail, we perform 132 combinatorial reporter gene assays in an in vitro Calu-6 cell line model. To dissect the role of individual subregions, we fit several mathematical models to the experimental data. We show that a multiplicative switch model fits best the experimental data and that one subregion has a dominant effect on promoter activity. Mapping of the sub-sequences on phylogenetic conservation data reveals that the dominant regulatory region is the one with the highest multi-species conservation score

Chemistry, Mineralogy, and Grain Properties at Namib and High Dunes, Bagnold Dune Field, Gale Crater, Mars: A Synthesis of Curiosity Rover Observations

The Mars Science Laboratory Curiosity rover performed coordinated measurements to examine the textures and compositions of aeolian sands in the active Bagnold dune field. The Bagnold sands are rounded to subrounded, very fine to medium sized (~45–500 μm) with ≥6 distinct grain colors. In contrast to sands examined by Curiosity in a dust-covered, inactive bedform called Rocknest and soils at other landing sites, Bagnold sands are darker, less red, better sorted, have fewer silt-sized or smaller grains, and show no evidence for cohesion. Nevertheless, Bagnold mineralogy and Rocknest mineralogy are similar with plagioclase, olivine, and pyroxenes in similar proportions comprising >90% of crystalline phases, along with a substantial amorphous component (35% ± 15%). Yet Bagnold and Rocknest bulk chemistry differ. Bagnold sands are Si enriched relative to other soils at Gale crater, and H_2O, S, and Cl are lower relative to all previously measured Martian soils and most Gale crater rocks. Mg, Ni, Fe, and Mn are enriched in the coarse-sieved fraction of Bagnold sands, corroborated by visible/near-infrared spectra that suggest enrichment of olivine. Collectively, patterns in major element chemistry and volatile release data indicate two distinctive volatile reservoirs in Martian soils: (1) amorphous components in the sand-sized fraction (represented by Bagnold) that are Si-enriched, hydroxylated alteration products and/or H_2O- or OH-bearing impact or volcanic glasses and (2) amorphous components in the fine fraction (<40 μm; represented by Rocknest and other bright soils) that are Fe, S, and Cl enriched with low Si and adsorbed and structural H_2O