US 12,141,133 B2
Systems and methods for analyzing report infrastructure health
Parul Sethi, Frisco, TX (US); Min Fang, Plano, TX (US); Wayne Zhen Yann Wong, Carrollton, TX (US); and Christopher Kim, Frisco, TX (US)
Assigned to CAPITAL ONE SERVICES, LLC, McLean, VA (US)
Filed by Capital One Services, LLC, McLean, VA (US)
Filed on Jul. 14, 2022, as Appl. No. 17/864,587.
Prior Publication US 2024/0020301 A1, Jan. 18, 2024
Int. Cl. G06F 16/242 (2019.01); G06F 16/22 (2019.01); G06F 16/2455 (2019.01); G06F 16/28 (2019.01)
CPC G06F 16/2433 (2019.01) [G06F 16/2282 (2019.01); G06F 16/2455 (2019.01); G06F 16/284 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A report management device, comprising:
one or more processors; and
memory in communication with the one or more processors and storing instructions that, when executed by the one or more processors, are configured to cause the report management device to:
extract a database table name for each of a plurality of database tables identified in a plurality of structured query language (SQL) queries defined in report data maintained in a stored repository, wherein the SQL queries are configured to communicate with one or more stored databases to facilitate generation of a report;
analyze each of the SQL queries to identify one or more driver tables;
analyze report metadata maintained in the stored repository to identify one or more required tables of the plurality of database tables;
store the database table names in a table inventory and mark in the table inventory each of the database table names associated with one of the driver tables or one of the required tables as required to be current for accuracy of the report;
for each of the SQL queries comprising a target table to which a result of the SQL query is to be inserted, extract one or more elements and one or more source table names for one or more source tables from which source data for the SQL query is to be retrieved and store in the table inventory an association of the elements and source table names with a first one of the database table names corresponding to the target table, wherein the elements correspond to columns of the source tables;
determine whether a failed table of the plurality of database tables is one of the one or more driver tables or one of the one or more required tables based on the marking in the table inventory, when the report was not executed successfully in response to a request to generate the report;
generate lineage data based on the association in the table inventory, wherein the lineage data reflects interrelationships of the plurality of database tables utilized to generate the report; and
generate and output for display a user interface with a graphical representation of the lineage data and an indication of the failed table and one or more of the source tables for the failed table.