Matches in SemOpenAlex for { <https://semopenalex.org/work/W2000206139> ?p ?o ?g. }
- W2000206139 abstract "language access data from databases. With exponential growth of data, optimization techniques need to be adopt for better results. Query performance tuning and optimization can be achieved by query reformation and index selection. Searching tuples from millions of results is overhead and it degrades overall system performance. To reduce searching time is goal of index recommendation. Index Selection Problem (ISP) is optimization problem. This is NPH problem and it can be solve by different approaches like greedy approach, dynamic programming, linear programming, branch and bound, genetic algorithm, etc. In general, indexing is done on candidate keys but it will not give assurance of optimal solution. Researchers tried to resemble ISP with knapsack problem and variation of it. Different data structure are used for indexing like tree, hash, bitmap, etc. In composite column indexes, order of columns affects overall performance In- memory databases are fast databases and new data structures to be suggest for indexing. Usually indexing is done on only columns which will yield profit in query execution. Join operations executions are discussed briefly." @default.
- W2000206139 created "2016-06-24" @default.
- W2000206139 creator A5054252498 @default.
- W2000206139 date "2015-03-18" @default.
- W2000206139 modified "2023-09-24" @default.
- W2000206139 title "A Survey on Query Performance Optimization by Index Recommendation" @default.
- W2000206139 cites W1556530724 @default.
- W2000206139 cites W1566300341 @default.
- W2000206139 cites W1765311349 @default.
- W2000206139 cites W1851390469 @default.
- W2000206139 cites W1978220611 @default.
- W2000206139 cites W1991271936 @default.
- W2000206139 cites W1999524281 @default.
- W2000206139 cites W2113888164 @default.
- W2000206139 cites W2125605956 @default.
- W2000206139 cites W2136390693 @default.
- W2000206139 cites W2165481122 @default.
- W2000206139 cites W2168503413 @default.
- W2000206139 doi "https://doi.org/10.5120/19937-2091" @default.
- W2000206139 hasPublicationYear "2015" @default.
- W2000206139 type Work @default.
- W2000206139 sameAs 2000206139 @default.
- W2000206139 citedByCount "3" @default.
- W2000206139 countsByYear W20002061392015 @default.
- W2000206139 countsByYear W20002061392018 @default.
- W2000206139 countsByYear W20002061392019 @default.
- W2000206139 crossrefType "journal-article" @default.
- W2000206139 hasAuthorship W2000206139A5054252498 @default.
- W2000206139 hasBestOaLocation W20002061392 @default.
- W2000206139 hasConcept C111919701 @default.
- W2000206139 hasConcept C113138325 @default.
- W2000206139 hasConcept C11413529 @default.
- W2000206139 hasConcept C118615104 @default.
- W2000206139 hasConcept C118930307 @default.
- W2000206139 hasConcept C124101348 @default.
- W2000206139 hasConcept C136764020 @default.
- W2000206139 hasConcept C154945302 @default.
- W2000206139 hasConcept C157692150 @default.
- W2000206139 hasConcept C164120249 @default.
- W2000206139 hasConcept C192939062 @default.
- W2000206139 hasConcept C23123220 @default.
- W2000206139 hasConcept C2777382242 @default.
- W2000206139 hasConcept C2779960059 @default.
- W2000206139 hasConcept C3115412 @default.
- W2000206139 hasConcept C33923547 @default.
- W2000206139 hasConcept C38652104 @default.
- W2000206139 hasConcept C41008148 @default.
- W2000206139 hasConcept C51823790 @default.
- W2000206139 hasConcept C75165309 @default.
- W2000206139 hasConcept C97854310 @default.
- W2000206139 hasConcept C99138194 @default.
- W2000206139 hasConceptScore W2000206139C111919701 @default.
- W2000206139 hasConceptScore W2000206139C113138325 @default.
- W2000206139 hasConceptScore W2000206139C11413529 @default.
- W2000206139 hasConceptScore W2000206139C118615104 @default.
- W2000206139 hasConceptScore W2000206139C118930307 @default.
- W2000206139 hasConceptScore W2000206139C124101348 @default.
- W2000206139 hasConceptScore W2000206139C136764020 @default.
- W2000206139 hasConceptScore W2000206139C154945302 @default.
- W2000206139 hasConceptScore W2000206139C157692150 @default.
- W2000206139 hasConceptScore W2000206139C164120249 @default.
- W2000206139 hasConceptScore W2000206139C192939062 @default.
- W2000206139 hasConceptScore W2000206139C23123220 @default.
- W2000206139 hasConceptScore W2000206139C2777382242 @default.
- W2000206139 hasConceptScore W2000206139C2779960059 @default.
- W2000206139 hasConceptScore W2000206139C3115412 @default.
- W2000206139 hasConceptScore W2000206139C33923547 @default.
- W2000206139 hasConceptScore W2000206139C38652104 @default.
- W2000206139 hasConceptScore W2000206139C41008148 @default.
- W2000206139 hasConceptScore W2000206139C51823790 @default.
- W2000206139 hasConceptScore W2000206139C75165309 @default.
- W2000206139 hasConceptScore W2000206139C97854310 @default.
- W2000206139 hasConceptScore W2000206139C99138194 @default.
- W2000206139 hasLocation W20002061391 @default.
- W2000206139 hasLocation W20002061392 @default.
- W2000206139 hasOpenAccess W2000206139 @default.
- W2000206139 hasPrimaryLocation W20002061391 @default.
- W2000206139 hasRelatedWork W1566300341 @default.
- W2000206139 hasRelatedWork W2000531802 @default.
- W2000206139 hasRelatedWork W2019270771 @default.
- W2000206139 hasRelatedWork W2067762222 @default.
- W2000206139 hasRelatedWork W2114231102 @default.
- W2000206139 hasRelatedWork W2122315596 @default.
- W2000206139 hasRelatedWork W2163453947 @default.
- W2000206139 hasRelatedWork W2337762748 @default.
- W2000206139 hasRelatedWork W2362279969 @default.
- W2000206139 hasRelatedWork W2362665752 @default.
- W2000206139 hasRelatedWork W2384074687 @default.
- W2000206139 hasRelatedWork W2429183140 @default.
- W2000206139 hasRelatedWork W2547426886 @default.
- W2000206139 hasRelatedWork W2783792647 @default.
- W2000206139 hasRelatedWork W2786468357 @default.
- W2000206139 hasRelatedWork W2788508941 @default.
- W2000206139 hasRelatedWork W2804215376 @default.
- W2000206139 hasRelatedWork W3119612849 @default.
- W2000206139 hasRelatedWork W3190745665 @default.
- W2000206139 hasRelatedWork W2177176476 @default.
- W2000206139 isParatext "false" @default.
- W2000206139 isRetracted "false" @default.
- W2000206139 magId "2000206139" @default.