Invention Grant
- Patent Title: Optimization of database sequence of joins for reachability and shortest path determination
-
Application No.: US17939525Application Date: 2022-09-07
-
Publication No.: US11720564B2Publication Date: 2023-08-08
- Inventor: Daniele Pini , Giovanni Tumarello , Renaud Delbru
- Applicant: Sindice Limited
- Applicant Address: IE Galway
- Assignee: Sindice Limited
- Current Assignee: Sindice Limited
- Current Assignee Address: IE Galway
- Agency: Warner Norcross + Judd LLP
- Priority: EP 161921 2020.03.09
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/2453 ; G06F16/22 ; G06F16/2455 ; G06F16/248

Abstract:
A method, system and computer program product are disclosed for determining a shortest path between two nodes of a graph, where the graph is represented in one or more tables of a relational database as a plurality of records identifying edges between pairs of connected nodes in the graph. A request specifies a source node (or set of source nodes), a target node (or set of target nodes) and a maximum path length L. Each path length l, from 1 to L, is iteratively tested by first generating a query comprising a sequence of join operations for that path length, and secondly decomposing the join operations into a sequence of one or more tree-structured queries comprising semi-join operations. Each tree-structured query when executed as a sequence of semi-join operations will return either an empty result set, indicating that no shortest path exists at that path length, or a non-empty result set which identifies all edges at step k of each shortest path of length l, where 1≤k≤l. If all of the tree-structured queries for a path length l return non-empty result sets, the shortest paths of length l can be constructed from the result sets with each result set specifying the edges at a particular step along the shortest path.
Public/Granted literature
- US20220414098A1 OPTIMIZATION OF DATABASE SEQUENCE OF JOINS FOR REACHABILITY AND SHORTEST PATH DETERMINATION Public/Granted day:2022-12-29
Information query