Processing Batch Database Workload While Avoiding Overload

• US 20100083264A1
• Filed: 09/30/2008
• Published: 04/01/2010
• Est. Priority Date: 09/30/2008
• Status: Active Grant

• Current Assignee: Micro Focus LLC (Open Text Corporation)
• Original Assignee: Hewlett Packard Enterprise Development LP (Hewlett-Packard Enterprise Company)
• Inventors: MEHTA, Abhay, Dayal, Umeshwar, Gupta, Chetan K.
• Granted Patent: US 9,069,613 B2
• Time in Patent Office: Days
• US Class Current: 718/103
• CPC Class Codes: G06F 2209/5021 Priority
• CPC Class Codes: G06F 9/4881 Scheduling strategies for dispatcher, e.g. round robin, multi-level priority queues
• CPC Class Codes: G06F 9/5011 the resources being hardware resources other than CPUs, Servers and Terminals

Abstract

Processing batch database workload while avoiding overload. A method for efficiently processing a database workload in a computer system comprises receiving the workload, which comprises a batch of queries directed toward the database. Each query within the batch of queries is assigned a priority. Resources of the computer system are assigned in accordance with the priority. The batch of queries is executed in unison within the computer system in accordance with the priority of each query thereby resolving a conflict within the batch of queries for the resources of the computer system, hence efficiently processing the database workload and avoiding overload of the computer system.

Claims

1. A method for efficiently processing a database warehouse workload in a computer system, said method comprising:

receiving said workload, which comprises a batch of queries directed toward said database warehouse;

assigning a priority to each query within said batch of queries, wherein said priority is unique within said batch of queries, whereby resources of said computer system are assigned in accordance with said priority; and

executing said batch of queries in unison within said computer system in accordance with said priority of said each query;

thereby resolving a conflict within said batch of queries for said resources of said computer system, hence efficiently processing said database workload and avoiding overload of said computer system.

2. The method of claim 1 wherein said assigning a priority to each query within said batch of queries comprises:

assigning one said priority to at least one said query, wherein said priority is unique within said batch of queries.

3. The method of claim 1 wherein said executing said batch of queries in unison comprises:

scheduling said batch of queries using preemptive priority.

4. The method of claim 1 wherein said method further comprises:

coupling with a feed forward method for defining a multi programming level for processing said batch of queries.

5. The method of claim 2 wherein said assigning a priority to each query within said batch of queries comprises:

reassigning one said priority to at least one new query, after said query originally assigned said priority has been completed.

6. The method of claim 3 wherein said executing said batch of queries in unison using preemptive priority further comprises:

scheduling said batch of queries using an operating system comprised within said computer system.

7. A computer-readable memory containing executable instructions wherein said instructions when executed effect a method for efficiently processing a database workload in a computer system, said method comprising:

receiving said workload which comprises a batch of queries directed toward said database;

assigning a priority to each query within said batch of queries by which resources of said computer system are assigned in accordance with said priority; and

executing said batch of queries in unison within said computer system in accordance with said priority of said each query, thereby resolving a conflict within said batch of queries for said resources of said computer system, hence efficiently processing said database workload and avoiding overload of said computer system.

8. The computer readable memory as described in claim 7 wherein said receiving said workload comprises:

receiving said workload directed toward said database comprising a data warehouse.

9. The computer readable memory as described in claim 7 wherein said assigning a priority to each query within said batch of queries comprises:

assigning one said priority to at least one said queries.

10. The computer readable memory as described in claim 7 wherein said executing said batch of queries in unison comprises:

scheduling said batch of queries using preemptive priority.

11. The computer readable memory as described in claim 7 wherein said method further comprises:

coupling with a feed forward method for defining a multi programming level for processing said batch of queries.

12. The computer readable memory as described in claim 7 wherein said executing said batch of queries in unison using preemptive priority further comprises:

scheduling said batch of queries using an operating system comprised within said computer system.

13. A processing system for a workload operable to a computer, said system comprising:

a receiving module for receiving said workload, wherein said workload comprises a batch of queries;

an assigning module for assigning a priority to each query within said batch of queries, wherein resources of said computer are assigned in accordance with said priority; and

an executing module for executing said batch of queries in unison within said computer in accordance with said priority of said each query, therein resolving a conflict between said queries for said resources of said computer, hence efficiently processing said workload and avoiding overload of said computer.

14. The system of claim 13 wherein said receiving module is configured to receive a workload comprised of a batch of queries.

15. The system of claim 13 wherein said executing module comprises a scheduler for scheduling said batch of queries using preemptive priority.

16. The system of claim 13 wherein said executing module is configured to preemptively schedule said workload using a processor of an operating system disposed within said computer.

17. The system of claim 15 wherein said scheduler is configured to relinquish said resources of said computer by a query having a higher priority, to a query having a lower priority, as said resources become available from said query having said higher priority.

18. The system of claim 15 wherein said scheduler is configured to relinquish said resources of said computer by said query having said lower priority, to said query having said higher priority, as said resources are required by said query having said higher priority.