Finally, a prototype implementation demonstrates the practical impact on query evaluation. Early experiments show potential for large performance gains on difficult queries in standard database systems (e.g., PostgreSQL, SparkSQL)
Check it out: arxiv.org/pdf/2412.11669
Finally, a prototype implementation demonstrates the practical impact on query evaluation. Early experiments show potential for large performance gains on difficult queries in standard database systems (e.g., PostgreSQL, SparkSQL)
Check it out: arxiv.org/pdf/2412.11669
• SHW can achieve smaller widths than HW while remaining tractable to compute, boosting efficiency.
• SHW induces a hierarchy of width measures that equal generalised hypertree width in the limit.
• SHW can achieve smaller widths than HW while remaining tractable to compute, boosting efficiency.
• SHW induces a hierarchy of width measures that equal generalised hypertree width in the limit.
We propose Soft Hypertree Width (SHW) – a relaxed version of hypertree width that provides additional algorithmic flexibility, which allows for efficiently incorporating preferences and constraints into query decompositions.
We propose Soft Hypertree Width (SHW) – a relaxed version of hypertree width that provides additional algorithmic flexibility, which allows for efficiently incorporating preferences and constraints into query decompositions.