Tractable Orders for Direct Access to Ranked Answers of Conjunctive Queries

Carmeli, Nofar; Tziavelis, Nikolaos; Gatterbauer, Wolfgang; Kimelfeld, Benny; Riedewald, Mirek

doi:10.48550/arxiv.2012.11965

Cited by 1 publication

(1 citation statement)

References 0 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…The related problems of enumerating in provably random order [20] and directly accessing any result via its rank [19] have also been considered, but are limited to equi-joins.…”

Section: Related Workmentioning

confidence: 99%

Beyond Equi-joins: Ranking, Enumeration and Factorization

Tziavelis,

Gatterbauer,

Riedewald

2021

Preprint

Self Cite

View full text Add to dashboard Cite

We study full acyclic join queries with general join predicates that involve conjunctions and disjunctions of inequalities, focusing on ranked enumeration where the answers are returned incrementally in an order dictated by a given ranking function. Our approach offers strong time and space complexity guarantees in the standard RAM model of computation, getting surprisingly close to those of equi-joins. With 𝑛 denoting the number of tuples in the database, we guarantee that for every value of 𝑘, the 𝑘 top-ranked answers are returned in O (𝑛 polylog 𝑛 +𝑘 log 𝑘) time and O (𝑛 polylog 𝑛 +𝑘) space. This is within a polylogarithmic factor of the best-known guarantee for equi-joins and even O (𝑛 + 𝑘), the time it takes to look at the input and output 𝑘 answers. The key ingredient is an O (𝑛 polylog 𝑛)-size factorized representation of the query output, which is constructed on-the-fly for a given query and database. As a side benefit, our techniques are also applicable to unranked enumeration (where answers can be returned in any order) for joins with inequalities, returning 𝑘 answers in O (𝑛 polylog 𝑛 + 𝑘). This guarantee improves over the state of the art for large values of 𝑘. In an experimental study, we show that our ranked-enumeration approach is not only theoretically interesting, but also fast and memory-efficient in practice.

show abstract

“…The related problems of enumerating in provably random order [20] and directly accessing any result via its rank [19] have also been considered, but are limited to equi-joins.…”

Section: Related Workmentioning

confidence: 99%

Beyond Equi-joins: Ranking, Enumeration and Factorization

Tziavelis,

Gatterbauer,

Riedewald

2021

Preprint

Self Cite

View full text Add to dashboard Cite

show abstract

Tractable Orders for Direct Access to Ranked Answers of Conjunctive Queries

Cited by 1 publication

References 0 publications

Beyond Equi-joins: Ranking, Enumeration and Factorization

Beyond Equi-joins: Ranking, Enumeration and Factorization

Contact Info

Product

Resources

About