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 language | English |
---|---|
Title of host publication | MODELSWARD |
Place of Publication | Lisbon |
Publisher | Science and Technology Publications, Lda |
Pages | 43-54 |
Number of pages | 12 |
ISBN (Print) | 978-989-758-633-0 |
DOIs | |
Publication status | Published - 2023 |
Event | 11th International Conference on Model-Driven Engineering and Software Development - Lisbon, Portugal Duration: 19 Feb 2023 → 21 Feb 2023 Conference number: 11 https://modelsward.scitevents.org/?y=2023 |
Publication series
Name | |
---|---|
Publisher | ScitePress |
ISSN (Print) | 2184-4348 |
Conference
Conference | 11th International Conference on Model-Driven Engineering and Software Development |
---|---|
Abbreviated title | MODELSWARD 2023 |
Country/Territory | Portugal |
City | Lisbon |
Period | 19/02/23 → 21/02/23 |
Internet address |