# US 8,280,847 B2 · Apparatus, method, and computer program product for synchronizing data sources

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

- Number: US 8,280,847 B2
- Document ID: US8280847B2
- Status: Granted
- Kind: B2
- Application number: 12/604,038
- Filed: 2009-10-22
- Published: 2010-02-18
- Granted: 2012-10-02
- Earliest claimed: 2006-12-06
- Assignees: Verizon Patent and Licensing Inc.
- Inventors: Jianxiu Hao; Diego S. Rozensztejn; Jian Huang; Muralikumar Venkatasubramaniam
- Web page: https://patentgrep.com/patent/US8280847B2

## CPC

- G06F 16/27: Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F 16/25: Integrating or interfacing systems involving database management systems
- Y10S 707/99942: Manipulating data structure, e.g. compression, compaction, compilation
- 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 is provided for synchronizing data sources. The method includes receiving at least first and second data tables. The data tables have one or more mutually similar fields and one or more dissimilar fields from one another. First normalized, second normalized, and intermediate data tables are stored, each including respective first normalized, second normalized, and intermediate data table fields that each correspond to the mutually similar fields of the first and second data tables. The first normalized data table is at least partially populated with corresponding entries from the first data table and the second normalized data table is at least partially populated with corresponding entries in the second data table. Intermediate data table entries are respectively replaced with corresponding inconsistent data entries of the first and second normalized data tables. An apparatus and a computer program product for accomplishing the above method are also provided.

## Claims

### Claim 1

An apparatus comprising:
a storage device for storing first and second data tables, each table having one or more fields of which at least some are populated with data entries, both data tables having one or more mutually similar fields and at least one of the data tables having one or more dissimilar fields that are dissimilar to fields of the other data table; and
a processing device in communication with said storage device, said processing device being configured to modify the first and second data tables so as to synchronize the similar fields of the first and second data tables;
wherein said processing device is further configured to determine a priority between respective differing data entries from similar fields of the first and second data tables and to modify both of the first and second data tables so as to synchronize the similar fields of the first and second data tables by replacing each differing data entry of lower priority with the corresponding differing data entry of higher priority; and
further wherein said storage device includes an intermediate data table having intermediate data table fields corresponding to the mutually similar fields of the first and second data tables, at least some of the intermediate data table fields being populated with previously stored intermediate data table entries, and wherein said processing device is configured to determine a priority and generate a dissimilarity indicator by using data entries of the first and second data tables to respectively replace corresponding inconsistent intermediate data table entries and subsequently using intermediate data table entries to respectively replace corresponding inconsistent first and second data table entries.

### Claim 2 (depends on 1)

The apparatus according to claim 1, further comprising a communications device configured to receive from at least one separate device, and to communicate to said storage device, the first and second data tables.

### Claim 3 (depends on 2)

The apparatus according to claim 2, wherein the communications device is further configured to communicate at least one of the first and second data tables, subsequent to modification, to at least one separate device.

### Claim 4 (depends on 2)

The apparatus according to claim 2, wherein said communications device is further configured to receive from the at least one separate device, and communicate to said storage device, at least one updated data table that replaces at least a respective one of the first and second data tables previously stored in said storage device.

### Claim 5 (depends on 2)

The apparatus according to claim 2, wherein said communications device is configured to communicate with at least one separate device that is selected from the group consisting of a mobile phone and a mobile data device.

### Claim 6 (depends on 1)

The apparatus according to claim 1, wherein said storage device includes first and second normalized data tables with respective first and second normalized data table fields corresponding to the mutually similar fields of the first and second data tables, and said processing device is further configured to at least partially populate the first normalized data table with corresponding entries from the first data table and the second normalized data table with corresponding entries in the second data table, and wherein said processing unit is configured to determine a priority and generate a dissimilarity indicator by using data entries of the first and second normalized data tables to respectively replace corresponding inconsistent intermediate data table entries and subsequently using intermediate data table entries to respectively replace corresponding inconsistent first and second normalized data table entries.

### Claim 7 (depends on 6)

The apparatus according to claim 6, wherein the entries in the first and second normalized data tables and in the intermediate data table are in a common data format, and wherein the processing device is further configured to use the entries in the first and second normalized data tables in common data format to generate data in alternative formats compatible with an external device.

### Claim 8

A method, comprising:
storing, in a storage device having a processor and a memory, first and second data tables, each table having one or more fields of which at least some are populated with data entries, both data tables having one or more mutually similar fields and at least one of the data tables having one or more dissimilar fields that are dissimilar to fields of the other data table;
generating an intermediate data table having intermediate data table fields corresponding to the mutually similar fields of the first and second data tables, at least some of the intermediate data table fields being populated with previously stored intermediate data table entries;
determining a priority between respective differing data entries from similar fields of the first and second data tables, and generating a dissimilarity indicator, by using data entries of the first and second data tables to respectively replace corresponding inconsistent intermediate data table entries and subsequently using intermediate data table entries to respectively replace corresponding inconsistent first and second data table entries; and
modifying the first and second data tables so as to synchronize the similar fields of the first and second data tables by replacing each differing data entry of lower priority with the corresponding differing data entry of higher priority.

### Claim 9 (depends on 8)

The method according to claim 8, further comprising receiving from at least one separate device, and communicating to said storage device, the first and second data tables.

### Claim 10 (depends on 9)

The method according to claim 9, further comprising communicating at least one of the first and second data tables, subsequent to modification, to at least one second separate device.

### Claim 11 (depends on 9)

The method according to claim 9, further comprising receiving from the at least one separate device, and communicating to said storage device, at least one updated data table that replaces at least a respective one of the first and second data tables previously stored in said storage device.

### Claim 12 (depends on 9)

The method according to claim 9, further comprising communicating with at least one second separate device that is selected from the group consisting of a mobile phone and a mobile data device.

### Claim 13 (depends on 9)

The method according to claim 9, wherein said storage device includes first and second normalized data tables with respective first and second normalized data table fields corresponding to the mutually similar fields of the first and second data tables, further comprising at least partially populating the first normalized data table with corresponding entries from the first data table and the second normalized data table with corresponding entries in the second data table, and determining a priority and generating a dissimilarity indicator by using data entries of the first and second normalized data tables to respectively replace corresponding inconsistent intermediate data table entries and subsequently using intermediate data table entries to respectively replace corresponding inconsistent first and second normalized data table entries.

### Claim 14 (depends on 13)

The method according to claim 13, wherein the entries in the first and second normalized data tables and in the intermediate data table are in a common data format, further comprising using the entries in the first and second normalized data tables in common data format to generate data in alternative formats compatible with an external device.
