Clustering-Based Materialized View Selection in Data Warehouses

Materialized view selection is a non-trivial task. Hence, its complexity must be reduced. A judicious choice of views must be cost-driven and influenced by the workload experienced by the system. In this paper, we propose a framework for materialized view selection that exploits a data mining technique (clustering), in order to determine clusters of similar queries. We also propose a view merging algorithm that builds a set of candidate views, as well as a greedy process for selecting a set of views to materialize. This selection is based on cost models that evaluate the cost of accessing data using views and the cost of storing these views. To validate our strategy, we executed a workload of decision-support queries on a test data warehouse, with and without using our strategy. Our experimental results demonstrate its efficiency, even when storage space is limited

In vivo imaging of ram spermatozoa in the ewe genital tract using fibered confocal microscopy

National audienceSperm transit in the female tract is one of the key factors in the success of fertilization after artificial insemination in sheep species. However, its study is limited by the absence of in vivo imaging methods. The imaging of ram sperm in the female genital tract was made possible using the confocal fibered microscopy and fluorescent stains adapted to spermatozoa. Our results show the active role of the uterotubal junction in the selection of sperm during their transit

Genome of the ramshorn snail Biomphalaria straminea-an obligate intermediate host of schistosomiasi

This is the final version. Available on open access from Oxford University Press via the DOI in this recordData Availability: The raw genome and RNA sequencing data have been deposited in the SRA under Bioproject No. PRJNA673593. The final chromosome assembly was submitted to NCBI Assembly under accession No. JADKLZ000000000. All data can also be found in the GigaScience Database [75].BACKGROUND: Schistosomiasis, or bilharzia, is a parasitic disease caused by trematode flatworms of the genus Schistosoma. Infection by Schistosoma mansoni in humans results when cercariae emerge into water from freshwater snails in the genus Biomphalaria and seek out and penetrate human skin. The snail Biomphalaria straminea is native to South America and is now also present in Central America and China, and represents a potential vector host for spreading schistosomiasis. To date, genomic information for the genus is restricted to the neotropical species Biomphalaria glabrata. This limits understanding of the biology and management of other schistosomiasis vectors, such as B. straminea. FINDINGS: Using a combination of Illumina short-read, 10X Genomics linked-read, and Hi-C sequencing data, our 1.005 Gb B. straminea genome assembly is of high contiguity, with a scaffold N50 of 25.3 Mb. Transcriptomes from adults were also obtained. Developmental homeobox genes, hormonal genes, and stress-response genes were identified, and repeat content was annotated (40.68% of genomic content). Comparisons with other mollusc genomes (including Gastropoda, Bivalvia, and Cephalopoda) revealed syntenic conservation, patterns of homeobox gene linkage indicative of evolutionary changes to gene clusters, expansion of heat shock protein genes, and the presence of sesquiterpenoid and cholesterol metabolic pathway genes in Gastropoda. In addition, hormone treatment together with RT-qPCR assay reveal a sesquiterpenoid hormone responsive system in B. straminea, illustrating that this renowned insect hormonal system is also present in the lophotrochozoan lineage. CONCLUSION: This study provides the first genome assembly for the snail B. straminea and offers an unprecedented opportunity to address a variety of phenomena related to snail vectors of schistosomiasis, as well as evolutionary and genomics questions related to molluscs more widely

Formation of Mobile Chromatin-Associated Nuclear Foci Containing HIV-1 Vpr and VPRBP Is Critical for the Induction of G2 Cell Cycle Arrest

HIV-1 Viral protein R (Vpr) induces a cell cycle arrest at the G2/M phase by activating the ATR DNA damage/stress checkpoint. Recently, we and several other groups showed that Vpr performs this activity by recruiting the DDB1-CUL4A (VPRBP) E3 ubiquitin ligase. While recruitment of this E3 ubiquitin ligase complex has been shown to be required for G2 arrest, the subcellular compartment where this complex forms and functionally acts is unknown. Herein, using immunofluorescence and confocal microscopy, we show that Vpr forms nuclear foci in several cell types including HeLa cells and primary CD4+ T-lymphocytes. These nuclear foci contain VPRBP and partially overlap with DNA repair foci components such as γ-H2AX, 53BP1 and RPA32. While treatment with the non-specific ATR inhibitor caffeine or depletion of VPRBP by siRNA did not inhibit formation of Vpr nuclear foci, mutations in the C-terminal domain of Vpr and cytoplasmic sequestration of Vpr by overexpression of Gag-Pol resulted in impaired formation of these nuclear structures and defective G2 arrest. Consistently, we observed that G2 arrest-competent sooty mangabey Vpr could form these foci but not its G2 arrest-defective paralog Vpx, suggesting that formation of Vpr nuclear foci represents a critical early event in the induction of G2 arrest. Indeed, we found that Vpr could associate to chromatin via its C-terminal domain and that it could form a complex with VPRBP on chromatin. Finally, analysis of Vpr nuclear foci by time-lapse microscopy showed that they were highly mobile and stable structures. Overall, our results suggest that Vpr recruits the DDB1-CUL4A (VPRBP) E3 ligase to these nuclear foci and uses these mobile structures to target a chromatin-bound cellular substrate for ubiquitination in order to induce DNA damage/replication stress, ultimately leading to ATR activation and G2 cell cycle arrest

The many facets of the matricelluar protein periostin during cardiac development, remodeling, and pathophysiology

Periostin is a member of a growing family of matricellular proteins, defined by their ability to interact with components of the extracellular milieu, and with receptors at the cell surface. Through these interactions, periostin has been shown to play a crucial role as a profibrogenic molecule during tissue morphogenesis. Tissues destined to become fibrous structures are dependent on cooperative interactions between periostin and its binding partners, whereas in its absence, these structures either totally or partially fail to become mature fibrous entities. Within the heart, fibrogenic differentiation is required for normal tissue maturation, remodeling and function, as well as in response to a pathological myocardial insult. In this review, aspects related to the function of periostin during cardiac morphogenesis, remodeling and pathology are summarized

The Drosophila melanogaster host model

The deleterious and sometimes fatal outcomes of bacterial infectious diseases are the net result of the interactions between the pathogen and the host, and the genetically tractable fruit fly, Drosophila melanogaster, has emerged as a valuable tool for modeling the pathogen–host interactions of a wide variety of bacteria. These studies have revealed that there is a remarkable conservation of bacterial pathogenesis and host defence mechanisms between higher host organisms and Drosophila. This review presents an in-depth discussion of the Drosophila immune response, the Drosophila killing model, and the use of the model to examine bacterial–host interactions. The recent introduction of the Drosophila model into the oral microbiology field is discussed, specifically the use of the model to examine Porphyromonas gingivalis–host interactions, and finally the potential uses of this powerful model system to further elucidate oral bacterial-host interactions are addressed