Machine-assisted key discovery and join generation

US Patent 10,162,881
December 25, 2018

Embodiments are directed towards managing data. Attributes of model fields of a plurality of model objects may be analyzed. If the analysis of the attributes discovers primary key fields in the model objects, the characteristics of the primary keys may be compared with the characteristics of other model objects. If affirmative results of the comparison indicate that one or more foreign key fields may be in the other model objects, one or more relationships that associate the primary key fields with the foreign key fields may be provided. And, a system model may be provided based on the relationships and the model objects that include the primary key fields and the model objects that include the foreign key fields.