TY - JOUR
T1 - Explainable AI for DBA
T2 - Bridging the DBA's experience and machine learning in tuning database systems
AU - Ouared, Abdelkader
AU - Amrani, Moussa
AU - Schobbens, Pierre Yves
N1 - Publisher Copyright:
© 2023 John Wiley & Sons, Ltd.
PY - 2023/9/25
Y1 - 2023/9/25
N2 - Recently artificial intelligence techniques in the database community have become a driver for many database applications. The proposed solution adopting AI in the core database shows that incorporating AI improves the query processing and the self-tuning of database systems. In traditional systems, self-tuning database systems are commonly addressed with heuristics to suggest the physical structures (e.g., creation of indexes and materialized views) that enable the fastest execution of queries. However, existing designer tools do not explain/justify how the system behaves and the reasoning behind tuning activities. Moreover, these tools do not keep the database administrator (DBA) in the loop of the optimization process to trust some of the automatic tuning decisions. To address this problem, we introduce a framework called Explain-Tun that enables to predict and explain self-tuning actions with transparent strategy from historical data using two explicit models, that is, decision tree and random forests. First, we propose AI-based DBMS to explain how to select physical structures and provide decision rules extracted by machine learning (ML) as a designed plug-gable component. Second, a goal-oriented model to keep DBA in the loop of the optimization process in order to manipulate ML models as CRUD entities. Finally, we evaluate our approach on three use cases, results show that bridging the DBA's experience and ML make sense in tuning database systems.
AB - Recently artificial intelligence techniques in the database community have become a driver for many database applications. The proposed solution adopting AI in the core database shows that incorporating AI improves the query processing and the self-tuning of database systems. In traditional systems, self-tuning database systems are commonly addressed with heuristics to suggest the physical structures (e.g., creation of indexes and materialized views) that enable the fastest execution of queries. However, existing designer tools do not explain/justify how the system behaves and the reasoning behind tuning activities. Moreover, these tools do not keep the database administrator (DBA) in the loop of the optimization process to trust some of the automatic tuning decisions. To address this problem, we introduce a framework called Explain-Tun that enables to predict and explain self-tuning actions with transparent strategy from historical data using two explicit models, that is, decision tree and random forests. First, we propose AI-based DBMS to explain how to select physical structures and provide decision rules extracted by machine learning (ML) as a designed plug-gable component. Second, a goal-oriented model to keep DBA in the loop of the optimization process in order to manipulate ML models as CRUD entities. Finally, we evaluate our approach on three use cases, results show that bridging the DBA's experience and ML make sense in tuning database systems.
KW - AI for DBMS
KW - database systems
KW - explainability
KW - machine learning
KW - self-driving DBMS
KW - transparency of self-tuning database
UR - http://www.scopus.com/inward/record.url?scp=85152072289&partnerID=8YFLogxK
U2 - 10.1002/cpe.7698
DO - 10.1002/cpe.7698
M3 - Article
AN - SCOPUS:85152072289
SN - 1532-0626
VL - 35
JO - Concurrency and Computation: Practice and Experience
JF - Concurrency and Computation: Practice and Experience
IS - 21
M1 - e7698
ER -