Patent Document ID: 20140089255
Application ID: 13832698
Patent Status: 0

Claim One:
1. A computer implemented method for foreign key (FK) identification in a databases management system, the method comprising: computing a threshold value for each of a primary key-foreign key (PK-FK) pair of a superset of PK-FK, wherein the threshold value is based on a standard principle of FK column; generating a sub-set of PK-FK pair based on comparison of the threshold value and a predefined threshold value, wherein the subset of PK-FK pair is a subset of the superset of PK-FK pair, and wherein the predefined threshold value is indicative of an acceptance criterion; determining a conformance score for each of the PK-FK pair of the subset of PK-FK pair, wherein the conformance score is based on deviations between Cumulative Probability Distribution (CPD) values of PK and CPD of FK for each PK-FK pair of the sub-set of PK-FK pairs; and comparing the conformance score of the each PK-FK pair of the sub-set of PK-FK pairs with a predetermined acceptability index, wherein the predetermined acceptability index is indicative of an acceptance of at least one positive FK from the set of PK-FK pairs.