Maintenance of cube automatic summary tables

Materialized views (or Automatic Summary Tables—ASTs) are commonly used to improve the performance of aggregation queries by orders of magnitude. In contrast to regular tables, ASTs are synchronized by the database system. In this paper, we present techniques for maintaining cube ASTs. Our implementation is based on IBM DB2 UDB

Position-effect variegation revisited: HUSHing up heterochromatin in human cells.

Much of what we understand about heterochromatin formation in mammals has been extrapolated from forward genetic screens for modifiers of position-effect variegation (PEV) in the fruit fly Drosophila melanogaster. The recent identification of the HUSH (Human Silencing Hub) complex suggests that more recent evolutionary developments contribute to the mechanisms underlying PEV in human cells. Although HUSH-mediated repression also involves heterochromatin spreading through the reading and writing of the repressive H3K9me3 histone modification, clear orthologues of HUSH subunits are not found in Drosophila but are conserved in vertebrates. Here we compare the insights into the mechanisms of PEV derived from genetic screens in the fly, the mouse and in human cells, review what is currently known about the HUSH complex and discuss the implications of HUSH-mediated silencing for viral latency. Future studies will provide mechanistic insight into HUSH complex function and reveal the relationship between HUSH and other epigenetic silencing complexes.This work was funded by a Wellcome Trust Principal Research Fellowship to P.J.L. (084957/Z/08/Z) and a Wellcome Trust PhD studentship to I.A.T. The Cambridge Institute for Medical Research is in receipt of a Wellcome Trust Strategic Award.This is the author accepted manuscript. The final version is available from Wiley via http://dx.doi.org/10.1002/bies.20150018

ATF7IP-Mediated Stabilization of the Histone Methyltransferase SETDB1 Is Essential for Heterochromatin Formation by the HUSH Complex

The histone methyltransferase SETDB1 plays a central role in repressive chromatin processes, but the functional requirement for its binding partner ATF7IP has remained enigmatic. Here, we show that ATF7IP is essential for SETDB1 stability: nuclear SETDB1 protein is degraded by the proteasome upon ablation of ATF7IP. As a result, ATF7IP is critical for repression that requires H3K9 trimethylation by SETDB1, including transgene silencing by the HUSH complex. Furthermore, we show that loss of ATF7IP phenocopies loss of SETDB1 in genome-wide assays. ATF7IP and SETDB1 knockout cells exhibit near-identical defects in the global deposition of H3K9me3, which results in similar dysregulation of the transcriptome. Overall, these data identify a critical functional role for ATF7IP in heterochromatin formation by regulating SETDB1 abundance in the nucleus.This work was supported by the Wellcome Trust through a Principal Research Fellowship to P.J.L. (101835/Z/13/Z) and a Ph.D. studentship to I.A.T. The CIMR is in receipt of a Wellcome Trust strategic award.This is the final version of the article. It first appeared from Elsevier (Cell Press) via https://doi.org/10.1016/j.celrep.2016.09.05

ATF7IP-Mediated Stabilization of the Histone Methyltransferase SETDB1 Is Essential for Heterochromatin Formation by the HUSH Complex.

The histone methyltransferase SETDB1 plays a central role in repressive chromatin processes, but the functional requirement for its binding partner ATF7IP has remained enigmatic. Here, we show that ATF7IP is essential for SETDB1 stability: nuclear SETDB1 protein is degraded by the proteasome upon ablation of ATF7IP. As a result, ATF7IP is critical for repression that requires H3K9 trimethylation by SETDB1, including transgene silencing by the HUSH complex. Furthermore, we show that loss of ATF7IP phenocopies loss of SETDB1 in genome-wide assays. ATF7IP and SETDB1 knockout cells exhibit near-identical defects in the global deposition of H3K9me3, which results in similar dysregulation of the transcriptome. Overall, these data identify a critical functional role for ATF7IP in heterochromatin formation by regulating SETDB1 abundance in the nucleus.This work was supported by the Wellcome Trust through a Principal Research Fellowship to P.J.L. (101835/Z/13/Z) and a Ph.D. studentship to I.A.T. The CIMR is in receipt of a Wellcome Trust strategic award.This is the final version of the article. It first appeared from Elsevier (Cell Press) via https://doi.org/10.1016/j.celrep.2016.09.05

