Invention Grant
- Patent Title: Graph processing system that can define a graph view from multiple relational database tables
-
Application No.: US15096034Application Date: 2016-04-11
-
Publication No.: US10339179B2Publication Date: 2019-07-02
- 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 Palermo Becker Bingham LLP
- Main IPC: G06F16/90
- IPC: G06F16/90 ; 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
- US20170293697A1 GRAPH PROCESSING SYSTEM THAT CAN DEFINE A GRAPH VIEW FROM MULTIPLE RELATIONAL DATABASE TABLES Public/Granted day:2017-10-12
Information query