| 摘要 |
Aspects include systems and methods for synchronizing a remote datastore that includes files and data for use by an application on a remote device, which can be represented on the device in a device-specific format, while the remote data store can have a different data representation, such as a relational database or object graph data model. A server can maintain a unique row identifier for each row in all synchronized tables and an update log table that has rows with the unique row identifiers for changed rows (inserted, updated or deleted), for each insert, update, or delete operation and a current update version that reflects the last change to that row. An update request from a device can comprise identifiers for a (sub)set of the data. The update log table can be used to prepare an update package containing this data. |
| 主权项 |
1. A method for use in remote device data synchronization, comprising:
storing a set of data tables in a non-transitory machine readable medium, each table having a set of rows, and each row having a set of columns and a row identifier that is unique among all rows of all of the tables in the set of the data tables, wherein each data table of the set is associated with a respective current table version; identifying a row insert operation to any data table of the set, and responsively producing a unique row identifier for that row,
creating an entry in a change log table, the created entry having the produced unique row identifier, and the then-current version of the data table as an insert version identifier, andupdating the current table version for that data table; identifying a row update operation to any data table of the set, and responsively locating the unique row identifier for that row in the change log table, and
associating the then-current version of the data table as an update version identifier, andupdating the current table version for that data table; and identifying a row delete operation to any data table of the set, and responsively locating the unique row identifier for that row in the change log table,
associating the then-current version of the data table as a delete version identifier, andupdating the current table version for that data table. |
