Dynamic query optimization between systems based on system conditions

• US 20090049024A1
• Filed: 08/14/2007
• Published: 02/19/2009
• Est. Priority Date: 08/14/2007
• Status: Abandoned Application

• Current Assignee: Teradata US, Inc. (Teradata Corporation)
• Original Assignee: NCR Corporation
• Inventors: Ramesh, Bhashyam, Richards, Anita, Kostamaa, Olli Pekka, Morris, John Mark, Brown, Douglas P.
• Application Number:
  US11/891,919
• Publication Number:
  US 20090049024A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2453 Query optimisation

Abstract

A computer-implemented system, method and article of manufacture for managing a plurality of database systems in a domain, wherein each of the database systems are managed by one or more closed-loop system management (CLSM) regulators. A virtual regulator manages the domain, wherein the virtual regulator communicates with the CLSM regulators to monitor the database systems'"'"' system conditions and operating environment events within the domain and to provide for dynamic query optimization between the database systems within in the domain based on the system conditions and operating environment events.

Claims

1. A computer-implemented apparatus for managing a plurality of database systems, comprising:

(a) a domain comprised of a plurality of database systems, wherein each of the database systems are managed by one or more closed-loop system management (CLSM) regulators; and

(b) a virtual regulator for managing the domain, wherein the virtual regulator communicates with the CLSM regulators to monitor the database systems'"'"' system conditions and operating environment events within the domain and to provide for dynamic query optimization between the database systems within in the domain based on the system conditions and operating environment events.

2. The apparatus of claim 1, wherein the dynamic query optimization comprises routing the queries to the database systems based on the systems conditions and operating environment events within the domain.

3. The apparatus of claim 2, wherein the routing of the queries to the database systems is based on combinations of the systems conditions and operating environment events within the domain.

4. The apparatus of claim 1, wherein the dynamic query optimization is performed using an n-dimensional state matrix to identify at least one state resulting from the monitored system conditions and operating environment events and then initiating an action in response to the identified state.

5. The apparatus of claim 4, wherein each element of the state matrix is a system condition and operating environment event pair that references a workload management state, which in turn invokes one or more workload management rules of a set of workload management rules.

6. The apparatus of claim 5, wherein the state matrix facilitates conflict resolution through prioritization of its dimensions, such that the system conditions and operating environment events positions within the matrix indicate their precedence.

7. The apparatus of claim 1, wherein the system conditions or operating environment events comprise performance conditions, availability indicators, resource utilization, user-defined systems conditions, used-defined operating environment events, and time period events.

12. The method of claim 11, wherein each element of the state matrix is a system condition and operating environment event pair that references a workload management state, which in turn invokes one or more workload management rules of a set of workload management rules.

13. The method of claim 12, wherein the state matrix facilitates conflict resolution through prioritization of its dimensions, such that the system conditions and operating environment events positions within the matrix indicate their precedence.

8. A computer-implemented method of managing a plurality of database systems, comprising:

(a) managing each of a plurality of database systems in a domain using one or more closed-loop system management (CLSM) regulators; and

(b) managing the domain using a virtual regulator, wherein the virtual regulator communicates with the CLSM regulators to monitor the database systems'"'"' system conditions and operating environment events within the domain and to provide for dynamic query optimization between the database systems within in the domain based on system conditions and operating environment events.

9. The method of claim 8, wherein the dynamic query optimization comprises routing the queries to the database systems based on the systems conditions and operating environment events within the domain.

10. The method of claim 9, wherein the routing of the queries to the database systems is based on combinations of the systems conditions and operating environment events within the domain.

11. The method of claim 8, wherein the dynamic query optimization is performed using an n-dimensional state matrix to identify at least one state resulting from the monitored system conditions and operating environment events and then initiating an action in response to the identified state.

14. The method of claim 8, wherein the system conditions or operating environment events comprise performance conditions, availability indicators, resource utilization, user-defined systems conditions, used-defined operating environment events, and time period events.

15. An article of manufacture comprising one or more storage devices tangibly embodying instructions that, when executed by one or more computer systems, result in the computer systems performing a method for managing a plurality of database systems, the method comprising:

(a) managing each of a plurality of database systems in a domain using one or more closed-loop system management (CLSM) regulators; and

(b) managing the domain using a virtual regulator, wherein the virtual regulator communicates with the CLSM regulators to monitor the database systems'"'"' system conditions and operating environment events within the domain and to provide for dynamic query optimization between the database systems within in the domain based on system conditions and operating environment events.

16. The article of claim 15, wherein the dynamic query optimization comprises routing the queries to the database systems based on the systems conditions and operating environment events within the domain.

17. The article of claim 16, wherein the routing of the queries to the database systems is based on combinations of the systems conditions and operating environment events within the domain.

18. The article of claim 15, wherein the dynamic query optimization is performed using an n-dimensional state matrix to identify at least one state resulting from the monitored system conditions and operating environment events and then initiating an action in response to the identified state.

19. The article of claim 18, wherein each element of the state matrix is a system condition and operating environment event pair that references a workload management state, which in turn invokes one or more workload management rules of a set of workload management rules.

21. The article of claim 15, wherein the system conditions or operating environment events comprise performance conditions, availability indicators, resource utilization, user-defined systems conditions, used-defined operating environment events, and time period events.

20. The article of claim 20, wherein the state matrix facilitates conflict resolution through prioritization of its dimensions, such that the system conditions and operating environment events positions within the matrix indicate their precedence.