A Branch-&-Bound Algorithm for Fractional Hypertree Decomposition

Conjunctive queries ( CQ s) have been widely used in database systems in which acyclic CQ s can be computed efficiently, whereas cyclic CQ s may not. Here, a CQ is acyclic if its hypergraph representation H is acyclic. In order to find a class of CQ s that are "mildly cyclic", hypertree decompositions (HDs) have been studied. The quality of such HDs is by the so-called hypertree width. The class of acyclic queries is the queries whose hypertree width is 1, and a mildly cyclic CQ can be processed efficiently if its hypertree width is bounded. There are several HDs, such as tree decomposition (TD), generalized hypertree decomposition (GHD), fractional hypertree decomposition (FHD), as well as hypertree decomposition (HD). The minimum hypertree width by FHD is the smallest among all, and it is NP-complete to check if the minimum hypertree width by FHD exists for a given hypertree width at most k. In the literature, there is no dynamic programming ( DP ) algorithm or branch-&-bound algorithm reported to compute FHD. In this paper, we show that there is a DP algorithm for FHD, and we give a branch-&-bound algorithm based on our DP algorithm to compute FHD with upper/lower bounds. We confirm the effectiveness and efficiency of our algorithm by testing all 3,648 hypergraphs given in a benchmark for HDs, and we also confirm our approach in query evaluation in real database systems.

Authors

Institutions

Publication Details

Journal
Proceedings of the VLDB Endowment
Published
2024-09-01
DOI
https://doi.org/10.14778/3704965.3704973
Citations
1
Primary Topic
Blind Source Separation Techniques
Type
article
Field-Weighted Citation Impact
0.35
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
article

A Branch-&-Bound Algorithm for Fractional Hypertree Decomposition

Jeffrey Xu Yu, Zongyan He
1 citations
Proceedings of the VLDB Endowment
Blind Source Separation Techniques
0.35
article

A Branch-&-Bound Algorithm for Fractional Hypertree Decomposition

Jeffrey Xu Yu, Zongyan He
article en
1 citations

Abstract

Conjunctive queries ( CQ s) have been widely used in database systems in which acyclic CQ s can be computed efficiently, whereas cyclic CQ s may not. Here, a CQ is acyclic if its hypergraph representation H is acyclic. In order to find a class of CQ s that are "mildly cyclic", hypertree decompositions (HDs) have been studied. The quality of such HDs is by the so-called hypertree width. The class of acyclic queries is the queries whose hypertree width is 1, and a mildly cyclic CQ can be processed efficiently if its hypertree width is bounded. There are several HDs, such as tree decomposition (TD), generalized hypertree decomposition (GHD), fractional hypertree decomposition (FHD), as well as hypertree decomposition (HD). The minimum hypertree width by FHD is the smallest among all, and it is NP-complete to check if the minimum hypertree width by FHD exists for a given hypertree width at most k. In the literature, there is no dynamic programming ( DP ) algorithm or branch-&-bound algorithm reported to compute FHD. In this paper, we show that there is a DP algorithm for FHD, and we give a branch-&-bound algorithm based on our DP algorithm to compute FHD with upper/lower bounds. We confirm the effectiveness and efficiency of our algorithm by testing all 3,648 hypergraphs given in a benchmark for HDs, and we also confirm our approach in query evaluation in real database systems.

Proceedings of the VLDB EndowmentVol. 17(13)
Chinese University of Hong Kong (HK)
Openalex Percentile: Top 38%
Blind Source Separation Techniques
0.35
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.