Go Meta of Learned Cost Models: On the Power of Abstraction

Abdelkader Ouared, Moussa Amrani, Pierre-Yves Schobbens

2023

Abstract

Cost-based optimization is a promising paradigm that relies on execution queries to enable fast and efficient execution reached by the database cost model (CM) during query processing/optimization. While a few database management systems (DBMS) already have support for mathematical CMs, developing such a CMs embedded or hard-coded for any DBMS remains a challenging and error-prone task. A generic interface must support a wide range of DBMS independently of the internal structure used for extending and modifying their signature; be efficient for good responsiveness. We propose a solution that provides a common set of parameters and cost primitives allowing intercepting the signature of the internal cost function and changing its internal parameters and configuration options. Therefore, the power of abstraction allows one to capture the designers/developers intent at a higher level of abstraction and encode expert knowledge of domain-specific transformation in order to construct complex CMs, receiving quick feedback as they calibrate and alter the specifications. Our contribution relies on a generic CM interface supported by Model-Driven Engineering paradigm to create cost functions for database operations as intermediate specifications in which more optimization concerning the performance are delegated by our framework and that can be compiled and executed by the target DBMS. A proof-of-concept prototype is implemented by considering the CM that exists in PostgreSQL optimizer.

Paper Citation

in Harvard Style

Ouared A., Amrani M. and Schobbens P. (2023). Go Meta of Learned Cost Models: On the Power of Abstraction. In Proceedings of the 11th International Conference on Model-Based Software and Systems Engineering - Volume 1: MODELSWARD, ISBN 978-989-758-633-0, pages 43-54. DOI: 10.5220/0011665800003402

in Bibtex Style

@conference{modelsward23,
author={Abdelkader Ouared and Moussa Amrani and Pierre-Yves Schobbens},
title={Go Meta of Learned Cost Models: On the Power of Abstraction},
booktitle={Proceedings of the 11th International Conference on Model-Based Software and Systems Engineering - Volume 1: MODELSWARD,},
year={2023},
pages={43-54},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0011665800003402},
isbn={978-989-758-633-0},
}

in EndNote Style

TY - CONF

JO - Proceedings of the 11th International Conference on Model-Based Software and Systems Engineering - Volume 1: MODELSWARD,
TI - Go Meta of Learned Cost Models: On the Power of Abstraction
SN - 978-989-758-633-0
AU - Ouared A.
AU - Amrani M.
AU - Schobbens P.
PY - 2023
SP - 43
EP - 54
DO - 10.5220/0011665800003402