Granted Patent B2

US 12,229,113 · App. 17/743,347 · Granted Feb 18, 2025

Inventors: Karthik Kamath (Bengaluru, IN); Satish Kumar Kara (Bengaluru, IN); Nagendra Manchuri (Bengaluru, IN); Tripati Sahu (Bengaluru, IN); Parmesh Kumar (Bengaluru, IN)

Assignee: SAP SE

G06F16/2365

Abstract

Claims (61)

1. A non-transitory machine-readable medium storing a program executable by at least one processing unit of a device, the program comprising sets of instructions for:

querying a plurality of master data sources to retrieve a plurality of sets of master data from the plurality of master data sources, each set of master data in the plurality of sets of master data comprising a set of master data entities, wherein the plurality of master data sources independently manage master data entities, wherein a schema definition specifies at least one master data entity from at least one master data source has an ancestor relationship to at least one other master data entity from at least one other master data source, and wherein said querying is performed at defined time intervals to retrieve most recently operated on master data entities, based on a time of a last request, from each of the plurality of master data sources, wherein the master data sources having ancestor master data entities are queried before master data sources having independent master data entities that are not ancestors of any master data entities;

for each master data entity in each set of master data entities,

determining whether a master data entity is consistent or inconsistent based on a schema definition associated with the plurality of sets of master data, wherein:

upon determining that the master data entity does not have any ancestor master data entities related to the master data entity or upon determining that the master data entity does have any ancestor master data entities related to the master data entity and that the ancestor master data entities exist in a storage configured to store master data received from the plurality of master data sources, determining that the master data entity is consistent; and

upon determining that the master data entity from a first master data source does have any ancestor master data entities from one or more other master data sources related to the master data entity and that the ancestor entities do not exist in the storage, determining that the master data entity is inconsistent,

wherein the schema definition further defines a particular set of master data entities and a set of relationships among the particular set of master data entities;

receiving, from an application, a request for a certain set of master data entities;

based on the plurality of sets of master data entities, determining a subset of the certain set of master data entities, each master data entity in the subset of the certain set of master data entities determined to be consistent; and

providing the subset of the certain set of master data entities to the application.

2. The non-transitory machine-readable medium of claim 1 , wherein retrieving the plurality of sets of master data from the plurality of master data sources comprises retrieving dependent master data entities first.

3. The non-transitory machine-readable medium of claim 2 , wherein retrieving dependent entities first comprises:

determining a first set of master data entities;

determining a second set of master data entities, wherein each master data entity in the second set of master data entities is dependent on a master data entity in the first set of master data entities;

retrieving the second set of master data entities; and

after retrieving the second set of master data entities, retrieving the first set of master data entities.

4. The non-transitory machine-readable medium of claim 1 , wherein the program further comprises a set of instructions for, for each master data entity in each set of master data entities determined to be inconsistent, marking the master data entity as being inconsistent.

5. The non-transitory machine-readable medium of claim 1 , wherein the program further comprises sets of instructions for:

identifying any master data entities previously marked as inconsistent; and

determining whether such master data entities are now consistent based on the plurality of sets of master data.

6. The non-transitory machine-readable medium of claim 1 , wherein retrieving the plurality of sets of master data comprises sending each master data source in the plurality of master data sources a request for master data and a time value indicating a time of a previous request.

7. The non-transitory machine-readable medium of claim 1 , wherein each master data source in the plurality of master data sources is configured to manage a particular set of master data entities.

8. A method comprising:

querying a plurality of master data sources to retrieve a plurality of sets of master data from the plurality of master data sources, each set of master data in the plurality of sets of master data comprising a set of master data entities, wherein the plurality of master data sources independently manage master data entities, wherein a schema definition specifies at least one master data entity from at least one master data source has an ancestor relationship to at least one other master data entity from at least one other master data source, and wherein said querying is performed at defined time intervals to retrieve most recently operated on master data entities, based on a time of a last request, from each of the plurality of master data sources, wherein the master data sources having ancestor master data entities are queried before master data sources having independent master data entities that are not ancestors of any master data entities;

for each master data entity in each set of master data entities,

determining whether a master data entity is consistent or inconsistent based on the schema definition associated with the plurality of sets of master data, and wherein:

