Invention Grant
- Patent Title: Graph processing system that can define a graph view from multiple relational database tables
-
Application No.: US16431294Application Date: 2019-06-04
-
Publication No.: US10984047B2Publication Date: 2021-04-20
- Inventor: Siham Yousfi , Sungpack Hong , Alexander Weld , Korbinian Schmid , Hassan Chafi
- 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/901
- IPC: G06F16/901 ; G06F16/25 ; G06F16/84 ; G06F16/903
Abstract:
Techniques are provided for mapping tables and columns of a legacy relational schema into synthetic tables that are dedicated for graph analysis. In an embodiment, a computer receives a mapping of relational tables to node tables and edge tables. The node tables contain columns and rows. The edge tables contain columns and rows. The rows of the node tables and the rows of the edge tables define a graph. Based on the mapping and the relational tables, the computer calculates a value of at least one column of at least one row of the node tables. Based on an execution of a query of the graph, the computer returns the value.
Public/Granted literature
- US20190286662A1 Graph Processing System that can Define A Graph View from Multiple Relational Database Tables Public/Granted day:2019-09-19
Information query
