Method and system for updating a remote database
First Claim
Patent Images
1. A method for updating a remote database over a network, comprising:
- generating a plurality of periodic updates based on incremental changes to a local database, each of the plurality of periodic updates having at least one transaction;
sending the plurality of periodic updates to the remote database over the network; and
while generating the plurality of periodic updates,generating an initialization update including a version of the local database at a start time,determining a last periodic update of the plurality of periodic updates based on the start time,determining a last transaction based on the start time, andsending the initialization update, a last periodic update identifier, and a last transaction identifier to the remote database over the network.
1 Assignment
0 Petitions
Accused Products
Abstract
A method and system for updating a remote database over a network. A plurality of periodic updates, called sendfiles, based on incremental changes to a local database are generated. Each of the periodic updates includes at least one transaction. An initialization update, called an initializing sendfile, including a version of the local database at a start time is generated. Additionally, an identifier associated with the last periodic update generated before the start time and an identifier associated with the last transaction committed prior to the start time are generated.
64 Citations
29 Claims
-
1. A method for updating a remote database over a network, comprising:
-
generating a plurality of periodic updates based on incremental changes to a local database, each of the plurality of periodic updates having at least one transaction; sending the plurality of periodic updates to the remote database over the network; and while generating the plurality of periodic updates, generating an initialization update including a version of the local database at a start time, determining a last periodic update of the plurality of periodic updates based on the start time, determining a last transaction based on the start time, and sending the initialization update, a last periodic update identifier, and a last transaction identifier to the remote database over the network. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A method for updating a remote database over a network, comprising:
-
receiving a plurality of periodic updates based on incremental changes to a local database over the network, each of the plurality of periodic updates having at least one transaction; receiving an initialization update including a version of the local database at a start time over the network; reading a last periodic update identifier from the initialization update; reading a last transaction identifier from the initialization update; determining a last periodic update from the last periodic update identifier, said determining the last periodic update based on the start time; determining a last transaction from the last transaction identifier, said determining the last transaction based on the start time; applying transactions generated after the last transaction to the remote database; and applying the periodic updates generated after the last periodic update to the remote database. - View Dependent Claims (8, 9, 10, 11)
-
-
12. A method for updating a remote database over a network, comprising:
-
generating a plurality of periodic updates based on incremental changes to a local database, each of the plurality of periodic updates having at least one transaction; generating an initialization update including a version of the local database at a start time, an update identifier associated with a last periodic update generated before the start time, and a transaction identifier associated with a last transaction committed before the start time; sending the initialization update, the update identifier, and the transaction identifier to the remote database over the network. - View Dependent Claims (13, 14, 15, 16)
-
-
17. A system for updating a remote database over a network, comprising:
-
at least one processor coupled to the network; and a memory coupled to the processor, the memory including a local database and instructions adapted to be executed by the processor to implement a method for updating the remote database over the network, the method including; generating a plurality of periodic updates based on incremental changes to the local database, each of the plurality of periodic updates having at least one transaction, sending the plurality of periodic updates to the remote database over the network, and while generating the plurality of periodic updates, generating an initialization update including a version of the local database at a start time, determining a last periodic update of the plurality of periodic updates based on the start time, determining a last transaction based on the start time, and sending the initialization update, a last periodic update identifier, and a last transaction identifier to the remote database over the network. - View Dependent Claims (18, 19, 20, 21, 22)
-
-
23. A system for updating a remote database over a network, comprising:
-
at least one processor coupled to the network; and a memory coupled to the processor, the memory including the remote database and instructions adapted to be executed by the processor to implement a method for updating the remote database over the network, the method including; receiving a plurality of periodic updates based on incremental changes to a local database over the network, each of the plurality of periodic updates having at least one transaction, receiving an initialization update including a version of the local database at a start time over the network, reading a last periodic update identifier from the initialization update, reading a last transaction identifier from the initialization update, determining a last periodic update from the last periodic update identifier, the last periodic update being based on the start time, determining a last transaction from the las1t transaction identifier, the last transaction being based on the start time, applying transactions generated after the last transaction to the remote database, and applying the periodic updates generated after the last periodic update to the remote database. - View Dependent Claims (24, 25, 26, 27)
-
-
28. A machine readable medium including program instructions adapted to be executed by a processor to implement a method for updating a remote database over a network, the method comprising:
-
generating a plurality of periodic updates based on incremental changes to a local database, each of the plurality of periodic updates having at least one transaction; sending the plurality of periodic updates to the remote database over the network; and while generating the plurality of periodic updates, generating an initialization update including a version of the local database at a start time, determining a last periodic update of the plurality of periodic updates based on the start time, determining a last transaction based on the start time, associating a last periodic update identifier with the last periodic update, associating a last transaction identifier with the last transaction, and sending the initialization update, the last periodic update identifier and the last transaction identifier to the remote database over the network.
-
-
29. A machine readable medium including program instructions adapted to be executed by a processor to implement a method for updating a remote database over a network, the method comprising:
-
receiving a plurality of periodic updates based on incremental changes to a local database over the network, each of the plurality of periodic updates having at least one transaction; receiving an initialization update including a version of the local database at a start time over the network; reading a last periodic update identifier from the initialization update; reading a last transaction identifier from the initialization update; determining a last periodic update from the last periodic update identifier, the last periodic update being based on the start time; determining a last transaction from the last transaction identifier, the last transaction being based on the start time; applying transactions generated after the last transaction to the remote database; and applying the periodic updates generated after the last periodic update to the remote database.
-
Specification