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

Research output: Contribution in Book/Catalog/Report/Conference proceedingConference contribution

Abstract

Cost-based optimization is a promising paradigm that relies on execution queries to enable fast and efficient ex- ecution 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/develop- ers 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.
Original languageEnglish
Title of host publicationMODELSWARD
Place of PublicationLisbon
PublisherScience and Technology Publications, Lda
Pages43-54
Number of pages12
ISBN (Print)978-989-758-633-0
DOIs
Publication statusPublished - 2023
Event11th International Conference on Model-Driven Engineering and Software Development - Lisbon, Portugal
Duration: 19 Feb 202321 Feb 2023
Conference number: 11
https://modelsward.scitevents.org/?y=2023

Publication series

Name
PublisherScitePress
ISSN (Print)2184-4348

Conference

Conference11th International Conference on Model-Driven Engineering and Software Development
Abbreviated titleMODELSWARD 2023
Country/TerritoryPortugal
CityLisbon
Period19/02/2321/02/23
Internet address

Fingerprint

Dive into the research topics of 'Go Meta of Learned Cost Models: On the Power of Abstraction'. Together they form a unique fingerprint.

Cite this