IP Library Granted Patent US 7,627,595
Granted Patent B2
US 7,627,595 · App. 11/567,325 · Granted Dec 1, 2009

Apparatus, method, and computer program product for synchronizing data sources

View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 7,627,595
App. No.
11/567,325
Granted
Dec 1, 2009
Kind
B2
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 (20)

1. A method comprising:

receiving at a server device at least a first data table from a first client device and a second data table from a second client device, the data tables having one or more mutually similar fields and one or more dissimilar fields from one another, the similar fields storing overlapping types of data with at least some coincidence of the content of the data, the dissimilar fields storing types of data exclusive to the respective table;

formatting the first and second data table entries to have a common format;

storing on the server device first normalized, second normalized, and intermediate data tables with respective first normalized, second normalized, and intermediate data table fields each corresponding to the mutually similar fields of the first and second data tables;

at least partially populating the first normalized data table with corresponding formatted entries from the first data table and the second normalized data table with corresponding formatted entries from the second data table; and

respectively replacing intermediate data table entries stored on the server with corresponding inconsistent data entries of the first and second normalized data tables.

2. A method according to claim 1 , further comprising, subsequent to respectively replacing intermediate data table entries with corresponding inconsistent first and second normalized data table entries, generating modified first and second normalized data tables by respectively replacing data entries of the first and second normalized data tables with corresponding inconsistent intermediate data table entries.

3. A method according to claim 1 , further comprising, generating modified first and second data tables respectively consistent with the modified first and second normalized data tables.

4. The method according to claim 1 , wherein receiving at least first and second data tables includes communicating with at least one mobile device, and further comprising transmitting at least one of the modified first and second data tables for a mobile device.

5. A method according to claim 4 , wherein transmitting at least one of the modified first and second data tables for the mobile device further comprises formatting the transmitted data tables in an original format received by the server device from the mobile device.

6. A method according to claim 1 , wherein formatting the first and second data table entries to have a common format further comprises at least one of converting into lower case lettering and removing parentheses and hyphens.

7. A computer program product comprising a computer-readable storage medium having computer-readable program code portions stored therein, the computer readable program code portions comprising:

a first executable code portion for receiving at least first and second data tables having one or more mutually similar fields and one or more dissimilar fields from one another, the similar fields storing overlapping types of data with at least some coincidence of the content of the data, the dissimilar fields storing types of data exclusive to the respective table;

a second executable code portion for storing first normalized, second normalized, and intermediate data tables with respective first normalized, second normalized, and intermediate data table fields each corresponding to the mutually similar fields of the first and second data tables;

a third executable code portion for formatting the first and second data table entries to have a common format and at least partially populating the first normalized data table with corresponding formatted entries from the first data table and the second normalized data table with corresponding formatted entries from the second data table; and

a fourth executable code portion for respectively replacing intermediate data table entries with corresponding inconsistent data entries of the first and second normalized data tables.

8. A computer program product according to claim 7 , further comprising a fifth executable code portion for, subsequent to respectively replacing intermediate data table entries with corresponding inconsistent first and second normalized data table entries, generating modified first and second normalized data tables by respectively replacing data entries of the first and second normalized data tables with corresponding inconsistent intermediate data table entries.

9. A computer program product according to claim 8 , further comprising a sixth executable code portion for generating modified first and second data tables respectively consistent with the modified first and second normalized data tables.

10. A computer program product according to claim 7 , wherein said first executable code portion for receiving at least first and second data tables includes executable code portions for communicating with at least one mobile device.

11. A computer program product according to claim 7 , further comprising a seventh executable code portion for communicating at least one of the modified first and second data tables for receipt by a mobile device.

Assignments (3)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Nov 2, 2009
From: VERIZON DATA SERVICES LLC
To: VERIZON PATENT AND LICENSING INC.
Reel/Frame 023455/0122 →
CHANGE OF NAME Recorded Sep 17, 2009
From: VERIZON DATA SERVICES INC.
To: VERIZON DATA SERVICES LLC
Reel/Frame 023248/0318 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Dec 6, 2006
From: HAO, JIANXIU; ROZENSZTEJN, DIEGO S.; HUANG, JIAN; VENKATASUBRAMANIAM, MURALIKUMAR
To: VERIZON DATA SERVICES INC.
Reel/Frame 018589/0760 →