	US 11,868,217 B2
	Selective database data rollback
Joseph Kessler, Grayslake, IL (US)
Assigned to CDW LLC, Vernon Hills, IL (US)
Filed by CDW LLC, Vernon Hills, IL (US)
Filed on Oct. 24, 2022, as Appl. No. 17/972,556.
Application 17/972,556 is a division of application No. 16/688,698, filed on Nov. 19, 2019, granted, now 11,481,285.
Prior Publication US 2023/0059184 A1, Feb. 23, 2023
Int. Cl. G06F 11/14 (2006.01); G06F 16/23 (2019.01); G06F 16/22 (2019.01)

CPC G06F 11/1469 (2013.01) [G06F 16/2282 (2019.01); G06F 16/2379 (2019.01); G06F 2201/84 (2013.01)]

20 Claims

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.