Matches in SemOpenAlex for { <https://semopenalex.org/work/W2913131854> ?p ?o ?g. }
- W2913131854 abstract "There has been considerable research on automated index tuning in database management systems (DBMSs). But the majority of these solutions tune the index configuration by retrospectively making computationally expensive physical design changes all at once. Such changes degrade the DBMS's performance during the process, and have reduced utility during subsequent query processing due to the delay between a workload shift and the associated change. A better approach is to generate small changes that tune the physical design over time, forecast the utility of these changes, and apply them ahead of time to maximize their impact. This paper presents predictive indexing that continuously improves a database's physical design using lightweight physical design changes. It uses a machine learning model to forecast the utility of these changes, and continuously refines the index configuration of the database to handle evolving workloads. We introduce a lightweight hybrid scan operator with which a DBMS can make use of partially-built indexes for query processing. Our evaluation shows that predictive indexing improves the throughput of a DBMS by 3.5--5.2x compared to other state-of-the-art indexing approaches. We demonstrate that predictive indexing works seamlessly with other lightweight automated physical design tuning methods." @default.
- W2913131854 created "2019-02-21" @default.
- W2913131854 creator A5049165312 @default.
- W2913131854 creator A5060680349 @default.
- W2913131854 creator A5072023220 @default.
- W2913131854 creator A5080130262 @default.
- W2913131854 date "2019-01-21" @default.
- W2913131854 modified "2023-09-28" @default.
- W2913131854 title "Predictive Indexing" @default.
- W2913131854 cites W1553825122 @default.
- W2913131854 cites W1594031697 @default.
- W2913131854 cites W1851390469 @default.
- W2913131854 cites W1972072126 @default.
- W2913131854 cites W2002131042 @default.
- W2913131854 cites W2005734204 @default.
- W2913131854 cites W2017992824 @default.
- W2913131854 cites W2026024369 @default.
- W2913131854 cites W2033283439 @default.
- W2913131854 cites W2047085757 @default.
- W2913131854 cites W2051756193 @default.
- W2913131854 cites W2057476334 @default.
- W2913131854 cites W2066671865 @default.
- W2913131854 cites W2085866051 @default.
- W2913131854 cites W2099918651 @default.
- W2913131854 cites W2107726111 @default.
- W2913131854 cites W2108490710 @default.
- W2913131854 cites W2118226259 @default.
- W2913131854 cites W2125198999 @default.
- W2913131854 cites W2148291485 @default.
- W2913131854 cites W2153329411 @default.
- W2913131854 cites W2167036165 @default.
- W2913131854 cites W2168503413 @default.
- W2913131854 cites W2170853664 @default.
- W2913131854 cites W2170942635 @default.
- W2913131854 cites W2240667924 @default.
- W2913131854 cites W2259014610 @default.
- W2913131854 cites W2426624872 @default.
- W2913131854 cites W2429298957 @default.
- W2913131854 cites W2429518132 @default.
- W2913131854 cites W2728889630 @default.
- W2913131854 hasPublicationYear "2019" @default.
- W2913131854 type Work @default.
- W2913131854 sameAs 2913131854 @default.
- W2913131854 citedByCount "1" @default.
- W2913131854 countsByYear W29131318542020 @default.
- W2913131854 crossrefType "posted-content" @default.
- W2913131854 hasAuthorship W2913131854A5049165312 @default.
- W2913131854 hasAuthorship W2913131854A5060680349 @default.
- W2913131854 hasAuthorship W2913131854A5072023220 @default.
- W2913131854 hasAuthorship W2913131854A5080130262 @default.
- W2913131854 hasConcept C104317684 @default.
- W2913131854 hasConcept C111919701 @default.
- W2913131854 hasConcept C124101348 @default.
- W2913131854 hasConcept C154945302 @default.
- W2913131854 hasConcept C158448853 @default.
- W2913131854 hasConcept C17020691 @default.
- W2913131854 hasConcept C185592680 @default.
- W2913131854 hasConcept C199360897 @default.
- W2913131854 hasConcept C2777382242 @default.
- W2913131854 hasConcept C2778476105 @default.
- W2913131854 hasConcept C41008148 @default.
- W2913131854 hasConcept C55493867 @default.
- W2913131854 hasConcept C59276292 @default.
- W2913131854 hasConcept C75165309 @default.
- W2913131854 hasConcept C77088390 @default.
- W2913131854 hasConcept C86339819 @default.
- W2913131854 hasConcept C98045186 @default.
- W2913131854 hasConceptScore W2913131854C104317684 @default.
- W2913131854 hasConceptScore W2913131854C111919701 @default.
- W2913131854 hasConceptScore W2913131854C124101348 @default.
- W2913131854 hasConceptScore W2913131854C154945302 @default.
- W2913131854 hasConceptScore W2913131854C158448853 @default.
- W2913131854 hasConceptScore W2913131854C17020691 @default.
- W2913131854 hasConceptScore W2913131854C185592680 @default.
- W2913131854 hasConceptScore W2913131854C199360897 @default.
- W2913131854 hasConceptScore W2913131854C2777382242 @default.
- W2913131854 hasConceptScore W2913131854C2778476105 @default.
- W2913131854 hasConceptScore W2913131854C41008148 @default.
- W2913131854 hasConceptScore W2913131854C55493867 @default.
- W2913131854 hasConceptScore W2913131854C59276292 @default.
- W2913131854 hasConceptScore W2913131854C75165309 @default.
- W2913131854 hasConceptScore W2913131854C77088390 @default.
- W2913131854 hasConceptScore W2913131854C86339819 @default.
- W2913131854 hasConceptScore W2913131854C98045186 @default.
- W2913131854 hasLocation W29131318541 @default.
- W2913131854 hasOpenAccess W2913131854 @default.
- W2913131854 hasPrimaryLocation W29131318541 @default.
- W2913131854 hasRelatedWork W1541944350 @default.
- W2913131854 hasRelatedWork W1678009800 @default.
- W2913131854 hasRelatedWork W1936410615 @default.
- W2913131854 hasRelatedWork W1964525561 @default.
- W2913131854 hasRelatedWork W2017992824 @default.
- W2913131854 hasRelatedWork W2081728040 @default.
- W2913131854 hasRelatedWork W2086529872 @default.
- W2913131854 hasRelatedWork W2098443134 @default.
- W2913131854 hasRelatedWork W2099280312 @default.
- W2913131854 hasRelatedWork W2159154943 @default.
- W2913131854 hasRelatedWork W2163864652 @default.
- W2913131854 hasRelatedWork W2379226663 @default.
- W2913131854 hasRelatedWork W2799015892 @default.