Techniques for building data lineages for queries
AssigneeCapital One Services, LLC
InventorsSrinivas KUMAR, Aravind BIRUDU, Rajeev TIWARI, Puneet GOYAL
Life of this patent
Estimating the term…
Loading patent…
AssigneeCapital One Services, LLC
InventorsSrinivas KUMAR, Aravind BIRUDU, Rajeev TIWARI, Puneet GOYAL
Estimating the term…
Various embodiments are generally directed to techniques for building data lineages for queries, such as SQL queries. Some embodiments are particularly directed to a lineage tool that is able to construct data lineages in a recursive manner that uses the text of a query to identify dependent tables. In several embodiments, the data lineage tool may parse SQL queries to identify columns and dependent tables, including analyzing interdependent queries used to populate dependent tables and proceeding until the true source of data is identified. In several embodiments, the data lineage tool may utilize the relationships and dependencies to build element and table level lineages.
An apparatus comprising:
A non-transitory computer-readable medium comprising a set of instructions that, in response to execution by a processor circuit, cause the processor circuit to:
A computer-implemented method comprising:
Dependencies are inferred from the claim text.