Classification of data for insertion into a database

• US 20030204540A1
• Filed: 03/21/2003
• Published: 10/30/2003
• Est. Priority Date: 04/29/2002
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Rielau, Serge, Zhu, Biao, Sidle, Richard S., Lapis, George, Cochrane, Roberta J., Pirahesh, Hamid
• Granted Patent: US 7,162,505 B2
• Time in Patent Office: Days
• US Class Current: 707/204
• CPC Class Codes: G06F 16/235 Update request formulation
• CPC Class Codes: G06F 16/24553 of query operations
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users
• CPC Class Codes: Y10S 707/99955 Archiving or backup

Abstract

A method and system for use in a computing environment for selecting a subset of records from a set of records for placement of the subset of records in a plurality of destinations. A group of replica records is formed for a record of the subset of records, and a destination identification is assigned to each replica record, except one, of the group of replica records. A replica record associated with one of the plurality of destinations can be selected and can be placed in the associated destination.

Claims

1. A method for use in a computing environment for selecting a subset of records from a set of records for placement of said subset of records in a plurality of destinations, comprising:

(a) forming a group of replica records for a record of said subset of records; and

(b) assigning a destination identification to each replica record, except one, of said group of replica records.

2. The method of claim 1 wherein said destinations have associated record modification and acceptance rules, and further comprising:

modifying said replica records having destination identification in accordance with record modification rules associated with the respective destinations of said replica records having destination identification.

3. The method of claim 1 further comprising selecting a replica record from said group of replica records satisfying record acceptance rules associated with their respective destinations.

4. The method of claim 3 wherein two replica records remain after said selecting said replica record, and further comprising:

choosing a replica record associated with one of said plurality of destinations.

5. The method of claim 4 further comprising placing said chosen replica record associated with a destination in said associated destination.

6. The method of claim 1 further comprising:

placing said replica records assigned destination identification in their respective destinations.

7. The method of claim 6 wherein said plurality of destinations comprise a plurality of tables.

8. A computer readable medium including program instructions for use with a data processing system having a central processing unit and associated memory, said program instructions for instructing said data processing system to implement a method for selecting a subset of records from a set of records and placing said subset of records in a plurality of destinations, comprising the steps of:

(a) forming a group of replica records for a record of said subset of records; and

(b) assigning a destination identification to each replica record, except one, of said group of replica records.

9. The computer readable medium of claim 8 wherein said destinations have associated record modification and acceptance rules, and wherein the data processing system further performs a step of:

modifying said replica records having destination identification in accordance with record modification rules associated with the respective destinations of said replica records having destination identification.

10. The computer readable medium of claim 8 wherein the data processing system further performs a step of selecting a replica record from said group of replica records satisfying record acceptance rules associated with their respective destinations.

11. The computer readable medium of claim 10 wherein two replica records remain after said selecting said replica record, and wherein the data processing system further performs a step of choosing a replica record associated with one of said plurality of destinations.

12. The computer readable medium of claim 11 wherein the data processing system further performs a step of placing said chosen replica record associated with a destination in said associated destination.

13. The computer readable medium of claim 8 wherein the data processing system further performs a step of placing said replica records assigned destination identification in their respective destinations.

14. The computer readable medium of claim 13 wherein said plurality of destinations comprise a plurality of tables.

15. A data processing system comprising:

a record allocator operatively coupled to said data processing system, said record allocator for allocating a plurality of destinations for a plurality of records from a set of records; and

a record selector operatively coupled to said data processing system, said record selector for selecting a subset of records from said plurality of records for subsequent placement of said selected records in said plurality of destinations, wherein each destination has an associated record modification rule and an associated record acceptance rule.

16. The data processing system of claim 15 further comprising a record former operative to form, for a record of said set of records, a group of replica records and allocating each replica record of said group, except one of said replica records, with a different one of said plurality of destinations, said one of said replica records not associated with any of said plurality of destinations.

17. The data processing system of claim 16 wherein said record selector is operative to assign a destination identification to each replica record of said group of replica records.

18. The data processing system of claim 17 wherein said record selector is operative to modify replica records of said group of replica records in accordance to said record modification rule associated with a destination identification assigned to respective replica records.

19. The data processing system of claim 18 wherein said record selector is operative to select replica records of said group of replicas satisfying said record acceptance rule associated with said destination identification assigned to said respective replica records of said group and selecting said one of said replica records.

