Matches in SemOpenAlex for { <https://semopenalex.org/work/W2110076987> ?p ?o ?g. }
Showing items 1 to 96 of
96
with 100 items per page.
- W2110076987 abstract "Repetitive queries refer to those queries that are likely to be executed repeatedly in the future. Examples of repetitive queries include those that are used to generate periodic reports, perform routine maintenance, summarize data for analysis, etc. They can constitute a large part of daily activities of the database system and deserve more optimization efforts. In this paper, we propose to collect information about joins of a repetitive query, called the trace, during execution. We intend to use this information to re-estimate selectivities of joins in all possible execution orders. We discuss the information needed to be kept for the joins and design an operator, called the extended full outer join, to gather such information. We show the sufficiency of the traces in computing the exact selectivities of joins in all plans of the query. With the exact selectivities of joins available, the query optimizer can utilize them to find truly the best join order for the query in its search space, guaranteeing optimal execution of the query in the future." @default.
- W2110076987 created "2016-06-24" @default.
- W2110076987 creator A5020897634 @default.
- W2110076987 creator A5029619179 @default.
- W2110076987 creator A5064061862 @default.
- W2110076987 creator A5068382010 @default.
- W2110076987 creator A5072935024 @default.
- W2110076987 date "2011-01-01" @default.
- W2110076987 modified "2023-09-26" @default.
- W2110076987 title "Join Selectivity Re-estimation for Repetitive Queries in Databases" @default.
- W2110076987 cites W1977570286 @default.
- W2110076987 cites W2026896584 @default.
- W2110076987 cites W2041563709 @default.
- W2110076987 cites W2046437776 @default.
- W2110076987 cites W2153329411 @default.
- W2110076987 doi "https://doi.org/10.1007/978-3-642-23091-2_35" @default.
- W2110076987 hasPublicationYear "2011" @default.
- W2110076987 type Work @default.
- W2110076987 sameAs 2110076987 @default.
- W2110076987 citedByCount "1" @default.
- W2110076987 countsByYear W21100769872019 @default.
- W2110076987 crossrefType "book-chapter" @default.
- W2110076987 hasAuthorship W2110076987A5020897634 @default.
- W2110076987 hasAuthorship W2110076987A5029619179 @default.
- W2110076987 hasAuthorship W2110076987A5064061862 @default.
- W2110076987 hasAuthorship W2110076987A5068382010 @default.
- W2110076987 hasAuthorship W2110076987A5072935024 @default.
- W2110076987 hasConcept C114614502 @default.
- W2110076987 hasConcept C124101348 @default.
- W2110076987 hasConcept C138885662 @default.
- W2110076987 hasConcept C157692150 @default.
- W2110076987 hasConcept C164120249 @default.
- W2110076987 hasConcept C172722865 @default.
- W2110076987 hasConcept C192028432 @default.
- W2110076987 hasConcept C192939062 @default.
- W2110076987 hasConcept C199360897 @default.
- W2110076987 hasConcept C23123220 @default.
- W2110076987 hasConcept C2776124973 @default.
- W2110076987 hasConcept C2778692605 @default.
- W2110076987 hasConcept C2989070954 @default.
- W2110076987 hasConcept C33923547 @default.
- W2110076987 hasConcept C41008148 @default.
- W2110076987 hasConcept C41895202 @default.
- W2110076987 hasConcept C75291252 @default.
- W2110076987 hasConcept C77088390 @default.
- W2110076987 hasConcept C80444323 @default.
- W2110076987 hasConcept C97854310 @default.
- W2110076987 hasConcept C99016210 @default.
- W2110076987 hasConceptScore W2110076987C114614502 @default.
- W2110076987 hasConceptScore W2110076987C124101348 @default.
- W2110076987 hasConceptScore W2110076987C138885662 @default.
- W2110076987 hasConceptScore W2110076987C157692150 @default.
- W2110076987 hasConceptScore W2110076987C164120249 @default.
- W2110076987 hasConceptScore W2110076987C172722865 @default.
- W2110076987 hasConceptScore W2110076987C192028432 @default.
- W2110076987 hasConceptScore W2110076987C192939062 @default.
- W2110076987 hasConceptScore W2110076987C199360897 @default.
- W2110076987 hasConceptScore W2110076987C23123220 @default.
- W2110076987 hasConceptScore W2110076987C2776124973 @default.
- W2110076987 hasConceptScore W2110076987C2778692605 @default.
- W2110076987 hasConceptScore W2110076987C2989070954 @default.
- W2110076987 hasConceptScore W2110076987C33923547 @default.
- W2110076987 hasConceptScore W2110076987C41008148 @default.
- W2110076987 hasConceptScore W2110076987C41895202 @default.
- W2110076987 hasConceptScore W2110076987C75291252 @default.
- W2110076987 hasConceptScore W2110076987C77088390 @default.
- W2110076987 hasConceptScore W2110076987C80444323 @default.
- W2110076987 hasConceptScore W2110076987C97854310 @default.
- W2110076987 hasConceptScore W2110076987C99016210 @default.
- W2110076987 hasLocation W21100769871 @default.
- W2110076987 hasOpenAccess W2110076987 @default.
- W2110076987 hasPrimaryLocation W21100769871 @default.
- W2110076987 hasRelatedWork W154216164 @default.
- W2110076987 hasRelatedWork W191169708 @default.
- W2110076987 hasRelatedWork W2006322307 @default.
- W2110076987 hasRelatedWork W2020584928 @default.
- W2110076987 hasRelatedWork W205518177 @default.
- W2110076987 hasRelatedWork W2160967997 @default.
- W2110076987 hasRelatedWork W2259181357 @default.
- W2110076987 hasRelatedWork W2276853748 @default.
- W2110076987 hasRelatedWork W2407804183 @default.
- W2110076987 hasRelatedWork W2460398959 @default.
- W2110076987 hasRelatedWork W2477134663 @default.
- W2110076987 hasRelatedWork W2522191305 @default.
- W2110076987 hasRelatedWork W2562053008 @default.
- W2110076987 hasRelatedWork W2788972412 @default.
- W2110076987 hasRelatedWork W2900791740 @default.
- W2110076987 hasRelatedWork W3030487757 @default.
- W2110076987 hasRelatedWork W3043679426 @default.
- W2110076987 hasRelatedWork W3201461576 @default.
- W2110076987 hasRelatedWork W95813568 @default.
- W2110076987 hasRelatedWork W2199242940 @default.
- W2110076987 isParatext "false" @default.
- W2110076987 isRetracted "false" @default.
- W2110076987 magId "2110076987" @default.
- W2110076987 workType "book-chapter" @default.