METHODS, SYSTEMS AND DEVICES FOR PERFORMING INCREMENTAL UPDATES OF PARTIAL DATABASES

摘要

Methods, systems and devices for performing incremental updates of a partial database stored on a client device from a computer system containing the database of which the partial database is a subset. A first database record which has been inserted into, deleted from or changed in the server database as a result of a database operation is identified in order to perform a corresponding operation on the client device. In addition, a second record that has not been inserted, deleted or changed, but that is related to the first record through a constraint, is identified. The second record is inserted into or deleted from the partial database through a database operation performed on the client device such that the constraint is fulfilled in the partial database. Identification of records is based on database logs and on the structured relationship between record types.