Systems and Methods for Use in Loading Data From Backup Databases to Task Databases

A computer-implemented method for use in loading data associated with a load job from a backup database to a task database, the method comprising:

• accessing a backup database, the backup database including multiple flat data files, each of the multiple flat data files including data and having a filename;
• appending, by a computing device, the filename of one of the multiple flat data files to an index stored in the computing device;
• changing, by the computing device, a global variable associated with a data loader for the one of the multiple flat data files to the filename;
• loading, by the computing device, the data from the one of the multiple flat data files into a stage database in memory of the computing device;
• and
• transferring, by the computing device, the loaded data in the stage database to a task database, thereby making the data available to queries associated with tasks relying on the loaded data.

A non-transitory computer-readable storage media comprising computer-executable instructions for loading data associated with a load job from a backup database to a task database, which when executed by at least one processor, cause the at least one processor to:

• access a backup database, the backup database including multiple flat files, each of the multiple flat files associated with a load job and having a filename;
• append the filename associated with one of the multiple flat files to an index;
• change a global variable for a data loader associated with the one of the multiple flat files to the filename;
• load data from the one of the multiple flat files into a stage database;
• and
• transfer the data loaded to the stage database to a task database, thereby making the data available to queries at the task database associated with tasks relying on the loaded data.