Loading [MathJax]/extensions/MathMenu.js
Lauca: A Workload Duplicator for Benchmarking Transactional Database Performance | IEEE Journals & Magazine | IEEE Xplore

Lauca: A Workload Duplicator for Benchmarking Transactional Database Performance


Abstract:

Generating synthetic workloads is essential and critical to the performance evaluation of database systems. When benchmarking database performance for a specific applicat...Show More

Abstract:

Generating synthetic workloads is essential and critical to the performance evaluation of database systems. When benchmarking database performance for a specific application, the similarity between synthetic workloads and real application workloads determines the credibility of the evaluation results. However, it meets a great challenge to catch workload characteristics for a target online transaction processing (OLTP) application considering the complexity of transaction executions. To address this problem, we propose a workload duplicator (Lauca) that can generate synthetic workloads with highly similar performance metrics compared to a specific application on both centralized and distributed databases. By carefully studying the application-driven workload generation problem, we present Transaction Logic, Data Access Distribution and Partition Access Distribution to characterize runtime workloads and propose novel generation algorithms to guarantee the high fidelity of synthetic workloads. To the best of our knowledge, Lauca is the first application-driven transactional workload generator. We conduct extensive experiments based on TPC-C, SmallBank and YCSB on both centralized and distributed databases. The experimental results show that Lauca consistently generates high-quality synthetic workloads.
Published in: IEEE Transactions on Knowledge and Data Engineering ( Volume: 36, Issue: 7, July 2024)
Page(s): 3180 - 3194
Date of Publication: 30 January 2024

ISSN Information:

Funding Agency:


Contact IEEE to Subscribe

References

References is not available for this document.