IP Library Granted Patent US 8,429,124
Granted Patent B2
US 8,429,124 · App. 12/975,012 · Granted Apr 23, 2013

On demand multi-location large database synchronization system

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 8,429,124
App. No.
12/975,012
Granted
Apr 23, 2013
Kind
B2
Abstract

Systems and method for distributing updates on demand to synchronize a remote client database with a source database are provided. A client can request an online update from the database content provider and the database provider can stream database updates to the client over a network connection in real time, or the database content provider can stream database updates to the client at scheduled times based on a licensing agreement with the client. This allows the client database to be kept in synch with the source database without requiring that the database provider generate a set of database updates on physical media and ship the physical media to the client for processing.

Claims (42)

1. A computer-implemented method for synchronizing the contents of a remote database with a source database, wherein one or more processors are programmed to perform the steps comprising:

maintaining a source database comprising a plurality of records, wherein each of the plurality of records comprises one or more fields, wherein each of the one or more fields is associated with a version identifier, wherein each of the plurality of records is associated with a version identifier corresponding to a highest version identifier of any of its one or more fields, and wherein the source database is associated with a version identifier corresponding to a highest version identifier of any of the plurality of records;

receiving a request from a content hosting server for an update to a remote database associated with the content hosting server;

identifying a database version associated with the remote database;

comparing the identified database version to a plurality of version identifiers associated with the plurality of records or fields in the source database;

identifying one or more data entries from the source database to be included in a database update based on the comparison;

generating a data stream that includes the identified one or more data entries by converting the identified one or more data entries to Extensible Markup Language (XML) data, and generating a data stream comprising the XML data; and transmitting the data stream to the content hosting server.

2. The method of claim 1 , further comprising:

receiving login credentials associated with a client;

authenticating the login credentials;

determining whether the client is eligible to receive an update for the remote database; and

performing the steps of comparing, identifying one or more data entries, generating the data stream, and transmitting the data stream only if it is determined that the client is eligible to receive an update for the remote database.

3. The method of claim 1 , wherein each of the one or more data entries included in the data stream comprises a persistent identifier (PID) that uniquely identifies the data entry and a processing code that identifies an action to be performed with the data entry when updating the remote database.

4. The method of claim 1 , wherein the content hosting server is configured to receive the data stream, convert the data stream to database update commands, and execute the database update commands to update the contents of the remote database.

5. The method of claim 1 , further comprising receiving a confirmation message from the content hosting server indicating that the remote database has been updated successfully, wherein the confirmation message includes a version identifier associated with the updated remote database.

6. The method of claim 1 , wherein the steps of identifying one or more data entries, generating the data stream, and transmitting the data stream are only performed if contents of the remote database are out of date.

7. The method of claim 6 , wherein the request from a content hosting server includes the database version associated with the remote database, wherein the contents of the remote database are out of date if the database version is less than the version identifier associated with the source database.

8. The method of claim 7 , wherein identifying one or more data entries comprises identifying records or fields in the source database having a version identifier that is greater than the database version associated with the remote database.

9. The method of claim 7 , wherein generating a data stream comprises compressing data included in the data stream.

10. The method of claim 7 , wherein generating a data stream comprises encrypting data included in the data stream.

11. A technical system for synchronizing the contents of a remote database with a source database, the system comprising:

a non-transitory computer readable medium configured to store one or more executable programmed modules;

at least one processor communicatively coupled with the non-transitory computer readable medium and configured to execute the one or more executable programmed modules;

the one or more executable programmed modules that, when executed by the at least one processor,

maintain a source database comprising a plurality of records, wherein each of the plurality of records comprises one or more fields, wherein each of the one or more fields is associated with a version identifier, wherein each of the plurality of records is associated with a version identifier corresponding to a highest version identifier of any of its one or more fields, and wherein the source database is associated with a version identifier corresponding to a highest version identifier of any of the plurality of records;

receive a request from a content hosting server to update a remote database;

determine whether the content hosting server is eligible to receive an update to the remote database;

identify a database version of the remote database;

compare the identified database version to a plurality of version identifiers associated with the plurality of records or fields in the source database;

identify one or more data entries from the source database to be included in a database update based on the comparison;

generate a data stream that includes the identified one or more data entries by converting the identified one or more data entries to Extensible Markup Language (XML) data, and generating a data stream comprising the XML data; and send the data stream to the content hosting server.

12. The system of claim 11 , wherein the one or more executable programmed modules further access data stored in the source database and a client information database and write data to the source database and the client information database.

13. The system of claim 11 , wherein the one or more executable programmed modules further generate a user interface that is configured to allow users to interact with the system, collect data from users, and display data to users.

14. The system of claim 11 , wherein the one or more executable programmed modules further:

receive login credentials associated with a client; and

authenticate the login credentials to determine whether the client is authorized to access content on the system.

15. The system of claim 11 , wherein each of the one or more data entries included in the data stream includes a persistent identifier (PID) that uniquely identifies the data entry and a processing code that identifies an action to be performed with the data entry when updating the remote database.

16. The system of claim 11 , wherein the one or more executable programmed modules further receive a confirmation message from the content hosting server indicating that the remote database has been updated successfully, wherein the confirmation message includes a version identifier associated with the updated remote database.

17. The system of claim 11 , wherein the request from a content hosting server includes the database version associated with the remote database, wherein the contents of the remote database are out of date if the database version does not match the version identifier associated with the source database.

18. The system of claim 11 , wherein identifying one or more data entries comprises identifying records or fields in the source database having a version identifier that is greater than the database version associated with the remote database.

19. The system of claim 11 , wherein the one or more executable programmed modules further compress data included in the data stream before sending the data stream to the content hosting server.

