IP Library › Granted Patent US 12,405,967
Granted Patent B2
US 12,405,967 · App. 17/697,705 · Granted Sep 2, 2025

System and method for generating a network graph from analytic artifacts in an analytics environment

Inventors: Kalyan Beemanapalli (Eden Prairie, MN); Gustavo Alejandro Cruz Silva (Jalisco, MX); Nikhil Surve (Pleasanton, CA); Kaijing Hu (Wuhan, CN)
Assignee: Oracle International Corporation
G06F16/26G06F16/254G06F16/283
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 12,405,967
App. No.
17/697,705
Granted
Sep 2, 2025
Kind
B2
Abstract

In accordance with an embodiment, described herein is a system and method for providing a network-visualization browser extension in an analytics environment. An analytic applications environment can be provided by, or otherwise operate at, a computer system providing access to a data warehouse, or data warehouse instance. The system is adapted for generating a network graph from analytic artifacts, including display of one or more dataflows as dataflow constellation visualizations that illustrates the dataflows and a lineage or other relationship information. The systems and methods disclosed herein can provide tools to provide insights for users of an analytics environment with regard to the users' analytic artifacts and relationships among the same.

Claims (60)

1. A system for generating a network graph from analytic artifacts in an analytics environment, comprising:

a computer comprising a microprocessor; and

an analytics applications environment at the computer;

wherein the microprocessor is configured to perform steps comprising:

providing a connection from the analytics applications environment to a plurality of metadata sources;

gathering, at the analytics applications environment and via the connection to the plurality of metadata sources, and from the plurality of metadata sources, metadata associated with analytic artifacts;

converting the gathered metadata associated with analytic artifacts to a format usable within a directed graph;

determining, from the gathered metadata, a plurality of nodes and a plurality of edges, each of the plurality of edges defining a relationship between at least two of the plurality of nodes, said determining including determining a type of relationship for each of the determined plurality of edges;

assigning each of the plurality of determined nodes a name and a node type based upon the gathered metadata, wherein a first set of the plurality of determined nodes are assigned a type based upon an automatic determination by the analytics application environment, wherein each of the plurality of nodes are respectively associated with a set of properties, wherein each set of properties are customizable based upon the assigned node type;

generating, based upon the determined plurality of nodes and the plurality of edges, a directed graph, the directed graph comprising the determined plurality of nodes and the determined plurality of edges;

displaying, as an interactive display, all or a portion of the generated directed graph via a user interface, said displaying further comprising an indication of each of the determined type of relationship for each of the determined plurality of edges, said display further comprising, as selectable options, an indication of each of the assigned node types assigned to each node and the respective set of properties for each node, wherein said indication of each assigned node type is displayed upon an indication of a selection of a node;

wherein access to the displayed portion of the generated directed graph, including the determined plurality of nodes and the determined plurality of edges, is restricted via an authentication level of a user accessing the displayed portion of the generated directed graph; and

wherein, based upon the connection, two of the plurality of determined nodes are determined as nearest neighbors, and, based upon said determination of the two of the plurality of nodes, a visualization comprising all artifacts to which the two nearest neighbor nodes have shared access to is displayed.

2. The system of claim 1 , the steps further comprising:

receiving an indication of a user instruction via the user interface; and

modifying the display of the generated directed graph at the user interface.

3. The system of claim 1 , wherein the metadata source comprises a data visualization.

4. The system of claim 1 , wherein the metadata source comprises a metadata repository.

5. The system of claim 1 ,

wherein at least a set of the determined plurality of edges indicates a directionality between two of the plurality of determined nodes; and

wherein such directionality is displayed via the user interface.

6. The system of claim 1 ,

wherein the display of the all or a portion of the generated graph is displayed via a web-browser interface.

7. A method for generating a network graph from analytic artifacts in an analytics environment, comprising:

providing a computer comprising a microprocessor;

providing, at the computer, an analytics applications environment;

providing a connection from the analytics applications environment to a plurality of metadata sources;

gathering, at the analytics applications environment and via the connection to the plurality of metadata sources, and from the plurality of metadata sources, metadata associated with analytic artifacts;

converting the gathered metadata associated with analytic artifacts to a format usable within a directed graph;

determining, from the gathered metadata, a plurality of nodes and a plurality of edges, each of the plurality of edges defining a relationship between at least two of the plurality of nodes, said determining including determining a type of relationship for each of the determined plurality of edges;

assigning each of the plurality of determined nodes a name and a node type based upon the gathered metadata, wherein a first set of the plurality of determined nodes are assigned a type based upon an automatic determination by the analytics application environment, wherein each of the plurality of nodes are respectively associated with a set of properties, wherein each set of properties are customizable based upon the assigned node type;

generating, based upon the determined plurality of nodes and the plurality of edges, a directed graph, the directed graph comprising the determined plurality of nodes and the determined plurality of edges;

displaying, as an interactive display, all or a portion of the generated directed graph via a user interface, said displaying further comprising an indication of each of the determined type of relationship for each of the determined plurality of edges, said display further comprising, as selectable options, an indication of each of the assigned node types assigned to each node and the respective set of properties for each node, wherein said indication of each assigned node type is displayed upon an indication of a selection of a node;

