Database-documentation propagation via temporal log backtracking

A computer-implemented method, comprising:

• scanning, by a computing device, a log comprising a plurality of database queries to identify a subset of the plurality of database queries, wherein each respective database query in the subset is one of:
• a create table query;
• a load table query;
• an insert query;
• or
• an update table query;
• identifying, by the computing device, a database query in the subset, the database query being associated with generating a new table of a database based on information in an existing table of the database;
• generating, by the computing device, based on the database query, a directed acyclic graph (DAG) comprising:
• a first vertex representing the existing table;
• a second vertex representing the new table;
• and
• a directed edge connecting the first vertex to the second vertex, indicating that the new table was generated based on the existing table;
• traversing, by the computing device, the DAG to identify a relationship between the new table and the existing table based on the directed edge;
• determining, by the computing device, that the relationship involves copying an entirety of a column of the existing table to the new table;
• obtaining, by the computing device, documentation associated with the column of the existing table;
• and
• propagating, by the computing device, the documentation to the new table by adding the documentation as metadata of the new table.

A system, comprising one or more processors and a non-transitory computer-readable medium comprising instructions that, when executed by the one or more processors, cause the system to perform a method, the method comprising:

• scanning a log comprising a plurality of database queries to identify one or more database queries of the plurality of database queries, the one or more database queries being associated with generating a new table of a database based on information in an existing table of the database;
• generating, based on the one or more database queries identified during the scanning, a directed acyclic graph (DAG) comprising:
• a first vertex representing the existing table;
• a second vertex representing the new table;
• and
• a directed edge connecting the first vertex to the second vertex, indicating that the new table was generated based on the existing table;
• obtaining documentation associated with the existing table;
• and
• propagating, based on the DAG, at least a subset of the documentation associated with the existing table to the new table.