US 12,007,975 B1
System, method, and computer program for identifying foreign keys between distinct tables
Yaniv Avrashi, Petach Tikva (IL); Gilli Shama, Ra'anana (IL); Irit Shamir, Zichron Yaakov (IL); and Pavel Vodolazov, Petah Tikva (IL)
Assigned to AMDOCS DEVELOPMENT LIMITED, Limassol (CY)
Filed by Amdocs Development Limited, Limassol (CY)
Filed on Oct. 3, 2022, as Appl. No. 17/959,100.
Application 17/959,100 is a continuation of application No. 17/199,287, filed on Mar. 11, 2021, granted, now 11,494,363.
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/22 (2019.01); G06F 16/27 (2019.01); G06F 17/18 (2006.01)
CPC G06F 16/2282 (2019.01) [G06F 16/27 (2019.01); G06F 17/18 (2013.01)] 18 Claims
OG exemplary drawing
 
1. A non-transitory computer readable medium storing computer code executable by a processor to perform a method comprising:
determining a plurality of candidate field combinations between a first table and a second table by:
generating all field combinations between fields of the first table and the second table,
generating a score for each of the field combinations between the first table and the second table, based on one or more parameters, and
selecting one or more field combinations of the plurality of field combinations as the plurality of candidate field combinations, based on the score generated for each of the plurality of field combinations, including:
selecting a field combination as a candidate field combination when the score generated for the field combination exceeds a threshold, or
selecting a predefined number of top scored field combinations as the plurality of candidate field combinations;
performing a statistical analysis of values stored in fields of each candidate field combination of the plurality of the candidate field combinations; and
identifying which candidate field combination of the plurality of candidate field combinations represents foreign keys between the first table and the second table, based on a result of the statistical analysis.