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

Claim 18:
19. A computer-readable medium having stored thereon computer-executable instructions that, when executed by one or more processors, cause a computer to:
for each column c1 in a first table,
for each column c2 in a second table,
compute 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,
generate 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, identify the column c2 in the second table as a foreign key of the column c1 in the first table.