19 research outputs found

    Basler Africa Portal

    Get PDF
    The article aims to present the project "Africa Portal" in which five institutions located in Basel create an integrated search interface in order to make their data accessible. Following a description of the process concerning normalizing different data structures and formats, the article also focuses on the outcomes and the possible developments of the "Africa Portal" in the future

    Integration von Worst-Case Optimal Join Algorithmen in Spalten-Orientierte Datenbanken

    No full text
    Arbeit an der Bibliothek noch nicht eingelangt - Daten nicht geprüftAbweichender Titel nach Übersetzung der Verfasserin/des VerfassersBusiness intelligence and analytical systems have to handle an increasing amount of data and require to efficiently answer queries. Therefore, the join evaluation has become a major challenge to be tackled by any database system to efficiently evaluate queries. To that end, plenty of research has been conducted to introduce concepts to compute join queries in a resource and runtime efficient way. The research area of column-oriented database systems has introduced a new database architecture from scratch. Such column-stores vertically partition a database and store columns independently of each other. Another research area that aims for optimizing query performance deals with worst-case optimal joins (WCOJ). Theoretical concepts and algorithms that define tight bounds on join algorithms’ runtime have been introduced in this field. Both areas successfully came up with join optimization concepts independently of each other. Since a combination of concepts from both fields yield great potential for further performance optimization, this thesis aims for integrating WCOJs into column-stores and is the first work to perform and evaluate such combination. This thesis introduces a way of integrating WCOJ algorithms into column-stores. The integration process discusses the query compiler of a specific column-store and the manual translation of a class of WCOJ algorithms into its internal language. Finally, the translation result is integrated into the column-store’s query compiler and the resulting system is evaluated against the original one. The evaluation showed that our system outperforms the original one on a given set of natural join queries in settings with skewed data and underlines the practical potential of WCOJ algorithms for fighting skew in input data. This thesis further showed that the column-store with WCOJ algorithm integrated can evaluate natural join queries with big input relation sizes which cause memory allocation errors for the original systems.10

    Basler Africa Portal

    Get PDF
    The article aims to present the project "Africa Portal" in which five institutions located in Basel create an integrated search interface in order to make their data accessible. Following a description of the process concerning normalizing different data structures and formats, the article also focuses on the outcomes and the possible developments of the "Africa Portal" in the future

    Methylation of the Retinoblastoma Tumor Suppressor by SMYD2*

    No full text
    The retinoblastoma tumor suppressor (RB) is a central cell cycle regulator and tumor suppressor. RB cellular functions are known to be regulated by a diversity of post-translational modifications such as phosphorylation and acetylation, raising the possibility that RB may also be methylated in cells. Here we demonstrate that RB can be methylated by SMYD2 at lysine 860, a highly conserved and novel site of modification. This methylation event occurs in vitro and in cells, and it is regulated during cell cycle progression, cellular differentiation, and in response to DNA damage. Furthermore, we show that RB monomethylation at lysine 860 provides a direct binding site for the methyl-binding domain of the transcriptional repressor L3MBTL1. These results support the idea that a code of post-translational modifications exists for RB and helps guide its functions in mammalian cells
    corecore