# US 6,732,122 B2 · System and method of synchronizing replicated data

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

- Number: US 6,732,122 B2
- Document ID: US6732122B2
- Status: Granted
- Kind: B2
- Application number: 10/336,076
- Filed: 2003-01-03
- Published: 2003-08-21
- Granted: 2004-05-04
- Earliest claimed: 2000-08-14
- Inventors: William Zoltan
- Web page: https://patentgrep.com/patent/US6732122B2

## CPC

- G06F 11/2082: {Data synchronisation}
- G06F 16/9017: {using directory or table look-up (use of a directory or look-up table in file systems G06F16/13)}
- G06F 11/2071: {using a plurality of controllers}
- Y10S 707/99938: Concurrency, e.g. lock management in shared database
- Y10S 707/99952: Coherency, e.g. same view to multiple users
- Y10S 707/99953: Recoverability
- 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 replication method is provided for synchronizing master and satellite data tables, including several acts. An identifier column is generated for each table of a tree of master tables. The tree of master tables is copied to a tree of satellite tables, so that the tree of satellite tables is a replica of the tree of master tables. An insert trigger is associated with each of the master tables. Inserts are allowed to be made to at least one of the master tables, and synchronizing the tree of satellite tables to the tree of master tables. Key and checksum columns of each of the master tables are compared with key and checksum columns of each of the satellite tables. Row sets of rows are produced, wherein each row set includes those rows present in the master table but not in the satellite table. The rows that are present in the satellite tables but not in the corresponding master tables are determined by comparing the key and checksum columns of the master tables to those of the satellite tables, and, are deleted. The row sets of rows are then inserted into the satellite tables.

## Claims

### Claim 1

A method for synchronizing a satellite table to a master table, the method comprising the steps of:
comparing a key column and identifier column of the master table with a key column and identifier column of the satellite table;
producing a row set of rows based on said comparing step, said rows being rows present in the master table but not present in the satellite table;
deleting rows present in the satellite table but not present in the master table, as determined based on said comparing step; and
inserting the row set of rows into the satellite table.

### Claim 2 (depends on 1)

A method for synchronizing a satellite table to a master table as claimed in claim 1, wherein the master table is in a first database residing on a first computing device, the satellite table is in a second database residing on a second computing device, and the first computing device is in communication with the second computing device.

### Claim 3 (depends on 1)

A method for synchronizing a satellite table to a master table as claimed in claim 1, wherein said comparing step further comprises issuing a distributed query command.
