# US 2003/0204540 A1 · Classification of data for insertion into a database

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2003/0204540 A1
- Document ID: US20030204540A1
- Status: Published application
- Kind: A1
- Application number: 10/393,852
- Filed: 2003-03-21
- Published: 2003-10-30
- Earliest claimed: 2002-04-29
- Assignees: International Business Machines Corporation
- Inventors: Serge Rielau; Roberta J. Cochrane; George Lapis; Hamid Pirahesh; Richard S. Sidle; Biao Zhu
- Web page: https://patentgrep.com/patent/US20030204540A1

## CPC

- G06F 16/235: {Update request formulation}
- G06F 16/24553: {of query operations}
- Y10S 707/99952: Coherency, e.g. same view to multiple users
- Y10S 707/99955: Archiving or backup
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- Y10S: TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS

## 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

### Claim 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.

### Claim 2 (depends on 1)

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.

### Claim 3 (depends on 1)

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.

### Claim 4 (depends on 3)

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.

### Claim 5 (depends on 4)

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

### Claim 6 (depends on 1)

The method of claim 1 further comprising:
placing said replica records assigned destination identification in their respective destinations.

### Claim 7 (depends on 6)

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

### Claim 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.

### Claim 9 (depends on 8)

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.

### Claim 10 (depends on 8)

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.

### Claim 11 (depends on 10)

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.

### Claim 12 (depends on 11)

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.

### Claim 13 (depends on 8)

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.

### Claim 14 (depends on 13)

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

### Claim 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.

### Claim 16 (depends on 15)

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.

### Claim 17 (depends on 16)

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.

### Claim 18 (depends on 17)

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.

### Claim 19 (depends on 18)

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.

### Claim 20 (depends on 18)

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.

### Claim 21 (depends on 20)

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.

### Claim 22 (depends on 15)

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

### Claim 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.

### Claim 24 (depends on 23)

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.

### Claim 25 (depends on 24)

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.

### Claim 26 (depends on 25)

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.

### Claim 27 (depends on 26)

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.

### Claim 28 (depends on 26)

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.

### Claim 29 (depends on 28)

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.

### Claim 30 (depends on 23)

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

### Claim 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.

### Claim 32 (depends on 31)

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.

### Claim 33 (depends on 32)

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.

### Claim 34 (depends on 33)

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.

### Claim 35 (depends on 31)

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.

### Claim 36 (depends on 31)

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

### Claim 37 (depends on 31)

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

### Claim 38 (depends on 31)

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.

### Claim 39 (depends on 31)

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.

### Claim 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.

### Claim 41 (depends on 40)

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.

### Claim 42 (depends on 41)

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.

### Claim 43 (depends on 42)

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.

### Claim 44 (depends on 40)

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.

### Claim 45 (depends on 40)

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.

### Claim 46 (depends on 40)

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

### Claim 47 (depends on 40)

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.

### Claim 48 (depends on 40)

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.

### Claim 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.

### Claim 50 (depends on 49)

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.

### Claim 51 (depends on 50)

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.

### Claim 52 (depends on 51)

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.

### Claim 53 (depends on 52)

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.

### Claim 54 (depends on 49)

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.

### Claim 55 (depends on 49)

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

### Claim 56 (depends on 49)

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.

### Claim 57 (depends on 49)

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.

### Claim 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.

### Claim 59 (depends on 58)

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.

### Claim 60 (depends on 59)

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.

### Claim 61 (depends on 60)

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.

### Claim 62 (depends on 61)

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.

### Claim 63 (depends on 58)

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.

### Claim 64 (depends on 58)

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

### Claim 65 (depends on 58)

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.

### Claim 66 (depends on 58)

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.
