×

PREDICTING EXECUTION TIMES OF CONCURRENT QUERIES

  • US 20160203404A1
  • Filed: 09/14/2013
  • Published: 07/14/2016
  • Est. Priority Date: 09/14/2013
  • Status: Abandoned Application
First Claim
Patent Images

1. A system for predicting execution times of concurrent queries, the system comprising of:

  • a processor to;

    iteratively generate historic data for creating 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 a plurality of query features from the query execution plan; and

    executing the pending concurrent query to determine a query execution time;

    create the machine learning model based on the plurality of query features, variation in the concurrency level, and the query execution time; and

    use the machine learning model to generate an execution schedule for a plurality of production queries, wherein the execution schedule satisfies service level agreements of the plurality of production queries.

View all claims
  • 8 Assignments
Timeline View
Assignment View
    ×
    ×