wherein access to the displayed portion of the generated directed graph, including the determined plurality of nodes and the determined plurality of edges, is restricted via an authentication level of a user accessing the displayed portion of the generated directed graph; and

wherein, based upon the connection, two of the plurality of determined nodes are determined as nearest neighbors, and, based upon said determination of the two of the plurality of nodes, a visualization comprising all artifacts to which the two nearest neighbor nodes have shared access to is displayed.

8. The method of claim 7 , further comprising:

receiving an indication of a user instruction via the user interface; and

modifying the display of the generated directed graph at the user interface.

9. The method of claim 7 , wherein the metadata source comprises a data visualization.

10. The method of claim 7 , wherein the metadata source comprises a metadata repository.

11. The method of claim 7 ,

wherein at least a set of the determined plurality of edges indicates a directionality between two of the plurality of determined nodes; and

wherein such directionality is displayed via the user interface.

12. A non-transitory computer readable storage medium having instructions thereon for generating a network graph from analytic artifacts in an analytics environment, which when read and executed cause a computer to perform steps comprising:

providing a computer comprising a microprocessor;

providing, at the computer, an analytics applications environment;

providing a connection from the analytics applications environment to a plurality of metadata sources;

gathering, at the analytics applications environment and via the connection to the plurality of metadata sources, and from the plurality of metadata sources, metadata associated with analytic artifacts;

converting the gathered metadata associated with analytic artifacts to a format usable within a directed graph;

determining, from the gathered metadata, a plurality of nodes and a plurality of edges, each of the plurality of edges defining a relationship between at least two of the plurality of nodes, said determining including determining a type of relationship for each of the determined plurality of edges;

assigning each of the plurality of determined nodes a name and a node type based upon the gathered metadata, wherein a first set of the plurality of determined nodes are assigned a type based upon an automatic determination by the analytics application environment, wherein each of the plurality of nodes are respectively associated with a set of properties, wherein each set of properties are customizable based upon the assigned node type;

generating, based upon the determined plurality of nodes and the plurality of edges, a directed graph, the directed graph comprising the determined plurality of nodes and the determined plurality of edges;

displaying, as an interactive display, all or a portion of the generated directed graph via a user interface, said displaying further comprising an indication of each of the determined type of relationship for each of the determined plurality of edges, said display further comprising, as selectable options, an indication of each of the assigned node types assigned to each node and the respective set of properties for each node, wherein said indication of each assigned node type is displayed upon an indication of a selection of a node;

wherein access to the displayed portion of the generated directed graph, including the determined plurality of nodes and the determined plurality of edges, is restricted via an authentication level of a user accessing the displayed portion of the generated directed graph; and

wherein, based upon the connection, two of the plurality of determined nodes are determined as nearest neighbors, and, based upon said determination of the two of the plurality of nodes, a visualization comprising all artifacts to which the two nearest neighbor nodes have shared access to is displayed.

13. The non-transitory computer readable storage medium of claim 12 , the steps further comprising:

receiving an indication of a user instruction via the user interface; and

modifying the display of the generated directed graph at the user interface.

14. The non-transitory computer readable storage medium of claim 12 , wherein the metadata source comprises a data visualization.

15. The non-transitory computer readable storage medium of claim 12 , wherein the metadata source comprises a metadata repository.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Mar 22, 2022
From: BEEMANAPALLI, KALYAN; CRUZ SILVA, GUSTAVO ALEJANDRO; SURVE, NIKHIL; HU, KAIJING
To: ORACLE INTERNATIONAL CORPORATION
Reel/Frame 059345/0257 →
Continuity (1)
Related Publication 20230297586A1 · Sep 21, 2023
References Cited (9)
US 9172621B1 · Dippenaar · 2015 [cited by examiner]
US 20200169565A1 · Badawy · 2020 [cited by examiner]
US 20210019325A1 · Edge · 2021 [cited by examiner]
US 20220188689A1 · Gunawardana · 2022 [cited by examiner]
US 20230032686A1 · Williams · 2023 [cited by examiner]
Neo4j, Inc. “Graph Database Visualization Graph Exploration & Collaboration”, © 2021, 11 pages, retrieved on Dec. 3, 2021 from: <https://neo4j.com/product/bloom/>. [cited by applicant]
Neo4j, Inc. “Graph Visualization Tools—Developer Guides”, © 2021, 7 pages, retrieved on Dec. 3, 2021 from: <https://neo4j.com/developer/tools-graph-visualization/>. [cited by applicant]
Oracle, Oracle Analytics Cloud, OAC Custom Viz Plugin-Network Graph Visualization—YouTube, 3 pages, retrieved on Dec. 7, 2020 from: <https://www.youtube.com/watch?v=NSGC7Gpmnzo>. [cited by applicant]
Oraclebitechdemo, “The New Network Graph Custom Viz Plugin for Oracle Analytics” Oracle Underground BI & Dataviz, OACS Partner Live Access, Dec. 7, 2020, 3 pages, retrieved from: <https://oracledataviz.blogspot.com/2020… [cited by applicant]