Dynamic data dependency graph

A system for database visualization comprising:

• a processor;
• and
• a computer-readable medium storing programming instructions for execution by the processor, the programming instructions, upon execution by the processor, causing the system to perform the following operations:
• identifying a data warehouse that includes tables having interdependencies such that data object(s) in each of the respective tables depend on data object(s) in the other tables;
• accessing metadata of the data warehouse, the metadata providing information about the interdependencies of the tables;
• generating, from the metadata, one or more navigational data entity objects;
• detecting an outage affecting at least a first data object in a first one of the tables, wherein dependent data objects in the other tables depend from the first data object in the first table, and wherein the outage triggers one or more secondary events that affect fewer than all of the dependent data objects;
• and
• responsive to detection of the outage, automatically generating a dynamic lineage graph from the one or more navigational data entity objects and displaying the dynamic lineage graph via a graphical user interface (GUI), the dynamic lineage graph representing dependencies between the first data object in the first table and the dependent data objects in the other tables, wherein the dynamic lineage graph visually indicates which of the dependent data objects are impacted by the one or more secondary events.

One or more computer storage devices having programming instructions stored thereon, which, upon execution by a processor of a system, cause the system to perform the following operations:

• identifying a data warehouse that includes tables having interdependencies such that data object(s) in each of the respective tables depend on data object(s) in the other tables;
• accessing metadata of the data warehouse, the metadata providing information about the interdependencies of the tables;
• generating, from the metadata, one or more navigational data entity objects;
• detecting an outage affecting at least a first data object in a first one of the tables, wherein dependent data objects in the other tables depend from the first data object in the first table, and wherein the outage triggers one or more secondary events that affect fewer than all of the dependent data objects;
• and
• responsive to detection of the outage, automatically generating a dynamic lineage graph from the one or more navigational data entity objects and displaying the dynamic lineage graph via a graphical user interface (GUI), the dynamic lineage graph representing dependencies between the first data object in the first table and the dependent data objects in the other tables, wherein the dynamic lineage graph visually indicates which of the dependent data objects are impacted by the one or more secondary events.