Granted Patent B1

US 12,411,895 · App. 18/776,070 · Granted Sep 9, 2025

Inventors: Prasad V. Pondicherry (Plano, TX); Ravinderjit Singh (Woodstock, MD)

Assignee: Wells Fargo Bank, N.A.

G06F16/906G06F16/215G06F16/24564

Abstract

Claims (36)

1. A computer system for executing data quality rules, the computer system comprising:

one or more processors; and

non-transitory computer-readable storage media encoding instructions which, when executed by the one or more processors, causes the computer system to:

receive a plurality of rules;

group the plurality of rules into one or more categories of rules;

determine a category of the one or more categories of rules to execute based on a scheduling trigger;

request execution of each rule of the category by a database;

receive, from the database, output from execution of the each rule of the category;

concatenate values from the output to form concatenated values;

deconstruct the concatenated values to generate a trend report indicating success rates across versions of the plurality of rules;

generate a new version of at least one rule of the plurality of rules; and

automatically adjust the new version of the at least one rule based on the trend report.

2. The computer system of claim 1 , wherein the trend report includes a success rate and a failure rate of each version of the plurality of rules.

3. The computer system of claim 1 , wherein the scheduling trigger is a period of time.

4. The computer system of claim 1 , wherein the scheduling trigger is an occurrence of an event.

5. The computer system of claim 4 , wherein the event is a reception of additional data.

6. The computer system of claim 1 , comprising further instructions which, when executed by the one or more processors, causes the computer system to schedule the execution of the one or more categories of rules.

7. The computer system of claim 1 , wherein the plurality of rules is grouped into the one or more categories of rules further based on executing on a same data set.

8. The computer system of claim 1 , comprising further instructions which, when executed by the one or more processors, causes the computer system to receive a rule roster that include specified rules that are to be executed.

9. A method for executing data quality rules, the method comprising:

receiving a plurality of rules;

grouping the plurality of rules into one or more categories of rules;

determining a category of the one or more categories of rules to execute based on a scheduling trigger;

requesting execution of each rule of the category by a database;

storing output from execution of each rule of the category;

concatenating values from the output to form concatenated values;

deconstructing the concatenated values to generate a trend report indicating success rates across versions of the plurality of rules;

generating a new version of at least one rule of the plurality of rules; and

automatically adjusting the new version of the at least one rule based on the trend report.

10. The method of claim 9 , wherein the output is stored in the database.

11. The method of claim 9 , wherein the output is stored in a device external to the database.

12. The method of claim 9 , wherein the trend report includes a success rate and a failure rate of each version of the plurality of versions of the rules.

13. The method of claim 9 , wherein the scheduling trigger is a period of time.

14. The method of claim 9 , wherein the scheduling trigger is an occurrence of an event.

15. The method of claim 14 , wherein the event is a reception of additional data.

16. The method of claim 9 , further comprising scheduling execution of the one or more categories of rules.

Assignments (2)

References Cited (13)