US 12,346,316 B2
Knowledge graph generation for data warehouse
Amit Aggarwal, Los Altos, CA (US)
Assigned to DataIris Platform, Inc., Palo Alto, CA (US)
Filed by Datalris Platform, Inc., Los Altos, CA (US)
Filed on Mar. 22, 2023, as Appl. No. 18/188,059.
Claims priority of provisional application 63/484,302, filed on Feb. 10, 2023.
Prior Publication US 2024/0273092 A1, Aug. 15, 2024
Int. Cl. G06F 16/24 (2019.01); G06F 16/22 (2019.01); G06F 16/242 (2019.01); G06F 16/2452 (2019.01); G06F 16/2453 (2019.01)
CPC G06F 16/243 (2019.01) [G06F 16/2246 (2019.01); G06F 16/24522 (2019.01); G06F 16/24539 (2019.01)] 18 Claims
OG exemplary drawing
 
1. A method for accessing one or more databases comprising:
receiving, by a computing device, a plurality of queries to the one or more databases;
creating, by the computing device, a plurality of nodes and a plurality of connections among the plurality of nodes according to the plurality of queries, wherein each node of the plurality of nodes represents an object of a plurality of objects referenced in the plurality of queries and wherein each connection of the plurality of connections represents a relationship between two objects of the plurality of objects in the plurality of queries;
processing, by the computing device, at least one of data stored in the one or more databases and one or more schemas of the one or more databases to identify first nodes of the plurality of nodes that represent dimensions of second nodes of the plurality of nodes;
assigning, by the computing device, names to at least the second nodes according to at least one of identifiers of the objects represented by the second nodes and content of the objects represented by the second nodes; and
for each query of the plurality of queries:
determining a frequency of occurrence of each query; and
assigning a score to each node of the plurality of nodes and each connection of the plurality of connections representing each query according to the frequency of occurrence.