Synchronizing records between databases
First Claim
Patent Images
1. At least one computer-readable storage medium having instructions stored thereon that, when executed by a computing device, cause the computing device to perform acts, the acts comprising:
- performing synchronization of a source database to a target database by processing historical data and new data of the source database for conversion from a source format of the source database to a target format of the target database, wherein the source format and the target format are different formats, the processing comprising;
causing the historical data of the source database to be recorded as historical entries on a transaction log, wherein the historical data is already stored in the source database when the synchronization is commenced,subsequently causing the new data of the source database to be recorded as new entries on the transaction log with the historical entries, wherein the new data is not present in the source database when the synchronization is commenced,identifying a distinct attribute associated with an individual historical entry,generating a message that reflects the individual historical entry, andsending the message to another computing device for uploading into the target database in the target format,wherein the transaction log is created after the historical data is already stored in the source database.
2 Assignments
0 Petitions
Accused Products
Abstract
The described implementations relate to synchronizing records between databases. One implementation can cause historical data of a source database to be recorded as entries on a transaction log and can subsequently cause new data of the source database to be recorded on the transaction log in a same manner as the historical data. This implementation can also identify a distinct attribute associated with an individual entry and generate a message that reflects the individual entry.
-
Citations
20 Claims
-
1. At least one computer-readable storage medium having instructions stored thereon that, when executed by a computing device, cause the computing device to perform acts, the acts comprising:
-
performing synchronization of a source database to a target database by processing historical data and new data of the source database for conversion from a source format of the source database to a target format of the target database, wherein the source format and the target format are different formats, the processing comprising; causing the historical data of the source database to be recorded as historical entries on a transaction log, wherein the historical data is already stored in the source database when the synchronization is commenced, subsequently causing the new data of the source database to be recorded as new entries on the transaction log with the historical entries, wherein the new data is not present in the source database when the synchronization is commenced, identifying a distinct attribute associated with an individual historical entry, generating a message that reflects the individual historical entry, and sending the message to another computing device for uploading into the target database in the target format, wherein the transaction log is created after the historical data is already stored in the source database. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
-
-
14. At least one computer-readable storage medium having instructions stored thereon that, when executed by a computing device, cause the computing device to perform acts, the acts comprising:
-
receiving a first message that conveys a first entry from a transaction log of database entries, the database entries including new database entries and historical database entries; receiving a second message that conveys a second entry from the transaction log of database entries; creating a first metadata tag for the first message, the first metadata tag including a first distinct identifier for the first entry, wherein the first distinct identifier indicates that the first message belongs to a first processing job such that processing of the first message for uploading in a target database format is performed by the first processing job with a first group of messages that are also associated with the first distinct identifier; and creating a second metadata tag for the second message, the second metadata tag including a second distinct identifier for the second entry, wherein the second distinct identifier indicates that the second message belongs to a second processing job such that processing of the second message for uploading in the target database format is performed by the second processing job with a second group of messages that are also associated with the second distinct identifier. - View Dependent Claims (15, 16)
-
-
17. A system, comprising:
-
a data acquisition and distribution tool configured to; obtain a first message, wherein the first message relates to first changed data in a source database of records, obtain a second message, wherein the second message relates to second changed data in the source database of records, identify a first identifier associated with the first message and a second identifier associated with the second message, attach the first identifier to the first message as first metadata and attach the second identifier to the second message as second metadata, and, specify a first processing path from available parallel processing paths, wherein the first processing path is configured to convert the first changed data into a target format and upload the first converted data into a target database, the first processing path being specified based at least in part on the first identifier of the first metadata; specify a second processing path from the available parallel processing paths, wherein the second processing path is configured to convert the second changed data into the target format and upload the second converted data into the target database, the second processing path being specified based at least in part on the second identifier of the second metadata; and a computing device configured to execute the data acquisition and distribution tool. - View Dependent Claims (18, 19, 20)
-
Specification