upon determining that the master data entity does not have any ancestor master data entities related to the master data entity or upon determining that the master data entity does have any ancestor master data entities related to the master data entity and that the ancestor master data entities exist in a storage configured to store master data received from the plurality of master data sources, determining that the master data entity is consistent; and

upon determining that the master data entity from a first master data source does have any ancestor master data entities from one or more other master data sources related to the master data entity and that the ancestor master data entities do not exist in the storage, determining that the master data entity is inconsistent,

wherein the schema definition further defines a particular set of master data entities and a set of relationships among the particular set of master data entities;

receiving, from an application, a request for a certain set of master data entities;

based on the plurality of sets of master data entities, determining a subset of the certain set of master data entities, each master data entity in the subset of the certain set of master data entities determined to be consistent; and

providing the subset of the certain set of master data entities to the application.

9. The method of claim 8 further comprising, for each master data entity in each set of master data entities determined to be inconsistent, marking the master data entity as being inconsistent.

10. The method of claim 8 further comprising:

identifying any master data entities previously marked as inconsistent; and

determining whether such master data entities are now consistent based on the plurality of sets of master data.

11. The method of claim 8 , wherein retrieving the plurality of sets of master data comprises sending each master data source in the plurality of master data sources a request for master data and a time value indicating a time of a previous request.

12. The method of claim 8 , wherein each master data source in the plurality of master data sources is configured to manage a particular set of master data master data entities.

13. A system comprising:

a set of processing units; and

a non-transitory machine-readable medium storing instructions that when executed by at least one processing unit in the set of processing units cause the at least one processing unit to:

query a plurality of master data sources to retrieve a plurality of sets of master data from the plurality of master data sources, each set of master data in the plurality of sets of master data comprising a set of master data entities, wherein the plurality of master data sources independently manage master data entities, wherein a schema definition specifies at least one master data entity from at least one master data source has an ancestor relationship to at least one other master data entity from at least one other master data source, and wherein said querying is performed at defined time intervals to retrieve most recently operated on master data entities, based on a time of a last request, from each of the plurality of master data sources, wherein the master data sources having ancestor master data entities are queried before master data sources having independent master data entities that are not ancestors of any master data entities;

for each master data entity in each set of master data entities,

determine whether a master data entity is consistent or inconsistent based on a schema definition associated with the plurality of sets of master data, wherein:

upon determining that the master data entity does not have any ancestor master data entities related to the master data entity or upon determining that the master data entity does have any ancestor master data entities related to the master data entity and that the ancestor master data entities exist in a storage configured to store master data received from the plurality of master data sources, determining that the master data entity is consistent; and

upon determining that the master data entity from a first master data source does have any ancestor master data entities from one or more other master data sources related to the master data entity and that the ancestor entities do not exist in the storage, determining that the master data entity is inconsistent,

wherein the schema definition further defines a particular set of master data entities and a set of relationships among the particular set of master data entities;

receive, from an application, a request for a certain set of master data entities;

based on the plurality of sets of master data entities, determine a subset of the certain set of master data entities, each master data entity in the subset of the certain set of master data entities determined to be consistent; and

provide the subset of the certain set of master data entities to the application.

14. The system of claim 13 , wherein retrieving the plurality of sets of master data from the plurality of master data sources comprises retrieving dependent master data entities first.

15. The system of claim 14 , wherein retrieving dependent master data entities first comprises:

determining a first set of master data entities;

determining a second set of master data entities, wherein each master data entity in the second set of master data entities is dependent on a master data entity in the first set of master data entities;

retrieving the second set of master data entities; and

after retrieving the second set of master data entities, retrieving the first set of master data entities.

16. The system of claim 13 , wherein the instructions further cause the at least one processing unit to, for each master data entity in each set of master data entities determined to be inconsistent, mark the master data entity as being inconsistent.

17. The system of claim 13 , wherein the instructions further cause the at least one processing unit to:

identify any master data entities previously marked as inconsistent; and

determine whether such master data entities are now consistent based on the plurality of sets of master data.

18. The system of claim 13 , wherein retrieving the plurality of sets of master data comprises sending each master data source in the plurality of master data sources a request for master data and a time value indicating a time of a previous request.

Assignments (1)

Continuity (1)

References Cited (21)