Data discovery and analysis tool

Apparatus for temporal data lineage analysis comprising:

• a receiver configured to receive a query for data lineage information of a technical data element (TDE), the query comprising two or more structural data parameters for the TDE;
• a processor configured to:
• identify data lineage information associated with the TDE, the data lineage information comprising:
• one or more systems associated with the TDE;
• one or more nodes within each system associated with the TDE, each node comprising a persistent state of the data;
• and
• one or more hops associated with the TDE, each hop comprising movement of the data between two of the nodes;
• the processor further configured to generate a data lineage map for the TDE, the data lineage map configured to show a flow of data lineage information toward the TDE identified by the structural data parameters and a flow of data lineage information from the TDE identified by the structural data parameters, the data lineage map comprising strata corresponding to the one or more systems associated with the TDE, the arrangement of the strata based on sequential inter-system hops for the TDE, the data lineage map comprising:
• a visual indicator showing the presence of a node in the data lineage information and the system associated with the node;
• a visual indicator showing the occurrence of a hop in the data lineage information and the nodes associated with the hop;
• and
• a visual indicator showing whether a transformation occurred at the hop.

An article of manufacture comprising a non-transitory computer usable medium having computer readable program code embodied therein, the code when executed by a processor causes a computer to perform a banking activity, the computer readable program code in said article of manufacture comprising:

• computer readable program code for causing the computer to store:
• a technical data element identifier (“TDEI”);
• a business element identifier (“BEI”);
• an association of one or more TDEIs with the BEI;
• computer readable program code for causing the computer to receive a query for data lineage information corresponding to the business element;
• computer readable program code for causing the computer to:
• identify the BEI corresponding to the business element;
• identify the one or more TDEIs associated with the BEI;
• identify a technical data element (TDE) associated with each TDEI;
• identify data lineage information associated with each TDE, the data lineage information comprising:
• one or more systems associated with the TDE;
• one or more nodes within each system associated with the TDE, each node comprising a persistent state of the data;
• one or more hops associated with the TDE, each hop comprising movement of the data between two of the nodes;
• and
• computer readable program code for causing the computer to generate a data lineage map aggregating the data lineage information for the one or more TDEs, the data lineage map comprising a stratified representation of the aggregated data lineage information, wherein the strata correspond to the one or more systems associated with the one or more TDEs and the arrangement of the strata is based on sequential inter-system hops for the one or more TDEs, the data lineage map further comprising:
• a visual indicator showing the presence of a node in the data lineage information and the system associated with the node;
• a visual indicator showing the occurrence of a hop in the data lineage information and the nodes associated with the hop;
• and
• a visual indicator showing whether a transformation occurred at the hop.