Matches in SemOpenAlex for { <https://semopenalex.org/work/W2790840297> ?p ?o ?g. }
- W2790840297 abstract "Efficient join processing is one of the most fundamental and well-studied tasks in database research. In this work, we examine algorithms for natural join queries over many relations and describe a novel algorithm to process these queries optimally in terms of worst-case data complexity. Our result builds on recent work by Atserias, Grohe, and Marx, who gave bounds on the size of a full conjunctive query in terms of the sizes of the individual relations in the body of the query. These bounds, however, are not constructive: they rely on Shearer's entropy inequality which is information-theoretic. Thus, the previous results leave open the question of whether there exist algorithms whose running time achieve these optimal bounds. An answer to this question may be interesting to database practice, as we show in this paper that any project-join plan is polynomially slower than the optimal bound for some queries. We construct an algorithm whose running time is worst-case optimal for all natural join queries. Our result may be of independent interest, as our algorithm also yields a constructive proof of the general fractional cover bound by Atserias, Grohe, and Marx without using Shearer's inequality. In addition, we show that this bound is equivalent to a geometric inequality by Bollobás and Thomason, one of whose special cases is the famous Loomis-Whitney inequality. Hence, our results algorithmically prove these inequalities as well. Finally, we discuss how our algorithm can be used to compute a relaxed notion of joins." @default.
- W2790840297 created "2018-03-29" @default.
- W2790840297 creator A5001041485 @default.
- W2790840297 creator A5049614530 @default.
- W2790840297 creator A5062573204 @default.
- W2790840297 creator A5070267604 @default.
- W2790840297 date "2012-05-21" @default.
- W2790840297 modified "2023-09-30" @default.
- W2790840297 title "Worst-case optimal join algorithms" @default.
- W2790840297 cites W1967066104 @default.
- W2790840297 cites W1967265779 @default.
- W2790840297 cites W1969116803 @default.
- W2790840297 cites W1999339208 @default.
- W2790840297 cites W2007069074 @default.
- W2790840297 cites W2010747199 @default.
- W2790840297 cites W2013092187 @default.
- W2790840297 cites W2037027334 @default.
- W2790840297 cites W2041829641 @default.
- W2790840297 cites W2046652577 @default.
- W2790840297 cites W2050280202 @default.
- W2790840297 cites W2057256946 @default.
- W2790840297 cites W2057512592 @default.
- W2790840297 cites W2064383543 @default.
- W2790840297 cites W2090322880 @default.
- W2790840297 cites W2126624503 @default.
- W2790840297 cites W2140620700 @default.
- W2790840297 cites W2143452574 @default.
- W2790840297 cites W2146492010 @default.
- W2790840297 cites W2150779766 @default.
- W2790840297 cites W2157827214 @default.
- W2790840297 cites W2158237121 @default.
- W2790840297 cites W2159738186 @default.
- W2790840297 cites W2171903035 @default.
- W2790840297 cites W2396635388 @default.
- W2790840297 cites W4233762723 @default.
- W2790840297 doi "https://doi.org/10.1145/2213556.2213565" @default.
- W2790840297 hasPublicationYear "2012" @default.
- W2790840297 type Work @default.
- W2790840297 sameAs 2790840297 @default.
- W2790840297 citedByCount "142" @default.
- W2790840297 countsByYear W27908402972012 @default.
- W2790840297 countsByYear W27908402972013 @default.
- W2790840297 countsByYear W27908402972014 @default.
- W2790840297 countsByYear W27908402972015 @default.
- W2790840297 countsByYear W27908402972016 @default.
- W2790840297 countsByYear W27908402972017 @default.
- W2790840297 countsByYear W27908402972018 @default.
- W2790840297 countsByYear W27908402972019 @default.
- W2790840297 countsByYear W27908402972020 @default.
- W2790840297 countsByYear W27908402972021 @default.
- W2790840297 countsByYear W27908402972022 @default.
- W2790840297 countsByYear W27908402972023 @default.
- W2790840297 crossrefType "proceedings-article" @default.
- W2790840297 hasAuthorship W2790840297A5001041485 @default.
- W2790840297 hasAuthorship W2790840297A5049614530 @default.
- W2790840297 hasAuthorship W2790840297A5062573204 @default.
- W2790840297 hasAuthorship W2790840297A5070267604 @default.
- W2790840297 hasBestOaLocation W27908402972 @default.
- W2790840297 hasConcept C111919701 @default.
- W2790840297 hasConcept C11413529 @default.
- W2790840297 hasConcept C114614502 @default.
- W2790840297 hasConcept C118615104 @default.
- W2790840297 hasConcept C134306372 @default.
- W2790840297 hasConcept C199360897 @default.
- W2790840297 hasConcept C202854965 @default.
- W2790840297 hasConcept C2776124973 @default.
- W2790840297 hasConcept C2778692605 @default.
- W2790840297 hasConcept C2778701210 @default.
- W2790840297 hasConcept C33923547 @default.
- W2790840297 hasConcept C41008148 @default.
- W2790840297 hasConcept C77553402 @default.
- W2790840297 hasConcept C80444323 @default.
- W2790840297 hasConcept C98045186 @default.
- W2790840297 hasConceptScore W2790840297C111919701 @default.
- W2790840297 hasConceptScore W2790840297C11413529 @default.
- W2790840297 hasConceptScore W2790840297C114614502 @default.
- W2790840297 hasConceptScore W2790840297C118615104 @default.
- W2790840297 hasConceptScore W2790840297C134306372 @default.
- W2790840297 hasConceptScore W2790840297C199360897 @default.
- W2790840297 hasConceptScore W2790840297C202854965 @default.
- W2790840297 hasConceptScore W2790840297C2776124973 @default.
- W2790840297 hasConceptScore W2790840297C2778692605 @default.
- W2790840297 hasConceptScore W2790840297C2778701210 @default.
- W2790840297 hasConceptScore W2790840297C33923547 @default.
- W2790840297 hasConceptScore W2790840297C41008148 @default.
- W2790840297 hasConceptScore W2790840297C77553402 @default.
- W2790840297 hasConceptScore W2790840297C80444323 @default.
- W2790840297 hasConceptScore W2790840297C98045186 @default.
- W2790840297 hasLocation W27908402971 @default.
- W2790840297 hasLocation W27908402972 @default.
- W2790840297 hasLocation W27908402973 @default.
- W2790840297 hasOpenAccess W2790840297 @default.
- W2790840297 hasPrimaryLocation W27908402971 @default.
- W2790840297 hasRelatedWork W1490568884 @default.
- W2790840297 hasRelatedWork W1707676430 @default.
- W2790840297 hasRelatedWork W182405777 @default.
- W2790840297 hasRelatedWork W2017945996 @default.
- W2790840297 hasRelatedWork W2045113137 @default.
- W2790840297 hasRelatedWork W2048954306 @default.
- W2790840297 hasRelatedWork W2134491188 @default.