Patent ID: 11899650
Assignee: CAPITAL ONE SERVICES, LLC
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 0:
1. A system for facilitating data integrity processes, the system comprising:
one or more processors; and
a non-transitory computer-readable storage medium storing instructions, which when executed by the one or more processors cause the one or more processors to:
access a database table comprising plurality of columns and a plurality of rows;
select a target column of the plurality of columns and a plurality of candidate columns of the plurality of columns;
determine, for each column of the plurality of candidate columns, a first corresponding gini impurity value based on field values in the target column;
select a first column of the plurality of candidate columns based on the first column having a lowest first gini impurity value of the first corresponding gini impurity values;
in response to determining that the lowest first gini impurity value is not zero:
determine, for each column of the plurality of candidate columns other than the first column, a second corresponding gini impurity value based on the field values in the target column; and
select a second column of the plurality of candidate columns based on the first column having a lowest second gini impurity value of the second corresponding gini impurity values; and

in response to determining that the lowest second gini impurity value is zero, generate a data integrity rule for a target feature comprising a mapping that indicates an association between an identifier of the target column and a combination of first and second identifiers of the first column and the second column, wherein the data integrity rule indicates that a row includes valid data when a value in the target column is defined by the combination of values in the first column and the second column.