US 10,311,155 B2Granted

Dynamic master record selection

AssigneeSap SE

InventorsRonald Dupey, Jeffrey Woody, Prasanthi Thatavarthy, Ryan Champlin, Chad Taylor

Life of this patent

Estimating the term…

Loading patent…

Abstract

A system includes identification of a group of records of a plurality of records of a database table associated with a plurality of columns, each of the plurality of records including zero or one value for each column, determination of a plurality of rules, each rule associated with one or more of the plurality of columns and for determining a record from which to select values for the associated one or more columns, evaluation of each of the plurality of rules to determine, for each rule, a record of the group of records, and determination of a first record of the group of records based on the record determined for each rule.

Claims15

Dependent claims

A system comprising:

a first memory storing a database table associated with a plurality of columns and comprising a plurality of records, each of the plurality of records including zero or one value for each column;
a second memory storing processor-executable process steps;
and
a processor to execute the processor-executable process steps to cause the system to:
identify a match group of records of the plurality of records, the records in the match group including data potentially relating to a same object;
determine a plurality of rules, each rule associated with one or more of the plurality of columns and defining criteria for determining a record from which to select values for the associated one or more columns;
evaluate each of the determined plurality of rules to determine, for each rule, a best record of the match group of records based on the criteria defined by each respective rule;
and
determine a first record of the match group of records based on the best records determined for each of the determined plurality of rules, the determination of the first record of the match group of records comprises:
determination of, for each best record of the match group of records, ef a number of rules which were evaluated to determine the best record;
and
determination of the first record as one of the best records which was determined by evaluation of a greatest number of rules.

9 more elements

A computer-implemented method comprising:

identifying a match group of records of a plurality of records of a database table associated with a plurality of columns, each of the plurality of records including zero or one value for each column and the records in the match group including data potentially relating to a same object;
determining a plurality of rules, each rule associated with one or more of the plurality of columns and defining criteria for determining a record from which to select values for the associated one or more columns;
evaluating each of the determined plurality of rules to determine, for each rule, a best record of the match group of records based in the criteria defined by each respective rule;
and
determining a first record of the match group of records based on the best records determined for each of the determined plurality of rules, the determining the first record of the match group of records comprising:
determining of, for each best record of the match group of records, a number of rules which were evaluated to determine the best record;
and
determining the first record as one of the best records which was determined by evaluation of a greatest number of rules.

5 more elements

A non-transitory computer-readable medium storing program code, the program code executable by a computer system to cause the computer system to:

identify a match group of records of a plurality of records of a database table associated with a plurality of columns, each of the plurality of records including zero or one value for each column and the records in the match group including data potentially relating to a same object;
determine a plurality of rules, each rule associated with one or more of the plurality of columns and defining criteria for determining a record from which to select values for the associated one or more columns;
evaluate each of the determined plurality of rules to determine, for each rule, a best record of the match group of records based on the criteria defined by the respective rule;
and
determine a first record of the match group of records based on the best records determined for each of the determined plurality of rules, the determination of the first record of the match group of records comprising:
determination of, for each best record of the match group of records, of a number of rules which were evaluated to determine the best record;
and
determination of the first record as one of the best records which was determined by evaluation of a greatest number of rules.

5 more elements

Dependencies are inferred from the claim text.