Approximate Analytical Solutions to the Initial Data Problem of Black Hole Binary Systems

We present approximate analytical solutions to the Hamiltonian and momentum constraint equations, corresponding to systems composed of two black holes with arbitrary linear and angular momentum. The analytical nature of these initial data solutions makes them easier to implement in numerical evolutions than the traditional numerical approach of solving the elliptic equations derived from the Einstein constraints. Although in general the problem of setting up initial conditions for black hole binary simulations is complicated by the presence of singularities, we show that the methods presented in this work provide initial data with $l_1$ and $l_\infty$ norms of violation of the constraint equations falling below those of the truncation error (residual error due to discretization) present in finite difference codes for the range of grid resolutions currently used. Thus, these data sets are suitable for use in evolution codes. Detailed results are presented for the case of a head-on collision of two equal-mass M black holes with specific angular momentum 0.5M at an initial separation of 10M. A straightforward superposition method yields data adequate for resolutions of $h=M/4$, and an "attenuated" superposition yields data usable to resolutions at least as fine as $h=M/8$. In addition, the attenuated approximate data may be more tractable in a full (computational) exact solution to the initial value problem.Comment: 6 pages, 5 postscript figures. Minor changes and some points clarified. Accepted for publication in Phys. Rev.

Ces1d deficiency protects against high-sucrose diet-induced hepatic triacylglycerol accumulation

Nonalcoholic fatty liver disease (NAFLD) is the most common chronic liver disease. Triacylglycerol accumulation in the liver is a hallmark of NAFLD. Metabolic studies have confirmed that increased hepatic de novo lipogenesis (DNL) in humans contributes to fat accumulation in the liver and to NAFLD progression. Mice deficient in carboxylesterase (Ces)1d expression are protected from high-fat diet-induced hepatic steatosis. To investigate whether loss of Ces1d can also mitigate steatosis induced by over-activated DNL, WT and Ces1d-deficient mice were fed a lipogenic high-sucrose diet (HSD). We found that Ces1d-deficient mice were protected from HSD-induced hepatic lipid accumulation. Mechanistically, Ces1d deficiency leads to activation of AMP-activated protein kinase and inhibitory phosphorylation of acetyl-CoA carboxylase. Together with our previous demonstration that Ces1d deficiency attenuated high-fat diet-induced steatosis, this study suggests that inhibition of CES1 (the human ortholog of Ces1d) might represent a novel pharmacological target for prevention and treatment of NAFLD.Fil: Lian, Jihong. University of Alberta; CanadáFil: Watts, Russell. University of Alberta; CanadáFil: Quiroga, Ariel Dario. Consejo Nacional de Investigaciones Científicas y Técnicas. Centro Científico Tecnológico Conicet - Rosario. Instituto de Fisiología Experimental. Universidad Nacional de Rosario. Facultad de Ciencias Bioquímicas y Farmacéuticas. Instituto de Fisiología Experimental; ArgentinaFil: Beggs, Megan R.. University of Alberta; CanadáFil: Alexander, R. Todd. University of Alberta; CanadáFil: Lehner, Richard. University of Alberta; Canad

Human cytomegalovirus: taking the strain

