loading
Papers Papers/2022 Papers Papers/2022

Research.Publish.Connect.

Paper

Authors: Abdelkader Ouared ; Moussa Amrani and Pierre-Yves Schobbens

Affiliation: Faculty of Computer Science / NaDI, University of Namur, Rue Grandgagnage, Namur 5000, Belgium

Keyword(s): Learned Database Cost Model, Database Management System, Meta-Learning, Generic Interface.

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 comple x 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. (More)

CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 18.223.171.12

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
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 - MODELSWARD; ISBN 978-989-758-633-0; ISSN 2184-4348, SciTePress, pages 43-54. DOI: 10.5220/0011665800003402

@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 - MODELSWARD},
year={2023},
pages={43-54},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0011665800003402},
isbn={978-989-758-633-0},
issn={2184-4348},
}

TY - CONF

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

- Science and Technology Publications, Lda.
RESOURCES

Proceedings

Papers

Authors

Ontology

CONTACTS

Science and Technology Publications, Lda
Avenida de S. Francisco Xavier, Lote 7 Cv. C,
2900-616 Setúbal, Portugal.

Phone: +351 265 520 185 (National fixed network call)
Fax: +351 265 520 186
Email: info@scitepress.org

EXTERNAL LINKS

PRIMORIS

INSTICC

SCITEVENTS

CROSSREF

PROCEEDINGS SUBMITTED FOR INDEXATION BY:

dblp

Ei Compendex

SCOPUS

Semantic Scholar

Google Scholar

Microsoft Academic