Multistep master data cleansing in operative business processes

• US 20060064456A1
• Filed: 09/17/2004
• Published: 03/23/2006
• Est. Priority Date: 09/17/2004
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Kalthoff, Wolfgang, Kuestner, Oliver, Wiederspohn, Joerg
• Granted Patent: US 7,587,423 B2
• Time in Patent Office: Days
• US Class Current: 709/201
• CPC Class Codes: H04L 67/1095 Replication or mirroring of data, e.g. scheduling or transport for data synchronisation between network nodes
• CPC Class Codes: H04L 67/288 Distributed intermediate devices, i.e. intermediate devices for interaction with other intermediate devices on the same level
• CPC Class Codes: H04L 67/564 Enhancement of application control based on intercepted application data
• CPC Class Codes: H04L 67/5682 Policies or rules for updating, deleting or replacing the stored data
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

Proliferation of duplicative master data in a master data server is prevented. Data is received from a first client computer system at a master data server that includes a data store for master data used by the first client computer system and a second client computer system. Preliminary tests are run to determine whether the data received from the first client computer system are duplicative of master data in the data store. The received data are in the data store as master data and distributed to the second client computer system if the preliminary tests do not determine that the received data are duplicative of master data in the data store. Additional tests are run after distribution of the received data to the second client computer system to determine whether the data received from the first client computer system are duplicative of master data in the data store.

Claims

1. A method for preventing proliferation of duplicative master data in a master data server, the method comprising:

receiving data from a first client computer system at a master data server, the master data server including a data store for master data used by the first client computer system and a second client computer system;

running preliminary tests to determine whether the data received from the first client computer system are duplicative of a portion of the master data stored in the data store;

storing the received data in the data store as master data and distributing the received data to the second client computer system if the preliminary tests do not determine that the received data are duplicative of a portion of the master data stored in the data store; and

running additional tests after distribution of the received data to the second client computer system to determine whether the data received from the first client computer system are duplicative of a portion of the master data stored in the data store.

2. The method of claim 1, further comprising cleansing the portion of the master data stored in the data store that is duplicative of the received data when the preliminary tests or the additional tests determine that the received data are duplicative of a portion of the master data stored in the data store.

3. The method of claim 2, wherein cleansing the portion of the master data stored in the data store that is duplicative of the received data comprises:

deleting the portion of the master data stored in the data store that is duplicative of the received data; and

storing the received data in the data store as master data.

4. The method of claim 2, wherein cleansing the portion of the master data stored in the data store that is duplicative of the received data comprises discarding the received data.

5. The method of claim 2, wherein cleansing the portion of the master data stored in the data store that is duplicative of the received data comprises setting attributes of the received data and the duplicative portion of the stored master data to a common value when the attributes do not have literally matching values between the received data and the duplicative portion of the stored master data.

6. The method of claim 2, wherein cleansing the portion of the master data stored in the data store that is duplicative of the received data comprises:

storing the received data in the data store as master data; and

causing the received data to refer to the duplicative portion.

7. The method of claim 1 wherein data received from the first client computer system are created or modified by the first client computer system, and further comprising:

prior to receiving data from the first client computer system, storing master data on the first client computer system and running preliminary tests to determine whether the created or modified data is duplicative of a portion of the master data stored on the first client computer system; and

transmitting to the master data server only the created portion or modified portion of the data that is not duplicative of the portion of the master data that is stored on the first client computer system.

8. The method of claim 1 wherein data distributed to the second client computer system are stored and used by the second client computer system, and further comprising:

after distributing the received data to the second client computer system, storing the received data as master data on the second client computer system and running additional tests to determine whether the received data is duplicative of a portion of the master data stored on the second client computer system; and

using only the portion of the received data that is not duplicative of the portion of the master data that is stored on the second client computer system.

9. The method of claim 1, wherein:

running preliminary tests to determine whether the data received from the first client computer system are duplicative of a portion of the master data stored in the data store comprises running the preliminary tests to definitively determine whether the received data are duplicative of a portion of the stored master data within a maximum allowable amount of time;

storing the received data in the data store comprises storing the received data in the data store when the preliminary tests do not definitively determine that the received data are duplicative of a portion of the stored master data within the maximum allowable amount of time; and

distributing the received data to the second client computer system comprises distributing the received data to the second client computer system when the preliminary tests do not definitively determine that the received data are duplicative of a portion of the stored master data within the maximum allowable amount of time.

10. The method of claim 9, further comprising cleansing the portion of the stored master data that are duplicative of the received data when the preliminary tests definitively determine that the received data are duplicative of a portion of the stored master data within the maximum allowable amount of time.

11. The method of claim 9, further comprising indicating that a later determination of whether the received data are duplicative of a portion of the master data stored in the data store is necessary when the preliminary tests do not definitively determine that the received data are duplicative of a portion of the stored master data within the maximum allowable amount of time.

12. The method of claim 11, further comprising enabling a user to manually indicate whether the received data are duplicative of a portion of the stored master data when an indication that a later determination of whether the received data are duplicative of a portion of the stored master data is necessary is received.

13. The method of claim 12, wherein enabling a user to manually indicate whether the received data are duplicative of a portion of the stored master data comprises:

enabling a user to identify a portion of the master data stored in the data store that is duplicative of the received data; and

cleansing the portion of the master data in the data store that is duplicative of the received data.