In celebrating the 60th anniversary of the first isolation of human cytomegalovirus (HCMV), we reflect on the merits and limitations of the viral strains currently being used to develop urgently needed treatments. HCMV research has been dependent for decades on the high-passage strains AD169 and Towne, heavily exploiting their capacity to replicate efficiently in fibroblasts. However, the genetic integrity of these strains is so severely compromised that great caution needs to be exercised when considering their past and future use. It is now evident that wild-type HCMV strains are not readily propagated in vitro. HCMV mutants are rapidly selected during isolation in fibroblasts, reproducibly affecting gene RL13, the UL128 locus (which includes genes UL128, UL130 and UL131A) and often the UL/b′ region. As a result, the virus becomes less cell associated, altered in tropism and less pathogenic. This problem is not restricted to high-passage strains, as even low-passage strains can harbour biologically significant mutations. Cloning and manipulation of the HCMV genome as a bacterial artificial chromosome (BAC) offers a means of working with stable, genetically defined strains. To this end, the low-passage strain Merlin genome was cloned as a BAC and sequentially repaired to match the viral sequence in the original clinical sample from which Merlin was derived. Restoration of UL128L to wild type was detrimental to growth in fibroblasts, whereas restoration of RL13 impaired growth in all cell types tested. Stable propagation of phenotypically wild-type virus could be achieved only by placing both regions under conditional expression. In addition to the development of these tools, the Merlin transcriptome and proteome have been characterized in unparalleled detail. Although Merlin may be representative of the clinical agent, high-throughput whole-genome deep sequencing studies have highlighted the remarkable high level of interstrain variation present in circulating virus. There is a need to develop systems capable of addressing the significance of this diversity, free from the confounding effects of genetic changes associated with in vitro adaptation. The generation of a set of BAC clones, each containing the genome of a different HCMV strain repaired to match the sequence in the clinical sample, would provide a pathway to address the biological and clinical effects of natural variation in wild-type HCMV

A Genetic Screen Identifies a Critical Role for the WDR81-WDR91 Complex in the Trafficking and Degradation of Tetherin.

Tetherin (BST2/CD317) is a viral restriction factor that anchors enveloped viruses to host cells and limits viral spread. The HIV-1 Vpu accessory protein counteracts tetherin by decreasing its cell surface expression and targeting it for ubiquitin-dependent endolysosomal degradation. Although the Vpu-mediated downregulation of tetherin has been extensively studied, the molecular details are not completely elucidated. We therefore used a forward genetic screen in human haploid KBM7 cells to identify novel genes required for tetherin trafficking. Our screen identified WDR81 as a novel gene required for tetherin trafficking and degradation in both the presence and absence of Vpu. WDR81 is a BEACH-domain containing protein that is also required for the degradation of EGF-stimulated epidermal growth factor receptor (EGFR) and functions in a complex with the WDR91 protein. In the absence of WDR81 the endolysosomal compartment appears swollen, with enlarged early and late endosomes and reduced delivery of endocytosed dextran to cathepsin-active lysosomes. Our data suggest a role for the WDR81-WDR91 complex in the fusion of endolysosomal compartments and the absence of WDR81 leads to impaired receptor trafficking and degradation.This work was supported by the Wellcome Trust, through a Principal Research Fellowship to PJL (084957/Z/08/Z) and Ph.D studentship to RR (079895/Z/06/Z), by MRC research grant MR/M010007/1 to JPL and by a BBSRC industrial CASE studentship with GSK Research and Development Ltd to LJD. The CIMR is in receipt of a Wellcome Trust strategic award 100140.This is the final version of the article. It first appeared from Wiley via https://doi.org/10.1111/tra.1240

Fluorescence-Based Phenotypic Selection Allows Forward Genetic Screens in Haploid Human Cells

The isolation of haploid cell lines has recently allowed the power of forward genetic screens to be applied to mammalian cells. The interest in applying this powerful genetic approach to a mammalian system is only tempered by the limited utility of these screens, if confined to lethal phenotypes. Here we expand the scope of these approaches beyond live/dead screens and show that selection for a cell surface phenotype via fluorescence-activated cell sorting can identify the key molecules in an intracellular pathway, in this case MHC class I antigen presentation. Non-lethal haploid genetic screens are widely applicable to identify genes involved in essentially any cellular pathway