Matches in SemOpenAlex for { <https://semopenalex.org/work/W2068901259> ?p ?o ?g. }
- W2068901259 endingPage "116" @default.
- W2068901259 startingPage "105" @default.
- W2068901259 abstract "We investigate the problem of using materialized views to answer SQL queries. We focus on modern decision-support queries, which involve joins, arithmetic operations and other (possibly user-defined) functions, aggregation (often along multiple dimensions), and nested subqueries. Given the complexity of such queries, the vast amounts of data upon which they operate, and the requirement for interactive response times, the use of materialized views (MVs) of similar complexity is often mandatory for acceptable performance. We present a novel algorithm that is able to rewrite a user query so that it will access one or more of the available MVs instead of the base tables. The algorithm extends prior work by addressing the new sources of complexity mentioned above, that is, complex expressions, multidimensional aggregation, and nested subqueries. It does so by relying on a graphical representation of queries and a bottom-up, pair-wise matching of nodes from the query and MV graphs. This approach offers great modularity and extensibility, allowing for the rewriting of a large class of queries." @default.
- W2068901259 created "2016-06-24" @default.
- W2068901259 creator A5016523046 @default.
- W2068901259 creator A5019025752 @default.
- W2068901259 creator A5029649647 @default.
- W2068901259 creator A5063929530 @default.
- W2068901259 creator A5083725187 @default.
- W2068901259 date "2000-05-16" @default.
- W2068901259 modified "2023-09-27" @default.
- W2068901259 title "Answering complex SQL queries using automatic summary tables" @default.
- W2068901259 cites W1975733288 @default.
- W2068901259 cites W2004405116 @default.
- W2068901259 cites W2055586952 @default.
- W2068901259 cites W2079590017 @default.
- W2068901259 cites W2134791164 @default.
- W2068901259 cites W2143401113 @default.
- W2068901259 doi "https://doi.org/10.1145/335191.335390" @default.
- W2068901259 hasPublicationYear "2000" @default.
- W2068901259 type Work @default.
- W2068901259 sameAs 2068901259 @default.
- W2068901259 citedByCount "82" @default.
- W2068901259 countsByYear W20689012592012 @default.
- W2068901259 countsByYear W20689012592013 @default.
- W2068901259 countsByYear W20689012592014 @default.
- W2068901259 countsByYear W20689012592015 @default.
- W2068901259 countsByYear W20689012592016 @default.
- W2068901259 countsByYear W20689012592017 @default.
- W2068901259 countsByYear W20689012592018 @default.
- W2068901259 countsByYear W20689012592019 @default.
- W2068901259 countsByYear W20689012592021 @default.
- W2068901259 crossrefType "journal-article" @default.
- W2068901259 hasAuthorship W2068901259A5016523046 @default.
- W2068901259 hasAuthorship W2068901259A5019025752 @default.
- W2068901259 hasAuthorship W2068901259A5029649647 @default.
- W2068901259 hasAuthorship W2068901259A5063929530 @default.
- W2068901259 hasAuthorship W2068901259A5083725187 @default.
- W2068901259 hasConcept C148840519 @default.
- W2068901259 hasConcept C154690210 @default.
- W2068901259 hasConcept C154945302 @default.
- W2068901259 hasConcept C157692150 @default.
- W2068901259 hasConcept C164120249 @default.
- W2068901259 hasConcept C172722865 @default.
- W2068901259 hasConcept C192028432 @default.
- W2068901259 hasConcept C192939062 @default.
- W2068901259 hasConcept C194222762 @default.
- W2068901259 hasConcept C199360897 @default.
- W2068901259 hasConcept C23123220 @default.
- W2068901259 hasConcept C2777212361 @default.
- W2068901259 hasConcept C2778692605 @default.
- W2068901259 hasConcept C41008148 @default.
- W2068901259 hasConcept C510870499 @default.
- W2068901259 hasConcept C54239708 @default.
- W2068901259 hasConcept C5655090 @default.
- W2068901259 hasConcept C65647387 @default.
- W2068901259 hasConcept C77088390 @default.
- W2068901259 hasConcept C80444323 @default.
- W2068901259 hasConcept C97854310 @default.
- W2068901259 hasConcept C98199447 @default.
- W2068901259 hasConceptScore W2068901259C148840519 @default.
- W2068901259 hasConceptScore W2068901259C154690210 @default.
- W2068901259 hasConceptScore W2068901259C154945302 @default.
- W2068901259 hasConceptScore W2068901259C157692150 @default.
- W2068901259 hasConceptScore W2068901259C164120249 @default.
- W2068901259 hasConceptScore W2068901259C172722865 @default.
- W2068901259 hasConceptScore W2068901259C192028432 @default.
- W2068901259 hasConceptScore W2068901259C192939062 @default.
- W2068901259 hasConceptScore W2068901259C194222762 @default.
- W2068901259 hasConceptScore W2068901259C199360897 @default.
- W2068901259 hasConceptScore W2068901259C23123220 @default.
- W2068901259 hasConceptScore W2068901259C2777212361 @default.
- W2068901259 hasConceptScore W2068901259C2778692605 @default.
- W2068901259 hasConceptScore W2068901259C41008148 @default.
- W2068901259 hasConceptScore W2068901259C510870499 @default.
- W2068901259 hasConceptScore W2068901259C54239708 @default.
- W2068901259 hasConceptScore W2068901259C5655090 @default.
- W2068901259 hasConceptScore W2068901259C65647387 @default.
- W2068901259 hasConceptScore W2068901259C77088390 @default.
- W2068901259 hasConceptScore W2068901259C80444323 @default.
- W2068901259 hasConceptScore W2068901259C97854310 @default.
- W2068901259 hasConceptScore W2068901259C98199447 @default.
- W2068901259 hasIssue "2" @default.
- W2068901259 hasLocation W20689012591 @default.
- W2068901259 hasOpenAccess W2068901259 @default.
- W2068901259 hasPrimaryLocation W20689012591 @default.
- W2068901259 hasRelatedWork W1566772664 @default.
- W2068901259 hasRelatedWork W2028596183 @default.
- W2068901259 hasRelatedWork W2068901259 @default.
- W2068901259 hasRelatedWork W2900791740 @default.
- W2068901259 hasRelatedWork W2985730042 @default.
- W2068901259 hasRelatedWork W3003282352 @default.
- W2068901259 hasRelatedWork W3013849046 @default.
- W2068901259 hasRelatedWork W4244600136 @default.
- W2068901259 hasRelatedWork W4300528265 @default.
- W2068901259 hasRelatedWork W2584076594 @default.
- W2068901259 hasVolume "29" @default.
- W2068901259 isParatext "false" @default.
- W2068901259 isRetracted "false" @default.
- W2068901259 magId "2068901259" @default.