Matches in SemOpenAlex for { <https://semopenalex.org/work/W1566300341> ?p ?o ?g. }
Showing items 1 to 98 of
98
with 100 items per page.
- W1566300341 endingPage "24" @default.
- W1566300341 startingPage "3" @default.
- W1566300341 abstract "A novel approach to solving Index Selection Problem (ISP) is presented. In contrast to other known ISP approaches, our method searches the space of possible query execution plans, instead of searching the space of index configurations. An evolutionary algorithm is used for searching. The solution is obtained indirectly as the set of indexes used by the best query execution plans. The method has important features over other known algorithms: (1) it converges to the optimal solution, unlike greedy heuristics, which for performance reasons tend to reduce the space of candidate solutions, possibly discarding optimal solutions; (2) though the search space is huge and grows exponentially with the size of the input workload, searching the space of the query plans allows to direct more computational power to the most costly plans, thus yielding very fast convergence to “good enough” solutions; and (3) the costly reoptimization of the workload is not needed for calculating the objective function, so several thousands of candidates can be checked in a second. The algorithm was tested for large synthetic and real-world SQL workloads to evaluate the performace and scalability." @default.
- W1566300341 created "2016-06-24" @default.
- W1566300341 creator A5010257812 @default.
- W1566300341 creator A5027943585 @default.
- W1566300341 date "2009-01-01" @default.
- W1566300341 modified "2023-09-27" @default.
- W1566300341 title "Automatic Index Selection in RDBMS by Exploring Query Execution Plan Space" @default.
- W1566300341 cites W1590637314 @default.
- W1566300341 cites W1971944099 @default.
- W1566300341 cites W1985699615 @default.
- W1566300341 cites W1995713768 @default.
- W1566300341 cites W2002131042 @default.
- W1566300341 cites W2015880537 @default.
- W1566300341 cites W2024060531 @default.
- W1566300341 cites W2047085757 @default.
- W1566300341 cites W2071688066 @default.
- W1566300341 cites W2078524330 @default.
- W1566300341 cites W2108883953 @default.
- W1566300341 cites W2124511785 @default.
- W1566300341 cites W2125605956 @default.
- W1566300341 cites W2130742187 @default.
- W1566300341 cites W2150101660 @default.
- W1566300341 cites W2172370087 @default.
- W1566300341 cites W4246598646 @default.
- W1566300341 cites W4243315762 @default.
- W1566300341 doi "https://doi.org/10.1007/978-3-642-02190-9_1" @default.
- W1566300341 hasPublicationYear "2009" @default.
- W1566300341 type Work @default.
- W1566300341 sameAs 1566300341 @default.
- W1566300341 citedByCount "14" @default.
- W1566300341 countsByYear W15663003412012 @default.
- W1566300341 countsByYear W15663003412013 @default.
- W1566300341 countsByYear W15663003412014 @default.
- W1566300341 countsByYear W15663003412015 @default.
- W1566300341 countsByYear W15663003412018 @default.
- W1566300341 countsByYear W15663003412021 @default.
- W1566300341 crossrefType "book-chapter" @default.
- W1566300341 hasAuthorship W1566300341A5010257812 @default.
- W1566300341 hasAuthorship W1566300341A5027943585 @default.
- W1566300341 hasConcept C111919701 @default.
- W1566300341 hasConcept C124101348 @default.
- W1566300341 hasConcept C154945302 @default.
- W1566300341 hasConcept C157692150 @default.
- W1566300341 hasConcept C164120249 @default.
- W1566300341 hasConcept C166957645 @default.
- W1566300341 hasConcept C192939062 @default.
- W1566300341 hasConcept C199360897 @default.
- W1566300341 hasConcept C205649164 @default.
- W1566300341 hasConcept C23123220 @default.
- W1566300341 hasConcept C24394798 @default.
- W1566300341 hasConcept C2776505523 @default.
- W1566300341 hasConcept C2777382242 @default.
- W1566300341 hasConcept C2778572836 @default.
- W1566300341 hasConcept C2779729312 @default.
- W1566300341 hasConcept C41008148 @default.
- W1566300341 hasConcept C5655090 @default.
- W1566300341 hasConcept C77088390 @default.
- W1566300341 hasConcept C81917197 @default.
- W1566300341 hasConcept C97854310 @default.
- W1566300341 hasConceptScore W1566300341C111919701 @default.
- W1566300341 hasConceptScore W1566300341C124101348 @default.
- W1566300341 hasConceptScore W1566300341C154945302 @default.
- W1566300341 hasConceptScore W1566300341C157692150 @default.
- W1566300341 hasConceptScore W1566300341C164120249 @default.
- W1566300341 hasConceptScore W1566300341C166957645 @default.
- W1566300341 hasConceptScore W1566300341C192939062 @default.
- W1566300341 hasConceptScore W1566300341C199360897 @default.
- W1566300341 hasConceptScore W1566300341C205649164 @default.
- W1566300341 hasConceptScore W1566300341C23123220 @default.
- W1566300341 hasConceptScore W1566300341C24394798 @default.
- W1566300341 hasConceptScore W1566300341C2776505523 @default.
- W1566300341 hasConceptScore W1566300341C2777382242 @default.
- W1566300341 hasConceptScore W1566300341C2778572836 @default.
- W1566300341 hasConceptScore W1566300341C2779729312 @default.
- W1566300341 hasConceptScore W1566300341C41008148 @default.
- W1566300341 hasConceptScore W1566300341C5655090 @default.
- W1566300341 hasConceptScore W1566300341C77088390 @default.
- W1566300341 hasConceptScore W1566300341C81917197 @default.
- W1566300341 hasConceptScore W1566300341C97854310 @default.
- W1566300341 hasLocation W15663003411 @default.
- W1566300341 hasOpenAccess W1566300341 @default.
- W1566300341 hasPrimaryLocation W15663003411 @default.
- W1566300341 hasRelatedWork W2146477719 @default.
- W1566300341 hasRelatedWork W2350026801 @default.
- W1566300341 hasRelatedWork W2363027842 @default.
- W1566300341 hasRelatedWork W2368479705 @default.
- W1566300341 hasRelatedWork W29343545 @default.
- W1566300341 hasRelatedWork W2955368753 @default.
- W1566300341 hasRelatedWork W2981354846 @default.
- W1566300341 hasRelatedWork W2992414350 @default.
- W1566300341 hasRelatedWork W4283028514 @default.
- W1566300341 hasRelatedWork W4324061758 @default.
- W1566300341 isParatext "false" @default.
- W1566300341 isRetracted "false" @default.
- W1566300341 magId "1566300341" @default.
- W1566300341 workType "book-chapter" @default.