Redbench: Workload Synthesis From Cloud Traces

Fuente: arXiv
Saved in:
Bibliographic Details
Main Authors: Wehrstein, Johannes, Heinrich, Roman, Stoian, Mihail, Krid, Skander, Stemmer, Martin, Kipf, Andreas, Binnig, Carsten, El-Hindi, Muhammad
Format: Preprint
Published: 2025
Subjects:
Online Access:
Tags: Add Tag
No Tags, Be the first to tag this record!
_version_ 1866913170280415232
author Wehrstein, Johannes
Heinrich, Roman
Stoian, Mihail
Krid, Skander
Stemmer, Martin
Kipf, Andreas
Binnig, Carsten
El-Hindi, Muhammad
author_facet Wehrstein, Johannes
Heinrich, Roman
Stoian, Mihail
Krid, Skander
Stemmer, Martin
Kipf, Andreas
Binnig, Carsten
El-Hindi, Muhammad
contents Workload traces from cloud data warehouse providers reveal that standard benchmarks such as TPC-H and TPC-DS fail to capture key characteristics of real-world workloads, including query repetition and string-heavy queries. In this paper, we introduce Redbench, a novel benchmark featuring a workload generator that reproduces real-world workload characteristics derived from traces released by cloud providers. Redbench integrates multiple workload generation techniques to tailor workloads to specific objectives, transforming existing benchmarks into realistic query streams that preserve intrinsic workload characteristics. By focusing on inherent workload signals rather than execution-specific metrics, Redbench bridges the gap between synthetic and real workloads. Our evaluation shows that (1) Redbench produces more realistic and reproducible workloads for cloud data warehouse benchmarking, and (2) Redbench reveals the impact of system optimizations across four commercial data warehouse platforms. We believe that Redbench provides a crucial foundation for advancing research on optimization techniques for modern cloud data warehouses.
format Preprint
id arxiv_https___arxiv_org_abs_2511_13059
institution arXiv
publishDate 2025
record_format arxiv
spellingShingle Redbench: Workload Synthesis From Cloud Traces
Wehrstein, Johannes
Heinrich, Roman
Stoian, Mihail
Krid, Skander
Stemmer, Martin
Kipf, Andreas
Binnig, Carsten
El-Hindi, Muhammad
Databases
Workload traces from cloud data warehouse providers reveal that standard benchmarks such as TPC-H and TPC-DS fail to capture key characteristics of real-world workloads, including query repetition and string-heavy queries. In this paper, we introduce Redbench, a novel benchmark featuring a workload generator that reproduces real-world workload characteristics derived from traces released by cloud providers. Redbench integrates multiple workload generation techniques to tailor workloads to specific objectives, transforming existing benchmarks into realistic query streams that preserve intrinsic workload characteristics. By focusing on inherent workload signals rather than execution-specific metrics, Redbench bridges the gap between synthetic and real workloads. Our evaluation shows that (1) Redbench produces more realistic and reproducible workloads for cloud data warehouse benchmarking, and (2) Redbench reveals the impact of system optimizations across four commercial data warehouse platforms. We believe that Redbench provides a crucial foundation for advancing research on optimization techniques for modern cloud data warehouses.
title Redbench: Workload Synthesis From Cloud Traces
topic Databases
url https://arxiv.org/abs/2511.13059