Patent ID: 8732143
Filing Date: 2014-05-20
Classification: G06F

Abstract:
1. A computer-implemented method for updating base data in a database, the computer-implemented method comprising performing computer-implemented operations for: receiving, at a server executing a server application, a plurality of operations from a plurality of corresponding devices, each of the operations comprising information for modifying the base data in the database; generating, by the server, a changeset for each particular corresponding device being private to and visible only to a respective corresponding device based upon each of the plurality of operations, the changeset indicating changes to be made to the base data in the database, wherein the changeset comprises two tables including a changed record table and a deleted record table, at least one of the two tables storing data indicating at least one of a record of the base data changed by one of the plurality of operations or a record of the base data deleted by one of the plurality of operations; storing, by the server, the changeset in the database; before updating the base data according to changes indicated in the changeset, receiving a query from at least one requesting device of the plurality of devices, the query comprising a request to read the base data from the database; generating, by the server, a modified query comprising the query and a changeset query for reading the data stored in at least one of the changed record table or the deleted record table, the changeset query including a select statement for data from the base data of the query and one or more statements for data from the changeset; returning, by the server, results satisfying the modified query to the at least one requesting device of the plurality of devices; and updating, by the server, the base data according to the changes indicated in the changeset, in response to determining that a transaction between the device and the server computer has ended.