14. The method of claim 1 wherein running the additional tests comprises accessing an external service to verify a determination of whether the data received from the first client computer system is duplicative of a portion of the master data stored in the data store.

15. The method of claim 14 wherein the external service is a web-based service.

16. A computer program product tangibly embodied in an information carrier, the computer program product including instructions that, when executed, result in at least the following:

receiving data from a first client computer system at a master data server, the master data server including a data store for master data used by the first client computer system and a second client computer system;

running preliminary tests to determine whether the data received from the first client computer system are duplicative of a portion of the master data stored in the data store;

storing the received data in the data store as master data and distributing the received data to the second client computer system if the preliminary tests do not determine that the received data are duplicative of a portion of the master data stored in the data store; and

running additional tests after distribution of the received data to the second client computer system to determine whether the data received from the first client computer system are duplicative of a portion of the master data stored in the data store.

17. The computer program product of claim 16, further comprising cleansing the portion of the master data stored in the data store that is duplicative of the received data when the preliminary tests or the additional tests determine that the received data are duplicative of a portion of the master data stored in the data store.

18. The computer program product of claim 16 wherein data received from the first client computer system are created or modified by the first client computer system, and further comprising:

prior to receiving data from the first client computer system, storing master data on the first client computer system and running preliminary tests to determine whether the created or modified data is duplicative of a portion of the master data stored on the first client computer system; and

transmitting to the master data server only the created portion or modified portion of the data that is not duplicative of the portion of the master data that is stored on the first client computer system.

19. The computer program product of claim 16 wherein data distributed to the second client computer system are stored and used by the second client computer system, and further comprising:

after distributing the received data to the second client computer system, storing the received data as master data on the second client computer system and running additional tests to determine whether the received data is duplicative of a portion of the master data stored on the second client computer system; and

using only the portion of the received data that is not duplicative of the portion of the master data that is stored on the second client computer system.

20. The computer program product of claim 16, wherein:

running preliminary tests to determine whether the data received from the first client computer system are duplicative of a portion of the master data stored in the data store comprises running the preliminary tests to definitively determine whether the received data are duplicative of a portion of the stored master data within a maximum allowable amount of time;

storing the received data in the data store comprises storing the received data in the data store when the preliminary tests do not definitively determine that the received data are duplicative of a portion of the stored master data within the maximum allowable amount of time; and

distributing the received data to the second client computer system comprises distributing the received data to the second client computer system when the preliminary tests do not definitively determine that the received data are duplicative of a portion of the stored master data within the maximum allowable amount of time.

21. The computer program product of claim 20, further comprising cleansing the portion of the stored master data that are duplicative of the received data when the preliminary tests definitively determine that the received data are duplicative of a portion of the stored master data within the maximum allowable amount of time.

22. The computer program product of claim 20, further comprising indicating that a later determination of whether the received data are duplicative of a portion of the master data stored in the data store is necessary when the preliminary tests do not definitively determine that the received data are duplicative of a portion of the stored master data within the maximum allowable amount of time.

23. The computer program product of claim 22, further comprising enabling a user to manually indicate whether the received data are duplicative of a portion of the stored master data when an indication that a later determination of whether the received data are duplicative of a portion of the stored master data is necessary is received.

24. The computer program product of claim 23, wherein enabling a user to manually indicate whether the received data are duplicative of a portion of the stored master data comprises:

enabling a user to identify a portion of the master data stored in the data store that is duplicative of the received data; and

cleansing the portion of the master data in the data store that is duplicative of the received data.

25. The computer program product of claim 16 wherein running the additional tests comprises accessing an external service to verify a determination of whether the data received from the first client computer system is duplicative of a portion of the master data stored in the data store.

26. A system for maintaining consistency among master data that are used by multiple client computer systems, the system comprising:

a first client computer system, the first client computer system being operable to

     1) create or modify data while performing a business function for a business enterprise that operates the first client computer system,

     2) store master data used by the first client computer system, and

     3) transmit the created or modified data; and

a master data server, the master data server being operable to

     1) receive data transmitted by the first client computer system,

     2) store the received data as master data in a local data store,

     3) distribute the master data stored in the data store to other client computer systems that may use the transmitted master data,

     4) run preliminary tests to determine whether the received data are duplicative of a portion of the master data stored in the data store before the master data are distributed,

     5) run additional tests to determine whether the received data are duplicative of a portion of the master data stored in the data store after the master data are distributed.

27. The system of claim 26, wherein the first client computer system is operable to 1) determine whether the created or modified data are duplicative of a portion of the master data stored by the first client computer system, 2) store the created or modified data as master data when the created or modified data are not duplicative of a portion of the stored master data, and 3) transmit the created or modified data when the created or modified data are not duplicative of a portion of the stored master data.

28. The system of claim 26, further comprising a second client computer system, the second client computer system being operable to 1) receive master data from the master data server, 2) store master data used by the second client computer system, 3) determine whether the received master data are duplicative of a portion of the stored master data, 4) store only the received master data that are not duplicative of a portion of the stored master data, and 5) use only the received master data that are not duplicative of a portion of the stored master data while performing a business function for the business enterprise.

29. The system of claim 26, wherein the master data server is operable to enable a user of the master data server to determine whether the received data are duplicative of a portion of the master data stored in the data store such that the master data server may cleanse the portion of the stored master data that is duplicative of the received data.