首页>
外国专利>
PREDICTING EXECUTION TIMES OF CONCURRENT QUERIES
PREDICTING EXECUTION TIMES OF CONCURRENT QUERIES
展开▼
机译:预测并发查询的执行时间
展开▼
页面导航
摘要
著录项
相似文献
摘要
Example embodiments relate to predicting execution times of concurrent queries. In example embodiments, historical data is iteratively generated for a machine learning model by varying a concurrency level of query executions in a database, determining a query execution plan for a pending concurrent query, extracting query features from the query execution plan, and executing the pending concurrent query to determine a query execution time. The machine learning model may then be created based on the query features, variation in the concurrency level, and the query execution time. The machine learning model is used to generate an execution schedule for production queries, where the execution schedule satisfies service level agreements of the production queries.
展开▼