Method of addressing query scheduling and system resource requirements

• US 7,454,404 B2
• Filed: 02/26/2004
• Issued: 11/18/2008
• 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): Wong; Don
• Assistant Examiner(s): Darno; Patrick A
• Application Number:
  US10/787,477
• Publication Number:
  US 20050192997A1
• Time in Patent Office: 1,727 Days
• Field of Search: 707/10, 707/101, 707/3, 707/100, 707/2, 707/200, 715/810, 715/825
• US Class Current: 1/1
• 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 computer-implemented method for scheduling execution of units of work, 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, wherein the larger set of scheduling options is stored on a computer readable storage medium and includes 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 interfaces 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 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 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

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 method of claim 1, wherein at least one of the first and second units of work is a query.

3. The method of claim 1, wherein at least one of the first and second units of work is an analysis routine.

4. The method 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 method 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.

6. The method 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;

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.

7. The method of claim 1, wherein determining the first and second costs to execute the first and second units of work, respectively, comprises estimating a respective time required to execute the respective unit of work.

8. The method of claim 1, wherein determining the first and second costs to execute the first and second units of work is done on the basis of historical query execution times for previous executions of the respective units of work.

9. The method of claim 1, wherein determining the first and second sets of user-selectable scheduling options comprises:

determining user parameters specific to a user; and

determining the respective set of user-selectable scheduling options for future execution of the respective unit of work on the basis of the respective cost and the user parameters.

10. The method of claim 9, wherein the user parameters include at least one of a user status of the user and other units of work already scheduled for execution by the user.

11. The computer-implemented method 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.

12. A computer-implemented method for scheduling units of work, comprising:

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

determining system availability to execute the first unit of work;

determining a first set of user-selectable scheduling options for future execution of the first unit of work on the basis of the first cost and the system availability, 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 is stored on a computer readable storage medium and includes 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 system availability 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 on the basis of the second cost and the system availability, wherein the first 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

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 whicha 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.

13. The method of claim 12, wherein determining system availability to execute the first and second units of work, respectively, comprises accessing a query scheduling having entries defined for respective units of work.

14. The method of claim 12, furthet 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;

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.

15. The method of claim 12, wherein determining the first and second costs to execute the first and second units of work comprises estimating a respective time required to execute the respective unit of work.

16. The method of claim 12, wherein determining the first and second costs to execute the first and second units of work is done on the basis of historical query execution times for previous executions of the respective unit of work.

17. The computer-implemented method of claim 12, 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.