Dynamic granularity for storage optimization

A computer system for generating feedback for dynamic granularity of a data storage, the computer system comprising:

• one or more computer processors;
• one or more computer-readable storage media;
• program instructions stored on the computer-readable storage media for execution by at least one of the one or more processors, the program instructions comprising:
• instructions to identify a plurality of tiers of data, each of the tiers of data comprising a plurality of units of data associated with a unit heat index corresponding to an activity level metric calculated for each of the units of data;
• instructions to identify a tier heat index for each of the plurality of tiers of data corresponding to an average of the unit heat index for the plurality of units of data within the corresponding plurality of tiers of data;
• instructions to determine a granularity index based on a data size of the plurality of units of data;
• instructions to calculate a pairing index by comparing the unit heat indexes from the corresponding plurality of tiers of data, the pairing index indicating a level of similarity of each of the unit heat indexes within each of the plurality of tiers of data;
• and
• instructions to calculate an efficiency index by comparing the unit heat indexes of each of the units of data within the corresponding plurality of tiers of data, the efficiency index indicating a percentage of the plurality of units of data within a first tier of data with a higher unit heat index than all of the units of data within a second tier of data, wherein the first tier of data has a higher tier heat index than the second tier of data.

A computer program product for generating feedback for query execution, comprising a computer-readable storage medium having program code embodied therewith, the program code executable by a processor of a computer to perform a method comprising:

• identifying a plurality of tiers of data, each of the tiers of data comprising a plurality of units of data associated with a unit heat index corresponding to an activity level metric calculated for each of the units of data;
• identifying a tier heat index for each of the plurality of tiers of data corresponding to an average of the unit heat index for the plurality of units of data within the corresponding plurality of tiers of data;
• determining a granularity index based on a data size of the plurality of units of data;
• calculating a pairing index by comparing the unit heat indexes from the corresponding plurality of tiers of data, the pairing index indicating a level of similarity of each of the unit heat indexes within each of the plurality of tiers of data;
• and
• calculating an efficiency index by comparing the unit heat indexes of each of the units of data within the corresponding plurality of tiers of data, the efficiency index indicating a percentage of the plurality of units of data within a first tier of data with a higher unit heat index than all of the units of data within a second tier of data, wherein the first tier of data has a higher tier heat index than the second tier of data.