We gratefully acknowledge support from
the Simons Foundation and member institutions.
Full-text links:

Download:

Current browse context:

cs.DB

Change to browse by:

cs

References & Citations

DBLP - CS Bibliography

Bookmark

(what is this?)
CiteULike logo BibSonomy logo Mendeley logo del.icio.us logo Digg logo Reddit logo ScienceWISE logo

Computer Science > Databases

Title: Degree Sequence Bound For Join Cardinality Estimation

Abstract: Recent work has demonstrated the catastrophic effects of poor cardinality estimates on query processing time. In particular, underestimating query cardinality can result in overly optimistic query plans which take orders of magnitude longer to complete than one generated with the true cardinality. Cardinality bounding avoids this pitfall by computing a strict upper bound on the query's output size using statistics about the database such as table sizes and degrees, i.e. value frequencies. In this paper, we extend this line of work by proving a novel bound called the Degree Sequence Bound which takes into account the full degree sequences and the max tuple multiplicity. This bound improves upon previous work incorporating degree constraints which focused on the maximum degree rather than the degree sequence. Further, we describe how to practically compute this bound using a learned approximation of the true degree sequences.
Subjects: Databases (cs.DB)
Cite as: arXiv:2201.04166 [cs.DB]
  (or arXiv:2201.04166v2 [cs.DB] for this version)

Submission history

From: Kyle Deeds [view email]
[v1] Tue, 11 Jan 2022 19:34:31 GMT (968kb,D)
[v2] Wed, 30 Mar 2022 16:30:46 GMT (242kb,D)

Link back to: arXiv, form interface, contact.