TIER-BASED DATA MANAGEMENT

• US 20100274827A1
• Filed: 04/22/2009
• Published: 10/28/2010
• Est. Priority Date: 04/22/2009
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Spencley, Philip T., Hix, Gary R.
• Granted Patent: US 9,031,914 B2
• Time in Patent Office: Days
• US Class Current: 707/813
• 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 a set of data in a computer database, the set of metrics comprising at least one of the following;

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

developing a lifecycle storage plan for the set of data based on the analyzing; and

storing the 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 the storage plan.

2. The method of claim 1, the developing further comprising determining a valuation score based on the analysis, the valuation score being used to identify the first storage tier.

3. The method of claim 1 further comprising moving the set of data from the first storage tier to a second storage tier 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 set of data.

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

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

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

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

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

10. A system for data management, comprising:

a module for analyzing a set of metrics for a set of data in a computer database, the set of metrics comprising at least one of 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 set of data based on the analyzing; and

a module for storing the 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 the storage plan.

11. The system of claim 10, further comprising a module for determining a valuation score based on the analysis, the valuation score being used to identify the first storage tier.

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

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

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

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

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

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

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

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

analyze a set of metrics for a set of data in a computer database, the set of metrics comprising at least one of the following;

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

develop a lifecycle storage plan for the set of data based on the analyzing; and

store the 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 the storage plan.

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

determine a valuation score based on the analysis, the valuation score being used to identify the first storage tier.

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

move the set of data from the first storage tier to a second storage tier 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 set of data in a computer database, the set of metrics comprising at least one of the following;

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

develop a lifecycle storage plan for the set of data based on the analyzing; and

store the 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 the storage plan.

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

determine a valuation score based on the analysis, the valuation score being used to identify the first storage tier.

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

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