Matches in SemOpenAlex for { <https://semopenalex.org/work/W2799015892> ?p ?o ?g. }
- W2799015892 abstract "The first step towards an autonomous database management system (DBMS) is the ability to model the target application's workload. This is necessary to allow the system to anticipate future workload needs and select the proper optimizations in a timely manner. Previous forecasting techniques model the resource utilization of the queries. Such metrics, however, change whenever the physical design of the database and the hardware resources change, thereby rendering previous forecasting models useless. We present a robust forecasting framework called QueryBot 5000 that allows a DBMS to predict the expected arrival rate of queries in the future based on historical data. To better support highly dynamic environments, our approach uses the logical composition of queries in the workload rather than the amount of physical resources used for query execution. It provides multiple horizons (short- vs. long-term) with different aggregation intervals. We also present a clustering-based technique for reducing the total number of forecasting models to maintain. To evaluate our approach, we compare our forecasting models against other state-of-the-art models on three real-world database traces. We implemented our models in an external controller for PostgreSQL and MySQL and demonstrate their effectiveness in selecting indexes." @default.
- W2799015892 created "2018-05-07" @default.
- W2799015892 creator A5003652981 @default.
- W2799015892 creator A5009502206 @default.
- W2799015892 creator A5012830032 @default.
- W2799015892 creator A5021303191 @default.
- W2799015892 creator A5049165312 @default.
- W2799015892 creator A5072023220 @default.
- W2799015892 date "2018-05-27" @default.
- W2799015892 modified "2023-09-28" @default.
- W2799015892 title "Query-based Workload Forecasting for Self-Driving Database Management Systems" @default.
- W2799015892 cites W108313336 @default.
- W2799015892 cites W1505991794 @default.
- W2799015892 cites W2016589492 @default.
- W2799015892 cites W2056660085 @default.
- W2799015892 cites W2060818668 @default.
- W2799015892 cites W2064675550 @default.
- W2799015892 cites W2070317073 @default.
- W2799015892 cites W2080909732 @default.
- W2799015892 cites W2081728040 @default.
- W2799015892 cites W2083658889 @default.
- W2799015892 cites W2093735480 @default.
- W2799015892 cites W2095458406 @default.
- W2799015892 cites W2100773341 @default.
- W2799015892 cites W2102303750 @default.
- W2799015892 cites W2115258141 @default.
- W2799015892 cites W2115629999 @default.
- W2799015892 cites W2115743854 @default.
- W2799015892 cites W2119438912 @default.
- W2799015892 cites W2119885577 @default.
- W2799015892 cites W2122792880 @default.
- W2799015892 cites W2130214028 @default.
- W2799015892 cites W2150190118 @default.
- W2799015892 cites W2150304332 @default.
- W2799015892 cites W2152922098 @default.
- W2799015892 cites W2156717879 @default.
- W2799015892 cites W2165558283 @default.
- W2799015892 cites W2240667924 @default.
- W2799015892 cites W2294798173 @default.
- W2799015892 cites W2331465412 @default.
- W2799015892 cites W2429298957 @default.
- W2799015892 cites W2439673131 @default.
- W2799015892 cites W2613232875 @default.
- W2799015892 doi "https://doi.org/10.1145/3183713.3196908" @default.
- W2799015892 hasPublicationYear "2018" @default.
- W2799015892 type Work @default.
- W2799015892 sameAs 2799015892 @default.
- W2799015892 citedByCount "101" @default.
- W2799015892 countsByYear W27990158922018 @default.
- W2799015892 countsByYear W27990158922019 @default.
- W2799015892 countsByYear W27990158922020 @default.
- W2799015892 countsByYear W27990158922021 @default.
- W2799015892 countsByYear W27990158922022 @default.
- W2799015892 countsByYear W27990158922023 @default.
- W2799015892 crossrefType "proceedings-article" @default.
- W2799015892 hasAuthorship W2799015892A5003652981 @default.
- W2799015892 hasAuthorship W2799015892A5009502206 @default.
- W2799015892 hasAuthorship W2799015892A5012830032 @default.
- W2799015892 hasAuthorship W2799015892A5021303191 @default.
- W2799015892 hasAuthorship W2799015892A5049165312 @default.
- W2799015892 hasAuthorship W2799015892A5072023220 @default.
- W2799015892 hasConcept C107535962 @default.
- W2799015892 hasConcept C111919701 @default.
- W2799015892 hasConcept C119857082 @default.
- W2799015892 hasConcept C124101348 @default.
- W2799015892 hasConcept C148840519 @default.
- W2799015892 hasConcept C154945302 @default.
- W2799015892 hasConcept C164120249 @default.
- W2799015892 hasConcept C194222762 @default.
- W2799015892 hasConcept C205711294 @default.
- W2799015892 hasConcept C23123220 @default.
- W2799015892 hasConcept C24028149 @default.
- W2799015892 hasConcept C2778476105 @default.
- W2799015892 hasConcept C41008148 @default.
- W2799015892 hasConcept C54239708 @default.
- W2799015892 hasConcept C70236469 @default.
- W2799015892 hasConcept C73555534 @default.
- W2799015892 hasConcept C77088390 @default.
- W2799015892 hasConcept C97854310 @default.
- W2799015892 hasConceptScore W2799015892C107535962 @default.
- W2799015892 hasConceptScore W2799015892C111919701 @default.
- W2799015892 hasConceptScore W2799015892C119857082 @default.
- W2799015892 hasConceptScore W2799015892C124101348 @default.
- W2799015892 hasConceptScore W2799015892C148840519 @default.
- W2799015892 hasConceptScore W2799015892C154945302 @default.
- W2799015892 hasConceptScore W2799015892C164120249 @default.
- W2799015892 hasConceptScore W2799015892C194222762 @default.
- W2799015892 hasConceptScore W2799015892C205711294 @default.
- W2799015892 hasConceptScore W2799015892C23123220 @default.
- W2799015892 hasConceptScore W2799015892C24028149 @default.
- W2799015892 hasConceptScore W2799015892C2778476105 @default.
- W2799015892 hasConceptScore W2799015892C41008148 @default.
- W2799015892 hasConceptScore W2799015892C54239708 @default.
- W2799015892 hasConceptScore W2799015892C70236469 @default.
- W2799015892 hasConceptScore W2799015892C73555534 @default.
- W2799015892 hasConceptScore W2799015892C77088390 @default.
- W2799015892 hasConceptScore W2799015892C97854310 @default.
- W2799015892 hasLocation W27990158921 @default.
- W2799015892 hasOpenAccess W2799015892 @default.
- W2799015892 hasPrimaryLocation W27990158921 @default.