公开(公告)号：US20180137158A1

公开(公告)日：2018-05-17

申请号：US15350350

申请日：2016-11-14

Applicant: SAP SE

Inventor： Florian Hoffmann ,  José Prados

IPC: G06F17/30 ,  G06F3/0484

CPC classification number: G06F16/2282 ,  G06F16/221 ,  G06F16/24564

Abstract: Provided are devices and methods for automated detection of foreign keys linking database tables together. In one example, a device includes a processor that receives a plurality of tables of data, and processes an automated foreign key learning application with respect to the plurality of tables. According to various embodiments, the foreign key learning application identifies at least one foreign key that links a list of columns of a first table to a list of columns of a second table. Furthermore, an output may display a user interface including an identification of the foreign key, the first table, and the second table. Based on the system and methods described herein, the detection of foreign keys may be performed automatically instead of by manual user input thus saving significant time and expense.