Increased database performance via migration of data to faster storage

Patent metadata

Field	Value
Publication number	US-9495396-B2
Application number	US-201313967403-A
Country	US
Kind code	B2
Filing date	Aug 15, 2013
Priority date	Sep 24, 2012
Publication date	Nov 15, 2016
Grant date	Nov 15, 2016

Abstract

According to an aspect, a computer implemented method for managing a database in real-time is provided. The method includes scanning for predetermined data in a predetermined workload stream during real-time operation of the database, and determining a workload priority for located predetermined data according to one or more workload rules. A storage priority of located predetermined data is determined according to a physical location of the located predetermined data. The located predetermined data are moved during the real-time operation of the database to a different physical location if the storage priority and the workload priority do not match.

First claim

What is claimed is:

1. A computer implemented method for managing a database in real-time comprising:
scanning for predetermined data in a predetermined workload stream during real-time operation of the database;
determining a workload priority for located predetermined data according to one or more workload rules, wherein the one or more workload rules determine the workload priority based upon a service class of the predetermined data;
determining a storage priority of located predetermined data according to a physical location of the located predetermined data; and
moving the located predetermined data during the real-time operation of the database to a different physical location if the storage priority and the workload priority do not match, wherein movement of the located predetermined data is postponed if new physical storage has less than a threshold space.

2. The method according to claim 1 wherein moving the located predetermined data comprises tagging the located predetermined data for movement.

3. The method according to claim 1 wherein the located predetermined data are moved to a higher priority physical location to match its determined workload priority.

4. The method according to claim 1 wherein the located predetermined data are moved to a lower priority physical location to match its determined workload priority.

5. The method according to claim 1 wherein the movement of the located predetermined data is performed asynchronously to the scanning and determining.

6. The method according to claim 1 wherein the data are prioritized in multiple categories.

7. The method according to claim 1 wherein the unit of data that is assigned a priority is a table.

8. The method according to claim 7 wherein groups of tables can be assigned the same priority.

9. A database management system, comprising:
a workload stream scanner in memory of a computer processing system comprising instructions executable by a processor of the computer processing system to scan for predetermined data in a predetermined workload stream during real-time operation of a database;
a workload priority engine in memory of the computer processing system comprising instructions executable by the processor of the computer processing system to determine a workload priority for located predetermined data according to one or more workload rules, wherein the one or more workload rules determine the workload priority based upon a service class of the predetermined data;
a storage priority engine in memory of the computer processing system comprising instructions executable by the processor of the computer processing system to determine a storage priority of located predetermined data according to a physical location of the located predetermined data; and
a data migration engine in memory of the computer processing system comprising instructions executable by the processor of the computer processing system to move the located predetermined data during the real-time operation of the database to a different physical location if the storage priority and the workload priority do not match, wherein movement of the located predetermined data is postponed if new physical storage has less than a threshold space.

10. The system according to claim 9 wherein movement of the located predetermined data comprises tagging the located predetermined data for movement.

11. The system according to claim 9 wherein the located predetermined data are moved to a physical location with a higher priority or lower priority to match its determined workload priority.

12. The system according to claim 9 wherein the movement of the located predetermined data is performed asynchronously to scanning and determining by the workload stream scanner, the workload priority engine, and the storage priority engine.

13. The system according to claim 9 wherein the data are prioritized in multiple categories.

14. A computer program product for managing a database, the computer program product comprising a non-transitory computer readable storage medium having computer readable program code embodied therewith, the computer readable program code comprising computer readable program code configured for:
scanning for predetermined data in a predetermined workload stream during real-time operation of the database;
determining a workload priority for located predetermined data according to one or more workload rules, wherein the one or more workload rules determine the workload priority based upon a service class of the predetermined data;
determining a storage priority of located predetermined data according to a physical location of the located predetermined data; and
moving the located predetermined data during the real-time operation of the database to a different physical location if the storage priority and the workload priority do not match, wherein movement of the located predetermined data is postponed if new physical storage has less than a threshold space.

15. The computer program product according claim 14 wherein moving the located predetermined data comprises tagging the located predetermined data for movement.

16. The computer program product according claim 14 wherein the located predetermined data are moved to a physical location with a higher priority or lower priority to match its determined workload priority.

17. The computer program product according claim 14 wherein the movement of the located predetermined data is performed asynchronously to scanning and determining by a workload stream scanner, a workload priority engine, and a storage priority engine.

18. The method according to claim 1 wherein the located predetermined data is subsequently moved after the movement has been postponed based on determining that the new physical storage is greater than or equal to the threshold space.

19. The system according to claim 9 wherein the located predetermined data is subsequently moved after the movement has been postponed based on determining that the new physical storage is greater than or equal to the threshold space.

20. The computer program product according to claim 14 wherein the located predetermined data is subsequently moved after the movement is postponed based on determining that the new physical storage is greater than or equal to the threshold space.

Assignees

• IBM

Inventors

• Ignacio Rizaldy G
• Maycock Ken
• Murtagh Gary F
• Roe Shay

Classifications

• G06F16/214 Primary

  Database migration support · CPC title

• G06F17/303 Primary

  Physics · mapped topic