2026-07-22T16:59:06Z https://drops.dagstuhl.de/oai

oai:drops-oai.dagstuhl.de:8610 2024-03-06T10:42:28Z ddc:004 open_access

Covers of Query Results Kara, Ahmet Olteanu, Dan factorized database fractional hypertree decomposition functional aggregate query minimal edge cover query plan We introduce succinct lossless representations of query results called covers. They are subsets of the query results that correspond to minimal edge covers in the hypergraphs of these results. We first study covers whose structures are given by fractional hypertree decompositions of join queries. For any decomposition of a query, we give asymptotically tight size bounds for the covers of the query result over that decomposition and show that such covers can be computed in worst-case optimal time up to a logarithmic factor in the database size. For acyclic join queries, we can compute covers compositionally using query plans with a new operator called cover-join. The tuples in the query result can be enumerated from any of its covers with linearithmic pre-computation time and constant delay. We then generalize covers from joins to functional aggregate queries that express a host of computational problems such as aggregate-join queries, in-database optimization, matrix chain multiplication, and inference in probabilistic graphical models. Schloss Dagstuhl – Leibniz-Zentrum für Informatik Ahmet Kara and Dan Olteanu 2018 Is Part Of LIPIcs, Volume 98, 21st International Conference on Database Theory (ICDT 2018) InProceedings Text doc-type:ResearchArticle publishedVersion application/pdf doi:10.4230/LIPIcs.ICDT.2018.16 urn:nbn:de:0030-drops-86100 https://drops.dagstuhl.de/entities/document/10.4230/LIPIcs.ICDT.2018.16 eng https://creativecommons.org/licenses/by/3.0/legalcode