US 11,921,785 B2
Inline graph algorithm execution with a relational SQL engine
Hugo Kapp, Zurich (CH); Laurent Daynes, Saint-Ismier (FR); Vlad Ioan Haprian, Zurich (CH); Jean-Pierre Lozi, Zurich (CH); Zhen Hua Liu, San Mateo, CA (US); Marco Arnaboldi, Zurich (CH); Sabina Petride, Tracy, CA (US); Andrew Witkowski, Foster City, CA (US); Hassan Chafi, San Mateo, CA (US); and Sungpack Hong, Palo Alto, CA (US)
Assigned to Oracle International Corporation, Redwood Shores, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on Jan. 25, 2022, as Appl. No. 17/584,262.
Prior Publication US 2023/0252077 A1, Aug. 10, 2023
Int. Cl. G06F 16/901 (2019.01); G06F 16/903 (2019.01)
CPC G06F 16/9024 (2019.01) [G06F 16/90335 (2019.01)] 24 Claims
OG exemplary drawing
 
1. A computer-executed method comprising:
a database management system (DBMS) defining a graph analytics function (GAF);
wherein the GAF is configured to analyze a property graph object structure;
the DBMS maintaining a database that stores a particular property graph object that defines a plurality of vertices and a plurality of edges;
the DBMS executing a query that (a) includes a GAF call over the particular property graph object and (b) utilizes one or more output properties, of a set of GAF output properties computed by the GAF, to produce a result set for the query;
wherein said executing the query comprises:
invoking the GAF over the particular property graph object to produce a set of output property values for the set of GAF output properties;
wherein the set of output property values comprises one or both of: a plurality of edge result values for the plurality of edges or a plurality of vertex result values for the plurality of vertices,
utilizing one or more of the set of output property values to produce the result set for the query; and
the DBMS returning the result set as a result of the query;
wherein the method is performed by one or more computing devices.