Matches in SemOpenAlex for { <https://semopenalex.org/work/W2520985585> ?p ?o ?g. }
Showing items 1 to 82 of
82
with 100 items per page.
- W2520985585 abstract "In a production system, increase in data size will increase the execution time of the application's SQL queries and degrade its performance. Tuning SQL queries in production requires additional efforts and cost. Time constraints during application development do not permit testing SQL queries with high data volumes. Having the capability to predict SQL query execution time for large data volumes can alert the developers to tune queries or database design upfront, in such scenarios. Application developers may use 'cost' of SQL query as given by optimizer based relational databases to estimate the SQL query execution time for large data sizes. However, the 'cost' based models may lead to large estimation errors as discussed in this paper. We have presented a modular approach of estimating SQL query execution time for high data volumes using measurements at low data volume. A compound SQL query execution plan is mapped to a sequential execution of a set of elementary steps. The execution time of a SQL query in isolation is predicted as summation of estimated execution time of all its elementary steps. We have built analytical models for estimating execution time of different IO access, DB cache access and SQL operators as function of data size for each such step. The proposed model dynamically adapts itself to the structure of the query execution plans and characteristics of the underlying hardware. We have evaluated the model by generating synthetic queries for all combinations of elementary steps for a range of data sizes. The model has also been validated with TPC-H benchmarks and three real life applications. The proposed model shows an average prediction error to be within 10%." @default.
- W2520985585 created "2016-09-23" @default.
- W2520985585 creator A5040769022 @default.
- W2520985585 creator A5086400313 @default.
- W2520985585 date "2016-01-01" @default.
- W2520985585 modified "2023-09-25" @default.
- W2520985585 title "Predicting SQL Query Execution Time for Large Data Volume" @default.
- W2520985585 cites W1987461110 @default.
- W2520985585 cites W2010149990 @default.
- W2520985585 cites W2061133801 @default.
- W2520985585 cites W2066262685 @default.
- W2520985585 cites W2096883892 @default.
- W2520985585 cites W2100773341 @default.
- W2520985585 cites W2103702871 @default.
- W2520985585 cites W2109907545 @default.
- W2520985585 cites W2167978511 @default.
- W2520985585 cites W2514077104 @default.
- W2520985585 cites W2546586934 @default.
- W2520985585 doi "https://doi.org/10.1145/2938503.2938552" @default.
- W2520985585 hasPublicationYear "2016" @default.
- W2520985585 type Work @default.
- W2520985585 sameAs 2520985585 @default.
- W2520985585 citedByCount "10" @default.
- W2520985585 countsByYear W25209855852017 @default.
- W2520985585 countsByYear W25209855852018 @default.
- W2520985585 countsByYear W25209855852019 @default.
- W2520985585 countsByYear W25209855852021 @default.
- W2520985585 countsByYear W25209855852023 @default.
- W2520985585 crossrefType "proceedings-article" @default.
- W2520985585 hasAuthorship W2520985585A5040769022 @default.
- W2520985585 hasAuthorship W2520985585A5086400313 @default.
- W2520985585 hasConcept C141589383 @default.
- W2520985585 hasConcept C154420247 @default.
- W2520985585 hasConcept C157692150 @default.
- W2520985585 hasConcept C164120249 @default.
- W2520985585 hasConcept C167544706 @default.
- W2520985585 hasConcept C172722865 @default.
- W2520985585 hasConcept C179531526 @default.
- W2520985585 hasConcept C192939062 @default.
- W2520985585 hasConcept C194222762 @default.
- W2520985585 hasConcept C206384180 @default.
- W2520985585 hasConcept C23123220 @default.
- W2520985585 hasConcept C2779729312 @default.
- W2520985585 hasConcept C41008148 @default.
- W2520985585 hasConcept C510870499 @default.
- W2520985585 hasConcept C55596503 @default.
- W2520985585 hasConcept C77088390 @default.
- W2520985585 hasConcept C97854310 @default.
- W2520985585 hasConceptScore W2520985585C141589383 @default.
- W2520985585 hasConceptScore W2520985585C154420247 @default.
- W2520985585 hasConceptScore W2520985585C157692150 @default.
- W2520985585 hasConceptScore W2520985585C164120249 @default.
- W2520985585 hasConceptScore W2520985585C167544706 @default.
- W2520985585 hasConceptScore W2520985585C172722865 @default.
- W2520985585 hasConceptScore W2520985585C179531526 @default.
- W2520985585 hasConceptScore W2520985585C192939062 @default.
- W2520985585 hasConceptScore W2520985585C194222762 @default.
- W2520985585 hasConceptScore W2520985585C206384180 @default.
- W2520985585 hasConceptScore W2520985585C23123220 @default.
- W2520985585 hasConceptScore W2520985585C2779729312 @default.
- W2520985585 hasConceptScore W2520985585C41008148 @default.
- W2520985585 hasConceptScore W2520985585C510870499 @default.
- W2520985585 hasConceptScore W2520985585C55596503 @default.
- W2520985585 hasConceptScore W2520985585C77088390 @default.
- W2520985585 hasConceptScore W2520985585C97854310 @default.
- W2520985585 hasLocation W25209855851 @default.
- W2520985585 hasOpenAccess W2520985585 @default.
- W2520985585 hasPrimaryLocation W25209855851 @default.
- W2520985585 hasRelatedWork W1995354730 @default.
- W2520985585 hasRelatedWork W2023980474 @default.
- W2520985585 hasRelatedWork W2107977219 @default.
- W2520985585 hasRelatedWork W2240099544 @default.
- W2520985585 hasRelatedWork W2750425440 @default.
- W2520985585 hasRelatedWork W3005816504 @default.
- W2520985585 hasRelatedWork W3108275191 @default.
- W2520985585 hasRelatedWork W3199663509 @default.
- W2520985585 hasRelatedWork W638381921 @default.
- W2520985585 hasRelatedWork W66203700 @default.
- W2520985585 isParatext "false" @default.
- W2520985585 isRetracted "false" @default.
- W2520985585 magId "2520985585" @default.
- W2520985585 workType "article" @default.