Virtual data maintenance

• US 20090132602A1
• 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: Brown, Douglas, Morris, John Mark, Walter, Todd
• Granted Patent: US 8,392,461 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

Abstract

A computer-implemented apparatus, method, and article of manufacture manage a plurality of database systems and perform data maintenance tasks in a data warehouse system. A domain includes a plurality of database systems. A virtual regulator manages the domain, detects a request to invoke a data maintenance task on a first system in the domain, routes the data maintenance task, for execution, to a second system in the domain, and applies results from the data maintenance task (executed by the second system) to the first system.

Claims

1. A computer-implemented apparatus for performing data maintenance tasks in a data warehouse system, comprising:

(a) a domain comprised of a plurality of database systems; and

(b) a virtual regulator for managing the domain, wherein the virtual regulator;

(i) detects a request to invoke a data maintenance task on a first system of the plurality of database systems;

(ii) routes the data maintenance task to a second system of the plurality of database systems for execution; and

(iii) applies results from the data maintenance task executed by the second system to the first system.

2. The apparatus of claim 1, wherein the data maintenance task comprises collecting statistics or demographics.

3. The apparatus of claim 2, wherein the statistics are maintained on a per access module processor (AMP) basis and the number of AMPs in each system is identical.

4. The apparatus of claim 2, wherein through export of a hash map, the statistics are maintained on a per access module processor (AMP) basis and the number of AMPs in each system is different.

5. The apparatus of claim 1, wherein the data maintenance task comprises space accounting.

6. The apparatus of claim 1, wherein:

the data maintenance task comprises compression analysis wherein data is examined for frequency of use of each value in each column domain; and

the results are applied by instantiating value compression on the first system.

7. The apparatus of claim 1, wherein the data maintenance task comprises integrity checking of the data.

8. The apparatus of claim 1, wherein the data maintenance task comprises index analysis to identify opportunities for improved indexes for a workload.

9. The apparatus of claim 1, wherein the data maintenance task comprises statistics analysis to identify opportunities for improved statistics collection.

10. A computer-implemented method for performing data maintenance tasks in a data warehouse system, comprising:

detecting a request to invoke a data maintenance task on a first system of a plurality of database systems in a domain;

routing the data maintenance task to a second system of the plurality of database systems for execution; and

applying results from the data maintenance task executed by the second system to the first system.

11. The method of claim 10, wherein the data maintenance task comprises collecting statistics or demographics.

12. The method of claim 11, wherein the statistics are maintained on a per access module processor (AMP) basis and the number of AMPs in each system is identical.

13. The method of claim 11, wherein through export of a hash map, the statistics are maintained on a per access module processor (AMP) basis and the number of AMPs in each system is different.

14. The method of claim 10, wherein the data maintenance task comprises space accounting.

15. The method of claim 10, wherein:

the data maintenance task comprises compression analysis wherein data is examined for frequency of use of each value in each column domain; and

the results are applied by instantiating value compression on the first system.

16. The method of claim 10, wherein the data maintenance task comprises integrity checking of the data.

17. The method of claim 10, wherein the data maintenance task comprises index analysis to identify opportunities for improved indexes for a workload.

18. The method of claim 10, wherein the data maintenance task comprises statistics analysis to identify opportunities for improved statistics collection.

19. 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 performing data maintenance tasks in a data warehouse system, the method comprising:

(a) managing each of a plurality of database systems in a domain; and

(b) managing the domain using a virtual regulator, wherein the virtual regulator;

(i) detects a request to invoke a data maintenance task on a first system of the plurality of database systems;

(ii) routes the data maintenance task to a second system of the plurality of database systems for execution; and

(iii) applies results from the data maintenance task executed by the second system to the first system.

20. The article of claim 19, wherein the data maintenance task comprises collecting statistics or demographics.

21. The article of claim 19, wherein the data maintenance task comprises space accounting.

22. The article of claim 19, wherein:

the data maintenance task comprises compression analysis wherein data is examined for frequency of use of each value in each column domain; and

the results are applied by instantiating value compression on the first system.

23. The article of claim 19, wherein the data maintenance task comprises integrity checking of the data.

24. The article of claim 19, wherein the data maintenance task comprises index analysis to identify opportunities for improved indexes for a workload.

25. The article of claim 19, wherein the data maintenance task comprises statistics analysis to identify opportunities for improved statistics collection.