Addressing query scheduling and system resource requirements

• US 7,925,619 B2
• Filed: 08/07/2008
• Issued: 04/12/2011
• Est. Priority Date: 02/26/2004
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Kolz, Daniel P., Dettinger, Richard D., Wenzel, Shannon E.
• Primary Examiner(s): CHEN, TE Y
• Application Number:
  US12/187,945
• Publication Number:
  US 20080295029A1
• Time in Patent Office: 978 Days
• Field of Search: None
• US Class Current: 707/607
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

Method, system and article of manufacture for scheduling queries. In particular, the scheduling options made available to a user for a particular unit of work are determined dynamically at the time of scheduling. In this way, the execution cost, for example, of a particular unit of work can be taken into account when determining which scheduling options to make available. In addition, or alternatively, system availability and/or user parameters may be accounted for when determining which scheduling options to make available.

Claims

1. A non-transitory computer readable storage medium containing a program which, when executed, performs an operation for scheduling execution of units of work, the operation comprising:

determining a first cost to execute a first unit of work;

determining a first set of user-selectable scheduling options for future execution of the first unit of work based on the first cost, wherein the first set of user-selectable scheduling options is a subset of a larger set of scheduling options, and wherein the larger set of scheduling options are stored on a computer readable storage medium and include a plurality of user-selectable time criteria and frequency criteria, wherein the time criteria specifies when the execution of a given unit of work will begin and the frequency criteria specifies how frequently the given unit of work will be executed;

returning the first set of user-selectable scheduling options to a user interface for display, whereby the user interface presents;

time criteria selection elements from which a user specifies a time at which execution of the first unit of work will begin; and

frequency criteria selection elements from which the user specifies a frequency at which the first unit of work will be executed beginning at the specified time;

determining a second cost to execute a second unit of work;

determining a second set of user-selectable scheduling options for future execution of the second unit of work based on the second cost, wherein the second set of user-selectable scheduling options a subset of the larger set of scheduling options, and wherein the second set of user-selectable scheduling options is different than the first set of user-selectable scheduling options; and

returning the second set of user-selectable scheduling options to a user interface for display, whereby the user interface presents;

time criteria selection elements from which a user specifies a time at which execution of the second unit of work will begin; and

frequency criteria selection elements from which the user specifies a frequency at which the second unit of work will be executed beginning at the specified time.

2. The computer-readable storage medium of claim 1, wherein:

the first cost to execute the first unit of work is higher than the second cost to execute the second unit of work; and

the first set of user-selectable scheduling options is less than the second set of user-selectable scheduling options.

3. The computer readable storage medium of claim 1, wherein determining the first and second sets of user-selectable scheduling options comprises:

determining system availability to execute the respective unit of work; and

determining the respective set of user-selectable scheduling options for repetitive execution of the unit of work on the basis of the respective cost and the system availability.

4. The computer readable storage medium of claim 1, further comprising displaying the returned first and second sets of user-selectable scheduling options via a menu in the user interface.

5. The computer readable storage medium of claim 1, further comprising determining the first and second sets of user-selectable scheduling options for future execution of the respective unit of work on the basis of the respective cost and at least one other factor selected from a user status and other queries already scheduled for execution by the user.

6. The computer readable storage medium of claim 1, further comprising, for each of the first and second sets of user-selectable scheduling options:

receiving a user selection from the respective set of user-selectable scheduling options; and

storing a schedule for the respective unit of work on the basis of the user selection.

7. The computer readable storage medium of claim 1, further comprising, for each of the first and second sets of user-selectable scheduling options:

receiving a user selection from the respective sets of user selectable scheduling options;

storing a schedule for the respective unit of work on the basis of the user selection; and

repetitively executing the respective unit of work on the basis of the schedule.

8. The computer readable storage medium of claim 1, wherein determining the first and second costs to execute the respective unit of work comprises estimating a respective time required to execute the respective unit of work.

9. The computer readable storage medium of claim 1, wherein determining the first and second costs to execute the respective units of work is done on the basis of historical query execution times for previous executions of the respective unit of work.

10. A computer system, comprising:

a schedule indicating when units of work are to be executed;

a scheduler configured to;

determine a first cost to execute a first unit of work;

determine a first set of user-selectable scheduling options for repetitive execution of the first unit of work on the basis of the first cost, wherein the scheduler determines the first set of user-selectable scheduling options base on the first cost, wherein the first set of user-selectable scheduling options is a subset of a larger set of scheduling options, and wherein the larger set of scheduling options are stored on a non-transitory computer readable storage medium and include a plurality of user-selectable time criteria and frequency criteria, wherein the time criteria specifies when the execution of a given unit of work will begin and the frequency criteria specifies how frequently the given unit of work will be executed;

return the first set of user-selectable scheduling unit of work to the user interface for display, whereby the user interface presents;

time criteria selection elements from which a user specifies a time at which execution of the first unit of work will begin; and

frequency criteria selection elements from which the user specifies a frequency at which the first unit of work will be executed beginning at the specified time;

determine a second cost to execute a second unit of work;

determine a second set of user-selectable scheduling options for repetitive execution of the second unit of work on the basis of the second cost, wherein the scheduler determines the second set of user-selectable scheduling options based on the second cost, wherein the second set of user-selectable scheduling options is a subset of the larger set of scheduling options, and wherein the second set of user-selectable scheduling options is different than the first set of user-selectable scheduling options; and

return the second set of user-selectable scheduling unit of work to the user interface for display, whereby the user interface presents;

time criteria selection elements from which a user specifies a time at which execution of the second unit of work will begin; and

frequency criteria selection elements from which the user specifies a frequency at which the second unit of work will be executed beginning at the specified time.

11. The computer system of claim 10, wherein:

the first cost to execute the first unit of work is higher than the second cost to execute the second unit of work; and

a number of scheduling options provided by the first set of user-selectable scheduling options is smaller than a number of scheduling options provided by the second set of user-selectable scheduling options.

12. The computer system of claim 10, further comprising a database against which the first and second units of work are executed.

13. The computer system of claim 10, wherein at least one of the first and second units of work is a query.

14. The computer system of claim 10, wherein at least one of the first and second units of work is an analysis routine.