Practical Machine Learning for Self-Tuning Buffer Pools in DBMS Mainframe Systems
CLEI Electronic Journal · 06.08.2026 · 29 (4)
DOI: 10.19153/cleiej.29.4.2 ↗Kurz gefasst
Fachartikel in der Zeitschrift CLEI Electronic Journal, online erschienen am 06.08.2026. Verfasst von Eduardo Pingarilho Mendizabal und 6 weiteren Autor:innen. Der Volltext ist frei zugänglich (Open Access, CC BY 4.0).
Abstract (Originalsprache)
This paper investigates the practical applicability of Machine Learning (ML) techniques for buffer pool optimization in Database Management Systems (DBMSs), a critical component traditionally tuned manually in mission-critical environments. While prior work proposes ML-based approaches, most evaluations are limited to simulated settings, leaving their feasibility in production systems—particularly on mainframes—largely unexplored. To address this gap, we present an empirical, production-level validation of an automated, data-driven optimization methodology applied to a relational DBMS running on a mainframe. Our approach integrates Bayesian Optimization based on Gaussian Process Regression (BO-GPR) with a three-phase pipeline: Exploratory Factor Analysis with clustering for metric reduction, LASSO regression for parameter selection, and BO-GPR for fine-grained configuration tuning. We validate the methodology using real workloads from a large-scale financial system, achieving substantial performance gains, including up to a 95\% reduction in maximum synchronous I/O wait time. These results provide reproducible evidence that ML-based optimization is both effective and operationally viable in mainframe-based DBMSs.
Zitieren
APA
Mendizabal, E. P., Filho, G. P. R., Marotta, M. A., Caetano, M. F., Gondim, J. J. C., Bondan, L., & Araujo, A. (2026). Practical Machine Learning for Self-Tuning Buffer Pools in DBMS Mainframe Systems. CLEI Electronic Journal, 29(4). https://doi.org/10.19153/cleiej.29.4.2
Vancouver
Mendizabal EP, Filho GPR, Marotta MA, Caetano MF, Gondim JJC, Bondan L, et al. Practical Machine Learning for Self-Tuning Buffer Pools in DBMS Mainframe Systems. CLEI Electronic Journal. 2026;29(4). doi:10.19153/cleiej.29.4.2
BibTeX
@article{Mendizabal2026,
author = {Mendizabal, Eduardo Pingarilho and Filho, Geraldo P. Rocha and Marotta, Marcelo A. and Caetano, Marcos F. and Gondim, Joao Jose C. and Bondan, Lucas and Araujo, Aleteia},
title = {Practical Machine Learning for Self-Tuning Buffer Pools in DBMS Mainframe Systems},
journal = {CLEI Electronic Journal},
year = {2026},
volume = {29},
number = {4},
doi = {10.19153/cleiej.29.4.2}
}
EUVIMED