Merging of products into a database

• US 7,283,994 B2
• Filed: 09/03/2004
• Issued: 10/16/2007
• Est. Priority Date: 09/15/2003
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Heusermann, Knut
• Primary Examiner(s): Gaffin; Jeffrey
• Assistant Examiner(s): Veillard; Jacques
• Application Number:
  US10/933,259
• Publication Number:
  US 20050065945A1
• Time in Patent Office: 1,138 Days
• Field of Search: 707/3, 707/4, 707/6, 707/10, 707/102, 707/201, 707/203, 711/143, 712/25
• US Class Current: 707/695
• CPC Class Codes: G06F 16/221 Column-oriented storage; Management thereof
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users

Abstract

The invention relates to a method for merging data sets of a data base with data sets of a data base of a data management system. To allow merging without losing relevant data, it is proposed to determine one data set as a merging basis, match data from the data bases to identify matching data sets, create a list of matching data sets, determine data sets within the list as merging partners, and merging the merge partners with the merging basis into a single data set.

Claims

1. A computer-implemented method for merging data sets of a first data base with data sets of a second data base of a data management system, the method comprising:

identifying a data set as a merging basis;

matching data from the first and second data bases to identify a matching data set, wherein the matching data set can be used to identify a merging partner;

determining whether the merging partner and the merging basis are compatible; and

merging the merging partners with the merging basis into a single data set based on the compatibility of the merging partner and the merging basis, wherein the single data set can be accessed by a user.

2. The method of claim 1, wherein the data set includes at least one data block comprising a defined set of product data.

3. The method of claim 1, wherein identifying the data set as the merging basis based on an update status of the data sets of the first and second data bases.

4. The method of claim 3, wherein identifying the data set as the merging basis if the data set exists in the system.

5. The method of claim 4, wherein a identifying the data set as the merging basis if the data set has not been changed.

6. The method of claim 3, wherein identifying the data set as the merging basis if the data set is new.

7. The method of claim 1, further comprising customizing the criteria for identifying the merging basis.

8. The method of claim 1, further comprising defining one or more merging rules that determine the process to be carried out during merging the data sets into one data set.

9. The method of claim 1, further comprising defining one or more merging tasks that determine a status of the merging basis and the merging partner and a relationship of the merging basis and the merging partner to each other.

10. The method of claim 1, further comprising assigning one or more merging rules to one or more merging tasks.

11. The method of claim 10, further comprising customizing the assignment of the merging rules to the merging tasks.

12. The method of claim 1, further comprising:

defining one or more merging tasks;

determining the status of the merging basis and the merging partner and a relationship of the merging basis and the merging partner to each other;

assigning one or more merging rules to one or more merging tasks; and

merging the merging partner with the merging basis according to the assignment of one or more merging rules to the one or more merging tasks into a single data set.

13. The method of claim 12, wherein the merging rules comprise cancelling the merging process.

14. The method of claim 12, wherein the merging rules comprise ignoring the merging partner and continuing with the next merging partner from the list.

15. The method of claim 12, wherein the merging rules comprise not altering the merging basis.

16. The method of claim 12, wherein the merging rules comprise replacing a data block of the merging basis with a data block of the merging partner or adding a data block of the merging partner to the data set of the merging basis.

17. The method of claim 12, wherein the merging rules comprise removing a data block from the merging basis.

18. The method of claim 1, further comprising checking an update indicator of the merging basis, wherein the merging of the data sets is cancelled if the update indicator is set to delete.

19. The method of claim 1, further comprising checking an update indicator of the merging partner, wherein the merging of the data sets is cancelled if the update indicator is set to delete.

20. The method of claim 1, further comprising checking the compatibility of the merging partner with the merging basis based on particular data within the data sets, wherein the merging of the data sets is cancelled if the data sets are incompatible.

21. The method of claim 1, further comprising defining one or more merging tasks that determine the status of the merging basis and the merging partner or the relationship of the merging basis and the merging partner to each other.

22. The method of claim 1, further comprising:

defining one or more merging tasks;

determining the status of the merging basis and the merging partner or the relationship of the merging basis and the merging partner to each other;

assigning one or more merging rules to one or more merging tasks; and

merging the merging partner with the merging basis according to the assignment of one or more merging rules to the one or more merging tasks into a single data set.

23. The method of claim 1, wherein the determination of the compatibility of the merging partner and the merging basis can involve the product types, the object families, or the change orders of the merging partner and the merging basis.

24. A computer program product including instructions that cause a computer, when executed, to provide a method for merging data sets of a first data base with data sets of a second data base of a data management system, the method comprising:

identifying a data set as a merging basis;

matching data from the first and second data bases to identify a matching data set, wherein the matching data set can be used to identify a merging partner;

