Complexity Analysis of Pipeline Execution Order Enumeration for Query Execution Plans

Research output: Contribution to conferencesPaperContributedpeer-review

Contributors

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

Original languageEnglish
Pages95-112
Number of pages18
Publication statusPublished - 2025
Peer-reviewedYes

Symposium

Title21st Conference on Database Systems for Business, Technology and Web
Abbreviated titleBTW 2025
Conference number21
Duration3 - 7 February 2025
Website
LocationOtto-Friedrich-Universität Bamberg
CityBamberg
CountryGermany

External IDs

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

Keywords

Research priority areas of TU Dresden

DFG Classification of Subject Areas according to Review Boards

Subject groups, research areas, subject areas according to Destatis

ASJC Scopus subject areas