×

Dynamically associating different query execution strategies with selective portions of a database table

  • US 9,063,982 B2
  • Filed: 01/24/2013
  • Issued: 06/23/2015
  • Est. Priority Date: 07/14/2005
  • Status: Active Grant
First Claim
Patent Images

1. A method for executing a database query in a computer system, comprising the computer-executed steps of:

  • automatically selecting one or more candidate partitions of a partitioned database table for determining separate query execution strategies to be used for evaluating said database query, said partitioned database table having multiple previously defined partitions, each partition having a common definitional structure and comprising a respective disjoint subset of records of said partitioned database table, said candidate partitions comprising at least one and fewer than all previously defined partitions of said partitioned database table, said one or more candidate partitions being automatically selected without determining whether execution of said database query can benefit from using a separate query execution strategy for evaluating said database query against any said previously defined partition by using at least one criterion from the set of criteria consisting of;

    (a) at least one parameter indicating the existence of at least one local index for a partition of said partitioned database table;

    (b) at least one parameter indicating volatility of a partition of said partitioned database table; and

    (c) at least one parameter indicated a relative size of a partition of said partitioned database table; and

    responsive to automatically selecting one or more candidate partitions of a partitioned database table, automatically generating multiple separate query execution strategies for evaluating said database query, each of said multiple separate query execution strategies being used for evaluating said database query against a different respective disjoint non-empty set of partitions of said partitioned database table, and automatically generating a union of a respective results set of each said separate query execution strategy.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×