Bookkeeping of download timestamps

摘要

Systems, methods and computer program products for bookkeeping of download stamps are described herein. An embodiment includes augmenting database table (or mobile business object) metadata with a synchronization (“sync”) key and assigning a unique identifier to each sync key. A sync key is assigned to one or more rows (or records) in the database table and a download timestamp is associated with each sync key. The embodiment further includes identifying a sync key associated with each row in the database table. Links between rows occurring in different database tables are maintained using sync keys. In this way, embodiments of the invention allow a server to record a download timestamp of database table subsets, where such subsets may include one or more rows in the database tables. This allows data to be downloaded by a client at subset granularity.

主权项

1. A method, comprising:
receiving, by a computing device, a first table and a second table from a first database; augmenting, by the computing device, the first table by adding a first synchronization key, wherein the first synchronization key identifies a first row in the first table; augmenting, by the computing device, the second table by adding a second synchronization key, wherein the second synchronization key identifies a second row in the second table; recording, by the computing device, a relationship between the first synchronization key and the second synchronization key, wherein the relationship is established by a common identifier in the first and second tables; recording, by the computing device, a timestamp for the first synchronization key, wherein the timestamp indicates an access to the first row; and synchronization the first database with a second database by performing a comparison of the first synchronization key and the timestamp with an additional synchronization key and an additional timestamp for the additional synchronization key, wherein the additional synchronization key and the additional timestamp for the additional synchronization key are from the second database, whereby the first row identified by the first synchronization key is synchronized due to the comparison and the second row identified by the second synchronization key is synchronized based on the relationship between the first synchronization key and the second synchronization key.