Matches in SemOpenAlex for { <https://semopenalex.org/work/W2002171029> ?p ?o ?g. }
- W2002171029 endingPage "573" @default.
- W2002171029 startingPage "526" @default.
- W2002171029 abstract "Summary-Table-by-Example (STBE) is a graphical language suitable for statistical database applications. STBE queries have a hierarchical subquery structure and manipulate summary tables and relations with set-valued attributes. The hierarchical arrangement of STBE queries naturally implies a tuple-by-tuple subquery evaluation strategy (similar to the nested loops join implementation technique) which may not be the best query processing strategy. In this paper we discuss the query processing techniques used in STBE. We first convert an STBE query into an “extended” relational algebra (ERA) expression. Two transformations are introduced to remove the hierarchical arrangement of subqueries so that query optimization is possible. To solve the “empty partition” problem of aggregate function evaluation, directional join (one-sided outer-join) is utilized. We give the algebraic properties of the ERA operators to obtain an “improved” ERA expression. Finally we briefly discuss the generation of alternative implementations of a given ERA expression. STBE is implemented in a prototype statistical database management system. We discuss the STBE-related features of the implemented system." @default.
- W2002171029 created "2016-06-24" @default.
- W2002171029 creator A5016412404 @default.
- W2002171029 creator A5034808531 @default.
- W2002171029 creator A5091049090 @default.
- W2002171029 date "1989-12-01" @default.
- W2002171029 modified "2023-10-17" @default.
- W2002171029 title "Query processing techniques in the summary-table-by-example database query language" @default.
- W2002171029 cites W1505238579 @default.
- W2002171029 cites W1986832527 @default.
- W2002171029 cites W2005471433 @default.
- W2002171029 cites W2008116177 @default.
- W2002171029 cites W2027639996 @default.
- W2002171029 cites W2053428424 @default.
- W2002171029 cites W2054870222 @default.
- W2002171029 cites W2083028719 @default.
- W2002171029 cites W2095263945 @default.
- W2002171029 cites W2113904485 @default.
- W2002171029 cites W2120936914 @default.
- W2002171029 cites W2122789628 @default.
- W2002171029 cites W2140921033 @default.
- W2002171029 cites W2153329411 @default.
- W2002171029 doi "https://doi.org/10.1145/76902.76906" @default.
- W2002171029 hasPublicationYear "1989" @default.
- W2002171029 type Work @default.
- W2002171029 sameAs 2002171029 @default.
- W2002171029 citedByCount "41" @default.
- W2002171029 countsByYear W20021710292012 @default.
- W2002171029 countsByYear W20021710292013 @default.
- W2002171029 crossrefType "journal-article" @default.
- W2002171029 hasAuthorship W2002171029A5016412404 @default.
- W2002171029 hasAuthorship W2002171029A5034808531 @default.
- W2002171029 hasAuthorship W2002171029A5091049090 @default.
- W2002171029 hasBestOaLocation W20021710291 @default.
- W2002171029 hasConcept C114614502 @default.
- W2002171029 hasConcept C118615104 @default.
- W2002171029 hasConcept C118930307 @default.
- W2002171029 hasConcept C134306372 @default.
- W2002171029 hasConcept C148840519 @default.
- W2002171029 hasConcept C157692150 @default.
- W2002171029 hasConcept C164120249 @default.
- W2002171029 hasConcept C177264268 @default.
- W2002171029 hasConcept C18912844 @default.
- W2002171029 hasConcept C192028432 @default.
- W2002171029 hasConcept C192939062 @default.
- W2002171029 hasConcept C194222762 @default.
- W2002171029 hasConcept C199360897 @default.
- W2002171029 hasConcept C23123220 @default.
- W2002171029 hasConcept C33923547 @default.
- W2002171029 hasConcept C41008148 @default.
- W2002171029 hasConcept C42812 @default.
- W2002171029 hasConcept C45235069 @default.
- W2002171029 hasConcept C54239708 @default.
- W2002171029 hasConcept C5655090 @default.
- W2002171029 hasConcept C77088390 @default.
- W2002171029 hasConcept C80444323 @default.
- W2002171029 hasConcept C9376300 @default.
- W2002171029 hasConcept C95916125 @default.
- W2002171029 hasConcept C97854310 @default.
- W2002171029 hasConcept C98199447 @default.
- W2002171029 hasConcept C99016210 @default.
- W2002171029 hasConceptScore W2002171029C114614502 @default.
- W2002171029 hasConceptScore W2002171029C118615104 @default.
- W2002171029 hasConceptScore W2002171029C118930307 @default.
- W2002171029 hasConceptScore W2002171029C134306372 @default.
- W2002171029 hasConceptScore W2002171029C148840519 @default.
- W2002171029 hasConceptScore W2002171029C157692150 @default.
- W2002171029 hasConceptScore W2002171029C164120249 @default.
- W2002171029 hasConceptScore W2002171029C177264268 @default.
- W2002171029 hasConceptScore W2002171029C18912844 @default.
- W2002171029 hasConceptScore W2002171029C192028432 @default.
- W2002171029 hasConceptScore W2002171029C192939062 @default.
- W2002171029 hasConceptScore W2002171029C194222762 @default.
- W2002171029 hasConceptScore W2002171029C199360897 @default.
- W2002171029 hasConceptScore W2002171029C23123220 @default.
- W2002171029 hasConceptScore W2002171029C33923547 @default.
- W2002171029 hasConceptScore W2002171029C41008148 @default.
- W2002171029 hasConceptScore W2002171029C42812 @default.
- W2002171029 hasConceptScore W2002171029C45235069 @default.
- W2002171029 hasConceptScore W2002171029C54239708 @default.
- W2002171029 hasConceptScore W2002171029C5655090 @default.
- W2002171029 hasConceptScore W2002171029C77088390 @default.
- W2002171029 hasConceptScore W2002171029C80444323 @default.
- W2002171029 hasConceptScore W2002171029C9376300 @default.
- W2002171029 hasConceptScore W2002171029C95916125 @default.
- W2002171029 hasConceptScore W2002171029C97854310 @default.
- W2002171029 hasConceptScore W2002171029C98199447 @default.
- W2002171029 hasConceptScore W2002171029C99016210 @default.
- W2002171029 hasIssue "4" @default.
- W2002171029 hasLocation W20021710291 @default.
- W2002171029 hasOpenAccess W2002171029 @default.
- W2002171029 hasPrimaryLocation W20021710291 @default.
- W2002171029 hasRelatedWork W2074576933 @default.
- W2002171029 hasRelatedWork W2359315734 @default.
- W2002171029 hasRelatedWork W2372649518 @default.
- W2002171029 hasRelatedWork W2604963418 @default.
- W2002171029 hasRelatedWork W4381740310 @default.
- W2002171029 hasRelatedWork W175663584 @default.