Workload priority influenced data temperature

• US 20080162417A1
• Filed: 03/12/2007
• Published: 07/03/2008
• Est. Priority Date: 12/08/2003
• Status: Active Grant

• Current Assignee: Teradata US, Inc. (Teradata Corporation)
• Original Assignee: NCR Corporation (NCR Voyix Corporation)
• Inventors: Richards, Anita, Morris, John Mark, Brown, Douglas P.
• Granted Patent: US 9,116,929 B2
• Time in Patent Office: Days
• US Class Current: 707/2
• CPC Class Codes: G06F 16/10 File systems; File servers
• CPC Class Codes: G06F 16/17 Details of further file system functions
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 16/90335 Query processing
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing

Abstract

A system and method for managing one or more database systems, wherein the database systems perform database queries to retrieve data stored by the database systems. One or more regulators are used for managing the database systems, wherein the regulators monitor workload priority influenced data temperature in order to allocate resources for the systems. The data temperature is a measure of physical accesses to logical data, and the workload priority is used to further define data temperature, in order to optimize data storage placement and data access decisions.

Claims

1. A system for managing database systems, comprising:

(a) one or more database systems, wherein each of the database systems performs database queries to retrieve data stored by the database systems; and

(b) one or more regulators for managing the database systems;

(c) wherein the regulators monitor workload priority influenced data temperature in order to allocate resources for the systems.

2. The system of claim 1, wherein the data temperature is a measure of physical accesses to logical data.

3. The system of claim 1, wherein the workload priority is used to further define data temperature.

4. The system of claim 1, wherein the workload priority is used for data storage placement optimization.

5. The system of claim 1, wherein data storage placement in the systems is influenced according to a priority of a workload group'"'"'s accesses to the data.

6. The system of claim 1, wherein the workload priority is used for data access optimization.

7. The system of claim 1, wherein data access in the systems is influenced according to a priority of a workload group'"'"'s accesses to the data.

8. A method for managing database systems, comprising:

(a) providing one or more database systems, wherein each of the database systems performs database queries to retrieve data stored by the database systems; and

(b) managing the database systems using one or more regulators;

(c) wherein the regulators monitor workload priority influenced data temperature in order to allocate resources for the systems.

9. The method of claim 8, wherein the data temperature is a measure of physical accesses to logical data.

10. The method of claim 8, wherein the workload priority is used to further define data temperature.

11. The method of claim 8, wherein the workload priority is used for data storage placement optimization.

12. The method of claim 8, wherein data storage placement in the systems is influenced according to a priority of a workload group'"'"'s accesses to the data.

13. The method of claim 8, wherein the workload priority is used for data access optimization.

14. The method of claim 8, wherein data access in the systems is influenced according to a priority of a workload group'"'"'s accesses to the data.