System and method for automated path discovery of joinable tables in database backups

A non-transitory computer-readable medium storing a set of instructions for constructing a join graph from normalized data, the set of instructions comprising:

• one or more instructions that, when executed by one or more processors of a device, cause the device to:
• receive normalized data derived from a plurality of database tables, wherein the normalized data corresponds to columns that have been standardized to a format across the plurality of database tables;
• identify one or more unique identifier columns among the plurality of database tables in the normalized data, wherein each unique identifier column includes values that enable matching of data across the plurality of database tables;
• generate a plurality of graph nodes, each node corresponding to at least one of the plurality of database tables;
• map joinable relationships between the graph nodes based on the unique identifier columns;
• and
• generate a join graph based on the mapped joinable relationships.

A system for constructing a join graph from normalized data comprising:

• one or more processors configured to:
• receive normalized data derived from a plurality of database tables, wherein the normalized data corresponds to columns that have been standardized to a format across the plurality of database tables;
• identify one or more unique identifier columns among the plurality of database tables in the normalized data, wherein each unique identifier column includes values that enable matching of data across the plurality of database tables;
• generate a plurality of graph nodes, each node corresponding to at least one of the plurality of database tables;
• map joinable relationships between the graph nodes based on the unique identifier columns;
• and
• generate a join graph based on the mapped joinable relationships.