公开(公告)号：US20170293697A1

公开(公告)日：2017-10-12

申请号：US15096034

申请日：2016-04-11

Applicant: Oracle International Corporation

Inventor： SIHAM YOUSHI ,  SUNGPACK HONG ,  Alexander Weld ,  Korbinian Schmid ,  Hassan Chafi

IPC: G06F17/30

CPC classification number: G06F16/9024 ,  G06F16/25 ,  G06F16/84 ,  G06F16/90335

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.