Patent ID: 9336294
Filing Date: 2016-05-10
CPC Classification: G06F

Claim Text:
1. A computer program product for defining database objects for storage in a storage hierarchy, the computer program product comprising: a non-transitory computer readable storage medium having computer readable program code embodied therewith, the program code executable by a processor to: automatically manage storage costs in the storage hierarchy for a plurality of database objects by: observing frequencies of accesses of a plurality of database objects over a predetermined time period comprising: computing a mean and a standard deviation for the plurality of database objects based on the observed frequencies of accesses of the plurality of database objects; determining a z-score for a given database object for correlation to an access frequency level for the given database object and storing the given database object in the storage hierarchy, the z-score based on a comparison of the frequency of access for the given database object with the mean and standard deviation of the plurality of database objects comprising: defining the access frequency level for the given database object based on the z-score of the given database object; and storing the given database object in the storage hierarchy according to the access frequency level and the storage costs associated with the storage hierarchy, wherein a more frequently accessed database object is stored within the storage hierarchy in higher cost storage, where the frequently accessed database object is accessed quicker than a less frequently accessed database object.