×

Dynamic query optimization

  • US 8,122,010 B2
  • Filed: 10/31/2007
  • Issued: 02/21/2012
  • Est. Priority Date: 02/26/2004
  • Status: Expired due to Fees
First Claim
Patent Images

1. A system comprising:

  • one or more processors;

    a memory coupled to at least the one processor; and

    ,a manager residing in the memory and executable by the at least one processor, wherein said manager;

    (a) evaluates a runtime instance of a query during execution of said runtime instance for data relative to performance of said runtime instance with respect to a predefined query time boundary, said data relative to performance of said runtime instance with respect to a predefined query time boundary being derived from execution of said runtime instance, said predefined query time boundary limiting a length of time in which said runtime instance of said query is allowed to complete runtime execution;

    (b) dynamically predicts, during execution of said runtime instance and using said data relative to performance of said runtime instance, a projected amount of computer resources required to complete execution of said runtime instance of said query within said predefined query time boundary; and

    (c) uses the results of said dynamically predicting step to dynamically allocate an amount of computer resources to complete execution of said runtime instance of said query, said amount being an amount required to make the total amount of said computer resources allocated to complete execution of said runtime instance of said query equal to said projected amount of computer resources required to complete execution of said runtime instance of said query within said predefined query time boundary dynamically predicted by said dynamically predicting step.

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