Complexity Analysis of Pipeline Execution Order Enumeration for Query Execution Plans

Publikation: Beitrag zu KonferenzenPaperBeigetragenBegutachtung

Beitragende

Abstract

Optimizing for memory consumption during query processing can be facilitated by enumerating pipeline execution orders to minimize the lifetime of intermediates. The number of possible enumerations is potentially factorial. Recent literature has explored algorithms to enumerate pipeline execution orders for any given query execution plan. However, no methods of calculating the number of pipeline execution orders have been yet provided. Due to the factorial complexity a pre-calculation of the expected enumeration count is necessary. This work will provide the combinatorial framework to calculate the structural complexity, i.e. the expected enumeration count, of any given query execution plan without traversing. Through this, we provide the means to identify expensive query execution plans. The precise calculation then enables optimizers to employ heuristics for memory optimization if the given query execution plan exhibits too many possible pipeline execution orders.

Details

OriginalspracheEnglisch
Seiten95-112
Seitenumfang18
PublikationsstatusVeröffentlicht - 2025
Peer-Review-StatusJa

(Fach-)Tagung

Titel21. Fachtagung “Datenbanksysteme für Business, Technologie und Web” des Fachbereichs “Datenbanken und Informationssysteme” (DBIS) der Gesellschaft fürInformatik (GI)
KurztitelBTW 2025
Veranstaltungsnummer21
Dauer3 - 7 Februar 2025
Webseite
OrtOtto-Friedrich-Universität Bamberg
StadtBamberg
LandDeutschland

Externe IDs

ORCID /0000-0001-8107-2775/work/199215617
Scopus 105037442512

Schlagworte

Forschungsprofillinien der TU Dresden

Fächergruppen, Lehr- und Forschungsbereiche, Fachgebiete nach Destatis

ASJC Scopus Sachgebiete