Granted Patent B2

US 12,561,297 · App. 18/625,765 · Granted Feb 24, 2026

Inventors: Prasanthi Thatavarthy (Onalaska, WI); Michael Bouska (Onalaska, WI); Jeffrey Woody (Onalaska, WI); Alexander Hammer (La Crescent, MN); Katlin Svendsen (Onalaska, WI)

Assignee: SAP SE

G06F16/215G06F11/0769G06F16/2365

Abstract

Claims (48)

1 . A computer-implemented method comprising:

receiving, by one or more processors, remediation rule definitions comprising a replacement remediation action defining placeholder parameters and conditions for replacing erroneous entries of a plurality of data tables to remedy the erroneous entries of the plurality of data tables;

mapping, by the one or more processors, the remediation rule definitions to the plurality of data tables;

receiving, by the one or more processors, an identification of one or more data tables to be verified;

verifying, by the one or more processors, data of the one or more data tables to identify erroneous entries in the one or more data tables;

selecting, by the one or more processors, using a prediction model, from a plurality of remediation plans comprising applicable remediation rule definitions mapped to the one or more data tables, a remediation plan comprising one or more remediation rule definitions to correct the erroneous entries in each of the one or more data tables, the prediction model being trained to select the remediation plan by optimizing a remediation workflow defining a sequence of replacement of interrelated data entries to remediate the erroneous entries; and

applying, by the one or more processors, the remediation plan to replace the erroneous entries in the one or more data tables with corrected entries according to the sequence of replacement of interrelated data entries.

2 . The computer-implemented method of claim 1 , wherein the remediation rule definitions comprise a link to a glossary entry for custom attributes.

3 . The computer-implemented method of claim 1 , wherein the mapping defines associations between the remediation rule definitions and data table types indicated by metadata of the data tables.

4 . The computer-implemented method of claim 3 , wherein the remediation plans are applied according to a sequence corresponding to a relationship between the data tables defined by the metadata of the data tables.

5 . The computer-implemented method of claim 1 , further comprising:

performing, by the one or more processors, a validation of the corrected entries.

6 . The computer-implemented method of claim 1 , wherein the conditions comprise restrictions supporting a form of replacement remediations.

7 . The computer-implemented method of claim 1 , wherein the placeholder parameters comprise constant parameters corresponding to a column value type or a row value type of a respective erroneous entry.

8 . The computer-implemented method of claim 1 , further comprising:

generating, by the one or more processors, a report indicating corrected entries modified by the remediation plan.

9 . The computer-implemented method of claim 1 , wherein at least one of the remediation rule definitions comprises a first mapping of the remediation rule definitions to a first data table of the plurality of data tables.

10 . The computer-implemented method of claim 9 , further comprising:

identifying, by the one or more processors, a second data table comprising a structure similar to the first data table; and

generating by the one or more processes a recommendation for a second mapping of the remediation rule definitions to the second data table.

11 . A computer-implemented system comprising:

one or more computers; and

one or more computer memory devices interoperably coupled with the one or more computers and having tangible, non-transitory, machine-readable media storing one or more instructions that, when executed by the one or more computers, perform one or more operations comprising:

receiving remediation rule definitions comprising a replacement remediation action defining placeholder parameters and conditions for replacing erroneous entries of a plurality of data tables to remedy the erroneous entries of the plurality of data tables;

mapping the remediation rule definitions to the plurality of data tables;

receiving an identification of one or more data tables to be verified;

verifying data of the one or more data tables to identify erroneous entries in the one or more data tables;

selecting using a prediction model, from a plurality of remediation plans comprising applicable remediation rule definitions mapped to the one or more data tables, a remediation plan comprising one or more remediation rule definitions to correct the erroneous entries in each of the one or more data tables, the prediction model being trained to select the remediation plan by optimizing a remediation workflow defining a sequence of replacement of interrelated data entries to remediate the erroneous entries; and

applying the remediation plan to replace the erroneous entries in the one or more data tables with corrected entries according to the sequence of replacement of interrelated data entries.

12 . The computer-implemented system of claim 11 , wherein the remediation rule definitions comprise a link to a glossary entry for custom attributes.

13 . The computer-implemented system of claim 11 , wherein the mapping defines associations between the remediation rule definitions and data table types indicated by metadata of the data tables.

14 . The computer-implemented system of claim 13 , wherein the remediation plans are applied according to a sequence corresponding to a relationship between the data tables defined by the metadata of the data tables.

15 . The computer-implemented system of claim 11 , wherein the operations further comprise:

performing a validation of the corrected entries.

16 . The computer-implemented system of claim 11 , wherein the conditions comprise restrictions supporting a form of replacement remediations.

17 . The computer-implemented system of claim 11 , wherein the placeholder parameters comprise constant parameters corresponding to a column value type or a row value type of a respective erroneous entry.

18 . The computer-implemented system of claim 11 , wherein the operations further comprise:

generating a report indicating corrected entries modified by the remediation plan.

19 . The computer-implemented system of claim 11 , wherein at least one of the remediation rule definitions comprises a first mapping of the remediation rule definitions to a first data table of the plurality of data tables, wherein the operations further comprise:

identifying a second data table comprising a structure similar to the first data table; and

generating by the one or more processes a recommendation for a second mapping of the remediation rule definitions to the second data table.

20 . A non-transitory computer-readable media encoded with a computer program, the computer program comprising instructions that when executed by one or more computers cause the one or more computers to perform operations comprising:

receiving remediation rule definitions comprising a replacement remediation action defining placeholder parameters and conditions for replacing erroneous entries of a plurality of data tables to remedy the erroneous entries of the plurality of data tables;

mapping the remediation rule definitions to the plurality of data tables;

receiving an identification of one or more data tables to be verified;

verifying data of the one or more data tables to identify erroneous entries in the one or more data tables;

selecting using a prediction model, from a plurality of remediation plans comprising applicable remediation rule definitions mapped to the one or more data tables, a remediation plan comprising one or more remediation rule definitions to correct the erroneous entries in each of the one or more data tables, the prediction model being trained to select the remediation plan by optimizing a remediation workflow defining a sequence of replacement of interrelated data entries to remediate the erroneous entries; and

applying the remediation plan to replace the erroneous entries in the one or more data tables with corrected entries according to the sequence of replacement of interrelated data entries.

Assignments (1)

Continuity (1)

References Cited (33)