Dynamic query and step routing between systems tuned for different objectives

• US 20090132471A1
• Filed: 11/19/2007
• Published: 05/21/2009
• Est. Priority Date: 11/19/2007
• Status: Active Grant

• Current Assignee: Teradata Corporation
• Original Assignee: Teradata Corporation
• Inventors: Morris, John Mark, Brown, Douglas P., Ward, William, Gnau, Scott E.
• Granted Patent: US 8,392,404 B2
• Time in Patent Office: Days
• 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/2471 Distributed queries

Abstract

A computer-implemented apparatus, method, and article of manufacture manage a plurality of database systems. A domain includes a plurality of database systems. Each of the database systems is tuned for a particular type of workload. A virtual regulator (or multiple virtual regulators running in parallel) manages the domain and routes a set of one or more queries to a particular database system within the domain based on a cost function for each database system.

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 is tuned for a particular type of workload; and

(b) a virtual regulator for managing the domain, wherein the virtual regulator routes a set of one or more queries to a particular database system within the domain based on a cost function for each database system.

2. The apparatus of claim 1, wherein one of the database systems is tuned to optimize a decision support system (DSS).

3. The apparatus of claim 1, wherein one of the database systems is tuned to optimize a tactical query in an active data warehouse (ADW).

4. The apparatus of claim 1, wherein a parameter for tuning the workload is selected from a group consisting of data block size, cylinder read buffers, memory for cache, disk size, and read-ahead.

5. The apparatus of claim 1, wherein each of the database systems in the domain is tuned for a different type of workload from other database systems in the domain.

6. The apparatus of claim 1, wherein the virtual regulator routes a step of one or more queries.

7. The apparatus of claim 1, wherein the virtual regulator routes a set of parallel steps of one or more queries.

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

(a) tuning each database system in a domain, wherein the domain is comprised of a plurality of database systems, for a particular type of workload; and

(b) routing a set of one or more queries to a particular database system within the domain based on a cost function for each database system.

9. The method of claim 8, wherein one of the database systems is tuned to optimize a decision support system (DSS).

10. The method of claim 8, wherein one of the database systems is tuned to optimize a tactical query in an active data warehouse (ADW).

11. The method of claim 8, further comprising selecting a parameter for tuning the workload from a group consisting of data block size, cylinder read buffers, memory for cache, disk size, and read-ahead.

12. The method of claim 8, wherein each of the database systems in the domain is tuned for a different type of workload from other database systems in the domain.

13. The method of claim 8, wherein the routing comprises routing a step of one or more queries.

14. The method of claim 8, wherein the routing comprises routing a set of parallel steps of one or more queries.

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) tuning each database system in a domain, wherein the domain is comprised of a plurality of database systems, for a particular type of workload; and

(b) routing a set of one or more queries to a particular database system within the domain based on a cost function for each database system.

16. The article of manufacture of claim 15, wherein one of the database systems is tuned to optimize a decision support system (DSS).

17. The article of manufacture of claim 15, wherein one of the database systems is tuned to optimize a tactical query in an active data warehouse (ADW).

18. The article of manufacture of claim 15, the method further comprising selecting a parameter for tuning the workload from a group consisting of data block size, cylinder read buffers, memory for cache, disk size, and read-ahead.

19. The article of manufacture of claim 15, wherein each of the database systems in the domain is tuned for a different type of workload from other database systems in the domain.

20. The article of manufacture of claim 15, wherein the routing comprises routing a step of one or more queries.

21. The article of manufacture of claim 15, wherein the routing comprises routing a set of parallel steps of one or more queries.