Patent ID: 11868217
Assignee: CDW LLC
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 0:
1. A computer-implemented method for identifying a key of a database, the method comprising:
for each column c1 in a first table,
for each column c2 in a second table,
computing a column similarity score by comparing a data type of the column c1 and a data type of the column c2,

for each row value r1 in the first table,
for each row value r2 in the second table,
generating a value similarity score comparing the row value r1 with the row value r2, and

when the column similarity score and/or the value similarity score exceed a respective threshold, identifying the column c2 in the second table as a foreign key of the column c1 in the first table.