Graphical Match Policy for Identifying Duplicative Data

A system comprising:

• a memory;
• and
• at least one processor coupled to the memory and configured to:
• receive, from a visual interface, a selection of a match rule for identifying duplicate records within a database, the match rule comprising a candidate filter and a comparison filter;
• determine one or more candidate attributes of the candidate filter corresponding to one or more columns of the database, wherein the visual interface provides an option for modifying the candidate filter;
• determine one or more comparison attributes of the comparison filter corresponding to one or more columns of the database, wherein the visual interface provides an option for modifying the comparison filter;
• identify a first subset of the records within the database that satisfy the candidate filter, wherein each respective record is evaluated against the candidate filter;
• identify a second subset of the records from the first subset of records that satisfy the comparison filter, wherein each respective record of the first subset of records is evaluated against one or more other records of the first subset of records;
• and
• return, responsive to the received selection from the visual interface, the second subset of records that satisfy both the candidate filter and the comparison filter.

A non-transitory computer-readable device having instructions stored thereon that, when executed by at least one computing device, cause the at least one computing device to perform operations comprising:

• receiving, from a visual interface, a selection of a match rule for identifying duplicate records within a database, the match rule comprising a candidate filter and a comparison filter;
• determining one or more candidate attributes of the candidate filter corresponding to one or more columns of the database, wherein the visual interface provides an option for modifying the candidate filter;
• determining one or more comparison attributes of the comparison filter corresponding to one or more columns of the database, wherein the visual interface provides an option for modifying the comparison filter;
• identifying a first subset of the records within the database that satisfy the candidate filter, wherein each respective record is evaluated against the candidate filter;
• identifying a second subset of the records from the first subset of records that satisfy the comparison filter, wherein each respective record of the first subset of records is evaluated against one or more other records of the first subset of records;
• and
• returning, responsive to the received selection from the visual interface, the second subset of records that satisfy both the candidate filter and the comparison filter.