Invention Grant
- Patent Title: Using temporary tables to store graph algorithm results for a relational database management system
-
Application No.: US17585146Application Date: 2022-01-26
-
Publication No.: US12124448B2Publication Date: 2024-10-22
- Inventor: Hugo Kapp , Laurent Daynes , Vlad Ioan Haprian , Jean-Pierre Lozi , Zhen Hua Liu , Marco Arnaboldi , Sabina Petride , Andrew Witkowski , Hassan Chafi , Sungpack Hong
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Becker Bingham Ledesma LLP
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/2453

Abstract:
An RDBMS specifies a graph algorithm function (GAF) that takes a graph object as input and returns a logical graph object as output. GAFs are used within graph queries to compute temporary and output properties (“GAF-computed properties”), which are live for the duration of the query cursor execution. GAF-computed output properties are accessible in the enclosing graph pattern matching query as though they were part of the input graph object of the GAF. Temporary cursor-duration tables are generated for the query cursor during compilation of a graph query that includes a GAF, and are used to store the GAF-computed properties. Each temporary table corresponds to one of the primary tables of the input graph, and includes, as a foreign key, primary key information from the corresponding primary table.
Public/Granted literature
- US20230267120A1 USING TEMPORARY TABLES TO STORE GRAPH ALGORITHM RESULTS FOR A RELATIONAL DATABASE MANAGEMENT SYSTEM Public/Granted day:2023-08-24
Information query