Maximizing persistent memory bandwidth utilization for OLAP workloads

B Daase, LJ Bollmeier, L Benson, T Rabl - Proceedings of the 2021 …, 2021 - dl.acm.org
Modern database systems for online analytical processing (OLAP) typically rely on in-
memory processing. Keeping all active data in DRAM severely limits the data capacity and …

Data dependencies for query optimization: a survey

J Kossmann, T Papenbrock, F Naumann - The VLDB Journal, 2022 - Springer
Effective query optimization is a core feature of any database management system. While
most query optimization techniques make use of simple metadata, such as cardinalities and …

Quantifying TPC-H choke points and their optimizations

M Dreseler, M Boissier, T Rabl, M Uflacker - Proceedings of the VLDB …, 2020 - dl.acm.org
TPC-H continues to be the most widely used benchmark for relational OLAP systems. It
poses a number of challenges, also known as" choke points", which database systems have …

Self-tuning Database Systems: A Systematic Literature Review of Automatic Database Schema Design and Tuning

M Mozaffari, A Dignös, J Gamper, U Störl - ACM Computing Surveys, 2024 - dl.acm.org
Self-tuning is a feature of autonomic databases that includes the problem of automatic
schema design. It aims at providing an optimized schema that increases the overall …

Efficient scalable multi-attribute index selection using recursive strategies

R Schlosser, J Kossmann… - 2019 IEEE 35th …, 2019 - ieeexplore.ieee.org
An efficient selection of indexes is indispensable for database performance. For large
problem instances with hundreds of tables, existing approaches are not suitable: They either …

Deep lake: A lakehouse for deep learning

S Hambardzumyan, A Tuli, L Ghukasyan… - arXiv preprint arXiv …, 2022 - arxiv.org
Traditional data lakes provide critical data infrastructure for analytical workloads by enabling
time travel, running SQL queries, ingesting data with ACID transactions, and visualizing …

Retrofitting high availability mechanism to tame hybrid transaction/analytical processing

S Shen, R Chen, H Chen, B Zang - 15th {USENIX} Symposium on …, 2021 - usenix.org
Many application domains can benefit from hybrid transaction/analytical processing (HTAP)
by executing queries on real-time datasets produced by concurrent transactions. However …

Robust and budget-constrained encoding configurations for in-memory database systems

M Boissier - Proceedings of the VLDB Endowment, 2021 - dl.acm.org
Data encoding has been applied to database systems for decades as it mitigates bandwidth
bottlenecks and reduces storage requirements. But even in the presence of these …

Morphstore: Analytical query engine with a holistic compression-enabled processing model

P Damme, A Ungethüm, J Pietrzyk, A Krause… - arXiv preprint arXiv …, 2020 - arxiv.org
In this paper, we present MorphStore, an open-source in-memory columnar analytical query
engine with a novel holistic compression-enabled processing model. Basically, compression …

TardisDB: extending SQL to support versioning

ME Schüle, J Schmeißer, T Blum, A Kemper… - Proceedings of the …, 2021 - dl.acm.org
Online encyclopaedias such as Wikipedia implement their own version control above
database systems to manage multiple revisions of the same page. In contrast to temporal …