Inferring graph model from data in lake

Abstract

Apparatuses, methods, and computer-readable media infer a graph model from data. The apparatus detects joinable columns within a plurality of columns of source tables in a data lake, the joinable columns defining a plurality of relationships between columns and including columns with an m:m relationship. The apparatus extracts, from the joinable columns, a virtual vertex table represented by a union of corresponding columns that breaks the m:m relationship into two m:1 relationships. The apparatus identifies at least one primary key for each relationship of the plurality of relationships, each relationship defining at least one from-table and one to-table. The apparatus creates a vertex table in the graph model for each source table or virtual vertex table having a primary key. The apparatus creates an edge table in the graph model for each from-table defined in the plurality of relationships.