20. The system of claim 11 , wherein the one or more executable programmed modules further encrypt data included in the data stream before sending the data stream to the content hosting server.

Assignments (9)
CORRECTIVE ASSIGNMENT TO CORRECT THE APPLICATION NO. 16/990,698 PREVIOUSLY RECORDED ON REEL 058294 FRAME 0010. ASSIGNOR(S) HEREBY CONFIRMS THE ASSIGNMENT. Recorded Apr 21, 2022
From: TRU OPTIK DATA CORP.; NEUSTAR INFORMATION SERVICES, INC.; NEUSTAR DATA SERVICES, INC.; TRUSTID, INC.; NEUSTAR, INC.; NEUSTAR IP INTELLIGENCE, INC.; MARKETSHARE PARTNERS, LLC; SONTIQ, INC.
To: DEUTSCHE BANK AG NEW YORK BRANCH
Reel/Frame 059846/0157 →
TERMINATION AND RELEASE OF SECURITY INTEREST IN PATENTS RECORDED AT REEL 058294, FRAME 0161 Recorded Dec 27, 2021
From: JPMORGAN CHASE BANK, N.A.
To: EBUREAU, LLC; IOVATION, INC.; SIGNAL DIGITAL, INC.; TRANS UNION LLC; TRANSUNION INTERACTIVE, INC.; TRANSUNION RENTAL SCREENING SOLUTIONS, INC.; TRANSUNION TELEDATA LLC; AGGREGATE KNOWLEDGE, LLC; TRU OPTIK DATA CORP.; NEUSTAR INFORMATION SERVICES, INC.; TRUSTID, INC.; NEUSTAR, INC.; NEUSTAR IP INTELLIGENCE, INC.; MARKETSHARE PARTNERS, LLC; SONTIQ, INC.
Reel/Frame 058593/0852 →
SECOND LIEN PATENT SECURITY AGREEMENT RELEASE Recorded Dec 3, 2021
From: UBS AG, STAMFORD BRANCH
To: NEUSTAR, INC.; MARKETSHARE PARTNERS LLC; AGGREGATE KNOWLEDGE, INC.; NEUSTAR INFORMATION SERVICES, INC.; NEUSTAR IP INTELLIGENCE, INC.
Reel/Frame 058300/0739 →
FIRST LIEN PATENT SECURITY AGREEMENT RELEASE Recorded Dec 3, 2021
From: BANK OF AMERICA, N.A.
To: NEUSTAR, INC.; MARKETSHARE PARTNERS LLC; AGGREGATE KNOWLEDGE, INC.; NEUSTAR INFORMATION SERVICES, INC.; NEUSTAR IP INTELLIGENCE, INC.
Reel/Frame 058300/0762 →
GRANT OF SECURITY INTEREST IN PATENT RIGHTS Recorded Dec 1, 2021
From: TRU OPTIK DATA CORP.; NEUSTAR INFORMATION SERVICES, INC.; NEUSTAR DATA SERVICES, INC.; TRUSTID, INC.; NEUSTAR, INC.; NEUSTAR IP INTELLIGENCE, INC.; MARKETSHARE PARTNERS, LLC; SONTIQ, INC.
To: DEUTSCHE BANK AG NEW YORK BRANCH
Reel/Frame 058294/0010 →
GRANT OF SECURITY INTEREST IN UNITED STATES PATENTS Recorded Dec 1, 2021
From: EBUREAU, LLC; IOVATION, INC.; SIGNAL DIGITAL, INC.; TRANS UNION LLC; TRANSUNION HEALTHCARE, INC.; TRANSUNION INTERACTIVE, INC.; TRANSUNION RENTAL SCREENING SOLUTIONS, INC.; TRANSUNION TELEDATA LLC; AGGREGATE KNOWLEDGE, LLC; TRU OPTIK DATA CORP.; NEUSTAR INFORMATION SERVICES, INC.; TRUSTID, INC.; NEUSTAR, INC.; NEUSTAR IP INTELLIGENCE, INC.; MARKETSHARE PARTNERS, LLC; SONTIQ, INC.
To: JPMORGAN CHASE BANK, N.A
Reel/Frame 058294/0161 →
SECOND LIEN PATENT SECURITY AGREEMENT Recorded Aug 22, 2017
From: MARKETSHARE PARTNERS LLC; AGGREGATE KNOWLEDGE, INC.; NEUSTAR INFORMATION SERVICES, INC.; NEUSTAR IP INTELLIGENCE, INC.; NEUSTAR, INC.
To: UBS AG, STAMFORD BRANCH
Reel/Frame 043633/0527 →
SECURITY INTEREST Recorded Aug 22, 2017
From: MARKETSHARE PARTNERS LLC; AGGREGATE KNOWLEDGE, INC.; NEUSTAR INFORMATION SERVICES, INC.; NEUSTAR IP INTELLIGENCE, INC.; NEUSTAR, INC.
To: BANK OF AMERICA, N.A.
Reel/Frame 043633/0440 →
RELEASE OF SECURITY INTEREST Recorded Aug 21, 2017
From: MORGAN STANLEY SENIOR FUNDING, INC.
To: NEUSTAR, INC.; NEUSTAR IP INTELLIGENCE, INC.; ULTRADNS CORPORATION; NEUSTAR INFORMATION SERVICES, INC.; NEUSTAR DATA SERVICES, INC.; AGGREGATE KNOWLEDGE, INC.; MARKETSHARE ACQUISITION CORPORATION; MARKETSHARE HOLDINGS, INC.; MARKETSHARE PARTNERS, LLC
Reel/Frame 043618/0826 →