20. The data processing system of claim 18 wherein said record selector is operative to choose said replica record associated with one of said plurality of destinations, wherein after said selecting two replica records remain, wherein one of said remaining replica records is said one of said replica records.

21. The data processing system of claim 20 wherein said record selector is operative to place said chosen replica associated with a destination in said associated destination.

22. The data processing system of claim 15 wherein said plurality of destinations is a plurality of tables.

23. A computer readable medium including program instructions for use with a data processing system having a central processing unit and associated memory, said program instructions for instructing said data processing system to implement a data processing system comprising:

a record allocator operatively coupled to said data processing system, said record allocator for allocating a plurality of destinations for a plurality of records from a set of records; and

a record selector operatively coupled to said data processing system, said record selector for selecting a subset of records from said plurality of records for subsequent placement of said selected records in said plurality of destinations, wherein each destination has an associated record modification rule and an associated record acceptance rule.

24. The computer readable medium of claim 23 further comprising a record former operative to form, for a record of said set of records, a group of replica records and allocating each replica record of said group, except one of said replica records, with a different one of said plurality of destinations, said one of said replica records not associated with any of said plurality of destinations.

25. The computer readable medium of claim 24 wherein said record selector is operative to assign a destination identification to each replica record of said group of replica records.

26. The computer readable medium of claim 25 wherein said record selector is operative to modify replica records of said group of replica records in accordance to said record modification rule associated with a destination identification assigned to respective replica records.

27. The computer readable medium of claim 26 wherein said record selector is operative to select replica records of said group of replicas satisfying said record acceptance rule associated with said destination identification assigned to said respective replica records of said group and selecting said one of said replica records.

28. The computer readable medium of claim 26 wherein said record selector is operative to choose said replica record associated with one of said plurality of destinations, wherein after said selecting two replica records remain, wherein one of said remaining replica records is said one of said replica records.

29. The computer readable medium of claim 28 wherein said record selector is operative to place said chosen replica associated with a destination in said associated destination.

30. The computer readable medium of claim 23 wherein said plurality of destinations is a plurality of tables.

31. A method for use in a computing environment for selecting records from a set of records for subsequent placement of selected records in a plurality of destinations, each destination having an associated record modification rule and an associated record acceptance rule, comprising:

(a) assigning a destination identification to each replica record of a group of replica records except one replica record in said group, wherein each of a plurality of groups of replica records corresponds to a particular record of said set of records; and

(b) assigning a null destination to said one replica record of said group of replica records.

32. The method of claim 31 further comprising modifying particular replica records in accordance to said record modification rule associated with a destination identification assigned to said particular replica records.

33. The method of claim 32 further comprising selecting replica records satisfying a record acceptance rule associated with said destination identification assigned to said selected replica records.

34. The method of claim 33 further comprising selecting, from an identified group of replica records only including:

a first replica record identified by said assigned null destination identification, and

a second replica record identified by said assigned destination identification,

wherein the second replica is identified by said identified assigned destination identification.

35. The method of claim 31 further comprising placing said selected replica record identified by said identified assigned destination identification in said identified assigned destination identification associated with said selected replica record.

36. The method of claim 31 further comprising creating said group of replica records corresponding to said record of said set of records.

37. The method of claim 31 wherein said plurality of destinations is a plurality of tables.

38. The method of claim 31 further comprising providing an error indicator for indicating if the only replica record remaining for said set of records is not assigned to a destination for said set of records.

39. The method of claim 31 further comprising providing an error indicator for indicating if there are more than two replica records remaining for said set of records.

40. A computer readable medium including program instructions for use with a data processing system having a central processing unit and associated memory, said program instructions for instructing said data processing system to implement a method for use in a computing environment for selecting records from a set of records for subsequent placement of selected records in a plurality of destinations, each destination having an associated record modification rule and an associated record acceptance rule, comprising the steps of:

(a) assigning a destination identification to each replica record of a group of replica records except one replica record in said group, wherein each of a plurality of groups of replica records corresponds to a record of said set of records; and

(b) assigning a null destination to said one replica record of said group of replica records.

41. The computer readable medium of claim 40 wherein the data processing system further perfoms a step of modifying particular replica records in accordance to said record modification rule associated with a destination identification assigned to said particular replica records.

42. The computer readable medium of claim 41 wherein the data processing system further perfoms a step of selecting replica records satisfying a record acceptance rule associated with said destination identification assigned to said selected replica records.

43. The computer readable medium of claim 42 wherein the data processing system further perfoms a step of selecting, from an identified group of replica records only including:

