Matches in SemOpenAlex for { <https://semopenalex.org/work/W2149156919> ?p ?o ?g. }
- W2149156919 endingPage "1630" @default.
- W2149156919 startingPage "1617" @default.
- W2149156919 abstract "We propose a logical framework to analyze complex predicates (those involving a subquery) in SQL. We propose a new operator in the relational algebra for handling such predicates, and study its properties and how it combines with traditional relational operator. We focus on predicates of the form att θ MOD S, where att is an attribute, θ a comparison operator, MOD is one of SOME or ALL, and S is a (correlated or non-correlated) subquery. We provide a formal characterization of these predicate, as well as an implementation and optimization strategies for it. We show that our approach is extendible, so we can support the expression and optimization of other, similar predicates. Finally, we describe experimental evidence that the proposed approach is more efficient than the traditional approach across a variety of conditions." @default.
- W2149156919 created "2016-06-24" @default.
- W2149156919 creator A5001886735 @default.
- W2149156919 creator A5047572731 @default.
- W2149156919 date "2014-07-01" @default.
- W2149156919 modified "2023-09-23" @default.
- W2149156919 title "Complex SQL Predicates as Quantifiers" @default.
- W2149156919 cites W1524062755 @default.
- W2149156919 cites W1768336749 @default.
- W2149156919 cites W177669833 @default.
- W2149156919 cites W1825341804 @default.
- W2149156919 cites W1975880448 @default.
- W2149156919 cites W1996467498 @default.
- W2149156919 cites W1999403095 @default.
- W2149156919 cites W2008116177 @default.
- W2149156919 cites W2026344425 @default.
- W2149156919 cites W2049578111 @default.
- W2149156919 cites W2075827270 @default.
- W2149156919 cites W2087290458 @default.
- W2149156919 cites W2103842029 @default.
- W2149156919 cites W2104127688 @default.
- W2149156919 cites W2108996071 @default.
- W2149156919 cites W2111421966 @default.
- W2149156919 cites W2120936914 @default.
- W2149156919 cites W2128126407 @default.
- W2149156919 cites W2132804311 @default.
- W2149156919 cites W2141469207 @default.
- W2149156919 cites W2142479363 @default.
- W2149156919 cites W2153967839 @default.
- W2149156919 cites W2154751879 @default.
- W2149156919 cites W2165692869 @default.
- W2149156919 cites W2167764264 @default.
- W2149156919 cites W2170188482 @default.
- W2149156919 cites W2911599249 @default.
- W2149156919 cites W2954301182 @default.
- W2149156919 cites W3142967064 @default.
- W2149156919 doi "https://doi.org/10.1109/tkde.2013.55" @default.
- W2149156919 hasPublicationYear "2014" @default.
- W2149156919 type Work @default.
- W2149156919 sameAs 2149156919 @default.
- W2149156919 citedByCount "3" @default.
- W2149156919 countsByYear W21491569192015 @default.
- W2149156919 crossrefType "journal-article" @default.
- W2149156919 hasAuthorship W2149156919A5001886735 @default.
- W2149156919 hasAuthorship W2149156919A5047572731 @default.
- W2149156919 hasConcept C104317684 @default.
- W2149156919 hasConcept C120665830 @default.
- W2149156919 hasConcept C121329065 @default.
- W2149156919 hasConcept C121332964 @default.
- W2149156919 hasConcept C136197465 @default.
- W2149156919 hasConcept C140146324 @default.
- W2149156919 hasConcept C154945302 @default.
- W2149156919 hasConcept C158448853 @default.
- W2149156919 hasConcept C17020691 @default.
- W2149156919 hasConcept C185592680 @default.
- W2149156919 hasConcept C192209626 @default.
- W2149156919 hasConcept C199360897 @default.
- W2149156919 hasConcept C40207289 @default.
- W2149156919 hasConcept C41008148 @default.
- W2149156919 hasConcept C510870499 @default.
- W2149156919 hasConcept C55493867 @default.
- W2149156919 hasConcept C5655090 @default.
- W2149156919 hasConcept C77088390 @default.
- W2149156919 hasConcept C80444323 @default.
- W2149156919 hasConcept C86339819 @default.
- W2149156919 hasConcept C95916125 @default.
- W2149156919 hasConcept C99436015 @default.
- W2149156919 hasConceptScore W2149156919C104317684 @default.
- W2149156919 hasConceptScore W2149156919C120665830 @default.
- W2149156919 hasConceptScore W2149156919C121329065 @default.
- W2149156919 hasConceptScore W2149156919C121332964 @default.
- W2149156919 hasConceptScore W2149156919C136197465 @default.
- W2149156919 hasConceptScore W2149156919C140146324 @default.
- W2149156919 hasConceptScore W2149156919C154945302 @default.
- W2149156919 hasConceptScore W2149156919C158448853 @default.
- W2149156919 hasConceptScore W2149156919C17020691 @default.
- W2149156919 hasConceptScore W2149156919C185592680 @default.
- W2149156919 hasConceptScore W2149156919C192209626 @default.
- W2149156919 hasConceptScore W2149156919C199360897 @default.
- W2149156919 hasConceptScore W2149156919C40207289 @default.
- W2149156919 hasConceptScore W2149156919C41008148 @default.
- W2149156919 hasConceptScore W2149156919C510870499 @default.
- W2149156919 hasConceptScore W2149156919C55493867 @default.
- W2149156919 hasConceptScore W2149156919C5655090 @default.
- W2149156919 hasConceptScore W2149156919C77088390 @default.
- W2149156919 hasConceptScore W2149156919C80444323 @default.
- W2149156919 hasConceptScore W2149156919C86339819 @default.
- W2149156919 hasConceptScore W2149156919C95916125 @default.
- W2149156919 hasConceptScore W2149156919C99436015 @default.
- W2149156919 hasIssue "7" @default.
- W2149156919 hasLocation W21491569191 @default.
- W2149156919 hasOpenAccess W2149156919 @default.
- W2149156919 hasPrimaryLocation W21491569191 @default.
- W2149156919 hasRelatedWork W1506863050 @default.
- W2149156919 hasRelatedWork W1639806124 @default.
- W2149156919 hasRelatedWork W1979093255 @default.
- W2149156919 hasRelatedWork W2002489304 @default.
- W2149156919 hasRelatedWork W2149156919 @default.