公开(公告)号：US10339179B2

公开(公告)日：2019-07-02

申请号：US15096034

申请日：2016-04-11

Applicant: Oracle International Corporation

Inventor： Siham Yousfi ,  Sungpack Hong ,  Alexander Weld ,  Korbinian Schmid ,  Hassan Chafi

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.

公开(公告)号：US10984047B2

公开(公告)日：2021-04-20

申请号：US16431294

申请日：2019-06-04

Applicant: Oracle International Corporation

Inventor： Siham Yousfi ,  Sungpack Hong ,  Alexander Weld ,  Korbinian Schmid ,  Hassan Chafi

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.