System and method for generating a digital backup of database applications to allow join operations

A non-transitory computer-readable medium storing a set of instructions for generating a digital backup of database applications to allow join operations, the set of instructions comprising:

• one or more instructions that, when executed by one or more processors of a device, cause the device to:
• access a plurality of database applications hosted on a plurality of virtual machines;
• export data stored in the database applications to a plurality of files, each file utilizing a column-oriented storage format;
• generate a joinable backup by at least computing searchable values for each table in the plurality of database applications;
• search for joinable database tables in the joinable backup;
• and
• generate a digital backup of the database application based on the plurality of files and the joinable backup, wherein the digital backup includes at least a list of joinable database tables.

A system for generating a digital backup of database applications to allow join operations comprising:

• one or more processors;
• and a memory to store instructions, the instructions are executed by the one or more processors to:
• access a plurality of database applications hosted on a plurality of virtual machines;
• export data stored in the database applications to a plurality of files, each file utilizing a column-oriented storage format;
• generate a joinable backup by at least computing searchable values for each table in the plurality of database applications;
• search for joinable database tables in the joinable backup;
• and
• generate a digital backup of the database application based on the plurality of files and the joinable backup, wherein the digital backup includes at least a list of joinable database tables.