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 …

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 …

Self-driving database systems: a conceptual approach

J Kossmann, R Schlosser - Distributed and Parallel Databases, 2020 - Springer
Challenges for self-driving database systems, which tune their physical design and
configuration autonomously, are manifold: Such systems have to anticipate future …

Fragment Allocations for Partially Replicated Databases Considering Data Modifications and Changing Workloads

S Halfpap, R Schlosser - Proceedings of the 33rd ACM International …, 2024 - dl.acm.org
Columnar database systems can process complex mixed workloads on a single node. In
case of increasing and peak analytical processing demand, we can offload read-only …

Column generation-based algorithm for fragment allocation: minimizing query splitting in distributed databases

A Amiri - Information Technology and Management, 2024 - Springer
This paper focuses on the fragment allocation problem in distributed databases and
proposes an approach that minimizes query splitting. Query splitting occurs when a query …

Log Replaying for Real-Time HTAP: An Adaptive Epoch-Based Two-Stage Framework

JP Zhu, Z Ye, P Cai, D Wang, F Zhang… - 2024 IEEE 40th …, 2024 - ieeexplore.ieee.org
As real-time analytics become increasingly important, more organizations are deploying
Hybrid Transactional/An-alytical Processing (HTAP) systems. The HTAP systems, based on …

Exploration of dynamic query-based load balancing for partially replicated database systems with node failures

S Halfpap, R Schlosser - Proceedings of the 29th ACM International …, 2020 - dl.acm.org
Database replication is a mechanism to achieve scalability, for example, by executing
queries independently on replica nodes. Partial replication is an approach to minimize the …

A comparison of allocation algorithms for partially replicated databases

S Halfpap, R Schlosser - 2019 IEEE 35th International …, 2019 - ieeexplore.ieee.org
Increasing demand for analytical processing capabilities can be managed by replication
approaches. However, to evenly balance the replicas' workload shares while at the same …

[PDF][PDF] Robust and Memory-Efficient Database Fragment Allocation for Large and Uncertain Database Workloads.

R Schlosser, S Halfpap - EDBT, 2021 - researchgate.net
Database replication and query load-balancing are mechanisms to scale query throughput.
The analysis of workloads allows loadbalancing queries to replica nodes according to their …

[PDF][PDF] Placement of Workloads from Advanced RDBMS Architectures into Complex Cloud Infrastructure.

AS Higginson, C Bostock, NW Paton, SM Embury - EDBT, 2022 - openproceedings.org
Capacity planning is an essential activity in the procurement and daily running of any multi-
server computer system. Workload placement is a well known problem and there are several …