a first replica record identified by said assigned null destination identification, and

a second replica record identified by said assigned destination identification,

wherein the second replica is identified by said identified assigned destination identification.

44. The computer readable medium of claim 40 wherein the data processing system further perfoms a step of placing said selected replica record identified by said identified assigned destination identification in said identified assigned destination identification associated with said selected replica record.

45. The computer readable medium of claim 40 wherein the data processing system further perfoms a step of creating said group of replica records corresponding to said record of said set of records.

46. The computer readable medium of claim 40 wherein said plurality of destinations is a plurality of tables.

47. The computer readable medium of claim 40 wherein the data processing system further perfoms a step ofproviding an error indicator for indicating if the only replica record remaining for said set of records is not assigned to a destination for said set of records.

48. The computer readable medium of claim 40 wherein the data processing system further perfoms a step of providing an error indicator for indicating if there are more than two replica records remaining for said set of records.

49. A data processing system comprising:

a record creator operatively coupled to the data processing system, the record creator for directing said data processing system to create a group of replica records corresponding to a record of a set of records; and

a record selector operatively coupled to the data processing system, said record selector for directing said data processing system to select said replica records for subsequent placement of selected replica records in a plurality of destinations, wherein each of said destinations has an associated record modification rule and an associated record acceptance rule.

50. The data processing system of claim 49 wherein said record selector directs said data processing system to assign a destination identification to each of said replica records of said group of replica records, wherein a null destination is assigned to one replica record of said group of replica records.

51. The data processing system of claim 50 wherein said record selector directs said data processing system to modify particular replica records in accordance to a record modification rule associated with a destination identification assigned to said particular replica records.

52. The data processing system of claim 51 wherein said record selector directs said data processing system to select respective replica records satisfying a record acceptance rule associated with said destination identification assigned to said respective replica records.

53. The data processing system of claim 52 wherein said record selector directs said data processing system to select, from an identified group of replica records only including:

a first replica record identified by an assigned null destination identification, and a second replica record identified by an assigned destination identification, the second replica record identified by said identified assigned destination identification.

54. The data processing system of claim 49 wherein said record selector directs said data processing system to place said selected replica record identified by said identified assigned destination identification in said identified assigned destination identification associated with said selected replica record.

55. The data processing system of claim 49 wherein said plurality of destinations is a plurality of tables.

56. The data processing system of claim 49 further providing an error indicator for indicating if the only replica record remaining for said set of records is not assigned to a destination for said set of records.

57. The data processing system of claim 49 further comprising providing an error indicator for indicating if there are more than two replica records remaining for said set of records.

58. A computer readable medium including program instructions for use with a data processing system having a central processing unit and associated memory, said program instructions for instructing said data processing system to implement a data processing system comprising:

a record creator operatively coupled to the data processing system, the record creator for directing said data processing system to create a group of replica records corresponding to a record of a set of records; and

a record selector operatively coupled to the data processing system, said record selector for directing said data processing system to select said replica records for subsequent placement of selected replica records in a plurality of destinations, wherein each of said destinations has an associated record modification rule and an associated record acceptance rule.

59. The computer readable medium of claim 58 wherein said record selector directs said data processing system to assign a destination identification to each of said replica records of said group of replica records, wherein a null destination is assigned to one replica record of said group of replica records.

60. The computer readable medium of claim 59 wherein said record selector directs said data processing system to modify particular replica records in accordance to a record modification rule associated with a destination identification assigned to said particular replica records.

61. The computer readable medium of claim 60 wherein said record selector directs said data processing system to select respective replica records satisfying a record acceptance rule associated with said destination identification assigned to said respective replica records.

62. The computer readable medium of claim 61 wherein said record selector directs said data processing system to select, from an identified group of replica records only including:

a first replica record identified by an assigned null destination identification, and a second replica record identified by an assigned destination identification, the second replica record identified by said identified assigned destination identification.

63. The computer readable medium of claim 58 wherein said record selector directs said data processing system to place said selected replica record identified by said identified assigned destination identification in said identified assigned destination identification associated with said selected replica record.

64. The computer readable medium of claim 58 wherein said plurality of destinations is a plurality of tables.

65. The computer readable medium of claim 58 further providing an error indicator for indicating if the only replica record remaining for said set of records is not assigned to a destination for said set of records.

66. The computer readable medium of claim 58 further comprising providing an error indicator for indicating if there are more than two replica records remaining for said set of records.