Selective and piecemeal data loading for computing efficiency

Abstract

One or more processors determine a level of data usage for two or more types of data to be loaded in a relational database. One or more processors prioritize data of the two or more types for loading. One or more processors load data of the two or more types in an order based, at least in part, on the level of data usage for the two or more types of data. One or more processors load data of the two or more types into a table within the relational database, the data being loaded in two or more portions and at times based, at least in part, on an availability of computer resources.

What is claimed is: 
     
         1 . A computer program product, 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 device to cause the device to perform a method comprising:
 determining, by one or more processors, a level of data usage for two or more types of data to be loaded in a relational database;   prioritizing, by the one or more processors, data of the two or more types for loading, wherein data of a first data type has a higher priority for loading than data of a second data type when the first data type has a higher level of data usage than the second data type;   loading, by the one or more processors, data of the two or more types in an order based, at least in part, on the level of data usage for the two or more types of data;   prioritizing, by the one or more processors, data of the two or more high-priority types for loading, wherein data of a first high-priority data type has a higher priority for loading than data of a second high-priority data type based, at least in part, on one or more of: an amount of data to be loaded, a number of types of data to be loaded, and a time requirement for data to be loaded;   partially loading, by the one or more processors, data of the two or more types into a table within the relational database, the data being loaded (i) in two or more portions, (ii) at times based, at least in part, on an availability of computer resources, and (iii) based, at least in part, on a determination of priority for the two or more types of data; and   utilizing, by the one or more processors, the partially loaded table within the relational database to execute a plurality of computing tasks that require at least two of the two or more types of data.