Database object management for a shared pool of configurable computing resources

A system of database object management for a shared pool of configurable computing resources, the system comprising:

• a memory having a set of computer readable computer instructions, and
• a processor for executing the set of computer readable instructions, the set of computer readable instructions including:
• collecting a set of database object profile data for a set of database objects, wherein the set of database objects comprises a first subset of database objects and a second subset of database objects;
• determining, based on the set of database object profile data, a first subset of database object priority values for the first subset of database objects and a second subset of database object priority values for the second subset of database objects, wherein the database object priority value is calculated based on a weighted summation of an update frequency value of the database object, a database user stature value of the database object, and a usage frequency value of the database object, and wherein the update frequency value relates to a rate of change of the database object, wherein the database user stature value relates to an organizational hierarchy of users that access the database object, and wherein the usage frequency value relates to a rate that the database object is queried;
• based on the first subset of database object priority values being above a first threshold priority value, deploying the first subset of database objects on a first storage medium having a first access-factor;
• in response to deploying the first subset of the set of database objects, a second subset of the set of database objects which corresponds with a second subset of the database object priority values that do not exceed the threshold priority value;
• and
• based on the second subset of database object priority values being below the first threshold priority value and above a second threshold priority value, deploying the second subset of database objects on a second storage medium having a second access-factor, wherein the second access-factor is lower than the first access-factor, and wherein an increase in access-factor corresponds an decrease in the time to access a subset of database objects.

A computer program product of database object management for a shared pool of configurable computing resources, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, wherein the computer readable storage medium is not a transitory signal per se, the program instructions executable by a processor to cause the processor to perform a method comprising:

• collecting a set of database object profile data for a set of database objects, wherein the set of database objects comprises a first subset of database objects and a second subset of database objects;
• determining, based on the set of database object profile data, a first subset of database object priority values for the first subset of database objects and a second subset of database object priority values for the second subset of database objects, wherein the database object priority value is calculated based on a weighted summation of an update frequency value of the database object, a database user stature value of the database object, and a usage frequency value of the database object, and wherein the update frequency value relates to a rate of change of the database object, wherein the database user stature value relates to an organizational hierarchy of users that access the database object, and wherein the usage frequency value relates to a rate that the database object is queried;
• based on the first subset of database object priority values being above a first threshold priority value, deploying the first subset of database objects on a first storage medium having a first access-factor;
• in response to deploying the first subset of the set of database objects, a second subset of the set of database objects which corresponds with a second subset of the database object priority values that do not exceed the threshold priority value;
• and
• based on the second subset of database object priority values being below the first threshold priority value and above a second threshold priority value, deploying the second subset of database objects on a second storage medium having a second access-factor, wherein the second access-factor is lower than the first access-factor, and wherein an increase in access-factor corresponds an decrease in the time to access a subset of database objects.