determining whether the merging partner and the merging basis are compatible; and

merging the merging partners with the merging basis into a single data set based on the compatibility of the merging partner and the merging basis, wherein the single data set can be accessed by a user.

25. The computer program product of claim 24, comprising instructions operable to cause a processor to identify the data set as the merging basis based on an update status of the data sets of the first and second data bases.

26. The computer program product of claim 24, comprising instructions operable to cause a processor to identify the data set as the merging basis if the data set exists in the system.

27. The computer program product of claim 24, comprising instructions operable to cause a processor to identify the data set as the merging basis if the data set has not been changed.

28. The computer program product of claim 24, comprising instructions operable to cause a processor to identify the data set as the merging basis if the data set is new.

29. The computer program product of claim 24, comprising instructions operable to cause a processor to customize the criteria for identifying the merging basis.

30. The computer program product of claim 24, comprising instructions operable to cause a processor to define merging rules determining the process to be carried out during merging the data sets into one data set.

31. The computer program product of claim 24, comprising instructions operable to cause a processor to define merging tasks determining a status of the merging basis and the merging partner and a relationship of the merging basis and the merging partner to each other.

32. The computer program product of claim 24, comprising instructions operable to cause a processor to assign one or more merging rules to one or more merging tasks.

33. The computer program product of claim 24, comprising instructions operable to cause a processor to customize the assignment of the merging rules to the merging tasks.

34. The computer program product of claim 24, comprising instructions operable to cause a processor to:

define one or more merging tasks determining a status of the merging basis and the merging partner and a relationship of the merging basis and the merging partner to each other,

assign one or more merging rules to one or more merging tasks, and

merge the merging partner with the merging basis according to the assignment of one or more merging rules to one or more merging tasks into a single data set.

35. The computer program product of claim 24, comprising instructions operable to cause a processor to cancel the merging process according to merging rules.

36. The computer program product of claim 24, comprising instructions operable to cause a processor to ignore the merging partner and continuing with the next merging partner from the list according to merging rules.

37. The computer program product of claim 24, comprising instructions operable to cause a processor to not alter the merging basis according to merging rules.

38. The computer program product of claim 24, comprising instructions operable to cause a processor to replace a data block of the merging basis with a data block of the merging partner or add a data block of the merging partner to the data set of the merging basis according to merging rules.

39. The computer program product of claim 24, comprising instructions operable to cause a processor to remove a data block from the merging basis according to merging rules.

40. The computer program product of claim 24, comprising instructions operable to cause a processor to check an update indicator of the merging basis and to cancel the merging of the data sets if the update indicator is set to delete.

41. The computer program product of claim 24, comprising instructions operable to cause a processor to check an update indicator of the merging partner and wherein to cancel the merging of the data sets if the update indicator is set to delete.

42. The computer program product of claim 24, comprising instructions operable to cause a processor to check a compatibility of the merging partner with the merging basis based on particular data within the data sets and to cancel the merging of the data sets if the data sets are incompatible.

43. The computer program product of claim 24, comprising instructions operable to cause a processor to define merging tasks determining the status of the merging basis and the merging partner or the relationship of the merging basis and the merging partner to each other.

44. The computer program product of claim 24, comprising instructions operable to cause a processor to:

define merging tasks determining the status of the merging basis and the merging partner or the relationship of the merging basis and the merging partner to each other,

assign merging rules to merging tasks, and

merge the merging partners with the merging basis according to the assignment of merging rules to merging tasks into a single data set.

45. The computer program product of claim 24, comprising instructions operable to cause a processor to define the determining of the compatibility of the merging partner and the merging basis can involve the product types, the object families, or the change orders of the merging partner and the merging basis.

46. A computer program product for merging data sets of a first data base with data sets of a second data base of a data management system with a computer program comprising instructions operable to cause a processor to:

determine one data set as a merging basis;

match data from the first and second data bases to identify matching data sets;

create a list of matching data sets;

determine data sets within the list as merging partners;

check a compatibility of the merging partner with the merging basis based on particular data within the data sets; and

merge the merging partners with the merging basis into a single data set based on the compatibility check, wherein the merging of the data sets are cancelled when the data sets are incompatible and wherein the single data set can be accessed by a user.

47. A data structure associated with a computer readable medium, wherein the data structure can be altered by a computer executing instructions that provide a method for merging data sets of a first data base with data sets of a second data base of a data management system, the method comprising:

identifying a data set as a merging basis;

matching data from the first and second data bases to identify matching data sets, wherein matching data sets can be used to identify a merging partner;

determining whether the merging partner and the merging basis are compatible; and

merging the merging partner with the merging basis into a single data set based on the compatibility of the merging partner and the merging basis, wherein the single data set can be accessed by a user.