Tier-based data management

• US 9,031,914 B2
• Filed: 04/22/2009
• Issued: 05/12/2015
• Est. Priority Date: 04/22/2009
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Hix, Gary R., Spencley, Philip T.
• Primary Examiner(s): LU, KUEN S
• Application Number:
  US12/428,091
• Publication Number:
  US 20100274827A1
• Time in Patent Office: 2,211 Days
• Field of Search: 707/654, 707/665
• US Class Current: 707/654
• CPC Class Codes: G06F 16/125 characterised by the use of retention policies retention policies for HSM systems G06F16/185
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases

Abstract

The present invention addresses the deficiencies of the related art by providing a tier-based data storage solution. Specifically, the present invention evaluates the data contained in database tables by analyzing several metrics for the data, and creating a valuation score. The valuation score is used to determine the storage tier that would meet the performance and availability requirements of the database with the goal of reducing the costs associated with storing that data. The metrics that are used to evaluate database tables include (among others): table purpose, data retention, disk requirements, data criticality, data relevance, and desired performance. As such, the present invention will develop a data (lifecycle) storage plan for each set of data. This storage plan not only identifies an initial storage tier where the data should be stored, but also identifies, if, when and to where the data should be moved thereafter.

Claims

1. A method for data management, comprising:

analyzing a set of metrics for each of a first set of data and a second set of data in a computer database, the set of metrics comprising the following;

table purpose, data retention, computer disk drive requirements, data criticality, data relevance, and desired performance;

developing a lifecycle storage plan for the first set of data that is specific to the first set of data, said developing comprising determining a first valuation score based on said analyzing of all of the set of metrics corresponding to the first set of data;

developing a second lifecycle storage plan for the second set of data that is specific to the second set of data, said developing comprising determining a second valuation score based on said analyzing of all of the set of metrics corresponding to the second set of data; and

storing the first set of data in a first storage tier, the first storage tier comprising an electronic storage device, and the first storage tier being selected based on said lifecycle storage plan.

2. The method of claim 1, said first valuation score being used to identify the first storage tier.

3. The method of claim 1 further comprising moving the first set of data from the first storage tier to a second storage tier corresponding to a lower valuation score after a predetermined amount of time, the second storage tier and the predetermined amount of time being based on the storage plan.

4. The method of claim 1, the table purpose identifying speed requirements and disk availability requirements of the first set of data.

5. The method of claim 1, the data retention identifying a length of time of storage of the first set of data.

6. The method of claim 1, the disk requirements identifying an erasability requirement and a writeability requirement of the first set of data stored on a disk.

7. The method of claim 1, the data criticality identifying a business importance of the first set of data.

8. The method of claim 1, the data relevance identifying an access pattern to the first set of data.

9. The method of claim 1, the desired performance identifying technical needs of an application using the first set of data.

10. A computer system for data management, comprising:

at least one processing unit;

memory operably associated with the at least one processing unit; and

a module for analyzing a set of metrics for a first set of data and a second set of data in a computer database, the set of metrics comprising the following;

table purpose, data retention, computer disk drive requirements, data criticality, data relevance, and desired performance;

a module for developing a lifecycle storage plan for the first set of data that is specific to the first set of data and for developing a second lifecycle storage plan for the second set of data that is specific to the second set of data, said developing comprising determining a first valuation score based on said analyzing of all of the set of metrics corresponding to the first set of data and determining a second valuation score based on said analyzing of all of the set of metrics corresponding to the second set of data; and

a module for storing the first set of data in a first storage tier, the first storage tier comprising an electronic storage device, and the first storage tier being selected based on said lifecycle storage plan.

11. The computer system of claim 10, further comprising a module for using said first valuation score to identify the first storage tier.

12. The computer system of claim 10, further comprising a module for moving the first set of data from the first storage tier to a second storage tier corresponding to a lower valuation score after a predetermined amount of time, the second storage tier and the predetermined amount of time being based on the storage plan.

13. The computer system of claim 10, the table purpose identifying speed requirements and disk availability requirements of the first set of data.

14. The computer system of claim 10, the data retention identifying a length of time of storage of the first set of data.

15. The computer system of claim 10, the disk requirements identifying an erasability requirement and a writeability requirement of the first set of data stored on a disk.

16. The computer system of claim 10, the data criticality identifying a business importance of the first set of data.

17. The computer system of claim 10, the data relevance identifying an access pattern to the first set of data.

18. The computer system of claim 10, the desired performance identifying technical needs of an application using the first set of data.

19. A computer readable storage device containing a program product for data management, the computer readable storage device comprising program code for causing a computer system to:

analyze a set of metrics for a first set of data and a second set of data in a computer database, the set of metrics comprising the following;

table purpose, data retention, computer disk drive requirements, data criticality, data relevance, and desired performance;

develop a lifecycle storage plan for the first set of data that is specific to the set of data, said developing comprising determining a first valuation score based on said analyzing of all of the set of metrics corresponding to the first set of data;

develop a second lifecycle storage plan for the second set of data that is specific to the second set of data, said developing comprising determining a second valuation score based on said analyzing of all of the set of metrics corresponding to the second set of data; and

store the first set of data in a first storage tier, the first storage tier comprising an electronic storage device, and the first storage tier being selected based on said lifecycle storage plan.

20. The computer readable storage device containing the program product of claim 19, the computer readable medium further comprising program code for causing the computer system to:

use said first valuation score to identify the first storage tier.

21. The computer readable storage device containing the program product of claim 19, the computer readable medium further comprising program code for causing the computer system to:

move the first set of data from the first storage tier to a second storage tier corresponding to a lower valuation score after a predetermined amount of time, the second storage tier and the predetermined amount of time being based on the storage plan.

22. A method for deploying a system for data management, comprising;

providing a computer infrastructure being operable to;

analyze a set of metrics for a first set of data and a second set of data in a computer database, the set of metrics comprising the following;

table purpose, data retention, computer disk drive requirements, data criticality, data relevance, and desired performance;

develop a lifecycle storage plan for the first set of data that is specific to the first set of data, said developing comprising determining a first valuation score based on said analyzing of all of the set of metrics corresponding to the first set of data;

develop a second lifecycle storage plan for the second set of data that is specific to the second set of data, said developing comprising determining a second valuation score based on said analyzing of all of the set of metrics corresponding to the second set of data; and

store the first set of data in a first storage tier, the first storage tier comprising an electronic storage device, and the first storage tier being selected based on said lifecycle storage plan.

23. The method of claim 22, the computer infrastructure being further operable to:

use the first valuation score to identify the first storage tier.

24. The method of claim 22, the computer infrastructure being further operable to:

move the first set of data from the first storage tier to a second storage tier corresponding to a lower valuation score after a predetermined amount of time, the second storage tier and the predetermined amount of time being based on the storage plan.